🗄️

SQL and Databases Fundamentals

Understand how data is stored, queried, and operated — the bedrock of every cloud data certification.

Beginner1 hours10 lessons
Start Course →

What You'll Learn

  • ✓Explain what a database is and when to use one
  • ✓Design tables with primary keys, foreign keys, and normalization
  • ✓Read and write SELECT queries with WHERE, ORDER BY, LIMIT
  • ✓Combine data from multiple tables with JOINs
  • ✓Aggregate data with GROUP BY, HAVING, and window functions
  • ✓Modify data safely with INSERT, UPDATE, DELETE inside transactions
  • ✓Use indexes to speed up queries and understand their costs
  • ✓Compare Postgres, MySQL, and SQLite — and pick the right one
  • ✓Identify when NoSQL (key-value, document, wide-column) is appropriate
  • ✓Understand cloud-managed databases, backups, replicas, and security basics

Prerequisites

  • •Basic command-line familiarity

Course Curriculum

Module 1: Database Foundations

  1. 01What Is a Database and Why Use One?5 min
  2. 02Data Modeling and Normalization6 min

Module 2: Core SQL

  1. 01SELECT, Filtering, and Sorting6 min
  2. 02Joins, Aggregations, and Window Functions7 min

Module 3: Modifying Data

  1. 01INSERT, UPDATE, DELETE, and Transactions6 min
  2. 02Indexes and Query Performance6 min

Module 4: Database Engines

  1. 01Postgres, MySQL, and SQLite Compared5 min
  2. 02When to Use NoSQL6 min

Module 5: Production

  1. 01Cloud Databases and Managed Services6 min
  2. 02Backups, Replication, and Database Security6 min

Practice for the Real Exam

After completing this course, test yourself with exam-style practice questions.

Practice DP 900 QuestionsPractice AWS CLF C02 QuestionsPractice GCP CDL Questions