Part of the Free Full-stack course: https://www.youtube.com/playlist?list=PL6yRaaP0WPkXo7Kl6LQcO69bsYTS7BDxo

Welcome to the Free Full-stack Course

In this course, we will be using Python as the programming language for our backend to deliver REST APIs. The REST APIs will be developed on top of Django which is a backend/website framework that sits on top of Python. And we will also use DRF (Django REST Framework) to actually deliver our APIs on top of Django.

PostgreSQL is the world's most advanced open-source relational database. Even though Django manages the database and models and relationships for us when hooked to any database management system such as PostgreSQL or MySQL, it is still beneficial to know the basics of PostgreSQL. In this chapter we will learn the basics of PostgreSQL.

Timestamps:
00:00 - PostgreSQL Crash Course for Django
00:10 - Django abstracts away the DB
01:37 - Get connection information
03:56 - List all users and their roles
05:44 - See a history of commands
06:12 - Get a list of all databases
07:10 - Switching databases
07:59 - Available psql commands
08:34 - Quitting psql
09:04 - Retrieving the current psql version
09:41 - Re-execute the previous command
10:36 - Creating databases
12:20 - Dropping databases
13:48 - Renaming databases
14:50 - Changing database owners
16:38 - Creating tables
17:55 - Listing all tables in current database
18:31 - Getting table schema
19:28 - Dropping tables
19:51 - Auto-generated identity columns
21:51 - Primary keys
22:42 - Foreign keys
26:35 - Inserting into tables
31:03 - Requiring data for columns
31:26 - Create your test tables
32:00 - Insert data into your test tables
34:07 - Deleting multiple rows
35:36 - Deleting all rows
36:24 - Selecting all rows and columns
36:37 - Selecting a specific column
37:10 - Selecting multiple columns
37:23 - Selecting rows starting with value
38:18 - Selecting rows ending with value
38:50 - Selecting rows containing a value
39:43 - There is a lot more to SQL
40:22 - You won't work directly with SQL in Django
41:28 - Congratulations

If you want to support my work, please consider joining my YouTube channel by pressing the Join button!

Twitter: https://twitter.com/vandadnp
LinkedIn: https://linkedin.com/in/vandadnp

Let's get started!