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

seeders: 0
leechers: 0
Added 6 months ago by freecoursewb in Other

Download Fast Safe Anonymous
movies, software, shows...

Files

Complete Guide to T-SQL for Data Analysts by Microsoft Press (Size: 902.9 MB)
  Bonus Resources.txt 102.4 B
  Get Bonus Downloads Here.url 204.8 B
  ~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 - 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 - 3. Joining Multiple Tables
  01 - Learning objectives.mp4 4 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 - 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 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 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 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 MB
  02 - Creating and managing tables.srt 17 KB
  03 - Data integrity constraints.mp4 17.7 MB
  03 - Data integrity constraints.srt 17.4 KB
  04 - Speeding data access Indexing.mp4 4.6 MB
  04 - Speeding data access Indexing.srt 4.5 KB
  05 - Create interfaces to the database using VIEWS.mp4 3.6 MB
  05 - Create interfaces to the database using VIEWS.srt 3.3 KB
  06 - Exercise.mp4 25.6 MB
  06 - Exercise.srt 15.7 KB
  10 - 9. Manage a Database
  01 - Learning objectives.mp4 4 MB
  01 - Learning objectives.srt 3.2 KB
  02 - Controlling user access.mp4 7.5 MB
  02 - Controlling user access.srt 6.6 KB
  03 - Transactions.mp4 15.9 MB
  03 - Transactions.srt 12.7 KB
  04 - Metadata.mp4 10.7 MB
  04 - Metadata.srt 6.8 KB
  11 - 10. Exploring the Road Ahead
  01 - Learning objectives.mp4 6.1 MB
  01 - Learning objectives.srt 4.5 KB
  02 - Other T-SQL constructs Next level.mp4 6.2 MB
  02 - Other T-SQL constructs Next level.srt 6.2 KB
  03 - Peek into Azure databases.mp4 16.2 MB
  03 - Peek into Azure databases.srt 14.7 KB
  12 - Conclusion
  01 - Complete guide to T-SQL for data analysts Next steps.mp4 5.9 MB
  01 - Complete guide to T-SQL for data analysts Next steps.srt 3.9 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
  04 - Filtering result sets Basics.mp4 9.4 MB
  04 - Filtering result sets Basics.srt 7 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 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
  03 - Describe features of structured data.mp4 8.1 MB
  03 - Describe features of structured data.srt 7 KB
  04 - Describe features of semistructured data.mp4 7 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 MB
  09 - Describe features of analytical workloads.srt 18.3 KB
  10 - GitHub repository.mp4 3.3 MB
  10 - GitHub repository.srt 2 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

Description


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.

Related Torrents

torrent name size uploader age seed leech
9
5
8
16
7