Learn Basic SQL in 3.5 hrs | Complete SQL Beginner Course
Get a 30-day free trial of Brilliant using the link: https://brilliant.org/techTFQ/
This video contains a full SQL course for beginners. Anyone willing to learn SQL from scratch will benefit from this video. Here I only cover IMPORTANT basic SQL concepts that can help you clear interviews and perform SQL activities at your job.
If you’d like to practice SQL queries or explore my recorded SQL courses, check out my all-in-one SQL learning platform, SQLNest 👇
https://sqlnest.com/
All the scripts, datasets, and notes used during the video can be downloaded from my blog below:
https://techtfq.com/blog/sql-tutorial...
Timestamp:
00:00 Intro
00:15 Overview of video content
01:39 Install PostgreSQL Database & PgAdmin tool
06:59 Create a new database
07:40 Brilliant Overview
10:02 What is a database?
11:40 What is a table?
12:23 Create a simple table
18:52 Load data
24:55 Read data
36:06 Modify data
46:14 Remove data
50:18 SQL Commands
55:00 Remove table
57:46 Modify table
01:00:54 Primary Key Constraint
01:10:08 Identity Constraint (column)
01:16:54 Foreign Key Constraint
01:21:17 Creating the Sales Order Dataset
01:24:15 Case Study
01:25:39 Problem no 1
01:28:44 Problem no 2
01:39:11 Problem no 3
01:44:17 INNER JOIN in SQL
01:52:00 Problem no 4
01:58:33 Problem no 5
01:59:35 GROUP BY in SQL
02:07:32 Problem no 6
02:11:00 Problem no 7
02:21:00 Problem no 8
02:26:40 Problem no 9
02:30:22 Problem no 10
02:39:40 Problem no 11
02:47:52 Problem no 12
02:52:09 Problem no 13
02:54:54 LEFT and RIGHT Outer JOIN
03:03:52 Problem no 14
03:08:12 Problem no 15
03:14:54 Problem no 16
03:18:50 Problem no 17
03:21:49 Problem no 18
03:26:26 Problem no 19
03:29:06 Problem no 20
Thank you for watching!
Subscribe to the channel for more such content.
En esta página del sitio puede ver el video en línea Learn Basic SQL in 3.5 hrs | Complete SQL Beginner Course de Duración hora minuto segunda en buena calidad , que subió el usuario techTFQ 01 enero 1970, comparta el enlace con amigos y conocidos, en youtube este video ya ha sido visto 222,744 veces y le gustó 4.7 mil a los espectadores. Disfruta viendo!
