Learn PostgreSQL from the ground up in this comprehensive tutorial. Dive into database fundamentals, design principles, and advanced features of PostgreSQL. Create and manipulate tables, master data types, and execute complex queries. Explore joins, views, functions, and PL/pgSQL for powerful database programming. Discover how to optimize performance with indexing, triggers, and stored procedures. Gain hands-on experience with practical examples and real-world scenarios. By the end of this course, develop the skills to design, implement, and manage robust PostgreSQL databases for various applications.
Overview
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
Taught by
Derek Banas
