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

File Name

Size

Get Bonus Downloads Here.url

182 B

~Get Your Files Here !/1. Introduction/1. Introduction.html

2.1 kB

~Get Your Files Here !/1. Introduction/2. Install PostgreSQL 13.mp4

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

13 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 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/__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 !/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 !/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 MB

~Get Your Files Here !/2. Employees Management System/10. Staking tables together.mp4

76 MB

~Get Your Files Here !/2. Employees Management System/2. Create tables and populate data.mp4

90 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

121 MB

~Get Your Files Here !/2. Employees Management System/4. Referencing an alias and concatenate columns.mp4

58 MB

~Get Your Files Here !/2. Employees Management System/5. Using conditional logic with CASE expression.mp4

48 MB

~Get Your Files Here !/2. Employees Management System/6. Using ORDER BY, LIMIT and RANDOM.mp4

51 MB

~Get Your Files Here !/2. Employees Management System/7. Find NULL values and transform into real values.mp4

39 MB

~Get Your Files Here !/2. Employees Management System/8. Searching for patterns.mp4

54 MB

~Get Your Files Here !/2. Employees Management System/9. Sorting on data dependent key.mp4

67 MB

~Get Your Files Here !/3. Hierarchical Queries/1. Expressing a Parent-Child Relationship.mp4

69 MB

~Get Your Files Here !/3. Hierarchical Queries/2. Expressing a Child-Parent-Grandparent Relationship.mp4

53 MB

~Get Your Files Here !/3. Hierarchical Queries/3. Creating a hierarchical view of a table.mp4

48 MB

~Get Your Files Here !/3. Hierarchical Queries/4. Finding all child rows for a given parent row.mp4

20 MB

~Get Your Files Here !/3. Hierarchical Queries/5. Which rows are leaf, branch, or root nodes.mp4

68 MB

~Get Your Files Here !/4. Working with numbers/1. Computing an average, minmax values.mp4

26 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 MB

~Get Your Files Here !/4. Working with numbers/4. Calculating 3-point moving averages.mp4

48 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 MB

~Get Your Files Here !/4. Working with numbers/6. Calculate a median, averages without highs and lows.mp4

30 MB

~Get Your Files Here !/5. Date Arithmetic/1. Add, subtract dates, and numbers of days.mp4

53 MB

~Get Your Files Here !/5. Date Arithmetic/2. Compute running date difference.mp4

34 MB

~Get Your Files Here !/5. Date Arithmetic/3. Comparing records using dates.mp4

34 MB

~Get Your Files Here !/6. Advances Searching/1. Find differences between rows within same group or partition.mp4

35 MB

~Get Your Files Here !/6. Advances Searching/2. Pagination.mp4

22 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

32 MB

~Get Your Files Here !/7. Window Functions/1. Turn aggregate function to window function.mp4

50 MB

~Get Your Files Here !/7. Window Functions/2. PARTITION BY clause.mp4

51 MB

~Get Your Files Here !/7. Window Functions/3. Handling NULLs.mp4

29 MB

~Get Your Files Here !/7. Window Functions/4. The ORDER BY clause matters.mp4

47 MB

~Get Your Files Here !/8. Metadata Queries/1. Listing tables, columns and indexes.mp4

79 MB

~Get Your Files Here !/8. Metadata Queries/2. Listing constraints on a table.mp4

47 MB

~Get Your Files Here !/8. Metadata Queries/3. Using SQL to Generate SQL.mp4

32 MB

~Get Your Files Here !/9. International Debt Analysis/1. Preparing the data.mp4

34 MB

~Get Your Files Here !/9. International Debt Analysis/1.1 sql_international_debts_data.sql

224 kB

~Get Your Files Here !/9. International Debt Analysis/2. Analyzing International debt - Part 1.mp4

57 MB

~Get Your Files Here !/9. International Debt Analysis/3. Analyzing International debt - Part 2.mp4

90 MB

~Get Your Files Here !/Bonus Resources.txt

386 B