FreeCourseSite com Udemy 15 Days of SQL The Complete SQL Masterclass 2023

FreeCourseSite com Udemy 15 Days of SQL The Complete SQL Masterclass 2023

Name	[FreeCourseSite.com] Udemy - 15 Days of SQL The Complete SQL Masterclass 2023	DOWNLOAD Copy Link
Total Size	6.1 GB
Total Files	281
Last Seen	2024-10-05 23:42
Hash	B317770FE43DB42B49810E0785094B4F5094BD43

/0. Websites you may like/
[CourseClub.Me].url	0.1 KB
[FreeCourseSite.com].url	0.1 KB
[GigaCourse.Com].url	0.0 KB
/1. Day 1 - Getting started with SQL!/
1. How to get the most out of the course.mp4	35.3 MB
10. Installing PostgreSQL & pgAdmin (MacOS).mp4	40.2 MB
11. Setting up the database.mp4	28.9 MB
11.1 pagila-master.zip	701.6 KB
12. The Project.mp4	22.6 MB
13. SELECT.mp4	40.7 MB
14. Challenge SELECT.mp4	6.9 MB
15. Solution SELECT.mp4	26.4 MB
16. ORDER BY.mp4	38.8 MB
17. Challenge ORDER BY.mp4	6.7 MB
18. Solution ORDER BY.mp4	22.0 MB
19. SELECT DISTINCT.mp4	26.7 MB
2. How this course works.mp4	26.4 MB
20. Challenge SELECT DISTINCT.mp4	5.4 MB
21. Solution SELECT DISTINCT.mp4	15.2 MB
22. LIMIT.mp4	27.4 MB
23. COUNT().mp4	22.4 MB
24. Today's challenges.mp4	33.0 MB
25. Today's summary.mp4	34.3 MB
25.1 Day 1 - Course slides.pdf	2.1 MB
3. Why learning SQL.mp4	26.0 MB
4. Let's get started!.html	0.2 KB
5. What is a database.mp4	20.5 MB
6. Databases.html	0.2 KB
7. Different dialects of SQL.mp4	14.5 MB
8. Dialects of SQL.html	0.2 KB
9. Installing PostgreSQL & pgAdmin (Windows).mp4	37.3 MB
/10. Day 10 - Advanced Views & Data Manipulation/
1. UPDATE.mp4	33.0 MB
10. CREATE VIEW.mp4	39.6 MB
11. Challenge CREATE VIEW.html	0.3 KB
12. Solution CREATE VIEW.html	0.3 KB
13. CREATE MATERIALIZED VIEW.mp4	33.2 MB
14. Managing views.mp4	16.9 MB
15. Challenge Managing views.html	0.8 KB
16. Solution Managing views.html	1.0 KB
17. Import & Export.mp4	66.2 MB
18. Today's slides.html	0.3 KB
18.1 Day 10 - Course slides.pdf	891.6 KB
2. Challenge UPDATE.mp4	5.4 MB
3. Solution UPDATE.mp4	25.5 MB
4. DELETE.mp4	35.2 MB
5. Challenge DELETE.mp4	4.4 MB
6. Solution DELETE.mp4	9.2 MB
7. CREATE TABLE AS.mp4	22.4 MB
8. Challenge CREATE TABLE AS.mp4	4.2 MB
9. Solution CREATE TABLE AS.mp4	20.8 MB
/11. Day 11 - Pro Window Functions/
1. OVER() with PARTITION BY.mp4	69.8 MB
10. FIRST_VALUE().mp4	26.1 MB
11. LEAD & LAG.mp4	32.4 MB
12. Challenge LEAD & LAG.mp4	6.0 MB
13. Solution LEAD & LAG.mp4	33.8 MB
14. Additional challenge.mp4	4.3 MB
15. Solution Additional Challenge.mp4	21.2 MB
16. Today's slides.html	0.2 KB
16.1 Day 11 - Course slides.pdf	728.3 KB
2. Challenge OVER() with PARTITION BY.mp4	10.3 MB
3. Solution OVER() with PARTITION BY.mp4	31.1 MB
4. OVER() with ORDER BY.mp4	47.0 MB
5. Challenge OVER() with ORDER BY.mp4	7.2 MB
6. Solution OVER() with ORDER BY.mp4	13.1 MB
7. RANK().mp4	51.0 MB
8. Challenge RANK().mp4	7.4 MB
9. Solution RANK().mp4	21.5 MB
/12. Day 12 - Pro Grouping sets, rollups, self-joins/
1. GROUPING SETS.mp4	44.1 MB
10. Self joins.mp4	53.3 MB
10.1 CreateTable.txt	0.4 KB
11. Challenge Self joins.mp4	6.2 MB
12. Solution Self joins.mp4	20.2 MB
13. CROSS JOIN.mp4	28.0 MB
14. NATURAL JOIN.mp4	34.9 MB
15. Today's slides.html	0.2 KB
15.1 Day 12 - Course slides.pdf	627.5 KB
2. Challenge GROUPING SETS.mp4	3.4 MB
3. Solution GROUPING SETS.mp4	11.9 MB
4. ROLLUP.mp4	51.2 MB
5. Challenge ROLLUP.mp4	8.6 MB
6. Solution ROLLUP.mp4	21.8 MB
7. CUBE.mp4	33.5 MB
8. Challenge CUBE.html	0.4 KB
9. Solution CUBE.html	0.4 KB
/13. Day 13 - Pro Course project/
1. Project introduction.html	1.5 KB
2. The challenges.html	11.8 KB
3. Solutions.html	8.2 KB
/14. Day 14 - Pro Stored procedures, transactions & user-defined functions/
1. User-defined functions.mp4	39.0 MB
10. Challenge Stored procedures.mp4	7.9 MB
11. Solution Stored procedure.mp4	65.3 MB
12. Today's slides.html	0.2 KB
12.1 Day 14 - Course slides.pdf	765.4 KB
2. User-defined functions - Example.mp4	28.2 MB
3. Challenge User-defined functions.mp4	3.8 MB
4. Solution.mp4	31.7 MB
5. Transactions.mp4	40.6 MB
5.1 TRANSACTIONS.txt	0.3 KB
6. Challenge Transactions.mp4	4.0 MB
6.1 Challenge_Transactions.txt	2.9 KB
7. Solution Transactions.mp4	31.6 MB
8. Rollbacks.mp4	34.7 MB
9. Stored procedures.mp4	59.2 MB
/15. Day 15 - Pro Indexes, Partitining & Query Optimization/
1. User management.mp4	20.7 MB
10. Indexes - Guidelines.mp4	28.3 MB
11. Creating indexes.mp4	47.9 MB
12. Creating indexes.html	0.2 KB
13. Execution plan & query performance.mp4	69.6 MB
14. Today's slides.html	0.4 KB
14.1 Day 15 - Course slides.pdf	1.0 MB
2. CREATE USER ROLE.mp4	49.6 MB
3. GRANT & REVOKE privileges.mp4	47.8 MB
4. Privileges - Hands-on.mp4	67.3 MB
5. Challenge Privileges.html	0.6 KB
6. Solution Privileges.html	0.5 KB
7. What are indexes.mp4	33.3 MB
8. B-Tree index.mp4	22.1 MB
9. Bitmap index.mp4	23.6 MB
/2. Day 2 - Basics Filtering/
1. WHERE.mp4	29.0 MB
10. BETWEEN.mp4	36.6 MB
11. Challenge BETWEEN.mp4	5.0 MB
12. Solution BETWEEN.mp4	17.9 MB
13. IN.mp4	23.7 MB
14. Challenge IN.mp4	7.4 MB
15. Solution IN.mp4	15.2 MB
16. LIKE.mp4	48.7 MB
17. Challenge LIKE.mp4	7.6 MB
18. Solution LIKE.mp4	37.0 MB
19. Comments & Aliases.mp4	43.8 MB
2. Challenge WHERE.mp4	5.8 MB
20. Today's summary.mp4	28.8 MB
20.1 Day 2 - Course slides.pdf	1.1 MB
21. Today's challenges.mp4	37.1 MB
3. Solution WHERE.mp4	22.3 MB
4. WHERE operators.mp4	29.4 MB
5. Challenge WHERE operators.mp4	8.0 MB
6. Solution WHERE operators.mp4	14.2 MB
7. WHERE with ANDOR.mp4	47.4 MB
8. Challenge WHERE with ANDOR.mp4	9.3 MB
9. Solution WHERE with ANDOR.mp4	23.2 MB
/3. Day 3 - Basics Grouping/
1. Today's plan.mp4	9.1 MB
10. HAVING.mp4	24.0 MB
11. Challenge HAVING.mp4	18.0 MB
12. Solution HAVING.mp4	28.0 MB
13. Introducing the second project.mp4	31.2 MB
13.1 flight_database.zip	22.5 MB
14. Today's summary.mp4	14.3 MB
14.1 Day 3 - Course slides.pdf	659.1 KB
2. Aggregate functions.mp4	33.3 MB
3. Challenge Aggregate function.mp4	10.9 MB
4. GROUP BY.mp4	32.8 MB
5. Challenge GROUP BY.mp4	10.6 MB
6. Solution GROUP BY.mp4	21.1 MB
7. GROUP BY multiple columns.mp4	22.6 MB
8. Challenge GROUP BY multiple columns.mp4	17.2 MB
9. Solution GROUP BY multiple columns.mp4	27.1 MB
/4. Day 4 - Intermediate Functions/
1. Today's plan.mp4	12.1 MB
10. Solution Concatenate.mp4	13.0 MB
11. POSITION.mp4	23.5 MB
12. Challenge POSITION.mp4	8.3 MB
13. Solution POSITION.mp4	17.1 MB
14. SUBSTRING.mp4	49.1 MB
15. Challenge SUBSTRING.mp4	7.1 MB
16. Solution SUBSTRING.mp4	36.2 MB
17. EXTRACT.mp4	52.4 MB
18. Challenge EXTRACT.mp4	9.3 MB
19. Solution EXTRACT.mp4	34.3 MB
2. LENGTH, LOWER & UPPER.mp4	37.8 MB
20. TO_CHAR.mp4	55.0 MB
21. Challenge TO_CHAR.mp4	7.0 MB
22. Solution TO_CHAR.mp4	34.6 MB
23. Intervals & Timestamps.mp4	34.1 MB
24. Challenge Intervals & Timestamps.mp4	7.0 MB
25. Solution Intervals & Timestamps.mp4	11.6 MB
26. Today's slides.html	0.2 KB
26.1 Day 4 - Course slides.pdf	761.3 KB
3. Challenge LENGTH, LOWER & UPPER.mp4	6.1 MB
4. Solution LENGTH, LOWER & UPPER.mp4	12.9 MB
5. LEFT & RIGHT.mp4	25.2 MB
6. Challenge LEFT & RIGHT.mp4	6.4 MB
7. Solution LEFT & RIGHT.mp4	14.3 MB
8. Concatenate.mp4	19.0 MB
9. Challenge Concatenate.mp4	7.1 MB
/5. Day 5 - Intermediate Conditional Expressions/
1. Mathematical functions and operators.mp4	41.1 MB
10. COALESCE.mp4	24.1 MB
11. CAST.mp4	42.9 MB
12. Challenge CAST & COALESCE.mp4	7.6 MB
13. Solution CAST & COALESCE.mp4	11.2 MB
14. REPLACE.mp4	27.4 MB
15. Today's slides.html	0.2 KB
15.1 Day 5 - Course slides.pdf	750.4 KB
2. Challenge Mathematical functions and operators.mp4	14.5 MB
3. Solution Mathematical functions and operators.mp4	26.5 MB
4. CASE WHEN - Theory.mp4	42.6 MB
5. CASE WHEN - Hands-on.mp4	45.8 MB
6. 3 Challenge CASE WHEN.mp4	27.6 MB
7. Quick solutions.html	1.7 KB
8. Solution CASE WHEN.mp4	53.6 MB
9. CASE WHEN & SUM.mp4	48.6 MB
/6. Day 6 - Intermediate Joins/
1. What are joins.mp4	21.0 MB
10. Solution LEFT OUTER JOIN.mp4	39.3 MB
11. RIGHT OUTER JOIN.mp4	32.2 MB
12. Challenge Joins.mp4	7.5 MB
13. Solution Joins.mp4	29.1 MB
14. Joins on multiple conditions.mp4	48.4 MB
15. Solution Joins on multiple conditions.mp4	13.7 MB
16. Joining multiple tables.mp4	36.6 MB
17. Joining multiple tables - Practice.mp4	41.3 MB
18. Challenge Joining multiple tables.mp4	3.7 MB
19. Solution Joining multiple tables.mp4	36.0 MB
2. INNER JOIN - Theory.mp4	70.6 MB
20. More challenges.html	0.5 KB
21. Solutions.html	1.6 KB
22. Today's slides.html	0.2 KB
22.1 Day 6 - Course slides.pdf	1.6 MB
3. INNER JOIN - Practice.mp4	53.8 MB
4. Challenge INNER JOIN.mp4	4.9 MB
5. Solution INNER JOIN.mp4	16.7 MB
6. FULL OUTER JOIN.mp4	45.8 MB
7. JOIN & WHERE.mp4	26.0 MB
8. LEFT OUTER JOIN.mp4	43.2 MB
9. Challenge LEFT OUTER JOIN.mp4	10.5 MB
/7. Day 7 - Advanced UNION & Subqueries/
1. UNION.mp4	48.3 MB
10. Solution Subqueries in FROM.mp4	14.7 MB
11. Subqueries in SELECT.mp4	26.9 MB
12. Challenge Subqueries in SELECT.mp4	4.4 MB
13. Solution Subqueries in SELECT.mp4	10.7 MB
14. Correlated Subqueries in WHERE.mp4	59.3 MB
15. Challenge Correlated subqueries in WHERE.mp4	6.2 MB
16. Solution Correlated subqueries in WHERE.mp4	18.3 MB
17. Correlated Subquery in SELECT.mp4	29.5 MB
18. More challenges Correlated subqueres.mp4	16.3 MB
19. Solution More challenges.mp4	64.9 MB
2. UNION - Practice.mp4	35.2 MB
20. Today's slides.html	0.3 KB
20.1 Day 7 - Course slides.pdf	1.0 MB
3. Subqueries in WHERE.mp4	40.4 MB
4. Challenge Subqueries in WHERE.mp4	6.8 MB
5. Solution Subqueries in WHERE.mp4	30.6 MB
6. More challenges Subqueries in WHERE.mp4	9.2 MB
7. Solution More challenges.mp4	39.7 MB
8. Subqueries in FROM.mp4	23.8 MB
9. Challenge Subqueries in FROM.mp4	2.9 MB
/8. Day 8 - Advanced Course project/
1. Project Introduction.mp4	49.5 MB
10. Solution 7.mp4	19.3 MB
11. Solution 8.mp4	11.9 MB
12. Solution 9.mp4	24.3 MB
13. Solution 10.mp4	26.8 MB
14. Solution 11.mp4	18.9 MB
15. Solution 12.mp4	38.8 MB
16. Solution 13.mp4	55.1 MB
17. Solution 14.mp4	42.4 MB
2. Challenges.html	5.3 KB
3. Solutions.html	5.3 KB
4. Solution 1.mp4	8.2 MB
5. Solution 2.mp4	23.7 MB
6. Solution 3.mp4	22.3 MB
7. Solution 4.mp4	9.7 MB
8. Solution 5.mp4	21.0 MB
9. Solution 6.mp4	21.9 MB
/9. Day 9 - Advanced Managing tables & databases/
1. Managing databases & tables.mp4	22.7 MB
10. CREATE TABLE.mp4	45.9 MB
11. CREATE TABLE.html	0.2 KB
12. INSERT.mp4	32.3 MB
13. INSERT.html	0.2 KB
14. ALTER TABLE.mp4	33.7 MB
15. Challenge ALTER TABLE.mp4	16.4 MB
16. Solution ALTER TABLE.mp4	42.0 MB
17. TRUNCATE & DROP TABLE.mp4	27.6 MB
17.1 DROP & TRUNCATE.txt	0.3 KB
18. CHECK.mp4	35.7 MB
19. Challenge CHECK.mp4	12.8 MB
2. CREATE DATABASE.mp4	28.7 MB
20. Solution CHECK.mp4	51.0 MB
21. Today's slides.html	0.2 KB
21.1 Day 9 - Course slides.pdf	2.0 MB
3. CREATE & DROP DATABASE.html	0.2 KB
4. Data Types.mp4	61.0 MB
5. Data Types.html	0.2 KB
6. Constraints.mp4	30.4 MB
7. Constraints.html	0.2 KB
8. Primary Key & Foreign Key.mp4	29.9 MB
9. Primary & Foreign Key.html	0.2 KB
Total files 281