Please note that this page does not hosts or makes available any of the listed filenames. You
cannot download any of those files from here.
|
[CourseClub.ME].url |
122B |
[FCS Forum].url |
133B |
[FreeCourseSite.com].url |
127B |
1. Aliasing Sources of Data.mp4 |
9.40MB |
1. Aliasing Sources of Data.vtt |
7.88KB |
1. Challenging Puzzles For the Brave.html |
135B |
1. Conditional Expressions Using CASE Clause + [EXERCISES].mp4 |
33.08MB |
1. Conditional Expressions Using CASE Clause + [EXERCISES].vtt |
24.24KB |
1. Course Overview.mp4 |
52.84MB |
1. Course Overview.vtt |
6.33KB |
1. Introducing Table Joins.mp4 |
25.62MB |
1. Introducing Table Joins.vtt |
19.48KB |
1. Introducing the SELECT Statement.mp4 |
32.79MB |
1. Introducing the SELECT Statement.vtt |
21.16KB |
1. Understanding Correlated Subqueries.mp4 |
32.05MB |
1. Understanding Correlated Subqueries.vtt |
24.88KB |
1. Understanding Grouping.mp4 |
8.91MB |
1. Understanding Grouping.vtt |
7.38KB |
1. UPPER(), LOWER(), LENGTH(), TRIM() + Boolean Expressions & Concatenation.mp4 |
25.01MB |
1. UPPER(), LOWER(), LENGTH(), TRIM() + Boolean Expressions & Concatenation.vtt |
19.64KB |
1. What is a Database.mp4 |
15.48MB |
1. What is a Database.vtt |
11.55KB |
1. Window Functions using the OVER() Clause.mp4 |
29.87MB |
1. Window Functions using the OVER() Clause.vtt |
23.61KB |
2. [EXERCISES] Correlated Subqueries Continued.mp4 |
26.11MB |
2. [EXERCISES] Correlated Subqueries Continued.vtt |
18.85KB |
2. Filter Data Using the WHERE Clause + AND & OR.mp4 |
40.41MB |
2. Filter Data Using the WHERE Clause + AND & OR.vtt |
28.43KB |
2. Get Access to All of my current and future courses!.html |
1021B |
2. GROUP BY & HAVING Clauses.mp4 |
25.88MB |
2. GROUP BY & HAVING Clauses.vtt |
20.89KB |
2. INNER and OUTER Joins + [EXERCISES].mp4 |
40.68MB |
2. INNER and OUTER Joins + [EXERCISES].vtt |
30.98KB |
2. Install Postgres Database on Mac.mp4 |
12.56MB |
2. Install Postgres Database on Mac.vtt |
9.31KB |
2. Introducing Subqueries.mp4 |
23.89MB |
2. Introducing Subqueries.vtt |
16.77KB |
2. Ordering Data in Window Frames.mp4 |
34.78MB |
2. Ordering Data in Window Frames.vtt |
25.32KB |
2. String Functions SUBSTRING(), REPLACE(), POSITION() and COALESCE().mp4 |
23.87MB |
2. String Functions SUBSTRING(), REPLACE(), POSITION() and COALESCE().vtt |
20.18KB |
2. Transposing Data using the CASE Clause + [EXERCISES].mp4 |
30.20MB |
2. Transposing Data using the CASE Clause + [EXERCISES].vtt |
20.80KB |
3. [EXERCISES] Using GROUP BY and HAVING Clauses.mp4 |
25.90MB |
3. [EXERCISES] Using GROUP BY and HAVING Clauses.vtt |
20.98KB |
3. Filtering Operators - IN, NOT IN, IS NULL, BETWEEN.mp4 |
30.13MB |
3. Filtering Operators - IN, NOT IN, IS NULL, BETWEEN.vtt |
18.59KB |
3. Grouping Functions MIN(), MAX(), AVG(), SUM(), COUNT().mp4 |
15.55MB |
3. Grouping Functions MIN(), MAX(), AVG(), SUM(), COUNT().vtt |
12.59KB |
3. Practice Using Case and Transposing Data.html |
135B |
3. RANK, FIRST_VALUE and NTILE Functions.mp4 |
111.24MB |
3. RANK, FIRST_VALUE and NTILE Functions.vtt |
15.11KB |
3. Subqueries Continued + [EXERCISES].mp4 |
29.73MB |
3. Subqueries Continued + [EXERCISES].vtt |
22.12KB |
3. Troubleshoot Connection.html |
1.14KB |
3. Using UNION, UNION ALL and EXCEPT Clauses + [EXERCISES].mp4 |
20.96MB |
3. Using UNION, UNION ALL and EXCEPT Clauses + [EXERCISES].vtt |
18.50KB |
4. [EXERCISES] WHERE Clause and Operators.mp4 |
19.26MB |
4. [EXERCISES] WHERE Clause and Operators.vtt |
13.58KB |
4. Cartesian Product with the CROSS JOIN.mp4 |
11.56MB |
4. Cartesian Product with the CROSS JOIN.vtt |
8.06KB |
4. Install Postgres on Windows.mp4 |
71.58MB |
4. Install Postgres on Windows.vtt |
10.15KB |
4. LEAD and LAG Functions.mp4 |
63.17MB |
4. LEAD and LAG Functions.vtt |
9.68KB |
4. Practice Aggregation Queries.html |
135B |
4. Practice with Functions, Conditional Expressions and Concatenation.html |
135B |
4. Subqueries with ANY and ALL Operators + [EXERCISES].mp4 |
32.95MB |
4. Subqueries with ANY and ALL Operators + [EXERCISES].vtt |
23.05KB |
5. [EXERCISES] Joins and Subqueries Continued.mp4 |
27.38MB |
5. [EXERCISES] Joins and Subqueries Continued.vtt |
20.30KB |
5. [EXERCISES] More Practice with Subqueries.mp4 |
22.47MB |
5. [EXERCISES] More Practice with Subqueries.vtt |
18.34KB |
5.1 sales_tbl.txt.txt |
696B |
5. Create Table and Insert Statements.mp4 |
43.26MB |
5. Create Table and Insert Statements.vtt |
25.61KB |
5. Using ORDER BY, LIMIT, DISTINCT and Renaming Columns.mp4 |
21.25MB |
5. Using ORDER BY, LIMIT, DISTINCT and Renaming Columns.vtt |
13.83KB |
5. Working with Rollups and Cubes.mp4 |
111.95MB |
5. Working with Rollups and Cubes.vtt |
14.40KB |
6. Creating Views vs. Inline Views.mp4 |
80.44MB |
6. Creating Views vs. Inline Views.vtt |
11.69KB |
6. Data file that will be used in the course (IMPORTANT).html |
444B |
6. Practice with Subqueries.html |
135B |
6. Practice Writing Basic Queries (5 Problems).html |
135B |
7.1 mock_data.sql.sql |
119.58KB |
7. ADVANCED Problems using Joins, Grouping and Subqueries.html |
135B |
7. Prepare the Database.mp4 |
39.94MB |
7. Prepare the Database.vtt |
17.10KB |
8. Create More Tables and Populate Data.html |
135B |