| 1. Add, subtract dates, and numbers of days.mp4 | 53.3 MB | ||
| 1. Computing an average, minmax values.mp4 | 25.6 MB | ||
| 1. Expressing a Parent-Child Relationship.mp4 | 69.1 MB | ||
| 1. Find differences between rows within same group or partition.mp4 | 34.9 MB | ||
| 1. Introduction to Stock Markets Data.html | 204.8 B | ||
| 1. Introduction.html | 2.1 KB | ||
| 1. Listing tables, columns and indexes.mp4 | 79.1 MB | ||
| 1. Preparing the data.mp4 | 33.9 MB | ||
| 1. Turn aggregate function to window function.mp4 | 49.8 MB | ||
| 1. Understand the database model.mp4 | 11.3 MB | ||
| 1. Your feedback is very valuable!.html | 716.8 B | ||
| 1.1 sql_international_debts_data.sql | 223.6 KB | ||
| 10. CODE Find total stocks per each sectors.html | 1.3 KB | ||
| 10. Staking tables together.mp4 | 76.3 MB | ||
| 2. Analyzing International debt - Part 1.mp4 | 56.7 MB | ||
| 2. CODE Table Creation - Sectors, Symbols, Prices.html | 1.9 KB | ||
| 2. Compute running date difference.mp4 | 33.8 MB | ||
| 2. Create tables and populate data.mp4 | 90.4 MB | ||
| 2. Expressing a Child-Parent-Grandparent Relationship.mp4 | 52.6 MB | ||
| 2. Install PostgreSQL 13.mp4 | 34.6 MB | ||
| 2. Listing constraints on a table.mp4 | 46.8 MB | ||
| 2. PARTITION BY clause.mp4 | 51.2 MB | ||
| 2. Pagination.mp4 | 21.6 MB | ||
| 2. Sum, and count.mp4 | 17 MB | ||
| 2. Updates to the course.html | 204.8 B | ||
| 2.1 sql_emp_tables_and_data.sql | 1.6 KB | ||
| 3. Analyzing International debt - Part 2.mp4 | 89.6 MB | ||
| 3. Bonus Lectures.html | 1.9 KB | ||
| 3. Comparing records using dates.mp4 | 33.8 MB | ||
| 3. Creating a hierarchical view of a table.mp4 | 48.4 MB | ||
| 3. Generating a running total.mp4 | 34.5 MB | ||
| 3. Get filtered data via WHERE clause.mp4 | 120.6 MB | ||
| 3. Handling NULLs.mp4 | 28.9 MB | ||
| 3. Import sample datasets.mp4 | 97.4 MB | ||
| 3. Install pgAdmin 4 v5.5.mp4 | 78 MB | ||
| 3. Skipping n rows.mp4 | 18 MB | ||
| 3. Using SQL to Generate SQL.mp4 | 32.1 MB | ||
| 4. CODE Import sample datasets.html | 1.4 KB | ||
| 4. Calculating 3-point moving averages.mp4 | 47.8 MB | ||
| 4. Finding all child rows for a given parent row.mp4 | 19.9 MB | ||
| 4. Referencing an alias and concatenate columns.mp4 | 57.7 MB | ||
| 4. Run PostgreSQL on the cloud.mp4 | 37.2 MB | ||
| 4. Selecting the Top n Records.mp4 | 31.9 MB | ||
| 4. The ORDER BY clause matters.mp4 | 47.4 MB | ||
| 4.1 daily_sales.sql | 307.2 B | ||
| 5. Calculate a mode.mp4 | 55.1 MB | ||
| 5. Important - SQL Query is in CODE Articles.mp4 | 12.8 MB | ||
| 5. Using conditional logic with CASE expression.mp4 | 47.6 MB | ||
| 5. Which rows are leaf, branch, or root nodes.mp4 | 67.5 MB | ||
| 6. Calculate a median, averages without highs and lows.mp4 | 29.9 MB | ||
| 6. List data, sectors in ascending and descending orders.mp4 | 70 MB | ||
| 6. Using ORDER BY, LIMIT and RANDOM.mp4 | 50.7 MB | ||
| 7. CODE List data, sectors in ascending and descending orders.html | 1.4 KB | ||
| 7. Find NULL values and transform into real values.mp4 | 39.3 MB | ||
| 8. Searching for patterns.mp4 | 53.8 MB | ||
| 8. Using COUNT, WHERE, IN and NOT IN with sectors.mp4 | 23.3 MB | ||
| 9. CODE Using COUNT, WHERE, IN and NOT IN with sectors.html | 512 B | ||
| 9. Sorting on data dependent key.mp4 | 66.9 MB | ||
| Bonus Resources.txt | 409.6 B | ||
| Get Bonus Downloads Here.url | 204.8 B | ||
| _stocks_prices_historical.csv | 307.2 B | ||
| _stocks_prices_latest.csv | 307.2 B | ||
| _stocks_sectors.csv | 409.6 B | ||
| _stocks_symbols.csv | 409.6 B | ||
| stocks_prices_historical.csv | 5.2 MB | ||
| stocks_prices_latest.csv | 8.6 KB | ||
| stocks_sectors.csv | 204.8 B | ||
| stocks_symbols.csv | 5.3 KB | ||
| ▲ 68 total files | |||
Master SQL - Simple to advanced 200+ queries
https://DevCourseWeb.com
Published 10/2023
Created by Adnan Waheed
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz, 2 Ch
Genre: eLearning | Language: English | Duration: 55 Lectures ( 5h 33m ) | Size: 2.12 GB
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
| torrent name | size | uploader | age | seed | leech |
|---|---|---|---|---|---|
| 3.2 GB | freecoursewb | 2 weeks | 14 | 2 | |
| 1.3 GB | freecoursewb | 3 weeks | 14 | 10 | |
|
Udemy - LoadRunner Essentials - Master Performance Testing and Analysis Posted by
freecoursewb in Other
|
942.4 MB | freecoursewb | 4 weeks | 0 | 0 |
|
Udemy - Master AI Prompt Writing - Content, Branding and Productivity Posted by
freecoursewb in Other
|
1.2 GB | freecoursewb | 4 weeks | 23 | 9 |
| 561.9 MB | freecoursewb | 4 weeks | 8 | 6 |
All Comments