17 OCT 2024 - Welcome Back to TorrentFunk! Get your pirate hat back out. Streaming is dying and torrents are the new trend. Account Registration works again and so do Torrent Uploads. We invite you all to start uploading torrents again!
TORRENT DETAILS
Udemy - Ace Your Tech Interview - SQL For Data Scientists And Engineers
TORRENT SUMMARY
Status:
All the torrents in this section have been verified by our verification system
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
If You Need More Stuff, kindly Visit and Support Us -->> https://CourseWikia.com
Get More Tutorials and Support Us -->> https://FreeCourseWeb.com
We upload these learning materials for the people from all over the world, who have the talent and motivation to sharpen their skills/ knowledge but do not have the financial support to afford the materials. If you like this content and if you are truly in a position that you can actually buy the materials, then Please, we repeat, Please, Support Authors. They Deserve it! Because always remember, without "Them", you and we won't be here having this conversation. Think about it! Peace...
VISITOR COMMENTS (0 )
FILE LIST
Filename
Size
~Get Your Files Here !/1. Introduction/1. Introduction.mp4
32.5 MB
~Get Your Files Here !/10. LeetCode Challenge Series Problem Set 3/1. SQL Challenges using SUBQUERIES.html
169 B
~Get Your Files Here !/11. Aggregation Introduction to Data Analysis Techniques/1. AGGREGATION COUNT Rows in the Result Set.mp4
32.8 MB
~Get Your Files Here !/11. Aggregation Introduction to Data Analysis Techniques/2. Display the Count of Students Enrolled in the Year 2021.html
168 B
~Get Your Files Here !/11. Aggregation Introduction to Data Analysis Techniques/3. AGGREGATION Retrieve DISTINCT Values from a Column and COUNT Them.mp4
26.3 MB
~Get Your Files Here !/11. Aggregation Introduction to Data Analysis Techniques/4. COUNT and DISTINCT Query Examples.html
1.1 KB
~Get Your Files Here !/11. Aggregation Introduction to Data Analysis Techniques/5. Understanding the Impact of NULL Values on Aggregation Operations.mp4
53.2 MB
~Get Your Files Here !/11. Aggregation Introduction to Data Analysis Techniques/6. Handling NULL Values in Arithmetic Operations Best Practices and Strategies.mp4
114.5 MB
~Get Your Files Here !/11. Aggregation Introduction to Data Analysis Techniques/7. Impact of NULL Values on Aggregation Functions Query Examples.html
2.4 KB
~Get Your Files Here !/11. Aggregation Introduction to Data Analysis Techniques/8. Display the Count of Courses with Prerequisites.html
168 B
~Get Your Files Here !/11. Aggregation Introduction to Data Analysis Techniques/9. Show Total Courses, Courses with Prerequisites, and Courses without Prerequisites.html
168 B
~Get Your Files Here !/12. Aggregation by Categories/1. Combining Results with UNION Merging Outputs from Multiple SELECT Statements.mp4
82.3 MB
~Get Your Files Here !/12. Aggregation by Categories/10. Aggregating Data Counting Students Enrolled in Each Course.html
1.1 KB
~Get Your Files Here !/12. Aggregation by Categories/11. Display Students and the Number of Courses Enrolled.html
168 B
~Get Your Files Here !/12. Aggregation by Categories/12. Filtering Groups with the HAVING Clause.mp4
66.9 MB
~Get Your Files Here !/12. Aggregation by Categories/13. HAVING Clause Display Courses with Two or More Students.html
512 B
~Get Your Files Here !/12. Aggregation by Categories/14. Retrieve Students Enrolled in Both 'Photography Basics' and 'Resume Writing for Success' Courses.html
168 B
~Get Your Files Here !/12. Aggregation by Categories/15. Utilizing GROUP BY with ROLLUP to Generate Subtotals and Grand Totals.mp4
84.4 MB
~Get Your Files Here !/12. Aggregation by Categories/16. ROLLUP Query Examples.html
643 B
~Get Your Files Here !/12. Aggregation by Categories/17. AWS data billing data for rollup exercises.html
168 B
~Get Your Files Here !/12. Aggregation by Categories/2. Counting Models Produced by Each Manufacturer Using UNION Example.html
426 B
~Get Your Files Here !/12. Aggregation by Categories/3. GROUP BY Perform aggregation based on categories.mp4
73.7 MB
~Get Your Files Here !/12. Aggregation by Categories/4. Filtering Rows with WHERE Clause and Handling NULL Values using GROUP BY.mp4
42.1 MB
~Get Your Files Here !/12. Aggregation by Categories/5. Counting Models Produced by Each Manufacturer Using GROUP BY Example.html
1.2 KB
~Get Your Files Here !/12. Aggregation by Categories/6. Show Average Bill Amount by Account.html
168 B
~Get Your Files Here !/12. Aggregation by Categories/7. Display Student Enrollments by Year.html
168 B
~Get Your Files Here !/12. Aggregation by Categories/8. Compute Average Price By Manufacturer and Vehicle Type.html
168 B
~Get Your Files Here !/12. Aggregation by Categories/9. Aggregating Data from Multiple Tables Using GROUP BY with JOINS.mp4
103.9 MB
~Get Your Files Here !/13. LeetCode Challenge Series Problem Set 4/1. SQL Challenges using UNION Operation.html
108 B
~Get Your Files Here !/13. LeetCode Challenge Series Problem Set 4/2. SQL Challenges using GROUP BY Operation.html
265 B
~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.9 MB
~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.4 MB
~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.2 KB
~Get Your Files Here !/14. Mastering Data Transformation Exploring Pivoting Techniques in SQL/4. Convert Billing Data From Long Format to Wide Format.html
168 B
~Get Your Files Here !/14. Mastering Data Transformation Exploring Pivoting Techniques in SQL/5. LeetCode Challenge Series Problem Set 5.html
113 B
~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.7 MB
~Get Your Files Here !/15. Mastering Common Table Expressions (CTEs) Simplifying Complex Queries/2. CTE Walkthrough Analyzing Fuel Efficiency.mp4
82.7 MB
~Get Your Files Here !/15. Mastering Common Table Expressions (CTEs) Simplifying Complex Queries/3. CTE Query Example.html
555 B
~Get Your Files Here !/15. Mastering Common Table Expressions (CTEs) Simplifying Complex Queries/4. Present Monthly Bill Amounts with Account Average.html
168 B
~Get Your Files Here !/16. Unlocking Data Insights Exploring WINDOW Functions for Advanced Analysis/1. WINDOW Functions Derive and Inject New Insights.mp4
84.7 MB
~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
481 B
~Get Your Files Here !/16. Unlocking Data Insights Exploring WINDOW Functions for Advanced Analysis/11. Coding Exercise Identify Third-Highest Priced Vehicle.html
1.8 KB
~Get Your Files Here !/16. Unlocking Data Insights Exploring WINDOW Functions for Advanced Analysis/12. Solution Identify Third-Highest Priced Vehicle.html
1.6 KB
~Get Your Files Here !/16. Unlocking Data Insights Exploring WINDOW Functions for Advanced Analysis/13. Trend Analysis with LAG and LEAD.mp4
95.3 MB
~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
420 B
~Get Your Files Here !/16. Unlocking Data Insights Exploring WINDOW Functions for Advanced Analysis/15. Coding Exercise Analyzing Monthly Billing Trends.html
2.3 KB
~Get Your Files Here !/16. Unlocking Data Insights Exploring WINDOW Functions for Advanced Analysis/16. Solution Analyzing Monthly Billing Trends.html
1.8 KB
~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
638 B
~Get Your Files Here !/16. Unlocking Data Insights Exploring WINDOW Functions for Advanced Analysis/3. WINDOW Functions with Partitions Data Segmentation Mastery.mp4
59.7 MB
~Get Your Files Here !/16. Unlocking Data Insights Exploring WINDOW Functions for Advanced Analysis/4. PARTITION Examples.html
931 B
~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.7 KB
~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.3 KB
~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.7 MB
~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
850 B
~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
38 MB
~Get Your Files Here !/17. LeetCode Challenge Series Problem Set 6/1. SQL Challenges using WINDOW Functions.html
352 B
~Get Your Files Here !/17. LeetCode Challenge Series Problem Set 6/2. Hard Problems.html
143 B
~Get Your Files Here !/18. Conclusion/1. Congratulations!.html
1002 B
~Get Your Files Here !/2. HouseKeeping/1. Database Setup MYSQL, VS Code, DBeaver Installation for Windows & MacOS.mp4
88.1 MB
~Get Your Files Here !/2. HouseKeeping/2. Windows Install Steps.html
640 B
~Get Your Files Here !/2. HouseKeeping/3. MacOS Install Steps.html
1.3 KB
~Get Your Files Here !/2. HouseKeeping/4. SQLCourse Database Setup.mp4
116.9 MB
~Get Your Files Here !/2. HouseKeeping/5. Setup Script Student Enrollment Tables.html
3.2 KB
~Get Your Files Here !/2. HouseKeeping/6. Setup Script Vehicle Details Table.html
2.9 KB
~Get Your Files Here !/2. HouseKeeping/7. Setup Script Aggregation Example Table.html
479 B
~Get Your Files Here !/2. HouseKeeping/8. Setup Script Billing Table.html
1015 B
~Get Your Files Here !/2. HouseKeeping/9. Popular Data Types in Relational Databases.html
1.4 KB
~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.7 MB
~Get Your Files Here !/3. Why Do Databases Have So Many Tables/2. Normalization 2NF Functional Dependencies and Data Duplication.mp4
125.8 MB
~Get Your Files Here !/3. Why Do Databases Have So Many Tables/3. Normalization 3NF Transitive Dependencies and Data Duplication.mp4
100.5 MB
~Get Your Files Here !/3. Why Do Databases Have So Many Tables/4. Entity Relationship Diagrams Visualizing Tables and Relationships.mp4
133.7 MB
~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.8 MB
~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
168 B
~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.2 MB
~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
804 B
~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.7 MB
~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.3 KB
~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
168 B
~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
168 B
~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.1 MB
~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
385 B
~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
168 B
~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
335 B
~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
168 B
~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.2 MB
~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
660 B
~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
168 B
~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.6 MB
~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.8 MB
~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
466 B
~Get Your Files Here !/5. LeetCode Challenge Series Problem Set 1/1. How to Approach LeetCode Problems 584 Customer Referee.mp4
139.6 MB
~Get Your Files Here !/5. LeetCode Challenge Series Problem Set 1/2. 595. Big Countries.html
80 B
~Get Your Files Here !/5. LeetCode Challenge Series Problem Set 1/3. Solution Discussion 595. Big Countries.html
955 B
~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.3 MB
~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
168 B
~Get Your Files Here !/6. Data Transformation Using Built-in Functions and Conditional Logic/2. Built-in Functions Query Examples.html
1.5 KB
~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
168 B
~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
