/Database Design & Development - Beginner

Course Curriculum

Section 1 · Module 1: Introduction to Databases

○ What is a database? ○ Types of databases (Relational, NoSQL, In-Memory, Cloud) ○ Relational Database Management Systems (RDBMS) overview ○ Popular database systems (MySQL, PostgreSQL, SQL Server, Oracle)

Section 2 · Module 2: Database Design & Data Modeling

○ Database design principles ○ Understanding Entities, Attributes, and Relationships ○ Introduction to Entity-Relationship (ER) Diagrams ○ Normalization (1NF, 2NF, 3NF, BCNF) and denormalization ○ Database schema creation

Section 3 · Module 3: SQL Basics – Querying Databases

○ Introduction to Structured Query Language (SQL) ○ Writing SELECT statements to retrieve data ○ Filtering data with WHERE, ORDER BY, and LIMIT ○ Using JOINs (INNER, LEFT, RIGHT, FULL) to combine tables ○ Grouping and aggregating data (GROUP BY, HAVING)

Section 4 · Module 4: Data Manipulation & Transactions

○ INSERT, UPDATE, DELETE – Modifying data ○ Understanding ACID properties (Atomicity, Consistency, Isolation, Durability) ○ Transactions and rollback mechanisms ○ Constraints (PRIMARY KEY, FOREIGN KEY, UNIQUE, CHECK, NOT NULL)

Section 5 · Module 5: Indexing & Query Optimization

○ Understanding indexes and how they improve performance ○ Creating indexes on tables ▶ Optimizing queries using EXPLAIN ANALYZE ○ Avoiding common performance bottlenecks

Module 5: Indexing & Query Optimization

Optimizing queries using EXPLAIN ANALYZE

← Previous Continue →