PostgreSQL Tutorial Full Course 2022

I'd greatly appreciate a review for it if you have time.

I provide here in this PostgreSQL tutorial a full course you can use to master PostgreSQL. Postgres is an object relational database that is just as fast as MySQL that adheres more closely to SQL standards and excels at concurrency. Postgres is also superior at avoiding data corruption.

Postgres also provides more advanced data types and allows for the creation of custom types, operators and index types.

Postgres is normally the best option when extensibility, scalability and data integrity are most important to you. The table of contents below provides timestamps to everything I cover.

MY UDEMY COURSES ARE 87.5% OFF TIL May 1st ($9.99)

#postgresql #postgres #fullcourse

TABLE OF CONTENTS
00:00 Intro
00:30 Why Use Postgres?
01:13 What is a Database
03:12 Change Database Theme
03:53 Create a Database
04:46 Design a Database
05:50 Turn Invoice into a Database
07:04 Make a Table
12:13 Data Types
16:36 Adding Data to Table
18:15 To See Data
18:25 SELECT
19:19 Create Custom Type
20:48 Change Column Data Type
22:58 Thinking About Tables
25:37 Breaking Up Tables
27:03 Primary & Foreign Keys
32:40 Foreign & Primary Keys
33:28 Altering Tables Many Examples
53:00 Getting Data from One Table
53:40 Where
54:30 Conditional Operators
55:48 Logical Operators
58:12 Order By
59:32 Limit
1:01:45 GROUP BY
1:03:11 Distinct
1:05:00 Getting Data from Multiple Tables
1:05:21 Inner Join
1:08:50 Join 3 Tables
1:13:15 Arithmetic Operators
1:13:45 Join with Where
1:14:55 Outer Joins
1:17:03 Cross Joins
1:18:16 Unions
1:19:27 Extract
1:21:05 IS NULL
1:22:03 SIMILAR LIKE & ~
1:29:25 GROUP BY
1:31:14 HAVING
1:32:18 AGGREGATE FUNCTIONS
1:34:22 WORKING WITH VIEWS
1:45:01 SQL Functions
1:49:00 Dollar Quotes
1:50:06 Functions that Return Void
1:52:38 Get Maximum Product Price
1:53:39 Get Total Value of Inventory
1:54:26 Get Number of Customers
1:56:15 Named Parameters
2:01:30 Return a Row / Composite
2:03:38 Get Multiple Rows
2:07:08 PL/pgSQL
2:11:35 Variables in Functions
2:15:55 Store Rows in Variables
2:19:17 IN INOUT and OUT
2:21:01 Using Multiple Outs
2:25:56 Return Query Results
2:33:42 IF ELSEIF and ELSE
2:38:48 CASE Statement
2:42:01 Loop Statement
2:45:20 FOR LOOP
2:48:34 Result Sets, Blocks & Raise Notice
2:51:11 For Each and Arrays
2:53:20 While Loop
2:54:54 Continue
3:01:34 Stored Procedures
3:09:35 Triggers
3:29:25 Cursors
3:39:45 Installation

[jaidynbelbin]

This guy is one of the OG programming tutorial guy on YT. Seriously, he helped me out so much way back in 2016-17 when I was starting out with Java, and he's still pumping out videos. Legend.

[CB-tdck]

Hey derek. Just wanted to let you know that from my very first engineering class ten years ago to today where i am a full fledged software engineer you have really helped out.
Thank you for your contributions to society.

[terrycox]

Another nice, thorough tutorial... A lot of material is covered over a short period of time. The pacing was good. Quick and to the point, using plausible scenarios to emphasize the concept. The thing I appreciate most is having a good explanation of Postgres broad capabilities, which are impressive. I will certainly use this video as a reference. I feel I have a good conceptual understanding of Postgres now. Well done. Thanks.

[Tech-fxdo]

hi, excellent tutorial! honestly i never seen an in depth tutorial on sql or postgres but this one is exactly that. Good job keep doing more advance videos on postgres! Thank you, regards!

[mkhairulfarihin]

Long tutorial with many things covered. I referred the documentation once in awhile but your content covers quite a lot, especially the useful stuff. Keep it up!

[mrt]

ABSOLUTELY BRILLIANT! Excellent speed flow, excellent lesson flow, excellent explanation and excellent "PASSION" which can be felt in the humour/attitude and presentation tones! REALLY GRATEFUL Derek! As this is my first official introduction to SQL in general, I still have ways to go before I can be as comfortable with it as I am with other languages but you definitely set me up to follow a methodical route to finding points of reference as the need may arise. Looking forward to other lessons!

PS: for what its worth, it took me a solid 18 hours to complete your 3.5hr lesson with notes and practices. And your request to leave comment "came this far" was noted but I waited until the video was complete :)

[MtrJck]

@Derek Banas - I Started watching your code tutorials back in 2016 with the python series you made, hoping to get a job/career in programming and away from security. Haven't got a spot yet, but haven't stopped watching your stuff yet. Thank you for making these videos, it helps me feel smarter every time I watch them as so little else keeps my brain preoccupied.

[muhammadhafizuddin]

Hi uncle derek, just wanna say i started learning with your videos back when i was 14-15. Now im doing my bachelor degree in software engineering, and already a full stack dev with experience shipping few production app. Yet i still had one month more to finish my degree, and im already shipping app. Partially of that is a big thanks to you and your tutorial in one video.

[quyenscc]

Hi sir, I made it until the point you mentioned in the tutorial. And I am going to finish the whole video today. I take note of everything you said because I find them all very important. Thank you for producing an amazing video.

[jessied]

This has been super helpful! I watch on 1.5 speed and try to follow along. Thanks so much.

[silvestrecamposano]

Wow!.... this is very comprehensive lecture... Thank you Sir, am beginning to understand the basics of SQL... More power to you....

[ilovecomputercoding]

Perfect Videoto get up and running with plenty of examples to use as reference ... thanks!

[Lourensps]

Thanks foor this. Likely the longest viedo on YoutTube I have watched. Time to implement and learn further!

[Cedric-ovwl]

Just perfect ! Thank's a lot for this comprehensive and detailed tuto !

[learner]

Thanks !!! This is a great video... It's the SQL tutorial that I needed !!!

[dickyv]

Great tutorial, voice pleasant to the ear, can't recommend enough. Thank you sir.

[rickali]

Wow I have a coding test for a grad scheme in a few days where I have to use postgres and you posted this, what a legend!

[cameronx]

Sometimes I feel like Derek must be following me around or something. Every time I start working with a new technology it seems I get a notification that Derek has made a new video about it lol. Thank you Derek. As always, your content is awesome.

[gulbalasalamov]

Incredibly educational and useful. Thank you very much for all of your efforts and sharing it ! Highly appreciated! Wish you a happy year :)

[agapioschortaras]

Incredible course that has to many information that you can search afterwards or during the course! Thanks Darek for making this video to all of us!!! Wish you all the best


Edit my comment after one month:
- This course is just so complete and with huge amount of work. You can spend at least 10 hours by yourself in order to understand each topic and search more information.


Question: Do you know how we can produce sample data automatically in order to work more with SQL and try different examples ?

Thank you!