Introduction to Relational Databases (RDBMS)

In this module, you’ll explore the types of SQL statements, like Data Definition Language (DDL) and Data Manipulation Language (DML). You’ll learn how to create, modify, and manage tables using DDL statements and understand data movement utilities for efficient data loading and management. Additionally, you’ll dive into key database objects such as schemas, primary keys, foreign keys, and indexes, gaining insights into their roles in data organization, integrity, and retrieval. You’ll also understand the importance of normalization for reducing redundancy and ensuring data consistency, while also understanding various constraints within the relational model to maintain data accuracy and reliability.

In this module, you will learn about the fundamental aspects of MySQL and PostgreSQL and identify Relational Database Management System (RDBMS) tools. You will explore the process of creating databases and tables and the definition of keys, constraints, and connections in MySQL. Additionally, you will discover important processes in PostgreSQL using command line, pgAdmin, and views. Moreover, you will gain essential skills such as database loading techniques and insights into securing sensitive data and streamlining data retrieval.

In this module, you will navigate the database design process, refine your practical skills, and understand essential steps. You will discover the role of Entity Relationship Diagrams (ERDs) and get an opportunity to engage in a hands-on database design lab, where you will use your theoretical knowledge to create databases. As you progress, you will receive an optional final assignment and project submission stages. For those seeking an advanced challenge, a final project using PostgreSQL, MySQL and (optionally) Db2. A glossary is available for quick reference to key terms used throughout the module.