Download Udemy - Master SQL - Simple to advanced 200 + queries torrent

Udemy - Master SQL - Simple to advanced 200 + queries

Torrent:	Udemy - Master SQL - Simple to advanced 200 + queries
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
Downloads:	190
Category:	Other /Tutorials
Size:	2.1 GB
Show 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) files
Added:	2023-11-02 11:02:31
Language:	English
Peers:	Seeders : 36 , Leechers : 13
Tags:	Development SQL Udemy
Release name:	Udemy - Master SQL - Simple to advanced 200 + queries
Trackers:	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