Back to: Database (DX) Design Course
Module 3: Relational Database Management Systems
This module focuses on introducing students to Relational Database Management Systems (RDBMS) and their fundamental concepts. Students will learn about commonly used RDBMS and gain hands-on experience in installing and configuring a database management system.Â
The key topics covered in this module include:
- Introduction to RDBMS:
- Definition and characteristics of Relational Database Management Systems.
- Understanding the components and architecture of an RDBMS.
- Exploring the advantages of using an RDBMS for data storage and retrieval.
- Commonly used RDBMS and their features:
- Overview of popular RDBMS such as MySQL, PostgreSQL, Oracle, and SQL Server.
- Comparing the features, performance, and scalability of different RDBMS.
- Understanding the suitability of each RDBMS for specific application requirements.
- Installation and configuration of a database management system:
- Step-by-step installation of an RDBMS on a local development environment.
- Configuring the RDBMS settings and parameters.
- Verifying the successful installation and connectivity to the RDBMS server.
- Basic SQL queries and commands:
- Introduction to Structured Query Language (SQL).
- Writing and executing basic SQL queries to retrieve data from a database.
- Performing common SQL operations such as filtering, sorting, and joining data.
- Modifying and updating data using SQL commands.
By the end of this module, students will have a solid understanding of Relational Database Management Systems, including their features and benefits. They will be able to install and configure an RDBMS on their local development environment. Additionally, they will gain proficiency in writing and executing basic SQL queries and commands to retrieve and manipulate data. This knowledge will serve as the foundation for the subsequent modules, where students will delve deeper into database schema design, normalization, and advanced SQL operations.