Udemy 15 Days of SQL The Complete SQL Masterclass 2024

Files Included :

001 How to get the most out of the course.mp4 (33.66 MB)
MP4
002 Why learning SQL.mp4 (24.82 MB)
MP4
004 What is a database.mp4 (10.54 MB)
MP4
006 Different dialects of SQL.mp4 (6.07 MB)
MP4
008 Installing PostgreSQL & pgAdmin (Windows).mp4 (35.61 MB)
MP4
009 Installing PostgreSQL & pgAdmin (MacOS).mp4 (30.99 MB)
MP4
010 pagila-master.zip (685.17 KB)
ZIP
010 Setting up the database.mp4 (12.88 MB)
MP4
013 The Project.mp4 (21.58 MB)
MP4
014 SELECT.mp4 (32.11 MB)
MP4
015 Challenge SELECT.mp4 (3.41 MB)
MP4
016 Solution SELECT.mp4 (13.62 MB)
MP4
017 ORDER BY.mp4 (22.63 MB)
MP4
018 Challenge ORDER BY.mp4 (2.87 MB)
MP4
019 Solution ORDER BY.mp4 (11.5 MB)
MP4
020 SELECT DISTINCT.mp4 (13.53 MB)
MP4
021 Challenge SELECT DISTINCT.mp4 (2.38 MB)
MP4
022 Solution SELECT DISTINCT.mp4 (7.97 MB)
MP4
023 LIMIT.mp4 (13.59 MB)
MP4
024 COUNT().mp4 (13.27 MB)
MP4
025 Today's challenges.mp4 (15.3 MB)
MP4
026 Today's summary.mp4 (19.4 MB)
MP4
001 WHERE.mp4 (27.66 MB)
MP4
002 Challenge WHERE.mp4 (2.83 MB)
MP4
003 Solution WHERE.mp4 (11.99 MB)
MP4
004 WHERE operators.mp4 (12.09 MB)
MP4
005 Challenge WHERE operators.mp4 (3.51 MB)
MP4
006 Solution WHERE operators.mp4 (7.3 MB)
MP4
007 WHERE with ANDOR.mp4 (23.99 MB)
MP4
008 Challenge WHERE with ANDOR.mp4 (4.69 MB)
MP4
009 Solution WHERE with ANDOR.mp4 (13.45 MB)
MP4
011 BETWEEN.mp4 (18.18 MB)
MP4
012 Challenge BETWEEN.mp4 (2.64 MB)
MP4
013 Solution BETWEEN.mp4 (7.91 MB)
MP4
014 IN.mp4 (11.93 MB)
MP4
015 Challenge IN.mp4 (3.28 MB)
MP4
016 Solution IN.mp4 (6.14 MB)
MP4
017 LIKE.mp4 (24.15 MB)
MP4
018 Challenge LIKE.mp4 (3.53 MB)
MP4
019 Solution LIKE.mp4 (20.85 MB)
MP4
020 Comments & Aliases.mp4 (25.99 MB)
MP4
021 Today's summary.mp4 (12.47 MB)
MP4
022 Today's challenges.mp4 (15.55 MB)
MP4
001 Today's plan.mp4 (3.69 MB)
MP4
002 Aggregate functions.mp4 (17.86 MB)
MP4
003 Challenge Aggregate function.mp4 (5.16 MB)
MP4
004 GROUP BY.mp4 (17.1 MB)
MP4
005 Challenge GROUP BY.mp4 (4.39 MB)
MP4
006 Solution GROUP BY.mp4 (9.17 MB)
MP4
007 GROUP BY multiple columns.mp4 (11.18 MB)
MP4
008 Challenge GROUP BY multiple columns.mp4 (7.02 MB)
MP4
009 Solution GROUP BY multiple columns.mp4 (13.03 MB)
MP4
010 HAVING.mp4 (10.02 MB)
MP4
011 Challenge HAVING.mp4 (10.47 MB)
MP4
012 Solution HAVING.mp4 (11.1 MB)
MP4
013 flight-database.zip (21.49 MB)
ZIP
013 Introducing the second project.mp4 (46.76 MB)
MP4
016 Today's summary.mp4 (6.25 MB)
MP4
001 Today's plan.mp4 (4.28 MB)
MP4
002 LENGTH, LOWER & UPPER.mp4 (17.02 MB)
MP4
003 Challenge LENGTH, LOWER & UPPER.mp4 (2.54 MB)
MP4
004 Solution LENGTH, LOWER & UPPER.mp4 (5.09 MB)
MP4
005 LEFT & RIGHT.mp4 (10.22 MB)
MP4
006 Challenge LEFT & RIGHT.mp4 (2.84 MB)
MP4
007 Solution LEFT & RIGHT.mp4 (7.96 MB)
MP4
008 Concatenate.mp4 (7.59 MB)
MP4
009 Challenge Concatenate.mp4 (2.87 MB)
MP4
010 Solution Concatenate.mp4 (6.77 MB)
MP4
011 POSITION.mp4 (9.35 MB)
MP4
012 Challenge POSITION.mp4 (3.29 MB)
MP4
013 Solution POSITION.mp4 (8.52 MB)
MP4
014 SUBSTRING.mp4 (47.07 MB)
MP4
015 Challenge SUBSTRING.mp4 (3.07 MB)
MP4
016 Solution SUBSTRING.mp4 (15.62 MB)
MP4
017 EXTRACT.mp4 (48.45 MB)
MP4
018 Challenge EXTRACT.mp4 (3.91 MB)
MP4
019 Solution EXTRACT.mp4 (13.84 MB)
MP4
020 TO CHAR.mp4 (53.56 MB)
MP4
021 Challenge TO CHAR.mp4 (3.47 MB)
MP4
022 Solution TO CHAR.mp4 (31.38 MB)
MP4
023 Intervals & Timestamps.mp4 (13.39 MB)
MP4
024 Challenge Intervals & Timestamps.mp4 (3.12 MB)
MP4
025 Solution Intervals & Timestamps.mp4 (5.53 MB)
MP4
001 Mathematical functions and operators.mp4 (37.22 MB)
MP4
002 Challenge Mathematical functions and operators.mp4 (5.58 MB)
MP4
003 Solution Mathematical functions and operators.mp4 (10.5 MB)
MP4
004 CASE WHEN - Theory.mp4 (18.19 MB)
MP4
005 CASE WHEN - Hands-on.mp4 (17.69 MB)
MP4
006 3 Challenge CASE WHEN.mp4 (11.77 MB)
MP4
008 Solution CASE WHEN.mp4 (41.48 MB)
MP4
009 CASE WHEN & SUM.mp4 (23.9 MB)
MP4
010 COALESCE.mp4 (22.81 MB)
MP4
011 CAST.mp4 (24.94 MB)
MP4
012 Challenge CAST & COALESCE.mp4 (2.82 MB)
MP4
013 Solution CAST & COALESCE.mp4 (3.82 MB)
MP4
014 REPLACE.mp4 (26.35 MB)
MP4
001 What are joins.mp4 (8.31 MB)
MP4
002 INNER JOIN - Theory.mp4 (36.17 MB)
MP4
003 INNER JOIN - Practice.mp4 (23.29 MB)
MP4
004 Challenge INNER JOIN.mp4 (2.14 MB)
MP4
005 Solution INNER JOIN.mp4 (8.54 MB)
MP4
006 FULL OUTER JOIN.mp4 (22.46 MB)
MP4
007 JOIN & WHERE.mp4 (20.45 MB)
MP4
008 LEFT OUTER JOIN.mp4 (24.01 MB)
MP4
009 Challenge LEFT OUTER JOIN.mp4 (4.94 MB)
MP4
010 Solution LEFT OUTER JOIN.mp4 (19.51 MB)
MP4
011 RIGHT OUTER JOIN.mp4 (24.7 MB)
MP4
012 Challenge Joins.mp4 (3.43 MB)
MP4
013 Solution Joins.mp4 (12.82 MB)
MP4
014 Joins on multiple conditions.mp4 (22.97 MB)
MP4
015 Solution Joins on multiple conditions.mp4 (5.36 MB)
MP4
016 Joining multiple tables.mp4 (20.02 MB)
MP4
017 Joining multiple tables - Practice.mp4 (18.57 MB)
MP4
018 Challenge Joining multiple tables.mp4 (1.65 MB)
MP4
019 Solution Joining multiple tables.mp4 (16.13 MB)
MP4
001 UNION.mp4 (26.29 MB)
MP4
002 UNION - Practice.mp4 (14.33 MB)
MP4
003 Subqueries in WHERE.mp4 (15.88 MB)
MP4
004 Challenge Subqueries in WHERE.mp4 (3.48 MB)
MP4
005 Solution Subqueries in WHERE.mp4 (17.84 MB)
MP4
006 More challenges Subqueries in WHERE.mp4 (4.36 MB)
MP4
007 Solution More challenges.mp4 (37.94 MB)
MP4
008 Subqueries in FROM.mp4 (10.28 MB)
MP4
009 Challenge Subqueries in FROM.mp4 (1.42 MB)
MP4
010 Solution Subqueries in FROM.mp4 (5.88 MB)
MP4
011 Subqueries in SELECT.mp4 (10 MB)
MP4
012 Challenge Subqueries in SELECT.mp4 (1.83 MB)
MP4
013 Solution Subqueries in SELECT.mp4 (4.21 MB)
MP4
014 Correlated Subqueries in WHERE.mp4 (32.78 MB)
MP4
015 Challenge Correlated subqueries in WHERE.mp4 (2.78 MB)
MP4
016 Solution Correlated subqueries in WHERE.mp4 (14.96 MB)
MP4
017 Correlated Subquery in SELECT.mp4 (16.28 MB)
MP4
018 More challenges Correlated subqueres.mp4 (7.45 MB)
MP4
019 Solution More challenges.mp4 (27.39 MB)
MP4
001 Project Introduction.mp4 (19.63 MB)
MP4
004 Solution 1.mp4 (3.64 MB)
MP4
005 Solution 2.mp4 (11 MB)
MP4
006 Solution 3.mp4 (20.39 MB)
MP4
007 Solution 4.mp4 (4.91 MB)
MP4
008 Solution 5.mp4 (11.33 MB)
MP4
009 Solution 6.mp4 (9.91 MB)
MP4
010 Solution 7.mp4 (7.83 MB)
MP4
011 Solution 8.mp4 (5.97 MB)
MP4
012 Solution 9.mp4 (12.6 MB)
MP4
013 Solution 10.mp4 (11.11 MB)
MP4
014 Solution 11.mp4 (7.84 MB)
MP4
015 Solution 12.mp4 (18.26 MB)
MP4
016 Solution 13.mp4 (25.93 MB)
MP4
017 Solution 14.mp4 (22.47 MB)
MP4
001 Managing databases & tables.mp4 (10.2 MB)
MP4
002 CREATE DATABASE.mp4 (16.09 MB)
MP4
004 Data Types.mp4 (39.15 MB)
MP4
006 Constraints.mp4 (12.8 MB)
MP4
008 Primary Key & Foreign Key.mp4 (14.45 MB)
MP4
010 CREATE TABLE.mp4 (24.72 MB)
MP4
011 INSERT.mp4 (13.81 MB)
MP4
012 ALTER TABLE.mp4 (18.41 MB)
MP4
013 Challenge ALTER TABLE.mp4 (6.95 MB)
MP4
014 Solution ALTER TABLE.mp4 (32.09 MB)
MP4
015 TRUNCATE & DROP TABLE.mp4 (11.99 MB)
MP4
016 CHECK.mp4 (14.04 MB)
MP4
017 Challenge CHECK.mp4 (4.96 MB)
MP4
018 Solution CHECK.mp4 (47.27 MB)
MP4
001 UPDATE.mp4 (16.56 MB)
MP4
002 Challenge UPDATE.mp4 (2.52 MB)
MP4
003 Solution UPDATE.mp4 (11.49 MB)
MP4
004 DELETE.mp4 (20.77 MB)
MP4
005 Challenge DELETE.mp4 (1.71 MB)
MP4
006 Solution DELETE.mp4 (3.71 MB)
MP4
007 CREATE TABLE AS.mp4 (9.54 MB)
MP4
008 Challenge CREATE TABLE AS.mp4 (1.84 MB)
MP4
009 Solution CREATE TABLE AS.mp4 (10.54 MB)
MP4
010 CREATE VIEW.mp4 (20.42 MB)
MP4
013 CREATE MATERIALIZED VIEW.mp4 (13.31 MB)
MP4
014 Managing views.mp4 (9.97 MB)
MP4
017 Import & Export.mp4 (64.37 MB)
MP4
001 OVER() with PARTITION BY.mp4 (25.56 MB)
MP4
002 Challenge OVER() with PARTITION BY.mp4 (4.47 MB)
MP4
003 Solution OVER() with PARTITION BY.mp4 (24.25 MB)
MP4
004 OVER() with ORDER BY.mp4 (21.5 MB)
MP4
005 Challenge OVER() with ORDER BY.mp4 (3.16 MB)
MP4
006 Solution OVER() with ORDER BY.mp4 (5.47 MB)
MP4
007 RANK().mp4 (23.19 MB)
MP4
008 Challenge RANK().mp4 (2.96 MB)
MP4
009 Solution RANK().mp4 (9.98 MB)
MP4
010 FIRST VALUE().mp4 (11.52 MB)
MP4
011 LEAD & LAG.mp4 (14.85 MB)
MP4
012 Challenge LEAD & LAG.mp4 (2.72 MB)
MP4
013 Solution LEAD & LAG.mp4 (14.75 MB)
MP4
001 GROUPING SETS.mp4 (17.24 MB)
MP4
002 Challenge GROUPING SETS.mp4 (1.49 MB)
MP4
003 Solution GROUPING SETS.mp4 (4.79 MB)
MP4
004 Additional challenge.mp4 (1.96 MB)
MP4
005 Solution Additional Challenge.mp4 (9.63 MB)
MP4
006 ROLLUP.mp4 (26.53 MB)
MP4
007 Challenge ROLLUP.mp4 (4.14 MB)
MP4
008 Solution ROLLUP.mp4 (10.71 MB)
MP4
009 CUBE.mp4 (19.06 MB)
MP4
012 Self joins.mp4 (32.45 MB)
MP4
013 Challenge Self joins.mp4 (2.81 MB)
MP4
014 Solution Self joins.mp4 (8.16 MB)
MP4
015 CROSS JOIN.mp4 (15.86 MB)
MP4
016 NATURAL JOIN.mp4 (20.77 MB)
MP4
001 User-defined functions.mp4 (21.95 MB)
MP4
002 User-defined functions - Example.mp4 (12.94 MB)
MP4
003 Challenge User-defined functions.mp4 (3.6 MB)
MP4
004 Solution.mp4 (13.71 MB)
MP4
005 Transactions.mp4 (21.58 MB)
MP4
006 Challenge Transactions.mp4 (1.84 MB)
MP4
007 Solution Transactions.mp4 (13.73 MB)
MP4
008 Rollbacks.mp4 (20.33 MB)
MP4
009 Stored procedures.mp4 (35.72 MB)
MP4
010 Challenge Stored procedures.mp4 (3.59 MB)
MP4
011 Solution Stored procedure.mp4 (29.56 MB)
MP4
001 User management.mp4 (9.93 MB)
MP4
002 CREATE USER ROLE.mp4 (45.11 MB)
MP4
003 GRANT & REVOKE privileges.mp4 (31.14 MB)
MP4
004 Privileges - Hands-on.mp4 (37.99 MB)
MP4
007 What are indexes.mp4 (14.93 MB)
MP4
008 B-Tree index.mp4 (10.5 MB)
MP4
009 Bitmap index.mp4 (12.97 MB)
MP4
010 Indexes - Guidelines.mp4 (14.22 MB)
MP4
011 Creating indexes.mp4 (38.6 MB)
MP4
012 Execution plan & query performance.mp4 (32.76 MB)
MP4