Course title 1 (Programming using T-SQL language) is for professionals who produce reports or develop queries for programming purposes in their daily work. There are no prerequisites for this course.
Course - 1: Programming using T-SQL Language
MS 20761 Querying data with transact-SQL.
Duration: 5 days
Course Content:
- Introduction to Microsoft SQL Server 2016
- Introduction to T-SQL Querying
- Writing Select Queries
- Querying Multiple Tables
- Sorting and Filtering Data
- Working with SQL Server 2016 Data Types
- Using DML to Modify Data
- Using Built-In Functions
- Grouping and Aggregating Data
- Using Subqueries
- Using Set Operators
- Using Table Expressions
- Using Windows Ranking, Offset, and Aggregate Functions
- Pivoting and Grouping Sets
- Executing Stored Procedures
- Programming with T-SQL
- Implementing Error Handling
- Implementing Transactions
Course - 2: Administering SQL Servers
MS 20764 Administering a SQL Server Infrastructure
Duration: 5 days
Course Content:
- Authenticating and Authorizing Users
- Assigning Server and Database
- Authorizing Users to Access
- SQL Server Recovery Models, Encryption and Auditing
- SQL Server Recovery Models
- Backup of SQL Server
- Restoring SQL Server Databases
- Automating SQL Server Management
- Configuring Security for SQL Server Agent
- Monitoring SQL Server with Alerts and Notifications
- Introduction to Managing SQL Server by using PowerShell
- Tracing Access to SQL Server
- Monitoring SQL Server
- Troubleshooting SQL Server
- Importing and Exporting Data