Dive into a comprehensive 4-hour crash course on raw SQL for beginners. Learn essential database concepts and SQL fundamentals, starting with an introduction to SQL and Postgres installation. Master data structures, CRUD operations, and constraints. Explore advanced topics like data filtering, sorting, and various types of joins. Practice your skills with coding challenges. Delve into relationships, foreign keys, and bridge tables. Understand group by operations, unions, and subqueries. Familiarize yourself with different datatypes and table alterations. Access supplementary resources including a GitHub repository, Postgres download link, and recommended SQL tools like Postico and PopSQL to enhance your learning experience.
Overview
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
