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

NitroFlare

https://nitroflare.com/view/93CD0A44331F8F6/
https://nitroflare.com/view/97F617F3CC09B8C/
https://nitroflare.com/view/6D1DF7B83476710/
https://nitroflare.com/view/432847BEA76F830/

DDownload

https://ddownload.com/k0z3rnz8nri0
https://ddownload.com/vre9q5up9yhz
https://ddownload.com/44oriwzllvsg
https://ddownload.com/225g9rp60rtk