- Total 0 kr
Querying Data with Transact SQL
Watch this product and we will notify you once it is back in stock.
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