DevCourseWeb com Udemy Ace Your Tech Interview SQL for Data Scientists and Engineers

/

Get Bonus Downloads Here.url

/1. Introduction/

1. Introduction.mp4

/.../10. LeetCode Challenge Series Problem Set 3/

1. SQL Challenges using SUBQUERIES.html

/.../11. Aggregation Introduction to Data Analysis Techniques/

1. AGGREGATION COUNT Rows in the Result Set.mp4

2. Display the Count of Students Enrolled in the Year 2021.html

3. AGGREGATION Retrieve DISTINCT Values from a Column and COUNT Them.mp4

4. COUNT and DISTINCT Query Examples.html

5. Understanding the Impact of NULL Values on Aggregation Operations.mp4

6. Handling NULL Values in Arithmetic Operations Best Practices and Strategies.mp4

7. Impact of NULL Values on Aggregation Functions Query Examples.html

8. Display the Count of Courses with Prerequisites.html

9. Show Total Courses, Courses with Prerequisites, and Courses without Prerequisites.html

/.../12. Aggregation by Categories/

1. Combining Results with UNION Merging Outputs from Multiple SELECT Statements.mp4

10. Aggregating Data Counting Students Enrolled in Each Course.html

11. Display Students and the Number of Courses Enrolled.html

12. Filtering Groups with the HAVING Clause.mp4

13. HAVING Clause Display Courses with Two or More Students.html

14. Retrieve Students Enrolled in Both 'Photography Basics' and 'Resume Writing for Success' Courses.html

15. Utilizing GROUP BY with ROLLUP to Generate Subtotals and Grand Totals.mp4

16. ROLLUP Query Examples.html

17. AWS data billing data for rollup exercises.html

2. Counting Models Produced by Each Manufacturer Using UNION Example.html

3. GROUP BY Perform aggregation based on categories.mp4

4. Filtering Rows with WHERE Clause and Handling NULL Values using GROUP BY.mp4

5. Counting Models Produced by Each Manufacturer Using GROUP BY Example.html

6. Show Average Bill Amount by Account.html

7. Display Student Enrollments by Year.html

8. Compute Average Price By Manufacturer and Vehicle Type.html

9. Aggregating Data from Multiple Tables Using GROUP BY with JOINS.mp4

/.../13. LeetCode Challenge Series Problem Set 4/

1. SQL Challenges using UNION Operation.html

2. SQL Challenges using GROUP BY Operation.html

/.../14. Mastering Data Transformation Exploring Pivoting Techniques in SQL/

1. Transforming Data Converting Result Sets from Long to Wide Format.mp4

2. Step-by-Step Guide Converting Result Sets from Long to Wide Format.mp4

3. PIVOTING Query Example with SUBQUERIES, CASE, and Aggregation Functions.html

4. Convert Billing Data From Long Format to Wide Format.html

5. LeetCode Challenge Series Problem Set 5.html

/.../15. Mastering Common Table Expressions (CTEs) Simplifying Complex Queries/

1. Utilizing CTEs to Create Temporary Tables for Advanced Data Analysis.mp4

2. CTE Walkthrough Analyzing Fuel Efficiency.mp4

3. CTE Query Example.html

4. Present Monthly Bill Amounts with Account Average.html

/.../16. Unlocking Data Insights Exploring WINDOW Functions for Advanced Analysis/

1. WINDOW Functions Derive and Inject New Insights.mp4

10. Top-N Query Example Show the Three Most Affordable Cars and SUVs.html

11. Coding Exercise Identify Third-Highest Priced Vehicle.html

12. Solution Identify Third-Highest Priced Vehicle.html

13. Trend Analysis with LAG and LEAD.mp4

14. LAG and LEAD Listing Each Vehicle with Its Previous and Next Vehicle by Price.html

15. Coding Exercise Analyzing Monthly Billing Trends.html

16. Solution Analyzing Monthly Billing Trends.html

2. WINDOW Functions Example List vehicles along with average new vehicle price.html

3. WINDOW Functions with Partitions Data Segmentation Mastery.mp4

4. PARTITION Examples.html

5. Coding Exercise Present Monthly Bill Amounts with Account Average.html

6. Solution Present Monthly Bill Amounts with Account Average.html

7. DENSE RANK and RANK Assigning Rank to Rows in the Result Set.mp4

8. Dense Rank Examples How to Rank Vehicles by Price.html

9. DENSE RANK and TOP-N Queries Finding Top and Bottom Performers.mp4

/.../17. LeetCode Challenge Series Problem Set 6/

1. SQL Challenges using WINDOW Functions.html

2. Hard Problems.html

/18. Conclusion/

1. Congratulations!.html

/2. HouseKeeping/

1. Database Setup MYSQL, VS Code, DBeaver Installation for Windows & MacOS.mp4

2. Windows Install Steps.html

3. MacOS Install Steps.html

4. SQLCourse Database Setup.mp4

5. Setup Script Student Enrollment Tables.html

6. Setup Script Vehicle Details Table.html

7. Setup Script Aggregation Example Table.html

8. Setup Script Billing Table.html

9. Popular Data Types in Relational Databases.html

/.../3. Why Do Databases Have So Many Tables/

1. Normalization and the Importance of Structured Data A Deep Dive into 1NF.mp4

2. Normalization 2NF Functional Dependencies and Data Duplication.mp4

3. Normalization 3NF Transitive Dependencies and Data Duplication.mp4

4. Entity Relationship Diagrams Visualizing Tables and Relationships.mp4

/.../4. Exploring Data Retrieval Basics of SELECT and WHERE Clauses from a Single Table/

1. Mastering SELECT Statements Retrieving Data from Table.mp4

10. List Bills for the Prod Account.html

11. Utilizing WHERE Clause with LIKE and Wildcards for Row Filtering.mp4

12. LIKE wildcard-based query examples.html

13. Advanced Filtering with WHERE Clause AND, OR, IN, BETWEEN.mp4

14. AND, OR, IN, BETWEEN Query examples.html

15. List SUVs in the price range $25,000 to $30,000.html

16. List vehicles while excluding certain makes..html

17. Working with NULL Values in WHERE Clause.mp4

18. Query examples to include or exclude NULL values.html

19. Exclude rows with missing value.html

2. Retrieving Data from Table Query Examples.html

3. List make, model of each vehicle in the vehicle table.html

4. ORDER Clause Arranging Rows in the Desired Sequence.mp4

5. Arranging Rows with ORDER Clause Query Examples.html

6. List vehicle details and sort the results.html

7. Utilizing WHERE Clause Setting Filters with Case Sensitivity.mp4

8. Utilizing WHERE Clause for Row Filtering in Single-Column, Single-Table Queries.mp4

9. Filtering rows - Single-Column, Single-Table Query Examples.html

/.../5. LeetCode Challenge Series Problem Set 1/

1. How to Approach LeetCode Problems 584 Customer Referee.mp4

2. 595. Big Countries.html

3. Solution Discussion 595. Big Countries.html

/.../6. Data Transformation Using Built-in Functions and Conditional Logic/

1. Exploring Functions Performing Operations on Data and Returning Results.mp4

10. Assign Fuel Efficiency Ratings to Vehicles Based on MPG Values..html

2. Built-in Functions Query Examples.html

3. List all students who enrolled in the year 2023.html

4. Perform Unit Conversion Calculate Kilometers per Liter from Miles per Gallon.html

5. Using the LIMIT Clause to Restrict the Number of Rows in the Result Set..mp4

6. Retrieving first few Rows in the Result Set Query Examples.html

7. Display Top 3 Most Expensive Bills from the Billing Table..html

8. Utilizing the CASE Expression for Conditional Logic and Evaluation Within Query.mp4

9. Conditional Logic with CASE Expressions Query Examples.html

/.../7. Mastering Joins Combining Rows from Multiple Tables Based on Related Columns/

1. Exploring INNER JOIN Combining Rows from Related Tables.mp4

10. Identify Data Quality Issues Duplicate Postal Codes Assigned to Different States.html

11. CROSS JOIN Generating the Cartesian Product of Two Tables.mp4

12. CROSS JOIN Query Examples.html

13. Generate All Possible Student Pairs for Forming Teams.html

2. Exploring INNER JOIN Query Examples.html

3. List students who are enrolled in either 'Dance 3' or 'Photography Basics'.html

4. LEFT OUTER JOIN Inner Join Results Plus Non-Matching Rows from the Left Table.mp4

5. Exploring LEFT OUTER JOIN Query Examples.html

6. List Students Not Enrolled in Any Course.html

7. Exploring SELF JOIN Join a Table with Itself.mp4

8. SELF JOIN Query Examples.html

9. Display Courses and Their Respective Pre-requisites.html

/.../8. LeetCode Challenge Series Problem Set 2/

1. SQL Challenges using JOINS.html

2. Solution Discussion 175. Combine Two Tables.html

/.../9. Exploring Subqueries Nested Queries for Advanced Filtering/

1. Nesting SQL Queries Exploring the Power of Subqueries.mp4

2. SUBQUERIES Display the List of Students Who Have Not Yet Enrolled in a Course..html

3. List Courses with No Student Enrollments.html

4. SUBQUERIES - Filtering Data.mp4

5. SUBQUERIES Show cars that give better mileage than average.html

6. Display Vehicle with the Highest Fuel Efficiency.html

7. Display Vehicle with the Second Highest Fuel Efficiency.html

/~Get Your Files Here !/

Bonus Resources.txt

Total files 127