Information Technology

Database and SQL Fundamentals

A practical, self-paced course covering database and sql fundamentals with ten structured lessons, real-world examples and a final assessment.

Beginner
10 lessons 5 hours Certificate available

Course curriculum

  1. 1Understanding Relational Data Models and Core Concepts Sign in
  2. 2Crafting Your First Queries with SELECT and FROM Sign in
  3. 3Refining Results Using WHERE Clauses and Logical Operators Sign in
  4. 4Managing Data Order and Eliminating Duplicates Sign in
  5. 5Mastering Aggregate Functions and Grouping Data Sign in
  6. 6Connecting Tables with Inner, Left, and Right Joins Sign in
  7. 7Database Manipulation: INSERT, UPDATE, and DELETE Operations Sign in
  8. 8Designing Schemas with Data Definition Language (DDL) Sign in
  9. 9Ensuring Integrity with Constraints and Primary Keys Sign in
  10. 10Practical SQL Project: Building and Querying a Business Inventory Sign in
  11. Final quiz — sign in and complete all 10 lessons to unlock