| 1. Download Sample Database.mp4 | 25 MB | ||
| 1. Introduction.mp4 | 4.7 MB | ||
| 1. What are Analytic Functions.mp4 | 21.8 MB | ||
| 1. What are SET Operators.mp4 | 2.3 MB | ||
| 10. Connect SSMS to SQL Server.mp4 | 36.8 MB | ||
| 10. Data Analysis of Most and least expensive products.mp4 | 59.5 MB | ||
| 10. Grouping Data.mp4 | 71.6 MB | ||
| 10. Using LAST_VALUE Function.mp4 | 22.6 MB | ||
| 11. Data Analysis of Orders placed.mp4 | 75 MB | ||
| 11. Install Sample database.mp4 | 32.6 MB | ||
| 11. Using PERCENT_RANK Function.mp4 | 25.8 MB | ||
| 12. Basic database concepts.mp4 | 18.9 MB | ||
| 12. Data Analysis of Orders shipped to specific countries.mp4 | 47.2 MB | ||
| 12. Using PERCENT_COUNT Function.mp4 | 16.6 MB | ||
| 13. Data Analysis of products stock.mp4 | 74.2 MB | ||
| 13. Using PERCENTILE_DISC Function.mp4 | 22.2 MB | ||
| 14. Data Analysis of specific products.mp4 | 66.9 MB | ||
| 15. Data Analysis of Total price.mp4 | 66.2 MB | ||
| 16. Data Analysis of Sales Reps.mp4 | 75.3 MB | ||
| 2. Filtering data with basic equality filters.mp4 | 129.8 MB | ||
| 2. Install Sample Database.mp4 | 42 MB | ||
| 2. Order By Clause.mp4 | 28.3 MB | ||
| 2. Query Data with EXCEPT.mp4 | 28.5 MB | ||
| 2. Syntax for Analytic Functions.mp4 | 12 MB | ||
| 2. Using COUNT ( ) Aggregate Function.mp4 | 65.8 MB | ||
| 2. What is SQL Server.mp4 | 11.2 MB | ||
| 2. Why Table Joins are necessary.mp4 | 3.9 MB | ||
| 3. CUME_DIST Function.mp4 | 21.1 MB | ||
| 3. Data Analysis of Countries with Customers.mp4 | 57.2 MB | ||
| 3. Filtering data with basic comparisons.mp4 | 55.8 MB | ||
| 3. Query Data with INTERSECT.mp4 | 18 MB | ||
| 3. Sorting by ascending.mp4 | 38.7 MB | ||
| 3. Using AVG ( ) Aggregate Function.mp4 | 61.1 MB | ||
| 3. Using INNER Join.mp4 | 111.6 MB | ||
| 3. What is SQL.mp4 | 15.2 MB | ||
| 4. Data Analysis of Customer Contact Titles.mp4 | 66.8 MB | ||
| 4. Filtering data with logical comparisons.mp4 | 153.4 MB | ||
| 4. Query Data with UNION.mp4 | 30.2 MB | ||
| 4. Row Number Functions.mp4 | 20.6 MB | ||
| 4. Sorting by descending.mp4 | 42.1 MB | ||
| 4. Using LEFT Outer Join.mp4 | 110.3 MB | ||
| 4. Using MAX ( ) Aggregate Function.mp4 | 42.2 MB | ||
| 4. What is MS SQL (T-SQL).mp4 | 7.4 MB | ||
| 5. Data Analysis of Customers and Employee Count.mp4 | 41.9 MB | ||
| 5. Filtering data with String Comparisons.mp4 | 113.3 MB | ||
| 5. Rank Functions.mp4 | 21.6 MB | ||
| 5. SQL Server Hardware and Software Requirements.mp4 | 21.5 MB | ||
| 5. Sorting by multiple columns.mp4 | 47.7 MB | ||
| 5. Using MIN ( ) Aggregate Function.mp4 | 46 MB | ||
| 5. Using Right Outer Join.mp4 | 85.2 MB | ||
| 6. Data Analysis of Employee Full Name.mp4 | 69.8 MB | ||
| 6. Filtering data with NULL Comparisons.mp4 | 42.7 MB | ||
| 6. NTILE Function.mp4 | 20.2 MB | ||
| 6. SQL Server Editions.mp4 | 28.5 MB | ||
| 6. Using SUM ( ) Aggregate Function.mp4 | 47.7 MB | ||
| 7. Data Analysis of Customer First Order.mp4 | 50.4 MB | ||
| 7. Download SQL Server.mp4 | 23.2 MB | ||
| 7. Using LEAD Function.mp4 | 34.6 MB | ||
| 7. Using VAR Function.mp4 | 12.8 MB | ||
| 8. Data Analysis of discontinued products.mp4 | 56.6 MB | ||
| 8. Install SQL Server.mp4 | 62.5 MB | ||
| 8. Using VARP Function.mp4 | 11 MB | ||
| 8. Using the LAG Function.mp4 | 34 MB | ||
| 9. Data Analysis of Shippers.mp4 | 40.8 MB | ||
| 9. Install SSMS.mp4 | 36.8 MB | ||
| 9. Using FIRST_VALUE Function.mp4 | 19.4 MB | ||
| 9. Using Multiple Aggregate Functions.mp4 | 49.9 MB | ||
| Bonus Resources.txt | 307.2 B | ||
| Get Bonus Downloads Here.url | 204.8 B | ||
| ▲ 73 total files | |||
SQL Data Analysis for beginners: MS SQL | SQL Server | SSMS
https://CourseMega.com
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz, 2 Ch
Genre: eLearning | Language: English + srt | Duration: 71 lectures (6h 31m) | Size: 2.51 GB
Master real World Data Analysis with SQL
What you'll learn:
Extract | Combine Data From Different Tables
Sorting Data
Filtering Data
Aggregating and Grouping Data
Data Analysis using SET Operators
Data Analysis using Analytic Functions
Build 27 Real World Data Analysis SQL Queries
Requirements
Basic knowledge of database concepts advised
Description
The volume of data available is huge and increasing daily. Structured Query Language -SQL (pronounced as sequel) is the standard language used to communicate and interact with data stored in relational management database systems like Microsoft SQL Server Oracle, PostgreSQL,MySQL etc.
Different database management systems have their own proprietary version of the SQL language but they all conform to using some commands in SQL the same way. Microsoft SQL Server's version of SQL is known as Transact-SQL (T-SQL). In this course you will learn the basics of the SQL language and Transact-SQL since both use certain commands in the same way.
| torrent name | size | uploader | age | seed | leech |
|---|---|---|---|---|---|
| 1.6 GB | freecoursewb | 3 days | 0 | 0 | |
| 1.3 GB | freecoursewb | 3 days | 0 | 0 | |
| 258.8 MB | freecoursewb | 3 days | 0 | 0 | |
| 3.8 GB | freecoursewb | 1 month | 23 | 3 | |
| 1.7 GB | freecoursewb | 1 month | 16 | 1 |
All Comments