Course Content
Subtitle Guide – Hướng dẫn thêm phụ đề
0/1
Set up subtitle for video – Hướng dẫn thêm phụ đề
01 – Course Introduction
0/12
Download Resource Files
002 Introduction
02:15
003 Course Curriculum Overview
01:41
004 Overview of Databases
07:37
006 Windows Installation – PostGreSQL and PgAdmin with Database Setup_part1
07:03
006 Windows Installation – PostGreSQL and PgAdmin with Database Setup_part2
07:03
006 Windows Installation – PostGreSQL and PgAdmin with Database Setup_part3
07:03
007 MacOS Installation – PostgreSQL and PgAdmin with First Query_part1
07:42
007 MacOS Installation – PostgreSQL and PgAdmin with First Query_part2
07:42
007 MacOS Installation – PostgreSQL and PgAdmin with First Query_part3
07:42
008 pgAdmin Overview_part1
04:52
008 pgAdmin Overview_part2
04:52
02 – SQL Statement Fundamentals
0/18
Download Resource Files
001 Overview of Challenges!
01:36
003 SQL Statement Fundamentals
00:42
004 SELECT Statement
08:40
005 Challenge SELECT
04:29
006 SELECT DISTINCT
05:38
007 Challenge SELECT DISTINCT
01:54
008 COUNT
07:23
009 SELECT WHERE – Part One
04:30
010 SELECT WHERE – Part Two
07:04
011 Challenge SELECT WHERE
05:35
012 ORDER BY
08:11
013 LIMIT
05:06
014 Challenge ORDER BY
05:01
015 BETWEEN
06:57
016 IN
04:55
017 LIKE and ILIKE
09:36
018 General Challenge 1
09:54
03 – GROUP BY Statements
0/8
Download Resource Files
001 Introduction to GROUP BY
00:57
002 Aggregation Functions
07:59
003 GROUP BY – Part One
07:48
004 GROUP BY – Part Two
10:42
005 GROUP BY – Challenge
04:05
006 HAVING
06:25
007 HAVING – Challenge Tasks
02:48
04 – Assessment Test 1
0/2
Download Resource Files
001 Overview of Assessment Test 1
01:08
05 – JOINS
0/9
Download Resource Files
002 Introduction to JOINs
01:14
003 AS Statement
07:48
004 Inner Joins
14:49
005 Full Outer Joins
14:22
006 Left Outer Join
11:18
007 Right Joins
04:21
008 UNION
02:27
009 JOIN Challenge Tasks
12:15
06 – Advanced SQL Commands
0/10
Download Resource Files
001 Overview of Advanced SQL Commands
00:47
002 Timestamps and Extract – Part One
07:38
003 Timestamps and Extract – Part Two
10:06
005 Timestamps and Extract – Challenge Tasks
03:39
006 Mathematical Functions and Operators
05:00
007 String Functions and Operators
08:24
008 SubQuery_part1
07:35
008 SubQuery_part2
07:35
009 Self-Join
10:55
07 – Assessment Test 2
0/5
Download Resource Files
002 Setting up New Database for Assessment Exercises
07:26
004 Solutions to Assessment Test 2_part1
07:55
004 Solutions to Assessment Test 2_part2
07:55
004 Solutions to Assessment Test 2_part3
07:55
08 – Creating Databases and Tables
0/13
Download Resource Files
001 Introduction to Section
01:12
002 Data Types
06:27
003 Primary Keys and Foreign Keys
09:04
004 Constraints
05:17
005 CREATE Table_part1
09:14
005 CREATE Table_part2
09:14
006 INSERT
09:05
007 UPDATE
07:58
008 DELETE
03:12
009 ALTER Table
06:47
010 DROP Table
03:18
011 CHECK Constraint
07:04
09 – Assessment Test 3
0/1
Download Resource Files
10 – Conditional Expressions and Procedures
0/10
Download Resource Files
001 Conditional Expressions and Procedures Introduction
00:43
002 CASE_part1
11:19
002 CASE_part2
11:19
003 CASE – Challenge Task
03:09
004 COALESCE
05:35
005 CAST
07:07
006 NULLIF
10:34
007 Views
07:07
008 Import and Export
13:30
11 – Extra PostGreSQL with Python
0/2
Download Resource Files
002 Psycopg2 Example Usage
10:24
12 – BONUS SECTION THANK YOU!
0/1
Download Resource Files
The Complete SQL Bootcamp: Go from Zero to Hero
About Lesson

Please follow the instructions at the following link to add subtitles 

[ Các bạn làm theo chỉ dẫn ở link sau để thêm phụ đề cho bài giảng]

 

Set up Subtitle for video

 

Join the conversation
Previous
Next

Please contact me via telegram

DMCA.com Protection Status