Torrent Downloads » Other » [ DevCourseWeb com ] Udemy - Ace Your Tech Interview - SQL for Data Scientists and Engineers
Other
[ DevCourseWeb com ] Udemy - Ace Your Tech Interview - SQL for Data Scientists and Engineers
Torrent info
Torrent Files List
Get Bonus Downloads Here.url (Size: 3.27 GB) (Files: 127)
Get Bonus Downloads Here.url
~Get Your Files Here !
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
Bonus Resources.txt
Torrent description
Feel free to post any comments about this torrent, including links to Subtitle, samples, screenshots, or any other relevant information, Watch [ DevCourseWeb com ] Udemy - Ace Your Tech Interview - SQL for Data Scientists and Engineers Online Free Full Movies Like 123Movies, Putlockers, Fmovies, Netflix or Download Direct via Magnet Link in Torrent Details.
