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!
Learn about Subqueries, CTEs, , Window Functions on real-world practical datasets...
What you'll learn
Solve 200+ SQL hands-on practical query exercises
Work with real-world, practical datasets and problems
Step-by-step walkthrough to perform simple to complex SQL queries
Learn simple to complex queries
Subqueries
Common Table Expressions (CTEs)
Advanced Window Functions
Requirements
No pre-knowledge is required: I'll teach you absolutely everything you need to know!
A computer is required, but any will do. A desktop or a laptop running Mac, Windows, or Linux
All the software used in the course is free, and I'll personally walk you through setting it all up
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.html
2.1 KB
~Get Your Files Here !/1. Introduction/2. Install PostgreSQL 13.mp4
34.6 MB
~Get Your Files Here !/1. Introduction/3. Install pgAdmin 4 v5.5.mp4
78 MB
~Get Your Files Here !/1. Introduction/4. Run PostgreSQL on the cloud.mp4
37.2 MB
~Get Your Files Here !/10. Stocks Markets Analysis/1. Introduction to Stock Markets Data.html
198 B
~Get Your Files Here !/10. Stocks Markets Analysis/10. CODE Find total stocks per each sectors.html
1.3 KB
~Get Your Files Here !/10. Stocks Markets Analysis/2. CODE Table Creation - Sectors, Symbols, Prices.html
1.9 KB
~Get Your Files Here !/10. Stocks Markets Analysis/3. Import sample datasets.mp4
97.4 MB
~Get Your Files Here !/10. Stocks Markets Analysis/4. CODE Import sample datasets.html
1.4 KB
~Get Your Files Here !/10. Stocks Markets Analysis/5. Important - SQL Query is in CODE Articles.mp4
12.8 MB
~Get Your Files Here !/10. Stocks Markets Analysis/6. List data, sectors in ascending and descending orders.mp4
70 MB
~Get Your Files Here !/10. Stocks Markets Analysis/7. CODE List data, sectors in ascending and descending orders.html
1.4 KB
~Get Your Files Here !/10. Stocks Markets Analysis/8. Using COUNT, WHERE, IN and NOT IN with sectors.mp4
23.3 MB
~Get Your Files Here !/10. Stocks Markets Analysis/9. CODE Using COUNT, WHERE, IN and NOT IN with sectors.html
508 B
~Get Your Files Here !/10. Stocks Markets Analysis/stocks_prices_historical.csv
5.2 MB
~Get Your Files Here !/10. Stocks Markets Analysis/stocks_prices_latest.csv
8.6 KB
~Get Your Files Here !/10. Stocks Markets Analysis/stocks_sectors.csv
253 B
~Get Your Files Here !/10. Stocks Markets Analysis/stocks_symbols.csv
5.3 KB
~Get Your Files Here !/10. Stocks Markets Analysis/__MACOSX/_stocks_prices_historical.csv
330 B
~Get Your Files Here !/10. Stocks Markets Analysis/__MACOSX/_stocks_prices_latest.csv
330 B
~Get Your Files Here !/10. Stocks Markets Analysis/__MACOSX/_stocks_sectors.csv
437 B
~Get Your Files Here !/10. Stocks Markets Analysis/__MACOSX/_stocks_symbols.csv
386 B
~Get Your Files Here !/11. Congratulations and Thank You!/1. Your feedback is very valuable!.html
690 B
~Get Your Files Here !/11. Congratulations and Thank You!/2. Updates to the course.html
173 B
~Get Your Files Here !/11. Congratulations and Thank You!/3. Bonus Lectures.html
1.9 KB
~Get Your Files Here !/2. Employees Management System/1. Understand the database model.mp4
11.3 MB
~Get Your Files Here !/2. Employees Management System/10. Staking tables together.mp4
76.3 MB
~Get Your Files Here !/2. Employees Management System/2. Create tables and populate data.mp4
90.4 MB
~Get Your Files Here !/2. Employees Management System/2.1 sql_emp_tables_and_data.sql
1.6 KB
~Get Your Files Here !/2. Employees Management System/3. Get filtered data via WHERE clause.mp4
120.6 MB
~Get Your Files Here !/2. Employees Management System/4. Referencing an alias and concatenate columns.mp4
57.7 MB
~Get Your Files Here !/2. Employees Management System/5. Using conditional logic with CASE expression.mp4
47.6 MB
~Get Your Files Here !/2. Employees Management System/6. Using ORDER BY, LIMIT and RANDOM.mp4
50.7 MB
~Get Your Files Here !/2. Employees Management System/7. Find NULL values and transform into real values.mp4
39.3 MB
~Get Your Files Here !/2. Employees Management System/8. Searching for patterns.mp4
53.8 MB
~Get Your Files Here !/2. Employees Management System/9. Sorting on data dependent key.mp4
66.9 MB
~Get Your Files Here !/3. Hierarchical Queries/1. Expressing a Parent-Child Relationship.mp4
69.1 MB
~Get Your Files Here !/3. Hierarchical Queries/2. Expressing a Child-Parent-Grandparent Relationship.mp4
52.6 MB
~Get Your Files Here !/3. Hierarchical Queries/3. Creating a hierarchical view of a table.mp4
48.4 MB
~Get Your Files Here !/3. Hierarchical Queries/4. Finding all child rows for a given parent row.mp4
19.9 MB
~Get Your Files Here !/3. Hierarchical Queries/5. Which rows are leaf, branch, or root nodes.mp4
67.5 MB
~Get Your Files Here !/4. Working with numbers/1. Computing an average, minmax values.mp4
25.6 MB
~Get Your Files Here !/4. Working with numbers/2. Sum, and count.mp4
17 MB
~Get Your Files Here !/4. Working with numbers/3. Generating a running total.mp4
34.5 MB
~Get Your Files Here !/4. Working with numbers/4. Calculating 3-point moving averages.mp4
47.8 MB
~Get Your Files Here !/4. Working with numbers/4.1 daily_sales.sql
346 B
~Get Your Files Here !/4. Working with numbers/5. Calculate a mode.mp4
55.1 MB
~Get Your Files Here !/4. Working with numbers/6. Calculate a median, averages without highs and lows.mp4
29.9 MB
~Get Your Files Here !/5. Date Arithmetic/1. Add, subtract dates, and numbers of days.mp4
53.3 MB
~Get Your Files Here !/5. Date Arithmetic/2. Compute running date difference.mp4
33.8 MB
~Get Your Files Here !/5. Date Arithmetic/3. Comparing records using dates.mp4
33.8 MB
~Get Your Files Here !/6. Advances Searching/1. Find differences between rows within same group or partition.mp4
34.9 MB
~Get Your Files Here !/6. Advances Searching/2. Pagination.mp4
21.6 MB
~Get Your Files Here !/6. Advances Searching/3. Skipping n rows.mp4
18 MB
~Get Your Files Here !/6. Advances Searching/4. Selecting the Top n Records.mp4
31.9 MB
~Get Your Files Here !/7. Window Functions/1. Turn aggregate function to window function.mp4
49.8 MB
~Get Your Files Here !/7. Window Functions/2. PARTITION BY clause.mp4
51.2 MB
~Get Your Files Here !/7. Window Functions/3. Handling NULLs.mp4
28.9 MB
~Get Your Files Here !/7. Window Functions/4. The ORDER BY clause matters.mp4
47.4 MB
~Get Your Files Here !/8. Metadata Queries/1. Listing tables, columns and indexes.mp4
79.1 MB
~Get Your Files Here !/8. Metadata Queries/2. Listing constraints on a table.mp4
46.8 MB
~Get Your Files Here !/8. Metadata Queries/3. Using SQL to Generate SQL.mp4
32.1 MB
~Get Your Files Here !/9. International Debt Analysis/1. Preparing the data.mp4
33.9 MB
~Get Your Files Here !/9. International Debt Analysis/1.1 sql_international_debts_data.sql
223.6 KB
~Get Your Files Here !/9. International Debt Analysis/2. Analyzing International debt - Part 1.mp4
56.7 MB
~Get Your Files Here !/9. International Debt Analysis/3. Analyzing International debt - Part 2.mp4
