Completed
WORKING WITH VIEWS
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
