❗The content presented here is sourced directly from Youtube platform. For comprehensive course details, including enrollment information, simply click on the 'Go to class' link on our website.
Updated in [February 21st, 2023]
Intro
Why Use Postgres?
What is a Database
Change Database Theme
Create a Database
Design a Database
Turn Invoice into a Database
Make a Table
Data Types
Adding Data to Table
To See Data
SELECT
Create Custom Type
Change Column Data Type
Thinking About Tables
Breaking Up Tables
Primary & Foreign Keys
Foreign & Primary Keys
Altering Tables Many Examples
Getting Data from One Table
Where
Conditional Operators
Logical Operators
Order By
Limit
GROUP BY
Distinct
Getting Data from Multiple Tables
Inner Join
Join 3 Tables
Arithmetic Operators
Join with Where
Outer Joins
Cross Joins
Unions
Extract
IS NULL
SIMILAR LIKE & ~
GROUP BY
HAVING
AGGREGATE FUNCTIONS
WORKING WITH VIEWS
SQL Functions
Dollar Quotes
Functions that Return Void
Get Maximum Product Price
Get Total Value of Inventory
Get Number of Customers
Named Parameters
Return a Row & Composite
Get Multiple Rows
PL&pgSQL
Variables in Functions
Store Rows in Variables
IN INOUT and OUT
Using Multiple Outs
Return Query Results
IF ELSEIF and ELSE
CASE Statement
Loop Statement
FOR LOOP
Result Sets Blocks & Raise Notice
For Each and Arrays
While Loop
Continue
Stored Procedures
Triggers
Cursors
Installation
