Don't like banners? Log in and we will make sure you see no banners. For free.
No cover art

Udemy - Master SQL - Simple to advanced 200 + queries

Other
Size
2.1 GB
Seeders
2
Leechers
2
Files
67
Category
Other
Added
at 10:51pm GMT+1
Infohash
65a4547b901151361514ce742d47110069141dcd
Direct linkTorrent fileDownload now
Don't like banners? Log in and we will make sure you see no banners. For free.

Description
[ DevCourseWeb.com ] Master SQL - Simple to advanced 200+ queries



If You Need More Stuff, kindly Visit and Support Us -->> 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



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...



Image error



Image error

File list
  • Udemy - Master SQL - Simple to advanced 200 + queries
  • ~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 89.6 MB
  • ~Get Your Files Here !/Bonus Resources.txt 386 B

Rating
Not rated yet
Log in to rate

Comments

No comments yet.


Similar torrents
NameSizeDate
675 MB20
1.3 GB01
2.3 GB01
1023 MB01
833 MB01