Introduction to TSQL Course

Our Introduction to T-SQL course teaches you how to retrieve the information stored in a Microsoft SQL Server database using [...]

What you will learn

  • Installing & Using SQL Server and SQL Management Studio
  • Writing SELECT queries
  • Filtering and sorting retrieved data
  • Matching text with LIKE and wildcards
  • Grouping records
  • Retrieving data using subqueries
  • Retrieving records from multiple tables
  • Using functions in T-SQL
  • Writing SQL scripts
  • Creating and using variables in a query
  • Monitoring and management Security and improving performance

Requirements

  • Familiarity with Windows 10
  • Knowing how to install programs and navigate files
  • Videos are best viewed with 1920 x 1080 resolution
  • A stable internet connection (10 Mbps recommended)

Description

Our Introduction to T-SQL course teaches you how to retrieve the information stored in a Microsoft SQL Server database using the Transact-SQL language. Learn the fundamental structure of a query and skillfully handle data using the language’s built-in functions, operators, filters, and other features to return datasets that meet the needs of your customers.

Work your way up from simple tasks like data retrieval to more complex concepts like the use of joins, sub-queries, full text-based searches, stored procedures, cursors, triggers, and table constraints. After completing this course, you will be able to pursue a career in database administration.

   

Course Content
9 Lectures
28 Quizzes
20 Hands on Labs
6 Hours
lessons and hands-on labs
  • Module1: Getting Started with TSQL
    In this module, you will learn the basics of databases and SQL to prepare you for T-SQL. We will also walk you through the installation of SQL Server 2019 and SQL Server Management Studio (SSMS).
    Lessons Duration
    Lesson 1: Introduction
    6 Minutes
    Lesson 2: Understanding SQL
    9 Minutes
    Module 1 Lesson 1 Quiz
    5 Minutes
    Module 1 Lesson 2 Quiz
    5 Minutes
    Labs Duration
    Lab 1: Enabling SQL Server Authentication 4 Minutes
  • Module 2: Understanding SQL Server
    This module details how to log into SQL Server, how to select databases using USE, and how to introspect SQL databases and tables. You will also learn how to use the SQL SELECT statement to retrieve single, multiple, and all table columns, as well as how to sort the retrieved data.
    Lessons Duration
    Lesson 1: Working with SQL
    8 Minutes
    Lesson 2: Retrieving Data
    3 Minutes
    Lesson 3: Sorting Retrieved Data
    5 Minutes
    Module 2 Lesson 1 Quiz
    5 Minutes
    Module 2 Lesson 2 Quiz
    5 Minutes
    Module 2 Lesson 3 Quiz
    5 Minutes
    Labs Duration
    Lab 1: Connecting SQL Server and selecting database 3 Minutes
    Lab 2: Retriving data from SQL tables 4 Minutes
  • Module 3: Filtering Data Techniques
    Filter returned data using the SELECT the statement’s WHERE clause. Combine WHERE clauses with the AND and OR operators. Manage the order of evaluation explicitly use the IN and NOT operators. Use SQL wildcards within your WHERE clauses.
    Lessons Duration
    Lesson 1: Filtering Data
    6 Minutes
    Lesson 2: Advance Data Filtering
    8 Minutes
    Lesson 3: Using Wildcard Filtering
    9 Minutes
    Module 3 Lesson 1 Quiz
    5 Minutes
    Module 3 Lesson 2 Quiz
    5 Minutes
    Module 3 Lesson 3 Quiz
    5 Minutes
    Labs Duration
    Lab1: Using WHERE to filter data 7 Minutes
    Lab 2: Using IN and NOT IN 7 Minutes
    Lab3: Usage of Wildcards to filter data 4 Minutes
  • Module 4: Calculated Fields and Data Manipulation Functions
    Overview of what calculated fields are and how to create them. We used examples to demonstrate the uses of calculated fields for both string concatenation and mathematical operations. We will also dive into T-SQL’s data manipulation functions.
    Lessons Duration
    Lesson1: Understanding Calculated Fields
    5 Minutes
    Lesson 2: Using Data Manipulation Functions
    7 Minutes
    Module 4 Lesson 1 Quiz
    5 Minutes
    Module 4 Lesson 2 Quiz
    5 Minutes
    Labs Duration
    Lab1: Apply Arithmetic on Calculated Fields 4 Minutes
    Lab2: Data manipulation T-SQL functions in action 3 Minutes
  • Module 5: Summarizing and Grouping Data
    SQL aggregate functions and how you can use them to summarize the data in tables. GROUP BY clause to perform calculations on groups of data, returning results for each group. Using HAVING clause to filter specific groups.
    Lessons Duration
    Lesson 1: Summarizing Data
    12 Minutes
    Lesson 2: Grouping Data
    11 Minutes
    Module 5 Lesson 1 Quiz
    5 Minutes
    Module 5 Lesson 2 Quiz
    5 Minutes
    Labs Duration
    Lab1: Using Aggregate function 5 Minutes
    Lab2: Grouping Data 4 Minutes
  • Module 6: Working with Subqueries and Joining Tables
    Learn the basics of relational database design as an introduction to learning about joins. Create an equijoin (also known as an inner join), which is the most commonly used form of join.
    Lessons Duration
    Lesson 1: Working with Subqueries
    10 Minutes
    Lesson 2: Joining Tables
    9 Minutes
    Module 6 Lesson 1 Quiz
    5 Minutes
    Module 6 Lesson 2 Quiz
    5 Minutes
    Labs Duration
    Lab1: Using Subquery 11 Minutes
    Lab1: Joining Multiple Tables 6 Minutes
  • Module 7: Combining Queries & Full text Searching
    Combine SELECT statements with the UNION operator. The use of UNION to simplify complex WHERE clauses and retrieving data from multiple tables. Full-text searching capabilities to perform sophisticated data querying and selection.
    Lessons Duration
    Lesson 1: Combining Queries
    9 Minutes
    Lesson 2: Full Text Searching
    18 Minutes
    Module 7 Lesson 1 Quiz
    5 Minutes
    Module 7 Lesson 2 Quiz
    5 Minutes
    Labs Duration
    Lab1: Combining Queries using UNION operation 7 Minutes
    Lab 2: Enable Full-Text Searching 5 Minutes
  • Module 8: Inserting, Updating & Deleting Data
    In this module, you will learn how to insert data into tables using the SQL INSERT statement and how to modify the data found in each table. You will also learn how to use the UPDATE and DELETE statements to manipulate your table data.
    Lessons Duration
    Lesson 1: Inserting Data
    13 Minutes
    Lesson 2: Updating and Deleting Data
    9 Minutes
    Module 8 Lesson 1 Quiz
    5 Minutes
    Module 8 Lesson 2 Quiz
    5 Minutes
    Labs Duration
    Lab 1: Inserting data in SQL tables 7 Minutes
    Lab 2: Modify data in Table 5 Minutes
  • Module 9: Creating and Manipulating Tables & Views
    Learn the basics of table creation, alteration, and deletion. Identity fields, defining primary and foreign keys, and other important tables and column options. What views are, how they work, and when they should be used. How views can be used to simplify some of the SQL operations.
    Lessons Duration
    Lesson 1: Creating Tables
    11 Minutes
    Lesson 2: Using Views
    17 Minutes
    Module 9 Lesson 1 Quiz
    5 Minutes
    Module 9 Lesson 2 Quiz
    5 Minutes
    Labs Duration
    Lab 1: CREATE and Modifying Tables 12 Minutes
    Lab 2: Creating Views 6 Minutes

About the Instructor


Brandon Ahmad, MCSE

Microsoft Certified Trainer Regional Lead - USA

8.8 out of 9.0 Average Instructor Rating

Top Instructor Award Twice

MCSE Certification in Dynamics 365

Freelances as hands-on Technical Lead with very advanced development scenarios for Day Job

Brandon Teaches D365 for Finance and Operations Programming

Brandon Ahmad is a Dynamics 365 Technical Solutions Architect and CEO of Instructor Brandon. In his years of experience working with different Microsoft Technologies such as Dynamics 365, Power BI and Power Apps, he has been able to consult over 60 implementations across the globe. Being solution-oriented and implementing advanced scenarios, he has dedicated his time to creating training courses for programmers and developers alike; those interested mainly in learning Microsoft Technologies.
As an Instructor, he strongly believes in being able to master developmental skills; as long as one achieves the right set of training and guidance. Providing students with several enhanced Microsoft training courses that focus on providing a hands-on learning experience, Ahmad’s biggest secret to teaching lies in his ability to nurture those who take his courses.
His best reward (in his own words) is “hearing that my students saved time and mastered Microsoft Technology skills, knowing that my courses played a vital part in that success.”

    Prominent Features
  • Custom enhanced HTML5 RDP labs
  • Interactive video lessons & quizzes
  • Mobile app
  • Dedicated support
  • Certification after completion
  • Licenses for hands on training