Completed
Primary & Foreign Keys
Class Central Classrooms beta
YouTube videos curated by Class Central.
Classroom Contents
PostgreSQL Tutorial Full Course
Automatically move to the next video in the Classroom when playback concludes
- 1 Intro
- 2 Why Use Postgres?
- 3 What is a Database
- 4 Change Database Theme
- 5 Create a Database
- 6 Design a Database
- 7 Turn Invoice into a Database
- 8 Make a Table
- 9 Data Types
- 10 Adding Data to Table
- 11 To See Data
- 12 SELECT
- 13 Create Custom Type
- 14 Change Column Data Type
- 15 Thinking About Tables
- 16 Breaking Up Tables
- 17 Primary & Foreign Keys
- 18 Foreign & Primary Keys
- 19 Altering Tables Many Examples
- 20 Getting Data from One Table
- 21 Where
- 22 Conditional Operators
- 23 Logical Operators
- 24 Order By
- 25 Limit
- 26 GROUP BY
- 27 Distinct
- 28 Getting Data from Multiple Tables
- 29 Inner Join
- 30 Join 3 Tables
- 31 Arithmetic Operators
- 32 Join with Where
- 33 Outer Joins
- 34 Cross Joins
- 35 Unions
- 36 Extract
- 37 IS NULL
- 38 SIMILAR LIKE & ~
- 39 GROUP BY
- 40 HAVING
- 41 AGGREGATE FUNCTIONS
- 42 WORKING WITH VIEWS
- 43 SQL Functions
- 44 Dollar Quotes
- 45 Functions that Return Void
- 46 Get Maximum Product Price
- 47 Get Total Value of Inventory
- 48 Get Number of Customers
- 49 Named Parameters
- 50 Return a Row / Composite
- 51 Get Multiple Rows
- 52 PL/pgSQL
- 53 Variables in Functions
- 54 Store Rows in Variables
- 55 IN INOUT and OUT
- 56 Using Multiple Outs
- 57 Return Query Results
- 58 IF ELSEIF and ELSE
- 59 CASE Statement
- 60 Loop Statement
- 61 FOR LOOP
- 62 Result Sets, Blocks & Raise Notice
- 63 For Each and Arrays
- 64 While Loop
- 65 Continue
- 66 Stored Procedures
- 67 Triggers
- 68 Cursors
- 69 Installation
