PostgreSQL Tutorial Full Course

Overview

This course aims to help learners master PostgreSQL, an object-relational database known for its adherence to SQL standards, concurrency capabilities, and data integrity features. By the end of the course, students will be able to design databases, create custom types, work with different data types, write SQL queries, use advanced features like views and triggers, and develop stored procedures. The teaching method involves a comprehensive tutorial with practical examples and hands-on coding exercises. This course is intended for individuals interested in database management, SQL programming, and data analysis.

Syllabus

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