Database Fundamentals: From Zero to Hero
Database Fundamentals: From Zero to Hero
This comprehensive 40-lesson course is designed specifically for absolute beginners, taking you on a journey from understanding what data is to mastering relational database design, data manipulation using SQL, and essential concepts like normalization and transactions. You will learn how to structure complex data, retrieve information efficiently, and build reliable database systems that power modern applications. By the end of this course, you will be proficient in basic SQL and possess the foundational knowledge required for any data-focused career path.
Lessons
- What is Data? The Building Blocks of Information
- Why Databases? The Problem with Flat Files
- Introduction to DBMS and Database Types
- The Relational Model (RDBMS) Terminology
- Setting up the Environment: Introduction to SQLite
- Designing the Schema: Tables, Rows, and Columns
- Keys Part 1: Primary Keys (PK)
- Keys Part 2: Foreign Keys (FK) and Relationships
- Relationship Modeling: One-to-One (1:1)
- Relationship Modeling: One-to-Many (1:N)
- Relationship Modeling: Many-to-Many (M:N) and Junction Tables
- Data Integrity Constraints (NOT NULL, UNIQUE, CHECK)
- Introduction to SQL: DDL, DML, and DCL
- The SELECT Statement: Basic Retrieval
- Filtering Data with WHERE Clauses
- Advanced Filtering: Logical and Range Operators
- Pattern Matching with LIKE
- Basic Arithmetic, Concatenation, and Column Aliases
- Sorting Results with ORDER BY
- Inserting New Data (INSERT)
- Modifying Existing Data (UPDATE)
- Deleting Data (DELETE vs. TRUNCATE)
- Handling NULL Values and IS NULL
- Aggregate Functions (COUNT, SUM, AVG, MIN, MAX)
- Grouping Data with GROUP BY and HAVING
- Why We Need Joins: Combining Multiple Tables
- The INNER JOIN (Standard Join)
- LEFT and RIGHT OUTER JOINS
- FULL OUTER JOIN and Self Joins
- Subqueries (Nested Queries)
- Common Table Expressions (CTEs) using WITH
- Database Design Methodology Overview
- Normalization Principle and Functional Dependency
- First Normal Form (1NF)
- Second Normal Form (2NF)
- Third Normal Form (3NF)
- Introduction to Indexing (Speeding up Queries)
- Views: Stored Queries for Security and Simplicity
- Transactions and ACID Properties
- Backup, Recovery, and Next Steps