The objective of this course is to provide you with a solid understanding of relational databases and Relational Database Management Systems (RDBMS).

After completing this course, you will be able to:

• Describe a relational database and explain relational database concepts.

• Design the schema of a relational database.

• Create database objects such as tables, keys, constraints, and views.

• Load tables with data from .CSV files.

• Demonstrate working knowledge of MySQL, PostgreSQL and IBM Db2.

Module 1 – Relational Database Concepts

• Review of data fundamentals

• Information and Data Models

• Types of Relationships

• Mapping Entities to Tables

• Data Types

• Relational Model ConceptsRelational Database Architectures and Usage Scenarios

• Introduction to Relational Database Products

• Db2

• MySQL

• PostgreSQL

Module 2 – Using Relational Databases

• Creating Tables

• Loading Data

• Exporting Data

• Primary Keys and Foreign Keys

• Overview of Indexes

• Normalization

• Relational Model Constraints

Module 3 – MySQL and PostgreSQL

• Getting started with MySQL - architecture, design focus

• Creating Databases and Tables in MySQL

• Loading Data in MySQL

• Using Keys and Constraints in MySQL

• Getting started with PostgreSQL

• Creating Databases and loading data into PostgreSQL

• Views

Module 4 – Database Design Project

• Approach to Database Design

• Final Project