Database & SQL

Learn the fundamentals of SQL including SELECT statements, filtering, and sorting.

Learn the difference between the classic Waterfall (SDLC) model, the flexible Agile philosophy, the SCRUM framework, and the CMMI quality standard to understand how modern software is planned and built.

Master the fundamentals of connecting data tables. This lesson covers Primary and Foreign Keys, INNER and LEFT JOINs, and essential logical operators like AND, OR, and NOT.

Learn to write cleaner and more powerful SQL by mastering subqueries (single-row, multi-row) and Common Table Expressions (CTEs) using the WITH clause.

Learn the complete 6-step journey of professional database design: from business rules to conceptual, logical, and physical models, including normalization and choosing datatypes.

Learn a modern workflow using a Generative AI chatbot to analyze a business, design a logical data model, and generate a physical SQL script in minutes.

Explore how different applications connect to databases, including traditional 3-tier web architecture, mobile apps using APIs, and enterprise systems using ORMs.