1 - Course Introduction.mp4 (12.66 MB)
MP4
2 - Course Curriculum.mp4 (21.88 MB)
MP4
111 - Section Introduction.mp4 (4.09 MB)
MP4
112 - Cloning a Database.mp4 (18.29 MB)
MP4
113 - Upper and Lower String Functions.mp4 (32.36 MB)
MP4
114 - Initcap Function.mp4 (20.98 MB)
MP4
115 - Left and Right String Functions.mp4 (44.39 MB)
MP4
116 - Reverse Function.mp4 (11.62 MB)
MP4
117 - Challenge 1 String Functions.mp4 (2.96 MB)
MP4
118 - Solution 1 String Functions.mp4 (196.77 MB)
MP4
119 - Substring Function.mp4 (34.11 MB)
MP4
120 - Replace Function.mp4 (77.3 MB)
MP4
121 - Split Part Function.mp4 (59.14 MB)
MP4
122 - Using the Cast Operator to Apply String Functions to NonString Data Types.mp4 (29.53 MB)
MP4
123 - Challenge 2 String Functions.mp4 (2.27 MB)
MP4
124 - Solution 2 String Functions.mp4 (48.68 MB)
MP4
125 - Summary.mp4 (2.28 MB)
MP4
4 - What is a Database.mp4 (5.72 MB)
MP4
5 - Relational Databases and SQL.mp4 (10.14 MB)
MP4
6 - Installing PostgreSQL for Mac.mp4 (68.24 MB)
MP4
7 - Installing PostgreSQL for Windows.mp4 (64.7 MB)
MP4
10 - Data Types Explained.mp4 (25.88 MB)
MP4
11 - Primary Keys and Foreign Keys.mp4 (10.52 MB)
MP4
12 - Unique Not Null and Check Constraints.mp4 (13.05 MB)
MP4
13 - Creating Our First Table.mp4 (48.78 MB)
MP4
14 - Creating the Actors Table.mp4 (24.34 MB)
MP4
15 - Creating a Table with a Foreign Key.mp4 (28.3 MB)
MP4
16 - Creating the Movie Revenues Table.mp4 (26.98 MB)
MP4
17 - Creating a Junction Table.mp4 (22.15 MB)
MP4
18 - Modifying Tables Part 1 Adding Columns.mp4 (37.83 MB)
MP4
19 - Modifying Tables Part 2 Changing a Columns Data Type.mp4 (21.55 MB)
MP4
20 - Deleting Tables from a Database.mp4 (13.83 MB)
MP4
21 - Challenge Data Definition Language.mp4 (3.3 MB)
MP4
22 - Solution Data Definition Language.mp4 (42.41 MB)
MP4
23 - Section Summary.mp4 (2.5 MB)
MP4
8 - Section Introduction.mp4 (3.7 MB)
MP4
9 - Database Tables.mp4 (14.7 MB)
MP4
24 - Section Introduction.mp4 (1.5 MB)
MP4
25 - Inserting Data into a Table.mp4 (139.76 MB)
MP4
26 - Updating Data in a Table.mp4 (39.32 MB)
MP4
27 - Deleting Data from a Table.mp4 (19.79 MB)
MP4
28 - Inserting Data into Our Movie Data Database.mp4 (64.48 MB)
MP4
29 - Challenge Data Manipulation Language.mp4 (2.85 MB)
MP4
30 - Solution Data Manipulation Language.mp4 (64.42 MB)
MP4
31 - Section Summary.mp4 (1.29 MB)
MP4
32 - Section Introduction.mp4 (4.71 MB)
MP4
33 - Select Queries.mp4 (15.82 MB)
MP4
34 - Where Clauses.mp4 (52.28 MB)
MP4
35 - Logical Operators.mp4 (63.7 MB)
MP4
36 - Challenge 1 Select Queries.mp4 (2.65 MB)
MP4
37 - Solution 1 Select Queries.mp4 (30.17 MB)
MP4
38 - In Not In.mp4 (29.77 MB)
MP4
39 - Like.mp4 (49.68 MB)
MP4
40 - Between.mp4 (62.05 MB)
MP4
41 - Challenge 2 Select Queries.mp4 (3.65 MB)
MP4
42 - Solution 2 Select Queries.mp4 (42.02 MB)
MP4
43 - Order By.mp4 (58.2 MB)
MP4
44 - Limiting the Number of Results.mp4 (63.56 MB)
MP4
45 - Fetch.mp4 (20.34 MB)
MP4
46 - Distinct Values.mp4 (49.41 MB)
MP4
47 - Challenge 3 Select Queries.mp4 (1.73 MB)
MP4
48 - Solution 3 Select Queries.mp4 (28.2 MB)
MP4
49 - Null Values.mp4 (34.68 MB)
MP4
50 - Setting a Column Name Alias.mp4 (65.27 MB)
MP4
51 - Concatenation.mp4 (35.5 MB)
MP4
52 - Challenge 4 Select Queries.mp4 (1.86 MB)
MP4
53 - Solution 4 Select Queries.mp4 (33.95 MB)
MP4
54 - Section Summary.mp4 (5.55 MB)
MP4
55 - Section Introduction.mp4 (2.66 MB)
MP4
56 - Aggregate Functions Explained.mp4 (5.04 MB)
MP4
57 - Count Aggregate Functions.mp4 (26.86 MB)
MP4
58 - Sum Aggregate Function.mp4 (20.35 MB)
MP4
59 - Min and Max Aggregate Functions.mp4 (36.23 MB)
MP4
60 - Average Aggregate Functions.mp4 (13.75 MB)
MP4
61 - Challenge 1 Aggregate Functions.mp4 (3.13 MB)
MP4
62 - Solution 1 Aggregate Functions.mp4 (29.87 MB)
MP4
63 - Grouping Data.mp4 (93.92 MB)
MP4
64 - Having Clauses.mp4 (32.7 MB)
MP4
65 - Challenge 2 Aggregate Functions.mp4 (1.87 MB)
MP4
66 - Solution 2 Aggregate Functions.mp4 (32.56 MB)
MP4
67 - Mathematical Operators.mp4 (40.53 MB)
MP4
68 - Section Summary.mp4 (2.02 MB)
MP4
69 - Section Introduction.mp4 (2.31 MB)
MP4
70 - What Are Database Relationships.mp4 (4.13 MB)
MP4
71 - One to One Relationships.mp4 (9.15 MB)
MP4
72 - One to Many Relationships.mp4 (10.2 MB)
MP4
73 - Many to Many Relationships.mp4 (13.78 MB)
MP4
74 - Optional Challenge Database Relationships.mp4 (5.61 MB)
MP4
75 - Solution Database Relationships.mp4 (14.64 MB)
MP4
76 - Section Summary.mp4 (1.46 MB)
MP4
100 - Section Summary.mp4 (2.15 MB)
MP4
77 - Section Introduction.mp4 (3.29 MB)
MP4
78 - SQL Joins Explained.mp4 (25.91 MB)
MP4
79 - Inner Joins Part 1.mp4 (81.06 MB)
MP4
80 - Inner Joins Part 2.mp4 (39.88 MB)
MP4
81 - Inner Joins Part 3.mp4 (30.91 MB)
MP4
82 - Challenge 1 Joins.mp4 (2.7 MB)
MP4
83 - Solution 1 Joins.mp4 (39.51 MB)
MP4
84 - Left Joins.mp4 (40.68 MB)
MP4
85 - Right Joins.mp4 (23.7 MB)
MP4
86 - Full Joins.mp4 (24.79 MB)
MP4
87 - Challenge 2 Joins.mp4 (1.44 MB)
MP4
88 - Solutions 2 Joins.mp4 (46.32 MB)
MP4
89 - Joining More Than Two Tables.mp4 (98.28 MB)
MP4
90 - Challenge 3 Joins.mp4 (2.22 MB)
MP4
91 - Solution 3 Joins.mp4 (70.68 MB)
MP4
92 - Union.mp4 (84.38 MB)
MP4
93 - Union All.mp4 (19.23 MB)
MP4
94 - Challenge 4 Joins.mp4 (1.65 MB)
MP4
95 - Solution 4 Joins.mp4 (25.46 MB)
MP4
96 - Intersect.mp4 (19.19 MB)
MP4
97 - Except.mp4 (20.88 MB)
MP4
98 - Challenge 5 Joins.mp4 (1.56 MB)
MP4
99 - Solution 5 Joins.mp4 (27 MB)
MP4
101 - Section Introduction.mp4 (2.02 MB)
MP4
102 - Subqueries Explained.mp4 (19.06 MB)
MP4
103 - Uncorrelated Subqueries Part 1.mp4 (54.77 MB)
MP4
104 - Uncorrelated Subqueries Part 2.mp4 (47.36 MB)
MP4
105 - Challenge 1 Subqueries.mp4 (3.83 MB)
MP4
106 - Solution 1 Subqueries.mp4 (45.89 MB)
MP4
107 - Correlated Subqueries.mp4 (49.16 MB)
MP4
108 - Challenge 2 Subqueries.mp4 (2.81 MB)
MP4
109 - Solution 2 Subqueries.mp4 (54.8 MB)
MP4
110 - Summary.mp4 (1.91 MB)
MP4