Overview
Syllabus
- Intro.
- Quick Word Before we begin.
- What is Database.
- What is SQL.
- SQL Example.
- Postgres.
- Install Postgres (MAC OS).
- Setup Postgres (MAC OS).
- Install Postgres (Windows.
- PSQL (Windows).
- Learn SQL the right way.
- Create Database.
- Connecting to Databases.
- Create Table Syntax + Datatypes.
- Create Table Without Constraints.
- Create Table With Constraints.
- Insert Data.
- Insert Into.
- SELECT FROM.
- Adding Data.
- Sorting.
- Removing Duplicates.
- WHERE clause.
- Comparison Operators.
- LIMIT OFFSET and FETCH.
- IN.
- BETWEEN.
- LIKE.
- GROUP BY.
- HAVING.
- Car Table.
- MIN MAX & AVG.
- SUM.
- Arithmetic Operators.
- Working with Arithmetic Operators.
- Alias.
- Coalesce.
- NULLIF.
- Timestamps & Dates.
- Adding & Subtracting Dates.
- Extracting Fields From Dates.
- Age Function.
- Primary Keys.
- Primary Keys (Part 2).
- Adding Primary Keys Constraints.
- Unique Constraints.
- Primary Keys.
- Check Constraints.
- Deleting Records.
- Updating Records.
- On Conflict Do Nothing.
- On Conflict Do Update.
- Foreign Keys & Relationships.
- Adding Foreign Keys.
- Updating Foreign Keys.
- Inner Joins.
- Left Joins.
- Deleting Foreign Keys.
- Sequences.
- Extensions.
- UUID.
- UUID in Action.
- Exporting to CSV.
- Next steps.
- Database Design Course.
Taught by
Amigoscode