All programmes
Database Management & Engineering
Lecturer / Staff
Student
Public
DBMS with SQL Server
University of Technology and Entrepreneurship, Phnom Penh
0 / 30 enrolled
About this programme
Course outline.
The Database Management Systems (DBMS) with SQL Server course focuses on database design, development, and administration using Microsoft SQL Server. Participants will gain hands-on experience with SQL Server tools, write advanced SQL queries, and manage enterprise-level databases. This course is ideal for students and professionals aiming to work with enterprise database systems and business applications.
What you'll get
Programme highlights.
Industry-led teaching
Live materials from practitioners working in the field today.
Hands-on exercises
You'll apply what you learn through structured workshops and case studies.
Mentor access
Personal contact with the instructor for questions and feedback.
UTE Certificate
A signed certificate of completion you can add to your CV.
Course outline
What we'll cover.
-
01
Introduction to SQL Server and DBMS Concepts
- • Overview of DBMS and Relational Databases • Introduction to SQL Server Architecture • SQL Server Management Studio (SSMS)
-
02
Database Design and Implementation
- • Creating Databases and Tables • Keys
- Constraints
- and Relationships • Data Types and Storage
-
03
SQL Query Fundamentals
- • SELECT Statements • Filtering
- Sorting
- and Aggregation • Joins and Subqueries
-
04
Advanced SQL and T-SQL
- • Stored Procedures • Functions and Views • Triggers and Transactions
-
05
Database Administration Basics
- • User Management and Security • Backup and Recovery • Performance Monitoring
-
06
Data Integrity and Optimization
- • Indexing Strategies • Query Optimization • Handling Large Datasets
-
07
Practical Applications and Projects
- • Business Reporting Queries • Database-Driven Applications • Final Hands-On SQL Server Project