Search⌘ K

AI Features

Introduction to Modern Databases *

1.Introduction to Databases

Data vs. Information What Databases Really Are From Files to Clouds Flat Files Relational Databases Relational vs. NoSQL NoSQL & Cloud

2.Database Models and Architectures

Understanding Schema Understanding Instance Schema vs. Instance Three Views of Database Architecture Data Independence Logical Data Independence Physical Data Independence Inside the DB Engine

3.Relational Model

Tables, Rows, Columns Why Keys Matter The Primary Key The Foreign Key Integrity Constraints Entity Integrity Constraint Referential Integrity Constraint Domain Integrity Constraint Constraints Quiz

4.Entity-Relationship Modeling

ER Models in Plain Words Reading Crow’s Foot From ER to Tables

5.SQL Fundamentals

SQL: What, Not How DDL vs. DML Anatomy of SELECT Filtering Rows with WHERE Handling NULLs Correctly Joining Tables Together Inner Join Basics Left Join Basics Grouping and Aggregates Filtering Aggregates Example Subqueries Conditional Logic in SQL CASE statement The IF function

6.Schema Design and Normalization

Database Design Flow Why Normalize Data First Normal Form (1NF)Second Normal Form (2NF)Third Normal Form (3NF)

7.Transactions and Concurrency Control

ACID in One Glance Transaction Control COMMIT changes ROLLBACK changes Checkpoints with SAVEPOINT Indexes for Speed Query Execution Plans Partition vs. Shard

8.NoSQL Databases Overview

Why NoSQL Emerged Documents and Collections Basic CRUD Operations

9.Conclusion

Database Essentials Recap Final Remarks

Introduction to Modern Databases *

Filtering Rows with WHERE

We'll cover the following...

This component is not supported in the current context

...