PostgreSQL Tutorial Full Course
Offered By: Derek Banas via YouTube
Course Description
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
Related Courses
Web Application Development: The Data TierUniversity of New Mexico via Coursera Desarrollo de Aplicaciones Web: Nivel de Datos
University of New Mexico via Coursera Hacking PostgreSQL: Data Access Methods
Ural Federal University via edX Spatial Data Science and Applications
Yonsei University via Coursera RDBMS PostgreSQL
Indian Institute of Technology Bombay via Swayam