NEED HELP? TALK TO AN EXPERT (904) 638-5743

Learn with the Nerds – Beginner to T-SQL (Recorded Live Event)

Part Of The On-Demand Courses

WHAT YOU'LL LEARN

  • What is T-SQL
  • The SELECT query and its elements
  • CALCULATE Function
  • 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
This course includes:

Course Description

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!

Outline

 

Module 01 | What is T-SQL

 

Module 02 | The SELECT query and its elements

 

Module 03 | How to retrieve data and filter the data

 

Module 04 | How to write single table queries and multi-table joins

 

Module 05 | How to return data in an aggregated format

Instructor

MITCHELL PEARSON

Training Content Manager
Mitchell Pearson has been with Pragmatic Works for 8 years as a Data Platform Consultant and the Training Content manager. Mitchell has authored books on SQL Server, Power BI and the Power Platform. Data Platform experience includes designing and implementing enterprise level Business Intelligence solutions with the Microsoft SQL Server stack (T-SQL, SSIS, SSAS, SSRS), the Power Platform and Microsoft Azure.

 

Click Here To Learn More About Mitchell And See Certifications And Reviews

System Requirements

What to Know Before Class

  • There are no prerequisite skills needed for this course.
REVIEWS

Pending reviews - check back later

Pending reviews - check back later

Pending reviews - check back later

Start With The Free Community Plan

Pragmatic Works free community plan gives you lifetime access to 7 Microsoft “in a day” courses on Power BI, Excel, Power Apps, Azure Synapse, Power Automate, Paginated Reports and Chatbots.

 

Bonus:

• Get preview access to all 70+ courses & custom Learning Paths for 7 days

• Labs and files included

• Access courses from our mobile app or desktop

• Access quizzes to practice while you learn

Get Instant Access Now!