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

  • CategoryOther
  • TypeTutorials
  • LanguageEnglish
  • Total size902.9 MB
  • Uploaded Byfreecoursewb
  • Downloads106
  • Last checkedDec. 24th '25
  • Date uploadedDec. 24th '25
  • Seeders 5
  • Leechers7

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 - Introduction
    • 01 - Complete guide to T-SQL for data analysts Introduction.mp4 (22.8 MB)
    • 01 - Complete guide to T-SQL for data analysts Introduction.srt (16.4 KB)
    02 - 1. Data Concepts and Technical Setup
    • 01 - Learning objectives.mp4 (4.2 MB)
    • 01 - Learning objectives.srt (2.7 KB)
    • 02 - Introduction to SQL and T-SQL.mp4 (8.1 MB)
    • 02 - Introduction to SQL and T-SQL.srt (7.4 KB)
    • 03 - Describe features of structured data.mp4 (8.1 MB)
    • 03 - Describe features of structured data.srt (7.0 KB)
    • 04 - Describe features of semistructured data.mp4 (7.0 MB)
    • 04 - Describe features of semistructured data.srt (5.3 KB)
    • 05 - Describe features of unstructured data.mp4 (3.2 MB)
    • 05 - Describe features of unstructured data.srt (2.5 KB)
    • 06 - Describe common data storage mechanisms.mp4 (11.7 MB)
    • 06 - Describe common data storage mechanisms.srt (10.4 KB)
    • 07 - Relational database concepts.mp4 (37.9 MB)
    • 07 - Relational database concepts.srt (29.9 KB)
    • 08 - Describe features of transactional workloads.mp4 (14.6 MB)
    • 08 - Describe features of transactional workloads.srt (14.1 KB)
    • 09 - Describe features of analytical workloads.mp4 (16.0 MB)
    • 09 - Describe features of analytical workloads.srt (18.3 KB)
    • 10 - GitHub repository.mp4 (3.3 MB)
    • 10 - GitHub repository.srt (2.0 KB)
    • 11 - Tool installation.mp4 (11.4 MB)
    • 11 - Tool installation.srt (8.6 KB)
    • 12 - Database setup.mp4 (11.1 MB)
    • 12 - Database setup.srt (7.8 KB)
    • 13 - Schema walkthrough.mp4 (13.8 MB)
    • 13 - Schema walkthrough.srt (8.9 KB)
    03 - 2. Writing Single Table Queries
    • 01 - Learning objectives.mp4 (5.6 MB)
    • 01 - Learning objectives.srt (4.4 KB)
    • 02 - Introduction to writing SQL.mp4 (18.2 MB)
    • 02 - Introduction to writing SQL.srt (13.7 KB)
    • 03 - Basic SQL.mp4 (23.1 MB)
    • 03 - Basic SQL.srt (16.7 KB)
    • 04 - Filtering result sets Basics.mp4 (9.4 MB)
    • 04 - Filtering result sets Basics.srt (7.0 KB)
    • 05 - Filtering result sets Handling NULLS.mp4 (16.3 MB)
    • 05 - Filtering result sets Handling NULLS.srt (11.5 KB)
    • 06 - Filtering result sets Next level.mp4 (87.0 MB)
    • 07 - Sorting result sets.mp4 (22.4 MB)
    • 07 - Sorting result sets.srt (16.4 KB)
    • 08 - Single-row functions.mp4 (59.6 MB)
    • 09 - Aggregate functions.mp4 (15.2 MB)
    • 09 - Aggregate functions.srt (11.5 KB)
    • 10 - Exercise.mp4 (8.9 MB)
    • 10 - Exercise.srt (6.8 KB)
    04 - 3. Joining Multiple Tables
    • 01 - Learning objectives.mp4 (4.0 MB)
    • 01 - Learning objectives.srt (2.9 KB)
    • 02 - Introduction to joins.mp4 (9.8 MB)
    • 02 - Introduction to joins.srt (9.2 KB)
    • 03 - INNER joins.mp4 (5.6 MB)
    • 03 - INNER joins.srt (4.9 KB)
    • 04 - OUTER joins.mp4 (14.8 MB)
    • 04 - OUTER joins.srt (13.1 KB)
    • 05 - CROSS joins.mp4 (3.4 MB)
    • 05 - CROSS joins.srt (3.2 KB)
    • 06 - Special joins.mp4 (19.4 MB)
    • 06 - Special joins.srt (15.9 KB)
    • 07 - Exercise.mp4 (18.6 MB)
    • 07 - Exercise.srt (12.6 KB)
    05 - 4. Writing Subqueries
    • 01 - Learning objectives.mp4 (3.6 MB)
    • 01 - Learning objectives.srt (2.6 KB)
    • 02 - Introduction to subqueries.mp4 (1.8 MB)
    • 02 - Introduction to subqueries.srt (1.3 KB)
    • 03 - Self-contained subqueries.mp4 (20.5 MB)
    • 03 - Self-contained subqueries.srt (11.8 KB)
    • 04 - Correlated subqueries.mp4 (15.5 MB)
    • 04 - Correlated subqueries.srt (11.0 KB)
    • 05 - Exercise.mp4 (8.2 MB)
    • 05 - Exercise.srt (5.2 KB)
    06 - 5. Set Operators
    • 01 - Learning objectives.mp4 (5.5 MB)
    • 01 - Learning objectives.srt (3.5 KB)
    • 02 - Defining and rules for using set operators.mp4 (20.8 MB)
    • 02 - Defining and rules for using set operators.srt (16.6 KB)
    • 03 - UNION.mp4 (7.5 MB)
    • 03 - UNION.srt (6.3 KB)
    • 04 - EXCEPT.mp4 (4.6 MB)
    • 04 - EXCEPT.srt (3.9 KB)
    • 05 - INTERSECT.mp4 (4.4 MB)
    • 05 - INTERSECT.srt (3.7 KB)
    • 06 - Exercise.mp4 (9.4 MB)
    • 06 - Exercise.srt (5.2 KB)
    07 - 6. Manipulate Data in a Database
    • 01 - Learning objectives.mp4 (6.5 MB)
    • 01 - Learning objectives.srt (4.4 KB)
    • 02 - Inserting data.mp4 (29.8 MB)
    • 02 - Inserting data.srt (20.1 KB)
    • 03 - Updating data.mp4 (22.5 MB)
    • 03 - Updating data.srt (12.6 KB)
    • 04 - Deleting data.mp4 (7.0 MB)
    • 04 - Deleting data.srt (5.3 KB)
    • 05 - Truncating a table.mp4 (5.9 MB)
    • 05 - Truncating a table.srt (5.3 KB)
    • 06 - Exercise.mp4 (14.8 MB)
    • 06 - Exercise.srt (9.9 KB)
    08 - 7. Design a Database
    • 01 - Learning objectives.mp4 (5.3 MB)
    • 01 - Learning objectives.srt (3.5 KB)
    • 02 - System development lifecycle (SDLC).mp4 (8.0 MB)
    • 02 - System development lifecycle (SDLC).srt (7.2 KB)
    • 03 - Logical design.mp4 (12.7 MB)
    • 03 - Logical design.srt (12.2 KB)
    • 04 - Normalization.mp4 (17.5 MB)
    • 04 - Normalization.srt (16.3 KB)
    • 05 - Exercise.mp4 (8.5 MB)
    • 05 - Exercise.srt (6.8 KB)
    09 - 8. Build a Database
    • 01 - Learning objectives.mp4 (5.6 MB)
    • 01 - Learning objectives.srt (3.9 KB)
    • 02 - Creating and managing tables.mp4 (18.0 MB)
    • 02 - Creating and managing tables.srt (17.0 KB)
    • 03

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