Torrent Downloads » Other » [ DevCourseWeb com ] Udemy - Master SQL - Simple to advanced 200 + queries
Other
[ DevCourseWeb com ] Udemy - Master SQL - Simple to advanced 200 + queries
Torrent info
Torrent Files List
Get Bonus Downloads Here.url (Size: 2.13 GB) (Files: 68)
Get Bonus Downloads Here.url
~Get Your Files Here !
1. Introduction
1. Introduction.html
2. Install PostgreSQL 13.mp4
3. Install pgAdmin 4 v5.5.mp4
4. Run PostgreSQL on the cloud.mp4
10. Stocks Markets Analysis
1. Introduction to Stock Markets Data.html
10. CODE Find total stocks per each sectors.html
2. CODE Table Creation - Sectors, Symbols, Prices.html
3. Import sample datasets.mp4
4. CODE Import sample datasets.html
5. Important - SQL Query is in CODE Articles.mp4
6. List data, sectors in ascending and descending orders.mp4
7. CODE List data, sectors in ascending and descending orders.html
8. Using COUNT, WHERE, IN and NOT IN with sectors.mp4
9. CODE Using COUNT, WHERE, IN and NOT IN with sectors.html
__MACOSX
_stocks_prices_historical.csv
_stocks_prices_latest.csv
_stocks_sectors.csv
_stocks_symbols.csv
stocks_prices_historical.csv
stocks_prices_latest.csv
stocks_sectors.csv
stocks_symbols.csv
11. Congratulations and Thank You!
1. Your feedback is very valuable!.html
2. Updates to the course.html
3. Bonus Lectures.html
2. Employees Management System
1. Understand the database model.mp4
10. Staking tables together.mp4
2. Create tables and populate data.mp4
2.1 sql_emp_tables_and_data.sql
3. Get filtered data via WHERE clause.mp4
4. Referencing an alias and concatenate columns.mp4
5. Using conditional logic with CASE expression.mp4
6. Using ORDER BY, LIMIT and RANDOM.mp4
7. Find NULL values and transform into real values.mp4
8. Searching for patterns.mp4
9. Sorting on data dependent key.mp4
3. Hierarchical Queries
1. Expressing a Parent-Child Relationship.mp4
2. Expressing a Child-Parent-Grandparent Relationship.mp4
3. Creating a hierarchical view of a table.mp4
4. Finding all child rows for a given parent row.mp4
5. Which rows are leaf, branch, or root nodes.mp4
4. Working with numbers
1. Computing an average, minmax values.mp4
2. Sum, and count.mp4
3. Generating a running total.mp4
4. Calculating 3-point moving averages.mp4
4.1 daily_sales.sql
5. Calculate a mode.mp4
6. Calculate a median, averages without highs and lows.mp4
5. Date Arithmetic
1. Add, subtract dates, and numbers of days.mp4
2. Compute running date difference.mp4
3. Comparing records using dates.mp4
6. Advances Searching
1. Find differences between rows within same group or partition.mp4
2. Pagination.mp4
3. Skipping n rows.mp4
4. Selecting the Top n Records.mp4
7. Window Functions
1. Turn aggregate function to window function.mp4
2. PARTITION BY clause.mp4
3. Handling NULLs.mp4
4. The ORDER BY clause matters.mp4
8. Metadata Queries
1. Listing tables, columns and indexes.mp4
2. Listing constraints on a table.mp4
3. Using SQL to Generate SQL.mp4
9. International Debt Analysis
1. Preparing the data.mp4
1.1 sql_international_debts_data.sql
2. Analyzing International debt - Part 1.mp4
3. Analyzing International debt - Part 2.mp4
Bonus Resources.txt
Torrent description
Feel free to post any comments about this torrent, including links to Subtitle, samples, screenshots, or any other relevant information, Watch [ DevCourseWeb com ] Udemy - Master SQL - Simple to advanced 200 + queries Online Free Full Movies Like 123Movies, Putlockers, Fmovies, Netflix or Download Direct via Magnet Link in Torrent Details.
