All programmes
Database Management & Engineering
Lecturer / Staff
Student
Public
DBMS with with MySQL and PostgreSQL
University of Technology and Entrepreneurship, Phnom Penh
0 / 30 enrolled
About this programme
Course outline.
The Database Management Systems (DBMS) with MySQL and PostgreSQL course provides learners with a solid foundation in relational database concepts and practical database management skills. Participants will learn how to design databases, write efficient SQL queries, manage data, and perform basic administration tasks using MySQL and PostgreSQL. The course is suitable for beginners and aspiring data professionals who work with data-driven 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 Database Management Systems
- • Database Concepts and Terminology • Types of Databases • Introduction to Relational Databases
-
02
Database Design and Modeling
- • Entity-Relationship (ER) Diagrams • Tables
- Keys
- and Constraints • Normalization Concepts
-
03
Introduction to SQL
- • SQL Syntax and Data Types • Creating and Modifying Tables • Basic CRUD Operations
-
04
Querying Data with SQL
- • Filtering and Sorting Data • Joins and Subqueries • Aggregate Functions and Grouping
-
05
Working with MySQL
- • Installing and Configuring MySQL • Database and User Management • Performance Basics and Indexing
-
06
Working with PostgreSQL
- • Installing and Configuring PostgreSQL • Advanced Data Types • Views and Stored Functions
-
07
Database Security and Backup
- • User Roles and Permissions • Backup and Restore Strategies • Best Practices for Database Management