Querying SQL Databases using T-SQL Training in New Zealand

This practical, instructor-led Querying SQL Databases using T-SQL Training in New Zealand provides a comprehensive introduction to the Transact-SQL (T-SQL) language — the foundation of querying Microsoft SQL Server databases.
Throughout the course, you’ll learn how to retrieve, filter, sort, and analyze data from multiple tables and gain hands-on experience using SQL Server Management Studio (SSMS) to write efficient queries.

By the end of this course, you’ll have the core T-SQL skills required to extract valuable insights from your data and prepare for more advanced SQL training.

No prior SQL experience is required.

By the end of this Querying SQL Databases using T-SQL Training in New Zealand, you will have gained knowledge and skills in the following areas:

• Access and navigate SQL Server Management Studio (SSMS).

• Write simple to complex SELECT queries.

• Retrieve data from multiple tables using JOIN clauses.

• Apply filters using the WHERE clause and logical operators.

• Sort and organize data using ORDER BY and TOP.

• Summarize data with GROUP BY, HAVING, and aggregate functions.

• Create and use Views and Stored Procedures.

• Utilize text, date, and conversion functions for data manipulation.

Module 1: Introduction to T-SQL

• Overview of Relational Database Management Systems (RDBMS)

• Introduction to Microsoft SQL Server

• Getting started with SQL Server Management Studio (SSMS)

• Query Editor basics

Lab: Familiarizing yourself with SSMS and writing your first query

Module 2: Retrieving Data

• Writing basic SELECT statements

• Using expressions in query results

Lab: Selecting data and using expressions

Module 3: Filtering Rows

• Using the WHERE clause to filter data

• Applying equality, logical, string, and NULL comparisons

Lab: Practicing different types of filters

Module 4: Sorting Returned Rows

• Managing output order with ORDER BY

• Sorting with expressions

• Using DISTINCT and TOP for unique and limited results

Lab: Sorting and limiting query results

Module 5: Grouping and Aggregating Data

• Using aggregate functions (SUM, AVG, COUNT, etc.)

• Grouping results with GROUP BY

• Filtering groups with HAVING

Lab: Aggregating and grouping data

Module 6: Using Multiple Tables

• Joining tables using INNER, OUTER, and CROSS JOIN

• Combining result sets with UNION, INTERSECT, EXCEPT

Lab: Joining and merging data from multiple tables

Module 7: Using Views and Stored Procedures

• Understanding pre-written queries and database objects

• Creating and executing views and stored procedures

Lab: Working with stored queries

Module 8: Common Functions

• Using text, date, and NULL functions

• Formatting and converting data types

Lab: Applying SQL functions in queries

Appendix (Optional): Modifying Data

• Introduction to INSERT, UPDATE, and DELETE statements (time permitting)