Completed
- Create Table Without Constraints
Class Central Classrooms beta
YouTube videos curated by Class Central.
Classroom Contents
SQL for Beginners Tutorial - Learn SQL in 4.2 Hours
Automatically move to the next video in the Classroom when playback concludes
- 1 - Intro
- 2 - Quick Word Before we begin
- 3 - What is Database
- 4 - What is SQL
- 5 - SQL Example
- 6 - Postgres
- 7 - Install Postgres (MAC OS)
- 8 - Setup Postgres (MAC OS)
- 9 - Install Postgres (Windows
- 10 - PSQL (Windows)
- 11 - Learn SQL the right way
- 12 - Create Database
- 13 - Connecting to Databases
- 14 - Create Table Syntax + Datatypes
- 15 - Create Table Without Constraints
- 16 - Create Table With Constraints
- 17 - Insert Data
- 18 - Insert Into
- 19 - SELECT FROM
- 20 - Adding Data
- 21 - Sorting
- 22 - Removing Duplicates
- 23 - WHERE clause
- 24 - Comparison Operators
- 25 - LIMIT OFFSET and FETCH
- 26 - IN
- 27 - BETWEEN
- 28 - LIKE
- 29 - GROUP BY
- 30 - HAVING
- 31 - Car Table
- 32 - MIN MAX & AVG
- 33 - SUM
- 34 - Arithmetic Operators
- 35 - Working with Arithmetic Operators
- 36 - Alias
- 37 - Coalesce
- 38 - NULLIF
- 39 - Timestamps & Dates
- 40 - Adding & Subtracting Dates
- 41 - Extracting Fields From Dates
- 42 - Age Function
- 43 - Primary Keys
- 44 - Primary Keys (Part 2)
- 45 - Adding Primary Keys Constraints
- 46 - Unique Constraints
- 47 - Primary Keys
- 48 - Check Constraints
- 49 - Deleting Records
- 50 - Updating Records
- 51 - On Conflict Do Nothing
- 52 - On Conflict Do Update
- 53 - Foreign Keys & Relationships
- 54 - Adding Foreign Keys
- 55 - Updating Foreign Keys
- 56 - Inner Joins
- 57 - Left Joins
- 58 - Deleting Foreign Keys
- 59 - Sequences
- 60 - Extensions
- 61 - UUID
- 62 - UUID in Action
- 63 - Exporting to CSV
- 64 - Next steps
- 65 - Database Design Course
