Udemy - SQL Data Analysis for beginners - MS SQL SQL Server SSMS

seeders: 9
leechers: 4
updated:
Download torrent
Added by freecoursewb in Other > Tutorials
Download Fast Safe Anonymous
movies, software, shows...

Files

[ CourseMega.com ] Udemy - SQL Data Analysis for beginners - MS SQL SQL Server SSMS
  • Get Bonus Downloads Here.url (0.2 KB)
    • ~Get Your Files Here ! 1. SQL Server Setup
    • 1. Introduction.mp4 (1.5 MB)
    • 10. Connect SSMS to SQL Server.mp4 (36.8 MB)
    • 11. Install Sample database.mp4 (32.6 MB)
    • 12. Basic database concepts.mp4 (18.9 MB)
    • 2. What is SQL Server.mp4 (11.2 MB)
    • 3. What is SQL.mp4 (15.2 MB)
    • 4. What is MS SQL (T-SQL).mp4 (7.4 MB)
    • 5. SQL Server Hardware and Software Requirements.mp4 (21.5 MB)
    • 6. SQL Server Editions.mp4 (28.5 MB)
    • 7. Download SQL Server.mp4 (23.2 MB)
    • 8. Install SQL Server.mp4 (62.5 MB)
    • 9. Install SSMS.mp4 (36.8 MB)
    2. Filtering Data
    • 1. Introduction.mp4 (9.1 MB)
    • 2. Filtering data with basic equality filters.mp4 (129.8 MB)
    • 3. Filtering data with basic comparisons.mp4 (55.8 MB)
    • 4. Filtering data with logical comparisons.mp4 (153.4 MB)
    • 5. Filtering data with String Comparisons.mp4 (113.3 MB)
    • 6. Filtering data with NULL Comparisons.mp4 (42.7 MB)
    3. Sorting Data
    • 1. Introduction.mp4 (2.5 MB)
    • 2. Order By Clause.mp4 (28.3 MB)
    • 3. Sorting by ascending.mp4 (38.7 MB)
    • 4. Sorting by descending.mp4 (42.1 MB)
    • 5. Sorting by multiple columns.mp4 (47.7 MB)
    4. Extract Combine Data From Different Tables
    • 1. Introduction.mp4 (1.6 MB)
    • 2. Why Table Joins are necessary.mp4 (3.9 MB)
    • 3. Using INNER Join.mp4 (111.6 MB)
    • 4. Using LEFT Outer Join.mp4 (110.3 MB)
    • 5. Using Right Outer Join.mp4 (85.2 MB)
    5. Aggregating and Grouping Data
    • 1. Introduction.mp4 (4.7 MB)
    • 10. Grouping Data.mp4 (71.6 MB)
    • 2. Using COUNT ( ) Aggregate Function.mp4 (65.8 MB)
    • 3. Using AVG ( ) Aggregate Function.mp4 (61.1 MB)
    • 4. Using MAX ( ) Aggregate Function.mp4 (42.2 MB)
    • 5. Using MIN ( ) Aggregate Function.mp4 (46.0 MB)
    • 6. Using SUM ( ) Aggregate Function.mp4 (47.7 MB)
    • 7. Using VAR Function.mp4 (12.8 MB)
    • 8. Using VARP Function.mp4 (11.0 MB)
    • 9. Using Multiple Aggregate Functions.mp4 (49.9 MB)
    6. Data Analysis using SET Operators
    • 1. What are SET Operators.mp4 (2.3 MB)
    • 2. Query Data with EXCEPT.mp4 (28.5 MB)
    • 3. Query Data with INTERSECT.mp4 (18.0 MB)
    • 4. Query Data with UNION.mp4 (30.2 MB)
    7. Data Analysis using Analytic Functions
    • 1. What are Analytic Functions.mp4 (21.8 MB)
    • 10. Using LAST_VALUE Function.mp4 (22.6 MB)
    • 11. Using PERCENT_RANK Function.mp4 (25.8 MB)
    • 12. Using PERCENT_COUNT Function.mp4 (16.6 MB)
    • 13. Using PERCENTILE_DISC Function.mp4 (22.2 MB)
    • 2. Syntax for Analytic Functions.mp4 (12.0 MB)
    • 3. CUME_DIST Function.mp4 (21.1 MB)
    • 4. Row Number Functions.mp4 (20.6 MB)
    • 5. Rank Functions.mp4 (21.6 MB)
    • 6. NTILE Function.mp4 (20.2 MB)
    • 7. Using LEAD Function.mp4 (34.6 MB)
    • 8. Using the LAG Function.mp4 (34.0 MB)
    • 9. Using FIRST_VALUE Function.mp4 (19.4 MB)
    8. 27 Real World Data Analysis SQL Queries
    • 1. Download Sample Database.mp4 (25.0 MB)
    • 10. Data Analysis of Most and least expensive products.mp4 (59.5 MB)
    • 11. Data Analysis of Orders placed.mp4 (75.0 MB)
    • 12. Data Analysis of Orders shipped to specific countries.mp4 (47.2 MB)
    • 13. Data Analysis of products stock.mp4 (74.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. Install Sample Database.mp4 (42.0 MB)
    • 3. Data Analysis of Countries with Customers.mp4 (57.2 MB)
    • 4. Data Analysis of Customer Contact Titles.mp4 (66.8 MB)
    • 5. Data Analysis of Customers and Employee Count.mp4 (41.9 MB)
    • 6. Data Analysis of Employee Full Name.mp4 (69.8 MB)
    • 7. Data Analysis of Customer First Order.mp4 (50.4 MB)
    • 8. Data Analysis of discontinued products.mp4 (56.6 MB)
    • 9. Data Analysis of Shippers.mp4 (40.8 MB)
    • Bonus Resources.txt (0.3 KB)

Description

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.



Download torrent
2.9 GB
seeders:9
leechers:4
Udemy - SQL Data Analysis for beginners - MS SQL SQL Server SSMS

Trackers

tracker name
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
µTorrent compatible trackers list

Download torrent
2.9 GB
seeders:9
leechers:4
Udemy - SQL Data Analysis for beginners - MS SQL SQL Server SSMS

Torrent hash: B22A4A02367396DC41AAAF5D93881422ADD73625