Learn SQL by designing a database schema for a social media website using PostgreSQL. Master essential SQL concepts while gaining practical skills to create databases for personal projects. Follow along as the tutorial covers installation, database creation, table design, constraints, data manipulation, and complex queries. Explore topics like altering tables, handling null columns, inserting and updating data, using WHERE clauses, and joining multiple tables. Access provided code and additional resources to enhance your learning experience and apply newfound knowledge to real-world scenarios.
Overview
Syllabus
Introduction
Installing Postgres
Connecting to Postgres
Creating a new database
Running the query
Creating a table
Constraints
Alter Table
Null Columns
Update
Create another table
Insert data
Add second post
Add third post
Where clause
Join multiple tables
Favorites
Taught by
Ben Awad
