SQL: Master Database Queries

What's in the five PDFs

1. 1

   Database Foundations

   5 topics

   • Intro to Databases
   • Relational Concepts
   • Installing MySQL/PostgreSQL
   • Creating Databases and Tables
   • Data Types
2. 2

   Data Manipulation & Basic Queries

   4 topics

   • INSERT, UPDATE & DELETE
   • SELECT
   • WHERE
   • ORDER BY and LIMIT
3. 3

   Aggregation & Joins

   5 topics

   • Aggregate Functions
   • GROUP BY and HAVING
   • JOINs
   • Subqueries
   • UNION
4. 4

   Keys, Constraints & Performance

   4 topics

   • Primary & Foreign Keys
   • Constraints
   • Indexes
   • Views
5. 5

   Advanced SQL & Projects

   4 topics

   • Stored Procedures
   • Transactions
   • Database Design Basics
   • Practice Projects