TOIT Training

Log in

Menu
Contact Sales
Roadmap

Beginner to T-SQL

Last updated: May 6, 2026

Overview

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 session, you will have acquired the skills and confidence to begin writing and querying data in your very own environment!

Curriculum

  • 32 Sections
  • 0 Lessons
  • 198 Minutes
Expand all sectionsCollapse all sections
  • 01. Class Introduction
    0
    • 02. Introduction to Power BI Reporting (Overview)
      0
      • 03. Introduction to Power BI Reporting (Licensing)
        0
        • 04. Introduction to the Reporting Environment (Getting to Know the Paginated Report Builder)
          0
          • 05. Introduction to the Reporting Environment (Designing Report Layouts)
            0
            • 06. Introduction to the Reporting Environment (Setting Dynamic Properties)
              0
              • 07. Building Your First Report
                0
                • 08. Bringing Data Into Your Report (Creating A Data Source)
                  0
                  • 09. Bringing Data Into Your Report (Creating A Dataset)
                    0
                    • 10. Bringing Data Into Your Report (Previewing Data Options)
                      0
                      • 11. Using Report Items (Line, Textbox, Rectangle)
                        0
                        • 12. Using Report Items (Working with Images)
                          0
                          • 13. Understanding The Table And Matrix (Table)
                            0
                            • 14. Understanding The Table And Matrix (Matrix)
                              0
                              • 15. Building A Report With Parameters (Parameter Basics)
                                0
                                • 16. Building A Report With Parameters (Cascading Parameters)
                                  0
                                  • 17. Making Reports Dynamic (Expressions)
                                    0
                                    • 18. Making Reports Dynamic (Date Expressions)
                                      0
                                      • 19. Visualizing Report Data (Charts)
                                        0
                                        • 20. Visualizing Report Data (Maps)
                                          0
                                          • 21. Visualizing Report Data (Databars And Sparklines)
                                            0
                                            • 22. Visualizing Report Data (Subreports And Drillthroughs)
                                              0
                                              • 23. Visualizing Report Data (Indicators)
                                                0
                                                • 24. Visualizing Report Data (Embedding In Power Bi)
                                                  0
                                                  • 25. Working With Power Bi Datasets
                                                    0
                                                    • 26. Beyond Report Development (Publishing)
                                                      0
                                                      • 27. Beyond Report Development (Delivering And Consuming Reports)
                                                        0
                                                        • 28. Beyond Report Development (Embedding Reports)
                                                          0
                                                          • 29. Beyond Report Development (Exporting Reports)
                                                            0
                                                            • 30. Beyond Report Development (When To Use Paginated Reports)
                                                              0
                                                              • 31. Beyond Report Development (Migrate Ssrs Reports)
                                                                0
                                                                • 32. Class Outro
                                                                  0

                                                                  Instructor

                                                                  User Avatar
                                                                  ToIT
                                                                  2 Students
                                                                  1351 Courses
                                                                  course thumbnail
                                                                  Free
                                                                  Student:
                                                                  0 Students
                                                                  Lesson:
                                                                  0 Lessons
                                                                  Duration: 198 Minutes
                                                                  Quiz:
                                                                  0 Quizzes
                                                                  Level: Beginner