[ DevCourseWeb.com ] Udemy - Ace Your Tech Interview - SQL for Data Scientists and Engineers

File Type Create Time File Size Seeders Leechers Updated
Movie 2024-03-01 3.27GB 0 1 1 day ago
Download
Magnet link   or   Save Instantly without Torrenting   or   Torrent download

To download this file, you need a free bitTorrent client such as qBittorrent.

Report Abuse
Tags
DevCourseWeb  com  Udemy  Ace  Your  Tech  Interview  SQL  for  Data  Scientists  and  Engineers  
Related Torrents
  1. [ DevCourseWeb.com ] Udemy - Master your brain to hardwire for Success (Part 5 of 5) 3.07GB
  2. [ DevCourseWeb.com ] Python Programming - This Book Includes - Python for Data Analysis and Science with Big Data Analysis 582.77KB
  3. [ DevCourseWeb.com ] Udemy - The complete Excel crash course for data analysis 1.45GB
  4. [ DevCourseWeb.com ] Udemy - Improve Your Business English - English For Accounting.zip 2.77GB
  5. [ DevCourseWeb.com ] Udemy - Control Your Career - Resume, LinkedIn, and Job Search 1.20GB
  6. [ DevCourseWeb.com ] Udemy - Ace Certified Secure Software Lifecycle Professional (CSSLP) 1.31GB
  7. [ DevCourseWeb.com ] Udemy - Build Your First Web App In Bubble For Beginners 1.67GB
  8. [ DevCourseWeb.com ] Udemy - 10X Your Results With 25 Advanced Google Ads Tips and Tricks 1.30GB
  9. [ DevCourseWeb.com ] Udemy - Make Your Own Melodies And Chords! In Less Than 2 Hours 327.72MB
Files
  1. Get Bonus Downloads Here.url 182B
  2. ~Get Your Files Here !/1. Introduction/1. Introduction.mp4 32.48MB
  3. ~Get Your Files Here !/10. LeetCode Challenge Series Problem Set 3/1. SQL Challenges using SUBQUERIES.html 169B
  4. ~Get Your Files Here !/11. Aggregation Introduction to Data Analysis Techniques/1. AGGREGATION COUNT Rows in the Result Set.mp4 32.79MB
  5. ~Get Your Files Here !/11. Aggregation Introduction to Data Analysis Techniques/2. Display the Count of Students Enrolled in the Year 2021.html 168B
  6. ~Get Your Files Here !/11. Aggregation Introduction to Data Analysis Techniques/3. AGGREGATION Retrieve DISTINCT Values from a Column and COUNT Them.mp4 26.32MB
  7. ~Get Your Files Here !/11. Aggregation Introduction to Data Analysis Techniques/4. COUNT and DISTINCT Query Examples.html 1.08KB
  8. ~Get Your Files Here !/11. Aggregation Introduction to Data Analysis Techniques/5. Understanding the Impact of NULL Values on Aggregation Operations.mp4 53.22MB
  9. ~Get Your Files Here !/11. Aggregation Introduction to Data Analysis Techniques/6. Handling NULL Values in Arithmetic Operations Best Practices and Strategies.mp4 114.49MB
  10. ~Get Your Files Here !/11. Aggregation Introduction to Data Analysis Techniques/7. Impact of NULL Values on Aggregation Functions Query Examples.html 2.37KB
  11. ~Get Your Files Here !/11. Aggregation Introduction to Data Analysis Techniques/8. Display the Count of Courses with Prerequisites.html 168B
  12. ~Get Your Files Here !/11. Aggregation Introduction to Data Analysis Techniques/9. Show Total Courses, Courses with Prerequisites, and Courses without Prerequisites.html 168B
  13. ~Get Your Files Here !/12. Aggregation by Categories/1. Combining Results with UNION Merging Outputs from Multiple SELECT Statements.mp4 82.26MB
  14. ~Get Your Files Here !/12. Aggregation by Categories/10. Aggregating Data Counting Students Enrolled in Each Course.html 1.12KB
  15. ~Get Your Files Here !/12. Aggregation by Categories/11. Display Students and the Number of Courses Enrolled.html 168B
  16. ~Get Your Files Here !/12. Aggregation by Categories/12. Filtering Groups with the HAVING Clause.mp4 66.87MB
  17. ~Get Your Files Here !/12. Aggregation by Categories/13. HAVING Clause Display Courses with Two or More Students.html 512B
  18. ~Get Your Files Here !/12. Aggregation by Categories/14. Retrieve Students Enrolled in Both 'Photography Basics' and 'Resume Writing for Success' Courses.html 168B
  19. ~Get Your Files Here !/12. Aggregation by Categories/15. Utilizing GROUP BY with ROLLUP to Generate Subtotals and Grand Totals.mp4 84.39MB
  20. ~Get Your Files Here !/12. Aggregation by Categories/16. ROLLUP Query Examples.html 643B
  21. ~Get Your Files Here !/12. Aggregation by Categories/17. AWS data billing data for rollup exercises.html 168B
  22. ~Get Your Files Here !/12. Aggregation by Categories/2. Counting Models Produced by Each Manufacturer Using UNION Example.html 426B
  23. ~Get Your Files Here !/12. Aggregation by Categories/3. GROUP BY Perform aggregation based on categories.mp4 73.74MB
  24. ~Get Your Files Here !/12. Aggregation by Categories/4. Filtering Rows with WHERE Clause and Handling NULL Values using GROUP BY.mp4 42.07MB
  25. ~Get Your Files Here !/12. Aggregation by Categories/5. Counting Models Produced by Each Manufacturer Using GROUP BY Example.html 1.24KB
  26. ~Get Your Files Here !/12. Aggregation by Categories/6. Show Average Bill Amount by Account.html 168B
  27. ~Get Your Files Here !/12. Aggregation by Categories/7. Display Student Enrollments by Year.html 168B
  28. ~Get Your Files Here !/12. Aggregation by Categories/8. Compute Average Price By Manufacturer and Vehicle Type.html 168B
  29. ~Get Your Files Here !/12. Aggregation by Categories/9. Aggregating Data from Multiple Tables Using GROUP BY with JOINS.mp4 103.91MB
  30. ~Get Your Files Here !/13. LeetCode Challenge Series Problem Set 4/1. SQL Challenges using UNION Operation.html 108B
  31. ~Get Your Files Here !/13. LeetCode Challenge Series Problem Set 4/2. SQL Challenges using GROUP BY Operation.html 265B
  32. ~Get Your Files Here !/14. Mastering Data Transformation Exploring Pivoting Techniques in SQL/1. Transforming Data Converting Result Sets from Long to Wide Format.mp4 89.88MB
  33. ~Get Your Files Here !/14. Mastering Data Transformation Exploring Pivoting Techniques in SQL/2. Step-by-Step Guide Converting Result Sets from Long to Wide Format.mp4 71.40MB
  34. ~Get Your Files Here !/14. Mastering Data Transformation Exploring Pivoting Techniques in SQL/3. PIVOTING Query Example with SUBQUERIES, CASE, and Aggregation Functions.html 1.23KB
  35. ~Get Your Files Here !/14. Mastering Data Transformation Exploring Pivoting Techniques in SQL/4. Convert Billing Data From Long Format to Wide Format.html 168B
  36. ~Get Your Files Here !/14. Mastering Data Transformation Exploring Pivoting Techniques in SQL/5. LeetCode Challenge Series Problem Set 5.html 113B
  37. ~Get Your Files Here !/15. Mastering Common Table Expressions (CTEs) Simplifying Complex Queries/1. Utilizing CTEs to Create Temporary Tables for Advanced Data Analysis.mp4 80.74MB
  38. ~Get Your Files Here !/15. Mastering Common Table Expressions (CTEs) Simplifying Complex Queries/2. CTE Walkthrough Analyzing Fuel Efficiency.mp4 82.71MB
  39. ~Get Your Files Here !/15. Mastering Common Table Expressions (CTEs) Simplifying Complex Queries/3. CTE Query Example.html 555B
  40. ~Get Your Files Here !/15. Mastering Common Table Expressions (CTEs) Simplifying Complex Queries/4. Present Monthly Bill Amounts with Account Average.html 168B
  41. ~Get Your Files Here !/16. Unlocking Data Insights Exploring WINDOW Functions for Advanced Analysis/1. WINDOW Functions Derive and Inject New Insights.mp4 84.72MB
  42. ~Get Your Files Here !/16. Unlocking Data Insights Exploring WINDOW Functions for Advanced Analysis/10. Top-N Query Example Show the Three Most Affordable Cars and SUVs.html 481B
  43. ~Get Your Files Here !/16. Unlocking Data Insights Exploring WINDOW Functions for Advanced Analysis/11. Coding Exercise Identify Third-Highest Priced Vehicle.html 1.76KB
  44. ~Get Your Files Here !/16. Unlocking Data Insights Exploring WINDOW Functions for Advanced Analysis/12. Solution Identify Third-Highest Priced Vehicle.html 1.57KB
  45. ~Get Your Files Here !/16. Unlocking Data Insights Exploring WINDOW Functions for Advanced Analysis/13. Trend Analysis with LAG and LEAD.mp4 95.34MB
  46. ~Get Your Files Here !/16. Unlocking Data Insights Exploring WINDOW Functions for Advanced Analysis/14. LAG and LEAD Listing Each Vehicle with Its Previous and Next Vehicle by Price.html 420B
  47. ~Get Your Files Here !/16. Unlocking Data Insights Exploring WINDOW Functions for Advanced Analysis/15. Coding Exercise Analyzing Monthly Billing Trends.html 2.32KB
  48. ~Get Your Files Here !/16. Unlocking Data Insights Exploring WINDOW Functions for Advanced Analysis/16. Solution Analyzing Monthly Billing Trends.html 1.84KB
  49. ~Get Your Files Here !/16. Unlocking Data Insights Exploring WINDOW Functions for Advanced Analysis/2. WINDOW Functions Example List vehicles along with average new vehicle price.html 638B
  50. ~Get Your Files Here !/16. Unlocking Data Insights Exploring WINDOW Functions for Advanced Analysis/3. WINDOW Functions with Partitions Data Segmentation Mastery.mp4 59.73MB
  51. ~Get Your Files Here !/16. Unlocking Data Insights Exploring WINDOW Functions for Advanced Analysis/4. PARTITION Examples.html 931B
  52. ~Get Your Files Here !/16. Unlocking Data Insights Exploring WINDOW Functions for Advanced Analysis/5. Coding Exercise Present Monthly Bill Amounts with Account Average.html 1.75KB
  53. ~Get Your Files Here !/16. Unlocking Data Insights Exploring WINDOW Functions for Advanced Analysis/6. Solution Present Monthly Bill Amounts with Account Average.html 1.32KB
  54. ~Get Your Files Here !/16. Unlocking Data Insights Exploring WINDOW Functions for Advanced Analysis/7. DENSE RANK and RANK Assigning Rank to Rows in the Result Set.mp4 100.69MB
  55. ~Get Your Files Here !/16. Unlocking Data Insights Exploring WINDOW Functions for Advanced Analysis/8. Dense Rank Examples How to Rank Vehicles by Price.html 850B
  56. ~Get Your Files Here !/16. Unlocking Data Insights Exploring WINDOW Functions for Advanced Analysis/9. DENSE RANK and TOP-N Queries Finding Top and Bottom Performers.mp4 37.99MB
  57. ~Get Your Files Here !/17. LeetCode Challenge Series Problem Set 6/1. SQL Challenges using WINDOW Functions.html 352B
  58. ~Get Your Files Here !/17. LeetCode Challenge Series Problem Set 6/2. Hard Problems.html 143B
  59. ~Get Your Files Here !/18. Conclusion/1. Congratulations!.html 1002B
  60. ~Get Your Files Here !/2. HouseKeeping/1. Database Setup MYSQL, VS Code, DBeaver Installation for Windows & MacOS.mp4 88.05MB
  61. ~Get Your Files Here !/2. HouseKeeping/2. Windows Install Steps.html 640B
  62. ~Get Your Files Here !/2. HouseKeeping/3. MacOS Install Steps.html 1.29KB
  63. ~Get Your Files Here !/2. HouseKeeping/4. SQLCourse Database Setup.mp4 116.87MB
  64. ~Get Your Files Here !/2. HouseKeeping/5. Setup Script Student Enrollment Tables.html 3.20KB
  65. ~Get Your Files Here !/2. HouseKeeping/6. Setup Script Vehicle Details Table.html 2.86KB
  66. ~Get Your Files Here !/2. HouseKeeping/7. Setup Script Aggregation Example Table.html 479B
  67. ~Get Your Files Here !/2. HouseKeeping/8. Setup Script Billing Table.html 1015B
  68. ~Get Your Files Here !/2. HouseKeeping/9. Popular Data Types in Relational Databases.html 1.40KB
  69. ~Get Your Files Here !/3. Why Do Databases Have So Many Tables/1. Normalization and the Importance of Structured Data A Deep Dive into 1NF.mp4 122.75MB
  70. ~Get Your Files Here !/3. Why Do Databases Have So Many Tables/2. Normalization 2NF Functional Dependencies and Data Duplication.mp4 125.75MB
  71. ~Get Your Files Here !/3. Why Do Databases Have So Many Tables/3. Normalization 3NF Transitive Dependencies and Data Duplication.mp4 100.55MB
  72. ~Get Your Files Here !/3. Why Do Databases Have So Many Tables/4. Entity Relationship Diagrams Visualizing Tables and Relationships.mp4 133.70MB
  73. ~Get Your Files Here !/4. Exploring Data Retrieval Basics of SELECT and WHERE Clauses from a Single Table/1. Mastering SELECT Statements Retrieving Data from Table.mp4 62.83MB
  74. ~Get Your Files Here !/4. Exploring Data Retrieval Basics of SELECT and WHERE Clauses from a Single Table/10. List Bills for the Prod Account.html 168B
  75. ~Get Your Files Here !/4. Exploring Data Retrieval Basics of SELECT and WHERE Clauses from a Single Table/11. Utilizing WHERE Clause with LIKE and Wildcards for Row Filtering.mp4 29.20MB
  76. ~Get Your Files Here !/4. Exploring Data Retrieval Basics of SELECT and WHERE Clauses from a Single Table/12. LIKE wildcard-based query examples.html 804B
  77. ~Get Your Files Here !/4. Exploring Data Retrieval Basics of SELECT and WHERE Clauses from a Single Table/13. Advanced Filtering with WHERE Clause AND, OR, IN, BETWEEN.mp4 93.74MB
  78. ~Get Your Files Here !/4. Exploring Data Retrieval Basics of SELECT and WHERE Clauses from a Single Table/14. AND, OR, IN, BETWEEN Query examples.html 1.28KB
  79. ~Get Your Files Here !/4. Exploring Data Retrieval Basics of SELECT and WHERE Clauses from a Single Table/15. List SUVs in the price range $25,000 to $30,000.html 168B
  80. ~Get Your Files Here !/4. Exploring Data Retrieval Basics of SELECT and WHERE Clauses from a Single Table/16. List vehicles while excluding certain makes..html 168B
  81. ~Get Your Files Here !/4. Exploring Data Retrieval Basics of SELECT and WHERE Clauses from a Single Table/17. Working with NULL Values in WHERE Clause.mp4 56.11MB
  82. ~Get Your Files Here !/4. Exploring Data Retrieval Basics of SELECT and WHERE Clauses from a Single Table/18. Query examples to include or exclude NULL values.html 385B
  83. ~Get Your Files Here !/4. Exploring Data Retrieval Basics of SELECT and WHERE Clauses from a Single Table/19. Exclude rows with missing value.html 168B
  84. ~Get Your Files Here !/4. Exploring Data Retrieval Basics of SELECT and WHERE Clauses from a Single Table/2. Retrieving Data from Table Query Examples.html 335B
  85. ~Get Your Files Here !/4. Exploring Data Retrieval Basics of SELECT and WHERE Clauses from a Single Table/3. List make, model of each vehicle in the vehicle table.html 168B
  86. ~Get Your Files Here !/4. Exploring Data Retrieval Basics of SELECT and WHERE Clauses from a Single Table/4. ORDER Clause Arranging Rows in the Desired Sequence.mp4 74.21MB
  87. ~Get Your Files Here !/4. Exploring Data Retrieval Basics of SELECT and WHERE Clauses from a Single Table/5. Arranging Rows with ORDER Clause Query Examples.html 660B
  88. ~Get Your Files Here !/4. Exploring Data Retrieval Basics of SELECT and WHERE Clauses from a Single Table/6. List vehicle details and sort the results.html 168B
  89. ~Get Your Files Here !/4. Exploring Data Retrieval Basics of SELECT and WHERE Clauses from a Single Table/7. Utilizing WHERE Clause Setting Filters with Case Sensitivity.mp4 29.58MB
  90. ~Get Your Files Here !/4. Exploring Data Retrieval Basics of SELECT and WHERE Clauses from a Single Table/8. Utilizing WHERE Clause for Row Filtering in Single-Column, Single-Table Queries.mp4 48.78MB
  91. ~Get Your Files Here !/4. Exploring Data Retrieval Basics of SELECT and WHERE Clauses from a Single Table/9. Filtering rows - Single-Column, Single-Table Query Examples.html 466B
  92. ~Get Your Files Here !/5. LeetCode Challenge Series Problem Set 1/1. How to Approach LeetCode Problems 584 Customer Referee.mp4 139.57MB
  93. ~Get Your Files Here !/5. LeetCode Challenge Series Problem Set 1/2. 595. Big Countries.html 80B
  94. ~Get Your Files Here !/5. LeetCode Challenge Series Problem Set 1/3. Solution Discussion 595. Big Countries.html 955B
  95. ~Get Your Files Here !/6. Data Transformation Using Built-in Functions and Conditional Logic/1. Exploring Functions Performing Operations on Data and Returning Results.mp4 126.26MB
  96. ~Get Your Files Here !/6. Data Transformation Using Built-in Functions and Conditional Logic/10. Assign Fuel Efficiency Ratings to Vehicles Based on MPG Values..html 168B
  97. ~Get Your Files Here !/6. Data Transformation Using Built-in Functions and Conditional Logic/2. Built-in Functions Query Examples.html 1.47KB
  98. ~Get Your Files Here !/6. Data Transformation Using Built-in Functions and Conditional Logic/3. List all students who enrolled in the year 2023.html 168B
  99. ~Get Your Files Here !/6. Data Transformation Using Built-in Functions and Conditional Logic/4. Perform Unit Conversion Calculate Kilometers per Liter from Miles per Gallon.html 168B
  100. ~Get Your Files Here !/6. Data Transformation Using Built-in Functions and Conditional Logic/5. Using the LIMIT Clause to Restrict the Number of Rows in the Result Set..mp4 66.56MB
  101. ~Get Your Files Here !/6. Data Transformation Using Built-in Functions and Conditional Logic/6. Retrieving first few Rows in the Result Set Query Examples.html 417B
  102. ~Get Your Files Here !/6. Data Transformation Using Built-in Functions and Conditional Logic/7. Display Top 3 Most Expensive Bills from the Billing Table..html 168B
  103. ~Get Your Files Here !/6. Data Transformation Using Built-in Functions and Conditional Logic/8. Utilizing the CASE Expression for Conditional Logic and Evaluation Within Query.mp4 45.46MB
  104. ~Get Your Files Here !/6. Data Transformation Using Built-in Functions and Conditional Logic/9. Conditional Logic with CASE Expressions Query Examples.html 664B
  105. ~Get Your Files Here !/7. Mastering Joins Combining Rows from Multiple Tables Based on Related Columns/1. Exploring INNER JOIN Combining Rows from Related Tables.mp4 163.63MB
  106. ~Get Your Files Here !/7. Mastering Joins Combining Rows from Multiple Tables Based on Related Columns/10. Identify Data Quality Issues Duplicate Postal Codes Assigned to Different States.html 168B
  107. ~Get Your Files Here !/7. Mastering Joins Combining Rows from Multiple Tables Based on Related Columns/11. CROSS JOIN Generating the Cartesian Product of Two Tables.mp4 58.79MB
  108. ~Get Your Files Here !/7. Mastering Joins Combining Rows from Multiple Tables Based on Related Columns/12. CROSS JOIN Query Examples.html 588B
  109. ~Get Your Files Here !/7. Mastering Joins Combining Rows from Multiple Tables Based on Related Columns/13. Generate All Possible Student Pairs for Forming Teams.html 168B
  110. ~Get Your Files Here !/7. Mastering Joins Combining Rows from Multiple Tables Based on Related Columns/2. Exploring INNER JOIN Query Examples.html 1.59KB
  111. ~Get Your Files Here !/7. Mastering Joins Combining Rows from Multiple Tables Based on Related Columns/3. List students who are enrolled in either 'Dance 3' or 'Photography Basics'.html 168B
  112. ~Get Your Files Here !/7. Mastering Joins Combining Rows from Multiple Tables Based on Related Columns/4. LEFT OUTER JOIN Inner Join Results Plus Non-Matching Rows from the Left Table.mp4 103.25MB
  113. ~Get Your Files Here !/7. Mastering Joins Combining Rows from Multiple Tables Based on Related Columns/5. Exploring LEFT OUTER JOIN Query Examples.html 835B
  114. ~Get Your Files Here !/7. Mastering Joins Combining Rows from Multiple Tables Based on Related Columns/6. List Students Not Enrolled in Any Course.html 168B
  115. ~Get Your Files Here !/7. Mastering Joins Combining Rows from Multiple Tables Based on Related Columns/7. Exploring SELF JOIN Join a Table with Itself.mp4 52.67MB
  116. ~Get Your Files Here !/7. Mastering Joins Combining Rows from Multiple Tables Based on Related Columns/8. SELF JOIN Query Examples.html 278B
  117. ~Get Your Files Here !/7. Mastering Joins Combining Rows from Multiple Tables Based on Related Columns/9. Display Courses and Their Respective Pre-requisites.html 168B
  118. ~Get Your Files Here !/8. LeetCode Challenge Series Problem Set 2/1. SQL Challenges using JOINS.html 329B
  119. ~Get Your Files Here !/8. LeetCode Challenge Series Problem Set 2/2. Solution Discussion 175. Combine Two Tables.html 1.79KB
  120. ~Get Your Files Here !/9. Exploring Subqueries Nested Queries for Advanced Filtering/1. Nesting SQL Queries Exploring the Power of Subqueries.mp4 55.09MB
  121. ~Get Your Files Here !/9. Exploring Subqueries Nested Queries for Advanced Filtering/2. SUBQUERIES Display the List of Students Who Have Not Yet Enrolled in a Course..html 1.01KB
  122. ~Get Your Files Here !/9. Exploring Subqueries Nested Queries for Advanced Filtering/3. List Courses with No Student Enrollments.html 168B
  123. ~Get Your Files Here !/9. Exploring Subqueries Nested Queries for Advanced Filtering/4. SUBQUERIES - Filtering Data.mp4 35.67MB
  124. ~Get Your Files Here !/9. Exploring Subqueries Nested Queries for Advanced Filtering/5. SUBQUERIES Show cars that give better mileage than average.html 506B
  125. ~Get Your Files Here !/9. Exploring Subqueries Nested Queries for Advanced Filtering/6. Display Vehicle with the Highest Fuel Efficiency.html 168B
  126. ~Get Your Files Here !/9. Exploring Subqueries Nested Queries for Advanced Filtering/7. Display Vehicle with the Second Highest Fuel Efficiency.html 168B
  127. ~Get Your Files Here !/Bonus Resources.txt 386B