AI, Data Science & Cloud Certificates from Google, IBM & Meta
Get 20% off all career paths from fullstack to AI
Overview
Google, IBM & Meta Certificates – 40% Off
One Coursera Plus subscription covers most Professional Certificates on Coursera.
Unlock All Certificates
This beginner course teaches raw SQL fundamentals, including data manipulation, filtering, sorting, table relationships, joins, unions, subqueries, datatypes, and table alteration. It uses PostgreSQL for practice.
Syllabus
- Intro to SQL
- Download Postgres
- Data Structure
- Inserting Data
- Selecting Data
- Deleting Data
- Primary Key Constraint
- Filtering Data
- AND, OR, NOT
- Ordering/Sorting Data
- Challenge 1
- Relationships
- Foreign Keys
- Bridge/Join Table
- Inner Joins
- Right, Left, Outer Joins
- Many to Many Joins
- Group By
- Unions
- Challenge 2
- Subqueries
- Datatypes
- Altering a Table
Taught by
Laith Academy