Building and Working with Relational Databases

Overview

This specialization covers the core principles and practical applications of relational databases, focusing on design, implementation, and management. Learners will build hands-on skills in SQL querying, data modeling, normalization, and developing database-driven applications.

Through real-world scenarios and projects, participants will learn how to create efficient, scalable database solutions to support business intelligence and decision-making processes.

Syllabus

• Introduction to Relational Databases
Overview of database concepts and applications
Advantages of relational databases
Key components: tables, rows, and columns
• Database Design and Data Modeling
Entity-Relationship (ER) modeling
Translating ER models into database schemas
Data types and integrity constraints
• Normalization
Concepts and importance of normalization
Normal forms (1NF, 2NF, 3NF, BCNF)
Decomposition of tables and dependency preservation
• SQL for Database Querying and Manipulation
Basic SQL queries: SELECT, FROM, WHERE, ORDER BY
Advanced SQL: JOINs, subqueries, and set operations
Data manipulation: INSERT, UPDATE, DELETE
Functions and aggregations in SQL
• Database Implementation and Management
Setting up and configuring a relational database
Indexing and query optimization
Transactions and concurrency control
Backup, recovery, and security measures
• Developing Database-Driven Applications
Integrating databases with applications
Using APIs and drivers for database connectivity
Building simple database-driven web applications
• Business Intelligence and Decision-Making
Introduction to business intelligence concepts
Data warehousing and OLAP technologies
Case studies and real-world applications
• Final Project
Design and implement a complete database solution
Present findings and demonstrate application functionality

---

Taught by

Gerald Balekaki and Yousef Elmehdwi

---

Subjects

Programming