SQL Server T-SQL Core Skills (2 days)


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 2017, 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
On-demand Please contact us

DAY 1 TS101 INTRODUCTION TO QUERYING SQL SERVER
Overview
Database Objects
Logical Database Design
LAB: Executing SQL Server Queries
DAY 1 TS102 QUERYING A TABLE
Single Table Queries
Executing SQL Statements
Filtering Rows
LAB: Querying Tables
DAY 1 TS103 QUERYING NUMBERS AND CHARACTERS
Numeric Data Types
Character Data Types
Character Functions
LAB: Querying Numbers and Characters
DAY 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
DAY 2 TS105 AGGREGATING DATA AND IMPLEMENTING LOGIC
Aggregating Data
Window Functions
Implementing Logic in Scripts
LAB: Aggregating Data and Implementing Logic
DAY 2 TS106 QUERYING MULTIPLE TABLES
Multi-Table Queries
Additional Join Strategies
Set Operations
LAB: Querying Multiple Tables
DAY 2 TS107 USING SUB-QUERIES
Sub-queries
Table Expressions
Querying Database Objects
LAB: Using Sub-queries
DAY 2 TS108 MODIFYING DATA
Inserting Data
Deleting Data
Updating and Merging Data
LAB: Modifying Data