Complete Guide to T-SQL for Data Analysts by Microsoft Press

Category Other
Type Tutorials
Language English
Total size 902.9 MB
Uploaded By freecoursewb

Downloads 104
Last checked 3 weeks ago
Date uploaded 3 weeks ago
Seeders 5
Leechers 7

Infohash : FDA9AC5FC768E6B2340A27012138B1F1E8EBC8D6

Complete Guide to T-SQL for Data Analysts by Microsoft Press

https://WebToolTip.com

Released 12/2025
With Chris Sorensen, Microsoft Press
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz, 2 Ch
Skill level: Beginner | Genre: eLearning | Language: English + subtitle | Duration: 6h 33m 49s | Size: 903 MB

Master T-SQL fundamentals for data analysis. Build skills in querying, joining, and managing databases with practical, business-focused instruction.

Course details
Unlock the power of SQL for business analytics in this approachable, beginner-to-intermediate course led by Chris Sorensen, Microsoft Certified Data Analyst and Trainer. Learn how to design, build, and manage relational databases using T-SQL, from foundational concepts to advanced techniques. Along the way, explore normalization, data integrity, indexing, and next-level database topics. Whether you’re a business user curious about SQL, an IT professional starting your data journey, or someone seeking to strengthen your data analysis skills, this course provides practical guidance rooted in industry best practices. No prior SQL experience required—just a familiarity with data management challenges.This course was created by Microsoft Press. We are pleased to host this training in our library.

                Files: 

                [ WebToolTip.com ] Complete Guide to T-SQL for Data Analysts by Microsoft Press
Get Bonus Downloads Here.url (0.2 KB)
~Get Your Files Here !01 - Introduction01 - Complete guide to T-SQL for data analysts Introduction.mp4 (22.8 MB)
- Complete guide to T-SQL for data analysts Introduction.srt (16.4 KB)
- 1. Data Concepts and Technical Setup01 - Learning objectives.mp4 (4.2 MB)
- Learning objectives.srt (2.7 KB)
- Introduction to SQL and T-SQL.mp4 (8.1 MB)
- Introduction to SQL and T-SQL.srt (7.4 KB)
- Describe features of structured data.mp4 (8.1 MB)
- Describe features of structured data.srt (7.0 KB)
- Describe features of semistructured data.mp4 (7.0 MB)
- Describe features of semistructured data.srt (5.3 KB)
- Describe features of unstructured data.mp4 (3.2 MB)
- Describe features of unstructured data.srt (2.5 KB)
- Describe common data storage mechanisms.mp4 (11.7 MB)
- Describe common data storage mechanisms.srt (10.4 KB)
- Relational database concepts.mp4 (37.9 MB)
- Relational database concepts.srt (29.9 KB)
- Describe features of transactional workloads.mp4 (14.6 MB)
- Describe features of transactional workloads.srt (14.1 KB)
- Describe features of analytical workloads.mp4 (16.0 MB)
- Describe features of analytical workloads.srt (18.3 KB)
- GitHub repository.mp4 (3.3 MB)
- GitHub repository.srt (2.0 KB)
- Tool installation.mp4 (11.4 MB)
- Tool installation.srt (8.6 KB)
- Database setup.mp4 (11.1 MB)
- Database setup.srt (7.8 KB)
- Schema walkthrough.mp4 (13.8 MB)
- Schema walkthrough.srt (8.9 KB)
- 2. Writing Single Table Queries01 - Learning objectives.mp4 (5.6 MB)
- Learning objectives.srt (4.4 KB)
- Introduction to writing SQL.mp4 (18.2 MB)
- Introduction to writing SQL.srt (13.7 KB)
- Basic SQL.mp4 (23.1 MB)
- Basic SQL.srt (16.7 KB)
- Filtering result sets Basics.mp4 (9.4 MB)
- Filtering result sets Basics.srt (7.0 KB)
- Filtering result sets Handling NULLS.mp4 (16.3 MB)
- Filtering result sets Handling NULLS.srt (11.5 KB)
- Filtering result sets Next level.mp4 (87.0 MB)
- Sorting result sets.mp4 (22.4 MB)
- Sorting result sets.srt (16.4 KB)
- Single-row functions.mp4 (59.6 MB)
- Aggregate functions.mp4 (15.2 MB)
- Aggregate functions.srt (11.5 KB)
- Exercise.mp4 (8.9 MB)
- Exercise.srt (6.8 KB)
- 3. Joining Multiple Tables01 - Learning objectives.mp4 (4.0 MB)
- Learning objectives.srt (2.9 KB)
- Introduction to joins.mp4 (9.8 MB)
- Introduction to joins.srt (9.2 KB)
- INNER joins.mp4 (5.6 MB)
- INNER joins.srt (4.9 KB)
- OUTER joins.mp4 (14.8 MB)
- OUTER joins.srt (13.1 KB)
- CROSS joins.mp4 (3.4 MB)
- CROSS joins.srt (3.2 KB)
- Special joins.mp4 (19.4 MB)
- Special joins.srt (15.9 KB)
- Exercise.mp4 (18.6 MB)
- Exercise.srt (12.6 KB)
- 4. Writing Subqueries01 - Learning objectives.mp4 (3.6 MB)
- Learning objectives.srt (2.6 KB)
- Introduction to subqueries.mp4 (1.8 MB)
- Introduction to subqueries.srt (1.3 KB)
- Self-contained subqueries.mp4 (20.5 MB)
- Self-contained subqueries.srt (11.8 KB)
- Correlated subqueries.mp4 (15.5 MB)
- Correlated subqueries.srt (11.0 KB)
- Exercise.mp4 (8.2 MB)
- Exercise.srt (5.2 KB)
- 5. Set Operators01 - Learning objectives.mp4 (5.5 MB)
- Learning objectives.srt (3.5 KB)
- Defining and rules for using set operators.mp4 (20.8 MB)
- Defining and rules for using set operators.srt (16.6 KB)
- UNION.mp4 (7.5 MB)
- UNION.srt (6.3 KB)
- EXCEPT.mp4 (4.6 MB)
- EXCEPT.srt (3.9 KB)
- INTERSECT.mp4 (4.4 MB)
- INTERSECT.srt (3.7 KB)
- Exercise.mp4 (9.4 MB)
- Exercise.srt (5.2 KB)
- 6. Manipulate Data in a Database01 - Learning objectives.mp4 (6.5 MB)
- Learning objectives.srt (4.4 KB)
- Inserting data.mp4 (29.8 MB)
- Inserting data.srt (20.1 KB)
- Updating data.mp4 (22.5 MB)
- Updating data.srt (12.6 KB)
- Deleting data.mp4 (7.0 MB)
- Deleting data.srt (5.3 KB)
- Truncating a table.mp4 (5.9 MB)
- Truncating a table.srt (5.3 KB)
- Exercise.mp4 (14.8 MB)
- Exercise.srt (9.9 KB)
- 7. Design a Database01 - Learning objectives.mp4 (5.3 MB)
- Learning objectives.srt (3.5 KB)
- System development lifecycle (SDLC).mp4 (8.0 MB)
- System development lifecycle (SDLC).srt (7.2 KB)
- Logical design.mp4 (12.7 MB)
- Logical design.srt (12.2 KB)
- Normalization.mp4 (17.5 MB)
- Normalization.srt (16.3 KB)
- Exercise.mp4 (8.5 MB)
- Exercise.srt (6.8 KB)
- 8. Build a Database01 - Learning objectives.mp4 (5.6 MB)
- Learning objectives.srt (3.9 KB)
- Creating and managing tables.mp4 (18.0 MB)
- Creating and managing tables.srt (17.0 KB)
- Data integrity constraints.mp4 (17.7 MB)
- Data integrity constraints.srt (17.4 KB)
- Speeding data access Indexing.mp4 (4.6 MB)
- Speeding data access Indexing.srt (4.5 KB)
- Create interfaces to the database using VIEWS.mp4 (3.6 MB)
- Create interfaces to the database using VIEWS.srt (3.3 KB)
- Exercise.mp4 (25.6 MB)
- Exercise.srt (15.7 KB)
- 9. Manage a Database01 - Learning objectives.mp4 (4.0 MB)
- Learning objectives.srt (3.2 KB)
- Controlling user access.mp4 (7.5 MB)
- Controlling user access.srt (6.6 KB)
- Transactions.mp4 (15.9 MB)
- Transactions.srt (12.7 KB)
- Metadata.mp4 (10.7 MB)
- Metadata.srt (6.8 KB)
- 10. Exploring the Road Ahead01 - Learning objectives.mp4 (6.1 MB)
- Learning objectives.srt (4.5 KB)
- Other T-SQL constructs Next level.mp4 (6.2 MB)
- Other T-SQL constructs Next level.srt (6.2 KB)
- Peek into Azure databases.mp4 (16.2 MB)
- Peek into Azure databases.srt (14.7 KB)
- Conclusion01 - Complete guide to T-SQL for data analysts Next steps.mp4 (5.9 MB)
- Complete guide to T-SQL for data analysts Next steps.srt (3.9 KB)
Bonus Resources.txt (0.1 KB)

There are currently no comments. Feel free to leave one :)

Code:

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