Learn how to write basic Transact-SQL queries for Microsoft SQL Server 2016. This course will provide a good understanding of the Transact-SQL language which is used by all SQL Server-related disciplines-namely, database administration, database development and business intelligence.
You will learn about: T-SQL elements, writing SQL queries, querying JOINs, sorting and filtering data, SQL Server 2016 data types, T-SQL DML, built-in functions, grouping and aggregating data, subqueries, and set operators.
This course incorporates material from the Official Microsoft Learning Product 20761: Querying Data with Transact-SQL.
What You'll Learn
- Basic architecture and concepts of Microsoft SQL Server 2016.
- Similarities and differences between Transact-SQL and other computer languages.
- Write SELECT queries.
- Query multiple tables.
- Sort and filter data.
- Using data types in SQL Server.
- Modify data using Transact-SQL.
- Use built-in functions.
- Group and aggregate data.
- Use subqueries.
- Use table expressions.
- Use set operators.
- Use window ranking, offset and aggregate functions.
- Implement pivoting and grouping sets.
- Execute stored procedures.
- Program with T-SQL.
- Implement error handling.
- Implement transactions.
Who Needs to Attend
- Database administrators
- Database developers
- Business intelligence professionals
- Report writers
- Business analysts
- Client application developers.
- Working knowledge of relational databases.
- Basic knowledge of the Microsoft Windows operating system and its core functionality.
- Administering a SQL Database Infrastructure (M20764)
- Implementing a SQL Data Warehouse (M20767)
- Developing SQL Databases (M20762)
- MCSA: SQL 2016 Database Development
Please complete the below form to confirm your provisional order for the Microsoft Official Course - On-Demand title Querying Data with Transact-SQL (M20761) We will contact you as soon as possible.