Introduction to Relational Databases (RDBMS)

This module provides a comprehensive review of data fundamentals and delves into information and data models, types of relationships, and relational model concepts. It also introduces various industry standard relational databases such as IBM DB2, MySQL, and PostgreSQL, and their usage patterns. Hands-on labs and quizzes reinforce learning.

Module 2 focuses on using relational databases, covering types of SQL statements, creating and managing tables, data movement utilities, database objects and hierarchy, normalization, and relational model constraints. Hands-on labs and quizzes provide practical application and assessment of knowledge.

This module explores MySQL and PostgreSQL, providing guidance on getting started with these databases, creating databases and tables, loading data, using keys and constraints, and working with views. Hands-on labs and quizzes offer practical experience and assessment.

The final module guides students through the approach to database design, culminating in a final project where they will apply their knowledge to design a database for specific analytics requirements using ERDs. The module concludes with a final quiz and project submission. Hands-on labs provide practical application of learned concepts.