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