Querying Data with Transact SQL

This Microsoft SQL Server / Transact-SQL-course will give you a basic skillset within databases and SQL. Subjects that will be touched includes: relational databas architecture, database design, you will also learn how to ask both easy and complex queries . You will learn how to select, filter and sort data from multiple tables and how to use views and stored procedures.

Transact-SQL is a important skill to have for a developer who works with SQL-databases. With the help of this combination of teacherled education, demonstrations and practical laborations will increase your understanding for the logic behind T-SQL step by step. The aim of the course is to give the participants the technical skills required to write basic Transact-SQL-queries for Microsoft SQL Server. The course also comprises basic queries against Azure SQL databases.

Target audience

The course is meant for SQL Server-database administrators, report developers, system engineers and developers who wants to be able to write queries on their own, but who lacks the required experience in writing T-SQL SELECT-sentences.

Prerequisites

This course has no prerequisits.

What you will learn

• Introduction to Microsoft SQL Server 
• Introduction to T-SQL Querying 
• Writing SELECT Queries 
• Querying Multiple Tables 
• Sorting and Filtering Data 
• Working with SQL Server Data Types 
• Using DML to Modify Data 
• Using Built-In Functions 
• Grouping and Aggregating Data 
• Using Subqueries 
• Using Table Expressions 
• Using Set Operators 
• Windows Ranking, Offset, and Aggregate Functions 
• Pivoting and Grouping Sets 
• Executing Stored Procedures 
• Programming with T-SQL 
• Implementing Error Handling 
• Implementing Transactions