6.43 GB | 8min 36s | mp4 | 1280X720 | 16:9
Genre:eLearning |Language:English

Files Included :
1 Welcome!.mp4 (20.44 MB)
11 Installing PostgreSQL & pgAdmin (Windows).mp4 (11.28 MB)
13 Installing PostgreSQL & pgAdmin (MacOS).mp4 (40.06 MB)
14 Setting up the database.mp4 (29.52 MB)
16 The Project.mp4 (22.72 MB)
17 SELECT.mp4 (41.03 MB)
19 Challenge SELECT.mp4 (6.89 MB)
2 How to get the most out of the course.mp4 (35.66 MB)
20 Solution SELECT.mp4 (27.21 MB)
21 ORDER BY.mp4 (39.54 MB)
23 Challenge ORDER BY.mp4 (6.78 MB)
24 Solution ORDER BY.mp4 (22.92 MB)
25 SELECT DISTINCT.mp4 (27.07 MB)
26 Challenge SELECT DISTINCT.mp4 (5.48 MB)
27 Solution SELECT DISTINCT.mp4 (15.62 MB)
28 LIMIT.mp4 (27.83 MB)
3 How this course works.mp4 (26.56 MB)
30 COUNT().mp4 (22.69 MB)
32 Today's challenges.mp4 (33.3 MB)
33 Today's summary.mp4 (34.35 MB)
4 Why learning SQL.mp4 (26.14 MB)
7 What is a database.mp4 (20.44 MB)
9 Different dialects of SQL.mp4 (14.58 MB)
1 WHERE.mp4 (29.73 MB)
11 Challenge WHERE with ANDOR.mp4 (9.35 MB)
12 Solution WHERE with ANDOR.mp4 (23.83 MB)
14 BETWEEN.mp4 (37.46 MB)
16 Challenge BETWEEN.mp4 (4.97 MB)
17 Solution BETWEEN.mp4 (18.49 MB)
18 IN.mp4 (24.44 MB)
20 Challenge IN.mp4 (7.44 MB)
21 Solution IN.mp4 (15.67 MB)
22 LIKE.mp4 (49.58 MB)
24 Challenge LIKE.mp4 (7.6 MB)
25 Solution LIKE.mp4 (37.93 MB)
26 Comments & Aliases.mp4 (44.73 MB)
27 Today's summary.mp4 (29.15 MB)
28 Today's challenges.mp4 (37.52 MB)
3 Challenge WHERE.mp4 (5.87 MB)
4 Solution WHERE.mp4 (22.93 MB)
5 WHERE operators.mp4 (29.9 MB)
7 Challenge WHERE operators.mp4 (8.1 MB)
8 Solution WHERE operators.mp4 (14.51 MB)
9 WHERE with ANDOR.mp4 (48.18 MB)
1 Today's plan.mp4 (9.43 MB)
11 Challenge GROUP BY multiple columns.mp4 (17.61 MB)
12 Solution GROUP BY multiple columns.mp4 (27.86 MB)
13 HAVING.mp4 (24.39 MB)
15 Challenge HAVING.mp4 (18.28 MB)
16 Solution HAVING.mp4 (28.71 MB)
17 Introducing the second project.mp4 (53.22 MB)
2 Aggregate functions.mp4 (33.66 MB)
20 Today's summary.mp4 (14.47 MB)
4 Challenge Aggregate function.mp4 (11.03 MB)
5 GROUP BY.mp4 (33.25 MB)
7 Challenge GROUP BY.mp4 (10.7 MB)
8 Solution GROUP BY.mp4 (21.67 MB)
9 GROUP BY multiple columns.mp4 (23.3 MB)
1 Today's plan.mp4 (12.46 MB)
11 Challenge Concatenate.mp4 (7.21 MB)
12 Solution Concatenate.mp4 (13.29 MB)
13 POSITION.mp4 (24.09 MB)
14 Challenge POSITION.mp4 (8.33 MB)
15 Solution POSITION.mp4 (17.47 MB)
16 SUBSTRING.mp4 (49.98 MB)
17 Challenge SUBSTRING.mp4 (7.21 MB)
18 Solution SUBSTRING.mp4 (37.15 MB)
19 EXTRACT.mp4 (53.34 MB)
2 LENGTH, LOWER & UPPER.mp4 (38.92 MB)
20 Challenge EXTRACT.mp4 (9.46 MB)
21 Solution EXTRACT.mp4 (35.21 MB)
22 TO CHAR.mp4 (56.03 MB)
23 Challenge TO CHAR.mp4 (7.06 MB)
24 Solution TO CHAR.mp4 (35.03 MB)
25 Intervals & Timestamps.mp4 (35.06 MB)
26 Challenge Intervals & Timestamps.mp4 (7.17 MB)
27 Solution Intervals & Timestamps.mp4 (11.92 MB)
4 Challenge LENGTH, LOWER & UPPER.mp4 (6.16 MB)
5 Solution LENGTH, LOWER & UPPER.mp4 (13.28 MB)
6 LEFT & RIGHT.mp4 (25.84 MB)
7 Challenge LEFT & RIGHT.mp4 (6.46 MB)
8 Solution LEFT & RIGHT.mp4 (14.63 MB)
9 Concatenate.mp4 (19.44 MB)
1 Mathematical functions and operators.mp4 (41.79 MB)
10 Solution CASE WHEN.mp4 (54.5 MB)
11 CASE WHEN & SUM.mp4 (49.83 MB)
13 COALESCE.mp4 (24.39 MB)
15 CAST.mp4 (43.66 MB)
16 Challenge CAST & COALESCE.mp4 (7.83 MB)
17 Solution CAST & COALESCE.mp4 (11.5 MB)
18 REPLACE.mp4 (27.95 MB)
3 Challenge Mathematical functions and operators.mp4 (14.64 MB)
4 Solution Mathematical functions and operators.mp4 (27.13 MB)
5 CASE WHEN - Theory.mp4 (43.24 MB)
6 CASE WHEN - Hands-on.mp4 (46.86 MB)
8 3 Challenge CASE WHEN.mp4 (11.8 MB)
1 What are joins.mp4 (21.15 MB)
10 Solution LEFT OUTER JOIN.mp4 (40.17 MB)
11 RIGHT OUTER JOIN.mp4 (32.6 MB)
12 Challenge Joins.mp4 (7.66 MB)
13 Solution Joins.mp4 (29.68 MB)
14 Joins on multiple conditions.mp4 (49.28 MB)
15 Solution Joins on multiple conditions.mp4 (13.99 MB)
16 Joining multiple tables.mp4 (36.97 MB)
17 Joining multiple tables - Practice.mp4 (42.25 MB)
18 Challenge Joining multiple tables.mp4 (3.76 MB)
19 Solution Joining multiple tables.mp4 (36.76 MB)
2 INNER JOIN - Theory.mp4 (71.31 MB)
3 INNER JOIN - Practice.mp4 (55.18 MB)
4 Challenge INNER JOIN.mp4 (2.78 MB)
6 FULL OUTER JOIN.mp4 (46.35 MB)
7 JOIN & WHERE.mp4 (26.52 MB)
8 LEFT OUTER JOIN.mp4 (43.95 MB)
9 Challenge LEFT OUTER JOIN.mp4 (10.65 MB)
1 UNION.mp4 (48.45 MB)
10 Solution Subqueries in FROM.mp4 (15.12 MB)
11 Subqueries in SELECT.mp4 (27.36 MB)
12 Challenge Subqueries in SELECT.mp4 (4.4 MB)
13 Solution Subqueries in SELECT.mp4 (11 MB)
14 Correlated Subqueries in WHERE.mp4 (60.39 MB)
15 Challenge Correlated subqueries in WHERE.mp4 (6.19 MB)
16 Solution Correlated subqueries in WHERE.mp4 (18.74 MB)
17 Correlated Subquery in SELECT.mp4 (30.1 MB)
18 More challenges Correlated subqueres.mp4 (16.44 MB)
19 Solution More challenges.mp4 (66.33 MB)
2 UNION - Practice.mp4 (36.03 MB)
3 Subqueries in WHERE.mp4 (41.32 MB)
4 Challenge Subqueries in WHERE.mp4 (6.8 MB)
5 Solution Subqueries in WHERE.mp4 (31.26 MB)
6 More challenges Subqueries in WHERE.mp4 (9.18 MB)
7 Solution More challenges.mp4 (40.37 MB)
8 Subqueries in FROM.mp4 (24.45 MB)
9 Challenge Subqueries in FROM.mp4 (2.89 MB)
1 Project Introduction.mp4 (49.9 MB)
10 Solution 7.mp4 (19.73 MB)
11 Solution 8.mp4 (12.05 MB)
12 Solution 9.mp4 (24.93 MB)
13 Solution 10.mp4 (27.38 MB)
14 Solution 11.mp4 (19.35 MB)
15 Solution 12.mp4 (39.65 MB)
16 Solution 13.mp4 (55.78 MB)
17 Solution 14.mp4 (43 MB)
4 Solution 1.mp4 (8.36 MB)
5 Solution 2.mp4 (24.15 MB)
6 Solution 3.mp4 (22.71 MB)
7 Solution 4.mp4 (9.87 MB)
8 Solution 5.mp4 (21.49 MB)
9 Solution 6.mp4 (22.38 MB)
1 Managing databases & tables.mp4 (22.82 MB)
10 CREATE TABLE.mp4 (46.56 MB)
12 INSERT.mp4 (32.52 MB)
14 ALTER TABLE.mp4 (18.92 MB)
15 Challenge ALTER TABLE.mp4 (16.65 MB)
16 Solution ALTER TABLE.mp4 (42.7 MB)
17 TRUNCATE & DROP TABLE.mp4 (27.94 MB)
18 CHECK.mp4 (36.03 MB)
19 Challenge CHECK.mp4 (12.98 MB)
2 CREATE DATABASE.mp4 (29.22 MB)
20 Solution CHECK.mp4 (52.13 MB)
4 Data Types.mp4 (61.44 MB)
6 Constraints.mp4 (30.76 MB)
8 Primary Key & Foreign Key.mp4 (30.07 MB)
1 UPDATE.mp4 (33.66 MB)
10 CREATE VIEW.mp4 (40.05 MB)
13 CREATE MATERIALIZED VIEW.mp4 (33.81 MB)
14 Managing views.mp4 (16.95 MB)
17 Import & Export.mp4 (67.51 MB)
2 Challenge UPDATE.mp4 (5.47 MB)
3 Solution UPDATE.mp4 (26.01 MB)
4 DELETE.mp4 (35.73 MB)
5 Challenge DELETE.mp4 (4.48 MB)
6 Solution DELETE.mp4 (9.41 MB)
7 CREATE TABLE AS.mp4 (22.74 MB)
8 Challenge CREATE TABLE AS.mp4 (4.3 MB)
9 Solution CREATE TABLE AS.mp4 (21.32 MB)
1 OVER() with PARTITION BY.mp4 (70.86 MB)
10 FIRST VALUE().mp4 (26.59 MB)
11 LEAD & LAG.mp4 (33.15 MB)
12 Challenge LEAD & LAG.mp4 (6.12 MB)
13 Solution LEAD & LAG.mp4 (34.38 MB)
2 Challenge OVER() with PARTITION BY.mp4 (10.49 MB)
3 Solution OVER() with PARTITION BY.mp4 (31.8 MB)
4 OVER() with ORDER BY.mp4 (48.11 MB)
5 Challenge OVER() with ORDER BY.mp4 (7.28 MB)
6 Solution OVER() with ORDER BY.mp4 (13.43 MB)
7 RANK().mp4 (51.87 MB)
8 Challenge RANK().mp4 (7.48 MB)
9 Solution RANK().mp4 (21.95 MB)
1 GROUPING SETS.mp4 (45.25 MB)
12 Self joins.mp4 (54.24 MB)
13 Challenge Self joins.mp4 (6.19 MB)
14 Solution Self joins.mp4 (20.7 MB)
15 CROSS JOIN.mp4 (28.45 MB)
16 NATURAL JOIN.mp4 (35.22 MB)
2 Challenge GROUPING SETS.mp4 (3.43 MB)
3 Solution GROUPING SETS.mp4 (12.13 MB)
4 Additional challenge.mp4 (4.37 MB)
5 Solution Additional Challenge.mp4 (21.58 MB)
6 ROLLUP.mp4 (52.19 MB)
7 Challenge ROLLUP.mp4 (8.65 MB)
8 Solution ROLLUP.mp4 (22.29 MB)
9 CUBE.mp4 (34.18 MB)
1 User-defined functions.mp4 (39.29 MB)
10 Challenge Stored procedures.mp4 (8 MB)
11 Solution Stored procedure.mp4 (29.66 MB)
2 User-defined functions - Example.mp4 (29.08 MB)
3 Challenge User-defined functions.mp4 (3.81 MB)
4 Solution.mp4 (32.65 MB)
5 Transactions.mp4 (41.28 MB)
6 Challenge Transactions.mp4 (4.05 MB)
7 Solution Transactions.mp4 (32.18 MB)
8 Rollbacks.mp4 (35.18 MB)
9 Stored procedures.mp4 (60.2 MB)
1 User management.mp4 (20.73 MB)
10 Indexes - Guidelines.mp4 (28.32 MB)
11 Creating indexes.mp4 (48.72 MB)
13 Execution plan & query performance.mp4 (71.26 MB)
2 CREATE USER ROLE.mp4 (50.34 MB)
3 GRANT & REVOKE privileges.mp4 (48.28 MB)
4 Privileges - Hands-on.mp4 (68.61 MB)
7 What are indexes.mp4 (33.45 MB)
8 B-Tree index.mp4 (22.27 MB)
9 Bitmap index.mp4 (23.75 MB)
10 Recursive CTEs - Hierarchical Data.mp4 (54.6 MB)
11 Recursive CTEs - Termination Condition.mp4 (43.19 MB)
2 Common Table Expressions (CTEs) - First Example.mp4 (48.22 MB)
3 Common Table Expressions - More Complex Example.mp4 (49 MB)
6 Common Table Expressions - Using Multiple CTEs.mp4 (81.15 MB)
9 Recursive CTEs - Concept.mp4 (35.05 MB)]
Screenshot