PostgreSQL Tutorial Full Course 2022

Description:

I wrote a Techno-Thriller called Whispers if you're interested: 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. Code & Transcript Here : Best Book on PostgreSQL : MY UDEMY COURSES ARE 87.5% OFF TIL May 1st ($9.99) ➡️ Python Data Science Series: Highest Rated & Largest Python Udemy Course + 56 Hrs + 200 Videos + Data Science ➡️ C++ Programming Bootcamp Series: Over 23 Hrs + 53 Videos + Quizzes + Graded Assignments ➡️ Golang Course: 15 Hrs + Web Apps + Core Language + Create a Blog + PostgreSQL + Problem Solving #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