Introduction to Relational Databases

Course Description

Welcome to the exciting world of relational databases! This comprehensive course, "Introduction to Relational Databases," is designed to provide you with a solid foundation in the fundamental concepts of relational databases and Relational Database Management Systems (RDBMS). Whether you're a complete beginner or looking to refresh your knowledge, this course offers a perfect blend of theory and hands-on practice to help you master the essentials of database design and management.

What Students Will Learn

  • Understanding of relational database concepts and RDBMS
  • Relational database design principles and techniques
  • Transformation of source data into well-structured tables with defined relationships
  • Creation of databases, tables, and data loading processes
  • Introduction to Structured Query Language (SQL)
  • Practical experience with industry-standard databases: IBM Db2, MySQL, and PostgreSQL
  • Application of keys and constraints in relational databases
  • Design, creation, and population of a multi-table database instance

Pre-requisites

Great news! No prior knowledge of databases or programming is required to take this course. It's designed for beginners and those looking to build a strong foundation in relational database concepts.

Course Coverage

  • Fundamentals of relational databases and RDBMS
  • Information and data models
  • Types of relationships in databases
  • Mapping entities to tables
  • Data types and relational model concepts
  • Relational database architectures and usage scenarios
  • Introduction to IBM Db2, MySQL, and PostgreSQL
  • Table creation and data loading techniques
  • Primary and foreign keys
  • Overview of indexes
  • Database normalization
  • Relational model constraints
  • Views in databases
  • Database design approach and best practices

Who This Course Is For

  • Aspiring data professionals looking to start their career in database management
  • Students interested in learning about data organization and storage
  • Professionals from other fields wanting to understand database fundamentals
  • Anyone curious about how data is structured and managed in modern applications

Real-World Applications

The skills gained from this course are highly valuable in today's data-driven world. You'll be able to:

  • Design efficient databases for various applications and businesses
  • Organize and structure data effectively for easy retrieval and analysis
  • Contribute to data-related projects in your workplace
  • Understand the backbone of most modern software applications
  • Lay the groundwork for more advanced database and data engineering roles
  • Improve data management practices in your personal or professional projects

Syllabus

Module 1 – Relational Database Concepts

  • Review of data fundamentals
  • Information and Data Models
  • Types of Relationships
  • Mapping Entities to Tables
  • Data Types
  • Relational Model Concepts
  • Relational 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

By the end of this course, you'll have the skills and confidence to design, create, and manage relational databases, setting you up for success in the world of data management and beyond!