Overview
Master relational database principles through hands-on SQL, data modeling, and application development, learning to create efficient solutions for business intelligence and decision-making.
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
Tags
On-Demand
