MCSA: SQL Server 2016 Database Development Boot Camp

Instructor-Led 6 Day Hands On Training Boot Camp

$3,995

Best Price Guarantee

Have Questions? Give Us a Call.

(866) 704-9244

GET TRAINED, GET CERTIFIED, GET AHEAD!

MCSA: SQL Server 2016 Database Development Training

Exams 70-761 & 70-762

Earn your Microsoft Certified Solutions Associate (MCSA) certification. Advance your career and upgrade your skills by achieving the MCSA: SQL Server 2016 Database Development Certification. This all-inclusive boot camp training covers courses:

20761: Querying Data with Transact-SQL
20762: Developing SQL Databases

Click below to view upcoming instructor-led course dates.

Best Price Guarantee!

About TechSherpas 365's Microsoft Certification Boot Camps

miCROSOFT PARTNER

TechSherpas 365 has been a trusted Microsoft Partner for Learning Solutions for 25 years and counting.

Best Price Guarantee

We'll beat or match any competitors price for an equivalent boot camp certification training program.

100% TEST PASS GUARANTEE

We're so confident in the quality of our training, our boot camps include a 100% Test Pass Guarantee.

ALL-INCLUSIVE TRAINING

Our certification boot camps include courseware, labs, test simulation and official exams.

Our clients say

"Leo was a great instructor. Very knowledgeable and well spoken enough to make some of the driest material palatable. It wasn’t until I started asking questions that I realized somehow I knew the answers. Thank you!

JOHN

Systems Administrator, Tampa, FL

The instructor was excellent and ranks tops in the 100+ classes that I have taken over my 21 years in the field. He did a great job of teaching, answering questions and working through the labs. He made himself very available to the students and responded to e-mail questions in a very timely manner. I would give him an A+. The training course and lab were great.

STEVE

Cyber Engineer, Atlanta, GA

Just wanted to follow up and say thanks. I not only passed the CISSO, but sat for the CISSP on Friday and passed that as well. There were definitely a few items during this week of training that helped outside of my self-study. Now on to the final step of endorsement!

ELIZE

IT Professional, New York, NY

MCSA: SQL Server 2016 Database Development Outline

Overview

Exams Included:

70-761: Querying with Transact-SQL
70-762: Developing SQL Databases

About TechSherpas 365 Boot Camps

TechSherpas 365’s boot camps are geared towards providing students with the necessary skills and knowledge to not only pass the Microsoft Certification exams, but to also excel in their IT career paths. All of our boot camps are all-inclusive and include benefits such as:

100% Test Pass Guarantee
All course materials, practice exams and official certification exams
Onsite Pearson Vue Testing Center
Hands-on instruction by a certified instructor
Lunch provided each day (in-classroom delivery only)
Airfare and lodging package upgrades available

Audience Profile

This boot camp is intended for SQL Server database administrators, system engineers, and developers with two or more years of experience who are seeking to validate their skills and knowledge in writing queries.

At Course Completion

Manage data with Transact-SQL
Query data with advanced Transact-SQL components
Program databases by using Transact-SQL
Design and implement database objects
Implement programmability objects
Manage database concurrency
Optimize database objects and SQL infrastructure

Description

Course Outline

Exam 1

Configure data access and auditing (20–25%)

Configure encryption
- Implement cell-level encryption, implement Always Encrypted, implement backup encryption, configure transparent data encryption, configure encryption for connections, troubleshoot encryption errors
Configure data access and permissions
- Manage database object permissions, create and maintain users, create and maintain custom roles, configure user options for Azure SQL Database, configure row-level security, configure dynamic data masking
Configure auditing
- Configure an audit on SQL Server, query the SQL Server audit log, manage a SQL Server audit, configure an Azure SQL Database audit, analyze audit logs and reports from Azure SQL Database

Manage backup and restore of databases (20–25%)

Develop a backup strategy
- Back up very large databases, configure alerting for failed backups, back up databases to Azure, manage transaction log backups, configure database recovery models, configure backup automation
Restore databases
- Perform piecemeal restores, perform page recovery, perform point-in-time recovery, restore file groups, develop a plan to automate and test restores
Manage database integrity
- Implement database consistency checks, identify database corruption, recover from database corruption

Manage and monitor SQL Server instances (35–40%)

Monitor database activity
- Monitor current sessions, identify sessions that cause blocking activity, identify sessions that consume tempdb resources, configure the data collector
Monitor queries
- Manage the Query Store, configure Extended Events and trace events, identify problematic execution plans, troubleshoot server health using Extended Events
Manage indexes
- Identify and repair index fragmentation, identify and create missing indexes, identify and drop underutilized indexes, manage existing columnstore indexes
Manage statistics
- Identify and correct outdated statistics, implement Auto Update Statistics, implement statistics for large tables
Monitor SQL Server instances
- Create and manage operators, create and manage SQL Agent alerts, define custom alert actions, define failure actions, configure database mail, configure Policy-Based Management, identify available space on data volumes, identify the cause of performance degradation

Manage high availability and disaster recovery (20–25%)

Implement log shipping
- Configure log shipping, monitor log shipping
Implement AlwaysOn Availability Groups
- Configure Windows clustering, create an availability group, configure read-only routing, manage failover, create distributed availability groups
Implement failover cluster instances
- Manage shared disks, configure cluster shared volumes

Exam 2

Implement SQL in Azure (40–45%)

Deploy a Microsoft Azure SQL Database
- Choose a service tier, create servers and databases, create a sysadmin account, configure elastic pools
Plan for SQL Server installation
- Plan for an IaaS or on-premises deployment, select the appropriate size for a virtual machine, plan storage pools based on performance requirements, evaluate best practices for installation, design a storage layout for a SQL Server virtual machine
Deploy SQL Server instances
- Deploy a SQL Server instance in IaaS and on-premises, manually install SQL Server on an Azure Virtual Machine, provision an Azure Virtual Machine to host a SQL Server instance, automate the deployment of SQL Server databases, deploy SQL Server by using templates
Deploy SQL Server databases to Azure virtual machines
- Migrate an on-premises SQL Server database to an Azure virtual machine, generate benchmark data for performance needs, perform performance tuning on Azure IaaS, support availability sets in Azure

Manage databases and instances (30-35%)

Configure secure access to Microsoft Azure SQL Databases
- Configure firewall rules, configure Always Encrypted for Azure SQL Database, configure cell-level encryption, configure dynamic data masking, configure transparent data encryption (TDE)
Configure SQL Server performance settings
- Configure database performance settings, configure max server memory, configure the database scope, configure operators and alerts
Manage SQL Server instances
- Create databases, manage files and file groups, manage system database files, configure tempdb

Manage Storage (30–35%)

Manage SQL Storage
- Manage SMB file shares, manage stretch databases, configure Azure storage, change service tiers, review wait statistics, manage storage pools, recover from failed storage
Perform database maintenance
- Monitor DMVs, maintain indexes, automate maintenance tasks, update statistics, verify database integrity, recover from database corruption