Guest
Part of the Free Full-stack course: 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: 🔵 LinkedIn: Let's get started!
