Udemy - Master SQL - Simple to advanced 200 + queries

seeders: 36
leechers: 13
updated:

Download Fast Safe Anonymous
movies, software, shows...

Files

[ DevCourseWeb.com ] Udemy - Master SQL - Simple to advanced 200 + queries
  • Get Bonus Downloads Here.url (0.2 KB)
  • ~Get Your Files Here ! 1. Introduction
    • 1. Introduction.html (2.1 KB)
    • 2. Install PostgreSQL 13.mp4 (34.6 MB)
    • 3. Install pgAdmin 4 v5.5.mp4 (78.0 MB)
    • 4. Run PostgreSQL on the cloud.mp4 (37.2 MB)
    10. Stocks Markets Analysis
    • 1. Introduction to Stock Markets Data.html (0.2 KB)
    • 10. CODE Find total stocks per each sectors.html (1.3 KB)
    • 2. CODE Table Creation - Sectors, Symbols, Prices.html (1.9 KB)
    • 3. Import sample datasets.mp4 (97.4 MB)
    • 4. CODE Import sample datasets.html (1.4 KB)
    • 5. Important - SQL Query is in CODE Articles.mp4 (12.8 MB)
    • 6. List data, sectors in ascending and descending orders.mp4 (70.0 MB)
    • 7. CODE List data, sectors in ascending and descending orders.html (1.4 KB)
    • 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 (0.5 KB)
    • __MACOSX
      • _stocks_prices_historical.csv (0.3 KB)
      • _stocks_prices_latest.csv (0.3 KB)
      • _stocks_sectors.csv (0.4 KB)
      • _stocks_symbols.csv (0.4 KB)
    • stocks_prices_historical.csv (5.2 MB)
    • stocks_prices_latest.csv (8.6 KB)
    • stocks_sectors.csv (0.2 KB)
    • stocks_symbols.csv (5.3 KB)
    • 11. Congratulations and Thank You!
      • 1. Your feedback is very valuable!.html (0.7 KB)
      • 2. Updates to the course.html (0.2 KB)
      • 3. Bonus Lectures.html (1.9 KB)
      2. Employees Management System
      • 1. Understand the database model.mp4 (11.3 MB)
      • 10. Staking tables together.mp4 (76.3 MB)
      • 2. Create tables and populate data.mp4 (90.4 MB)
      • 2.1 sql_emp_tables_and_data.sql (1.6 KB)
      • 3. Get filtered data via WHERE clause.mp4 (120.6 MB)
      • 4. Referencing an alias and concatenate columns.mp4 (57.7 MB)
      • 5. Using conditional logic with CASE expression.mp4 (47.6 MB)
      • 6. Using ORDER BY, LIMIT and RANDOM.mp4 (50.7 MB)
      • 7. Find NULL values and transform into real values.mp4 (39.3 MB)
      • 8. Searching for patterns.mp4 (53.8 MB)
      • 9. Sorting on data dependent key.mp4 (66.9 MB)
      3. Hierarchical Queries
      • 1. Expressing a Parent-Child Relationship.mp4 (69.1 MB)
      • 2. Expressing a Child-Parent-Grandparent Relationship.mp4 (52.6 MB)
      • 3. Creating a hierarchical view of a table.mp4 (48.4 MB)
      • 4. Finding all child rows for a given parent row.mp4 (19.9 MB)
      • 5. Which rows are leaf, branch, or root nodes.mp4 (67.5 MB)
      4. Working with numbers
      • 1. Computing an average, minmax values.mp4 (25.6 MB)
      • 2. Sum, and count.mp4 (17.0 MB)
      • 3. Generating a running total.mp4 (34.5 MB)
      • 4. Calculating 3-point moving averages.mp4 (47.8 MB)
      • 4.1 daily_sales.sql (0.3 KB)
      • 5. Calculate a mode.mp4 (55.1 MB)
      • 6. Calculate a median, averages without highs and lows.mp4 (29.9 MB)
      5. Date Arithmetic
      • 1. Add, subtract dates, and numbers of days.mp4 (53.3 MB)
      • 2. Compute running date difference.mp4 (33.8 MB)
      • 3. Comparing records using dates.mp4 (33.8 MB)
      6. Advances Searching
      • 1. Find differences between rows within same group or partition.mp4 (34.9 MB)
      • 2. Pagination.mp4 (21.6 MB)
      • 3. Skipping n rows.mp4 (18.0 MB)
      • 4. Selecting the Top n Records.mp4 (31.9 MB)
      7. Window Functions
      • 1. Turn aggregate function to window function.mp4 (49.8 MB)
      • 2. PARTITION BY clause.mp4 (51.2 MB)
      • 3. Handling NULLs.mp4 (28.9 MB)
      • 4. The ORDER BY clause matters.mp4 (47.4 MB)
      8. Metadata Queries
      • 1. Listing tables, columns and indexes.mp4 (79.1 MB)
      • 2. Listing constraints on a table.mp4 (46.8 MB)
      • 3. Using SQL to Generate SQL.mp4 (32.1 MB)
      9. International Debt Analysis
      • 1. Preparing the data.mp4 (33.9 MB)
      • 1.1 sql_international_debts_data.sql (223.6 KB)
      • 2. Analyzing International debt - Part 1.mp4 (56.7 MB)
      • 3. Analyzing International debt - Part 2.mp4 (89.6 MB)
      • Bonus Resources.txt (0.4 KB)

Description

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



Download torrent
2.1 GB
seeders:36
leechers:13
Udemy - Master SQL - Simple to advanced 200 + queries


Trackers

tracker name
udp://tracker.torrent.eu.org:451/announce
udp://tracker.tiny-vps.com:6969/announce
http://tracker.foreverpirates.co:80/announce
udp://tracker.cyberia.is:6969/announce
udp://exodus.desync.com:6969/announce
udp://explodie.org:6969/announce
udp://tracker.opentrackr.org:1337/announce
udp://9.rarbg.to:2780/announce
udp://tracker.internetwarriors.net:1337/announce
udp://ipv4.tracker.harry.lu:80/announce
udp://open.stealth.si:80/announce
udp://9.rarbg.to:2900/announce
udp://9.rarbg.me:2720/announce
udp://opentor.org:2710/announce
µTorrent compatible trackers list

Download torrent
2.1 GB
seeders:36
leechers:13
Udemy - Master SQL - Simple to advanced 200 + queries


Torrent hash: 65A4547B901151361514CE742D47110069141DCD