Training
SQL Server T-SQL Core Skills
The ability to write Transact-SQL (T-SQL) statements is essential for a wide variety of attendees:

- Those who need to write T-SQL queries for use with query tools such as SQL Server Report Builder
- Those who intend to progress to roles as SQL Server developers or database administrators (DBAs)

In this course, you will learn the most important aspects of writing T-SQL queries, at just the right amount of depth, and within two days.

The course starts by covering the most common SQL Server tools, then progresses through writing queries against database tables. You'll learn how to use appropriate data types, how to convert between data types and how to group and aggregate data. You will see how to retrieve data from multiple tables, how to modify data and how to manage errors that might occur in your code.

While our courses are based on SQL Server 2016, we realise that many customers are not yet running that version. Rather than provide you a course that only covers a single version of SQL Server, our courses are designed to be relevant (wherever possible) to a range of SQL Server versions including SQL Server 2008, SQL Server 2008 R2, SQL Server 2012, SQL Server 2014 and SQL Server 2016. Where there are differences between versions, the differences are clearly highlighted.
City
Dates
Course Price
Early Bird Price
There isn't a public offering for this course scheduled at present but please contact us to register your interest or to request a quote for private training.
Day
Code
Module
1
TS101
Introduction to Querying SQL Server
- Overview
- Database Objects
- Logical Database Design
- LAB: Executing SQL Server Queries
1
TS102
Querying a Table
- Single Table Queries
- Executing SQL Statements
- Filtering Rows
- LAB: Querying Tables
1
TS103
Querying Numbers and Characters
- Numeric Data Types
- Character Data Types
- Character Functions
- LAB: Querying Numbers and Characters
1
TS104
Querying and Formatting Dates and Times
- Date and Time Data Types
- Date and Time Functions
- Converting Between Data Types
- LAB: Querying and Formatting Dates and Times
2
TS105
Aggregating Data and Implementing Logic
- Aggregating Data
- Window Functions
- Implementing Logic in Scripts
- LAB: Aggregating Data and Implementing Logic
2
TS106
Querying Multiple Tables
- Multi-Table Queries
- Additional Join Strategies
- Set Operations
- LAB: Querying Multiple Tables
2
TS107
Using Sub-queries
- Sub-queries
- Table Expressions
- Querying Database Objects
- LAB: Using Sub-queries
2
TS108
Modifying Data
- Inserting Data
- Deleting Data
- Updating and Merging Data
- LAB: Modifying Data
Phone: 1300 SQL SQL (1300 775 775) l International +61 1300 775 775 l Fax: +61 3 8676-4913
Copyright 2017 by SQL Down Under | Terms Of Use | Privacy Statement