|
|
1. AGGREGATION COUNT Rows in the Result Set.mp4
|
MP4
|
32.8 MB
|
|
|
1. Combining Results with UNION Merging Outputs from Multiple SELECT Statements.mp4
|
MP4
|
82.3 MB
|
|
|
1. Congratulations!.html
|
HTML
|
1 KB
|
|
|
1. Database Setup MYSQL, VS Code, DBeaver Installation for Windows & MacOS.mp4
|
MP4
|
88.1 MB
|
|
|
1. Exploring Functions Performing Operations on Data and Returning Results.mp4
|
MP4
|
126.3 MB
|
|
|
1. Exploring INNER JOIN Combining Rows from Related Tables.mp4
|
MP4
|
163.6 MB
|
|
|
1. How to Approach LeetCode Problems 584 Customer Referee.mp4
|
MP4
|
139.6 MB
|
|
|
1. Introduction.mp4
|
MP4
|
32.5 MB
|
|
|
1. Mastering SELECT Statements Retrieving Data from Table.mp4
|
MP4
|
62.8 MB
|
|
|
1. Nesting SQL Queries Exploring the Power of Subqueries.mp4
|
MP4
|
55.1 MB
|
|
|
1. Normalization and the Importance of Structured Data A Deep Dive into 1NF.mp4
|
MP4
|
122.7 MB
|
|
|
1. SQL Challenges using JOINS.html
|
HTML
|
307.2 B
|
|
|
1. SQL Challenges using SUBQUERIES.html
|
HTML
|
204.8 B
|
|
|
1. SQL Challenges using UNION Operation.html
|
HTML
|
102.4 B
|
|
|
1. SQL Challenges using WINDOW Functions.html
|
HTML
|
307.2 B
|
|
|
1. Transforming Data Converting Result Sets from Long to Wide Format.mp4
|
MP4
|
89.9 MB
|
|
|
1. Utilizing CTEs to Create Temporary Tables for Advanced Data Analysis.mp4
|
MP4
|
80.7 MB
|
|
|
1. WINDOW Functions Derive and Inject New Insights.mp4
|
MP4
|
84.7 MB
|
|
|
10. Aggregating Data Counting Students Enrolled in Each Course.html
|
HTML
|
1.1 KB
|
|
|
10. Assign Fuel Efficiency Ratings to Vehicles Based on MPG Values..html
|
HTML
|
204.8 B
|
|
|
10. Identify Data Quality Issues Duplicate Postal Codes Assigned to Different States.html
|
HTML
|
204.8 B
|
|
|
10. List Bills for the Prod Account.html
|
HTML
|
204.8 B
|
|
|
10. Top-N Query Example Show the Three Most Affordable Cars and SUVs.html
|
HTML
|
512 B
|
|
|
11. CROSS JOIN Generating the Cartesian Product of Two Tables.mp4
|
MP4
|
58.8 MB
|
|
|
11. Coding Exercise Identify Third-Highest Priced Vehicle.html
|
HTML
|
1.8 KB
|
|
|
11. Display Students and the Number of Courses Enrolled.html
|
HTML
|
204.8 B
|
|
|
11. Utilizing WHERE Clause with LIKE and Wildcards for Row Filtering.mp4
|
MP4
|
29.2 MB
|
|
|
12. CROSS JOIN Query Examples.html
|
HTML
|
614.4 B
|
|
|
12. Filtering Groups with the HAVING Clause.mp4
|
MP4
|
66.9 MB
|
|
|
12. LIKE wildcard-based query examples.html
|
HTML
|
819.2 B
|
|
|
12. Solution Identify Third-Highest Priced Vehicle.html
|
HTML
|
1.6 KB
|
|
|
13. Advanced Filtering with WHERE Clause AND, OR, IN, BETWEEN.mp4
|
MP4
|
93.7 MB
|
|
|
13. Generate All Possible Student Pairs for Forming Teams.html
|
HTML
|
204.8 B
|
|
|
13. HAVING Clause Display Courses with Two or More Students.html
|
HTML
|
512 B
|
|
|
13. Trend Analysis with LAG and LEAD.mp4
|
MP4
|
95.3 MB
|
|
|
14. AND, OR, IN, BETWEEN Query examples.html
|
HTML
|
1.3 KB
|
|
|
14. LAG and LEAD Listing Each Vehicle with Its Previous and Next Vehicle by Price.html
|
HTML
|
409.6 B
|
|
|
14. Retrieve Students Enrolled in Both 'Photography Basics' and 'Resume Writing for Success' Courses.html
|
HTML
|
204.8 B
|
|
|
15. Coding Exercise Analyzing Monthly Billing Trends.html
|
HTML
|
2.3 KB
|
|
|
15. List SUVs in the price range $25,000 to $30,000.html
|
HTML
|
204.8 B
|
|
|
15. Utilizing GROUP BY with ROLLUP to Generate Subtotals and Grand Totals.mp4
|
MP4
|
84.4 MB
|
|
|
16. List vehicles while excluding certain makes..html
|
HTML
|
204.8 B
|
|
|
16. ROLLUP Query Examples.html
|
HTML
|
614.4 B
|
|
|
16. Solution Analyzing Monthly Billing Trends.html
|
HTML
|
1.8 KB
|
|
|
17. AWS data billing data for rollup exercises.html
|
HTML
|
204.8 B
|
|
|
17. Working with NULL Values in WHERE Clause.mp4
|
MP4
|
56.1 MB
|
|
|
18. Query examples to include or exclude NULL values.html
|
HTML
|
409.6 B
|
|
|
19. Exclude rows with missing value.html
|
HTML
|
204.8 B
|
|
|
2. 595. Big Countries.html
|
HTML
|
102.4 B
|
|
|
2. Built-in Functions Query Examples.html
|
HTML
|
1.5 KB
|
|
|
2. CTE Walkthrough Analyzing Fuel Efficiency.mp4
|
MP4
|
82.7 MB
|
|
|
2. Counting Models Produced by Each Manufacturer Using UNION Example.html
|
HTML
|
409.6 B
|
|
|
2. Display the Count of Students Enrolled in the Year 2021.html
|
HTML
|
204.8 B
|
|
|
2. Exploring INNER JOIN Query Examples.html
|
HTML
|
1.6 KB
|
|
|
2. Hard Problems.html
|
HTML
|
102.4 B
|
|
|
2. Normalization 2NF Functional Dependencies and Data Duplication.mp4
|
MP4
|
125.8 MB
|
|
|
2. Retrieving Data from Table Query Examples.html
|
HTML
|
307.2 B
|
|
|
2. SQL Challenges using GROUP BY Operation.html
|
HTML
|
307.2 B
|
|
|
2. SUBQUERIES Display the List of Students Who Have Not Yet Enrolled in a Course..html
|
HTML
|
1 KB
|
|
|
2. Solution Discussion 175. Combine Two Tables.html
|
HTML
|
1.8 KB
|
|
|
2. Step-by-Step Guide Converting Result Sets from Long to Wide Format.mp4
|
MP4
|
71.4 MB
|
|
|
2. WINDOW Functions Example List vehicles along with average new vehicle price.html
|
HTML
|
614.4 B
|
|
|
2. Windows Install Steps.html
|
HTML
|
614.4 B
|
|
|
3. AGGREGATION Retrieve DISTINCT Values from a Column and COUNT Them.mp4
|
MP4
|
26.3 MB
|
|
|
3. CTE Query Example.html
|
HTML
|
512 B
|
|
|
3. GROUP BY Perform aggregation based on categories.mp4
|
MP4
|
73.7 MB
|
|
|
3. List Courses with No Student Enrollments.html
|
HTML
|
204.8 B
|
|
|
3. List all students who enrolled in the year 2023.html
|
HTML
|
204.8 B
|
|
|
3. List make, model of each vehicle in the vehicle table.html
|
HTML
|
204.8 B
|
|
|
3. List students who are enrolled in either 'Dance 3' or 'Photography Basics'.html
|
HTML
|
204.8 B
|
|
|
3. MacOS Install Steps.html
|
HTML
|
1.3 KB
|
|
|
3. Normalization 3NF Transitive Dependencies and Data Duplication.mp4
|
MP4
|
100.5 MB
|
|
|
3. PIVOTING Query Example with SUBQUERIES, CASE, and Aggregation Functions.html
|
HTML
|
1.2 KB
|
|
|
3. Solution Discussion 595. Big Countries.html
|
HTML
|
921.6 B
|
|
|
3. WINDOW Functions with Partitions Data Segmentation Mastery.mp4
|
MP4
|
59.7 MB
|
|
|
4. COUNT and DISTINCT Query Examples.html
|
HTML
|
1.1 KB
|
|
|
4. Convert Billing Data From Long Format to Wide Format.html
|
HTML
|
204.8 B
|
|
|
4. Entity Relationship Diagrams Visualizing Tables and Relationships.mp4
|
MP4
|
133.7 MB
|
|
|
4. Filtering Rows with WHERE Clause and Handling NULL Values using GROUP BY.mp4
|
MP4
|
42.1 MB
|
|
|
4. LEFT OUTER JOIN Inner Join Results Plus Non-Matching Rows from the Left Table.mp4
|
MP4
|
103.3 MB
|
|
|
4. ORDER Clause Arranging Rows in the Desired Sequence.mp4
|
MP4
|
74.2 MB
|
|
|
4. PARTITION Examples.html
|
HTML
|
921.6 B
|
|
|
4. Perform Unit Conversion Calculate Kilometers per Liter from Miles per Gallon.html
|
HTML
|
204.8 B
|
|
|
4. Present Monthly Bill Amounts with Account Average.html
|
HTML
|
204.8 B
|
|
|
4. SQLCourse Database Setup.mp4
|
MP4
|
116.9 MB
|
|
|
4. SUBQUERIES - Filtering Data.mp4
|
MP4
|
35.7 MB
|
|
|
5. Arranging Rows with ORDER Clause Query Examples.html
|
HTML
|
614.4 B
|
|
|
5. Coding Exercise Present Monthly Bill Amounts with Account Average.html
|
HTML
|
1.7 KB
|
|
|
5. Counting Models Produced by Each Manufacturer Using GROUP BY Example.html
|
HTML
|
1.2 KB
|
|
|
5. Exploring LEFT OUTER JOIN Query Examples.html
|
HTML
|
819.2 B
|
|
|
5. LeetCode Challenge Series Problem Set 5.html
|
HTML
|
102.4 B
|
|
|
5. SUBQUERIES Show cars that give better mileage than average.html
|
HTML
|
512 B
|
|
|
5. Setup Script Student Enrollment Tables.html
|
HTML
|
3.2 KB
|
|
|
5. Understanding the Impact of NULL Values on Aggregation Operations.mp4
|
MP4
|
53.2 MB
|
|
|
5. Using the LIMIT Clause to Restrict the Number of Rows in the Result Set..mp4
|
MP4
|
66.6 MB
|
|
|
6. Display Vehicle with the Highest Fuel Efficiency.html
|
HTML
|
204.8 B
|
|
|
6. Handling NULL Values in Arithmetic Operations Best Practices and Strategies.mp4
|
MP4
|
114.5 MB
|
|
|
6. List Students Not Enrolled in Any Course.html
|
HTML
|
204.8 B
|
|
|
6. List vehicle details and sort the results.html
|
HTML
|
204.8 B
|
|
|
6. Retrieving first few Rows in the Result Set Query Examples.html
|
HTML
|
409.6 B
|
|
|
6. Setup Script Vehicle Details Table.html
|
HTML
|
2.9 KB
|
|
|
6. Show Average Bill Amount by Account.html
|
HTML
|
204.8 B
|
|
|
6. Solution Present Monthly Bill Amounts with Account Average.html
|
HTML
|
1.3 KB
|
|
|
7. DENSE RANK and RANK Assigning Rank to Rows in the Result Set.mp4
|
MP4
|
100.7 MB
|
|
|
7. Display Student Enrollments by Year.html
|
HTML
|
204.8 B
|
|
|
7. Display Top 3 Most Expensive Bills from the Billing Table..html
|
HTML
|
204.8 B
|
|
|
7. Display Vehicle with the Second Highest Fuel Efficiency.html
|
HTML
|
204.8 B
|
|
|
7. Exploring SELF JOIN Join a Table with Itself.mp4
|
MP4
|
52.7 MB
|
|
|
7. Impact of NULL Values on Aggregation Functions Query Examples.html
|
HTML
|
2.4 KB
|
|
|
7. Setup Script Aggregation Example Table.html
|
HTML
|
512 B
|
|
|
7. Utilizing WHERE Clause Setting Filters with Case Sensitivity.mp4
|
MP4
|
29.6 MB
|
|
|
8. Compute Average Price By Manufacturer and Vehicle Type.html
|
HTML
|
204.8 B
|
|
|
8. Dense Rank Examples How to Rank Vehicles by Price.html
|
HTML
|
819.2 B
|
|
|
8. Display the Count of Courses with Prerequisites.html
|
HTML
|
204.8 B
|
|
|
8. SELF JOIN Query Examples.html
|
HTML
|
307.2 B
|
|
|
8. Setup Script Billing Table.html
|
HTML
|
1 KB
|
|
|
8. Utilizing WHERE Clause for Row Filtering in Single-Column, Single-Table Queries.mp4
|
MP4
|
48.8 MB
|
|
|
8. Utilizing the CASE Expression for Conditional Logic and Evaluation Within Query.mp4
|
MP4
|
45.5 MB
|
|
|
9. Aggregating Data from Multiple Tables Using GROUP BY with JOINS.mp4
|
MP4
|
103.9 MB
|
|
|
9. Conditional Logic with CASE Expressions Query Examples.html
|
HTML
|
614.4 B
|
|
|
9. DENSE RANK and TOP-N Queries Finding Top and Bottom Performers.mp4
|
MP4
|
38 MB
|
|
|
9. Display Courses and Their Respective Pre-requisites.html
|
HTML
|
204.8 B
|
|
|
9. Filtering rows - Single-Column, Single-Table Query Examples.html
|
HTML
|
512 B
|
|
|
9. Popular Data Types in Relational Databases.html
|
HTML
|
1.4 KB
|
|
|
9. Show Total Courses, Courses with Prerequisites, and Courses without Prerequisites.html
|
HTML
|
204.8 B
|
|
|
Bonus Resources.txt
|
TXT
|
409.6 B
|
|
|
Get Bonus Downloads Here.url
|
URL
|
204.8 B
|
