4.4 GB | 11min 54s | mp4 | 1920X1080 | 16:9
Genre:eLearning |Language:English

Files Included :
1 Course Introduction.mp4 (2.96 MB)
2 Course Curriculum.mp4 (7.63 MB)
1 What is a Database.mp4 (5.72 MB)
2 Relational Databases and SQL.mp4 (10.14 MB)
3 Installing PostgreSQL for Mac.mp4 (68.24 MB)
4 Installing PostgreSQL for Windows.mp4 (64.7 MB)
1 Section Introduction.mp4 (3.7 MB)
2 Database Tables.mp4 (14.7 MB)
3 Data Types Explained.mp4 (25.88 MB)
4 Primary Keys and Foreign Keys.mp4 (10.52 MB)
5 Unique, Not Null and Check Constraints.mp4 (13.05 MB)
6 Creating Our First Table.mp4 (48.78 MB)
7 Creating the Actors Table.mp4 (24.34 MB)
8 Creating a Table with a Foreign Key.mp4 (28.3 MB)
9 Creating the Movie Revenues Table.mp4 (26.98 MB)
10 Creating a Junction Table.mp4 (22.15 MB)
11 Modifying Tables Part 1 Adding Columns.mp4 (37.83 MB)
12 Modifying Tables Part 2 Changing a Columns Data Type.mp4 (21.55 MB)
13 Deleting Tables from a Database.mp4 (13.83 MB)
14 Challenge Data Definition Language.mp4 (3.3 MB)
15 Solution Data Definition Language.mp4 (42.41 MB)
16 Section Summary.mp4 (2.5 MB)
1 Section Introduction.mp4 (1.5 MB)
2 Inserting Data into a Table.mp4 (139.76 MB)
3 Updating Data in a Table.mp4 (39.32 MB)
4 Deleting Data from a Table.mp4 (19.79 MB)
5 Inserting Data into Our Movie Data Database.mp4 (64.48 MB)
6 Challenge Data Manipulation Language.mp4 (2.85 MB)
7 Solution Data Manipulation Language.mp4 (64.42 MB)
8 Section Summary.mp4 (1.29 MB)
1 Section Introduction.mp4 (4.71 MB)
2 Select Queries.mp4 (15.82 MB)
3 Where Clauses.mp4 (52.28 MB)
4 Logical Operators.mp4 (63.7 MB)
5 Challenge 1 Select Queries.mp4 (2.65 MB)
6 Solution 1 Select Queries.mp4 (30.17 MB)
7 In, Not In.mp4 (29.77 MB)
8 Like.mp4 (49.68 MB)
9 Between.mp4 (62.05 MB)
10 Challenge 2 Select Queries.mp4 (3.65 MB)
11 Solution 2 Select Queries.mp4 (42.02 MB)
12 Order By.mp4 (58.2 MB)
13 Limiting the Number of Results.mp4 (63.56 MB)
14 Fetch.mp4 (20.34 MB)
15 Distinct Values.mp4 (49.41 MB)
16 Challenge 3 Select Queries.mp4 (1.73 MB)
17 Solution 3 Select Queries.mp4 (28.2 MB)
18 Null Values.mp4 (34.68 MB)
19 Setting a Column Name Alias.mp4 (65.27 MB)
20 Concatenation.mp4 (35.5 MB)
21 Challenge 4 Select Queries.mp4 (1.86 MB)
22 Solution 4 Select Queries.mp4 (33.95 MB)
23 Section Summary.mp4 (5.55 MB)
1 Section Introduction.mp4 (2.66 MB)
2 Aggregate Functions Explained.mp4 (5.04 MB)
3 Count Aggregate Functions.mp4 (26.86 MB)
4 Sum Aggregate Function.mp4 (20.35 MB)
5 Min and Max Aggregate Functions.mp4 (36.23 MB)
6 Average Aggregate Functions.mp4 (13.75 MB)
7 Challenge 1 Aggregate Functions.mp4 (3.13 MB)
8 Solution 1 Aggregate Functions.mp4 (29.87 MB)
9 Grouping Data.mp4 (93.92 MB)
10 Having Clauses.mp4 (32.7 MB)
11 Challenge 2 Aggregate Functions.mp4 (1.87 MB)
12 Solution 2 Aggregate Functions.mp4 (32.56 MB)
13 Mathematical Operators.mp4 (40.53 MB)
14 Section Summary.mp4 (2.02 MB)
1 Section Introduction.mp4 (2.31 MB)
2 What Are Database Relationships.mp4 (4.13 MB)
3 One to One Relationships.mp4 (9.15 MB)
4 One to Many Relationships.mp4 (10.2 MB)
5 Many to Many Relationships.mp4 (13.78 MB)
6 (Optional) Challenge Database Relationships.mp4 (5.61 MB)
7 Solution Database Relationships.mp4 (14.64 MB)
8 Section Summary.mp4 (1.46 MB)
1 Section Introduction.mp4 (3.29 MB)
2 SQL Joins Explained.mp4 (25.91 MB)
3 Inner Joins Part 1.mp4 (81.06 MB)
4 Inner Joins Part 2.mp4 (39.88 MB)
5 Inner Joins Part 3.mp4 (30.91 MB)
6 Challenge 1 Joins.mp4 (2.7 MB)
7 Solution 1 Joins.mp4 (39.51 MB)
8 Left Joins.mp4 (40.68 MB)
9 Right Joins.mp4 (23.7 MB)
10 Full Joins.mp4 (24.79 MB)
11 Challenge 2 Joins.mp4 (1.44 MB)
12 Solutions 2 Joins.mp4 (46.32 MB)
13 Joining More Than Two Tables.mp4 (98.28 MB)
14 Challenge 3 Joins.mp4 (2.22 MB)
15 Solution 3 Joins.mp4 (70.68 MB)
16 Union.mp4 (84.38 MB)
17 Union All.mp4 (19.23 MB)
18 Challenge 4 Joins.mp4 (1.65 MB)
19 Solution 4 Joins.mp4 (25.46 MB)
20 Intersect.mp4 (19.19 MB)
21 Except.mp4 (20.88 MB)
22 Challenge 5 Joins.mp4 (1.56 MB)
23 Solution 5 Joins.mp4 (27 MB)
24 Section Summary.mp4 (2.15 MB)
1 Section Introduction.mp4 (2.02 MB)
2 Subqueries Explained.mp4 (19.06 MB)
3 Uncorrelated Subqueries Part 1.mp4 (54.77 MB)
4 Uncorrelated Subqueries Part 2.mp4 (47.36 MB)
5 Challenge 1 Subqueries.mp4 (3.83 MB)
6 Solution 1 Subqueries.mp4 (45.89 MB)
7 Correlated Subqueries.mp4 (49.16 MB)
8 Challenge 2 Subqueries.mp4 (2.81 MB)
9 Solution 2 Subqueries.mp4 (54.8 MB)
10 Summary.mp4 (1.91 MB)
1 Section Introduction.mp4 (4.09 MB)
2 Cloning a Database.mp4 (18.29 MB)
3 Upper and Lower String Functions.mp4 (32.36 MB)
4 Initcap Function.mp4 (20.98 MB)
5 Left and Right String Functions.mp4 (44.39 MB)
6 Reverse Function.mp4 (11.62 MB)
7 Challenge 1 String Functions.mp4 (2.96 MB)
8 Solution 1 String Functions.mp4 (196.77 MB)
9 Substring Function.mp4 (34.11 MB)
10 Replace Function.mp4 (77.3 MB)
11 Split Part Function.mp4 (59.14 MB)
12 Using the Cast Operator to Apply String Functions to Non-String Data Types.mp4 (29.53 MB)
13 Challenge 2 String Functions.mp4 (2.27 MB)
14 Solution 2 String Functions.mp4 (48.68 MB)
15 Summary.mp4 (2.28 MB)
1 Section Introduction.mp4 (1.86 MB)
2 Conditional Statements in SQL.mp4 (18.91 MB)
3 Basic CASE Expressions.mp4 (24.09 MB)
4 Order of WHEN Clauses in CASE Expressions.mp4 (24.06 MB)
5 Challenge 1 Conditional Statements and Functions.mp4 (1.9 MB)
6 Solution 1 Conditional Statements and Functions.mp4 (42.87 MB)
7 Case Expressions with Aggregate Functions.mp4 (39.37 MB)
8 Further Case Expressions with Aggregate Functions.mp4 (20.04 MB)
9 Challenge 2 Conditional Statements and Functions.mp4 (2.79 MB)
10 Solution 2 Conditional Statements and Functions.mp4 (27.5 MB)
11 COALESCE Function.mp4 (21.25 MB)
12 NULLIF Function.mp4 (15.81 MB)
13 Challenge 3 Conditional Statements and Functions.mp4 (2.38 MB)
14 Solution 3 Conditional Statements and Functions.mp4 (25.9 MB)
15 GREATEST and LEAST Functions.mp4 (23.81 MB)
16 Summary.mp4 (2.13 MB)
1 Section Introduction.mp4 (1.68 MB)
2 Window Functions Explained.mp4 (7.3 MB)
3 Basic Window Functions.mp4 (79.91 MB)
4 Multiple Window Functions.mp4 (41.82 MB)
5 Running Totals Using Window Functions.mp4 (19.59 MB)
6 Challenge 1 Window Functions.mp4 (2.11 MB)
7 Solution 1 Window Functions.mp4 (58.69 MB)
8 ROW NUMBER Function.mp4 (27.79 MB)
9 RANK and DENSE RANK Functions.mp4 (31.97 MB)
10 FIRST VALUE and LAST VALUE Functions.mp4 (46.75 MB)
11 Challenge 2 Window Functions.mp4 (1.44 MB)
12 Solution 2 Window Functions.mp4 (22.44 MB)
13 LAG Function.mp4 (71.83 MB)
14 LEAD Function.mp4 (32.75 MB)
15 NTH VALUE Function.mp4 (35.62 MB)
16 Challenge 3 Window Functions.mp4 (2.24 MB)
17 Solution 3 Window Functions.mp4 (30.13 MB)
18 CUME DIST Function.mp4 (28.83 MB)
19 PERCENT RANK Function.mp4 (21.58 MB)
20 NTILE Function.mp4 (24.75 MB)
21 Challenge 4 Window Functions.mp4 (1.99 MB)
22 Solution 4 Window Functions.mp4 (21.09 MB)
23 Summary.mp4 (3.71 MB)]
Screenshot

RapidGator
NitroFlare
DDownload