Azure

Azure certification Study Guide

---

SQL SERVER

Exam 70-761: Querying Data with Transact-SQL

1. Create Transact-SQL SELECT queries
2. Query multiple tables by using joins
3. Implement functions and aggregate data
4. Modify data

Query data with advanced Transact-SQL components

1. Query data by using subqueries and APPLY
2. Query data by using table expressions
3. Group and pivot data by using queries
4. Query temporal data and non-relational data

Program databases by using Transact-SQL

1. Create database programmability objects by using Transact-SQL
2. Implement error handling and transactions
3. Implement data types and NULLs

Study Guide

Exam Ref 70-761 Querying Data with Transact-SQL

Focus on the expertise measured by these objectives:

• Filter, sort, join, aggregate, and modify data
• Use subqueries, table expressions, grouping sets, and pivoting
• Query temporal and non-relational data, and output XML or JSON
• Create views, user-defined functions, and stored procedures
• Implement error handling, transactions, data types, and nulls

This Microsoft Exam Ref:

• Organizes its coverage by exam objectives
• Features strategic, what-if scenarios to challenge you
• Assumes you have experience working with SQL Server as a database administrator, system engineer, or developer
• Includes downloadable sample database and code for SQL Server 2016 SP1 (or later) and Azure SQL Database

Tools

MSSMS - Microsoft SQL Server Managment Studio

https://docs.microsoft.com/pt-br/sql/ssms/download-sql-server-management-studio-ssms?view=sql-server-ver15

Azure Data Studio

https://docs.microsoft.com/pt-br/sql/azure-data-studio/download-azure-data-studio?view=sql-server-ver15#get-azure-data-studio-for-windows

DBeaver

https://dbeaver.io/download/

Navicat

https://www.navicat.com/en/products/navicat-for-sqlserver

Visual Studio Code

https://code.visualstudio.com/

mssql for Visual Studio Code

https://marketplace.visualstudio.com/items?itemName=ms-mssql.mssql

Manual / Documentation ( Please Read the Docs )

• https://docs.microsoft.com/pt-br/azure/azure-sql/
• https://docs.microsoft.com/pt-br/learn/?view=sql-server-ver15
• https://docs.microsoft.com/pt-br/sql/t-sql/language-reference?view=sql-server-ver15
• https://docs.microsoft.com/pt-br/sql/sql-server/educational-sql-resources?view=sql-server-ver15
• https://docs.microsoft.com/pt-br/learn/paths/azure-sql-fundamentals/
• https://microsoft.github.io/sqlworkshops/?WT.mc_id=azuresql4beg_azuresql-ch9-code
• https://www.tutorialspoint.com/t_sql/index.htm

Youtube / Videos

https://www.youtube.com/playlist?list=PLlrxD0HtieHi5c9-i_Dnxw9vxBY-TqaeN&WT.mc_id=azuresql4beg_azuresql-ch9-niner

Docker commands for this application

Ref.: https://hub.docker.com/_/microsoft-mssql-server

$ docker-compose -f "docker-compose.yml" up -d --build
$ docker-compose -f "docker-compose.yml" down --remove-orphans