Home / T-SQL / Learn with the Nerds - Beginner to T-SQL (Recorded Live Event)
Learn with the Nerds - Beginner to T-SQL (Recorded Live Event)
Learn T-SQL, the primary language for data management. Build strong fundamentals with Mitchell Pearson's session. Quick and efficient T-SQL startup. Learn database concepts, query writing, enhance your database expertise.
For decades, T-SQL (Structured Query Language) has been the primary language for storing, retrieving, and manipulating data in databases. As greater amounts of data are imported into environments, organizations need individuals that have built their database knowledge upon strong fundamentals.
In this session, Mitchell Pearson will teach you how to get started with T-SQL quickly and efficiently. You will learn database fundamentals and concepts, then dive into writing T-SQL queries. You'll also learn how to filter, find data, and tackle writing multi-table joins. After watching our Learn with The Nerds session, you will have acquired the skills and confidence to begin writing and querying data in your very own environment!
✔ What You’ll Learn:
• What is T-SQL
• The SELECT query and its elements
• How to retrieve data and filter the data
• How to write single-table queries and multi-table joins
• How to return data in an aggregated format
✔️ Download student files - [Learn with the Nerds - Beginner to T-SQL](https://learning.pragmaticworkstraining.com/api/upload/get/687e2c15-00f0-49ed-b59f-419ccfec8c76.zip)
👉 To download your certificate of completion, visit: https://prag.works/certificate-beginner-to-tsql
Mitchell Pearson is a Solution Architect, Consultant, and Trainer with 14 years of experience at Pragmatic Works helping organizations modernize their data and analytics platforms using Microsoft Azure and Microsoft Fabric. He specializes in designing scalable, enterprise-ready data solutions that align technical architecture with real business outcomes.
Mitchell is known for helping organizations navigate some of the most complex aspects of modern data platforms. Whether guiding customers through Fabric implementations, data modernization initiatives, or enterprise analytics strategies, he has a unique ability to break down sophisticated concepts into practical, understandable frameworks. From Lakehouse architecture and data engineering to medallion architecture design and governance strategies, Mitchell helps teams understand not only what to build, but why it matters and how to implement it successfully.
As a Solution Architect, Mitchell works closely with customers to design both consulting engagements and training programs that accelerate adoption and ensure long-term success. He helps organizations create clear roadmaps for Azure and Fabric implementations, balancing technical best practices with business priorities. His experience spans data platform modernization, analytics strategy, cloud migration, AI readiness, governance, and enterprise reporting solutions.
A recognized author, speaker, and educator, Mitchell has written books on SQL Server, Power BI, and the Power Platform and regularly shares insights on modern data architecture and analytics. His technical expertise includes Microsoft Fabric, Azure data services, Power BI, and the broader Microsoft data ecosystem. Customers value his ability to make complex technologies approachable, helping technical and business teams align around a common vision and confidently move forward with modern data solutions.
Prerequisites: (to follow along)
✔️ Download the latest version of SSMS - https://tinyurl.com/bdh72b3n
✔️ Download student files - [Learn with the Nerds - Beginner to T-SQL](https://learning.pragmaticworkstraining.com/api/upload/get/687e2c15-00f0-49ed-b59f-419ccfec8c76.zip)