Microsoft Certified Solutions Associate SQL 2016 Database Administration
Marcin Szeliga › Data Philosopher › 20 years of experience with SQL Server
› Data Platform MVP & MCT › MCSE: Data Platform & Business Intelligence › MCSD: Azure & Microsoft.NET Solutions Architect ›
[email protected]
MCSA: SQL 2016 Database Administration › This certification validates your skills with database installation, maintenance, configuration, and provisioning tasks, and will qualify you for a position as a database administrator or infrastructure specialist › Step 1: Provisioning SQL Databases (exam 765) › Step 2: Administering a SQL Database Infrastructure (exam 764) › https://www.microsoft.com/enus/learning/mcsa-sql-2016-certification.aspx
Exam policies › Microsoft has specific policies in place that address the areas of security pertinent to Microsoft Certified Professional (MCP) exams › Exam retake policy › Academic pricing on MCP exams is available in most countries › Non-Disclosure Agreement
Exam basics › The number of questions on an exam is subject to change as we update the certification exam over time to keep current with the technology. Most Microsoft Certification exams contain 40-60 questions; however, the number can vary › Exam time is 120 minutes, seat time - 150 minutes › You will receive notification of your pass or fail status within a few minutes of completing your exam › In addition, you will receive a printed report that provides your exam score and feedback on your performance on the skill areas measured
What you will need to prepare for the exam › Microsoft Azure account – https://azure.microsoft.com/get-started/
› SQL Server 2016 Developer edition – https://www.microsoft.com/en-us/cloud-platform/sql-server-editionsdevelopers
› About 40 hours of learning and practicing
Agenda A
SQL Server 2016 components
B
Implement SQL in Azure
C
Install SQL Server 2016
› Introduction to the SQL Server platform › Overview of SQL Server architecture › SQL Server Services and configuration options
Agenda A
SQL Server 2016 components
B
Implement SQL in Azure
› Deploy a Microsoft Azure SQL Database – Security – Elastic databases
› Plan for SQL Server installation – Azure Resource Manager
C
Install SQL Server 2016
› Deploy SQL Server instances in IaaS
Agenda A
SQL Server 2016 components
B
Implement SQL in Azure
C
Install SQL Server 2016
› Planning a SQL Server 2016 Installation › Configuring Operating System
› Installing SQL Server 2016 › Configuring SQL Server
Agenda D
Upgrade SQL Server to SQL Server 2016
E
Manage database files
F
Deploy and migrate applications
› Upgrade Requirements › Upgrade of SQL Server Services › Migrating SQL Server Data and Applications (Side-by-Side Upgrade) › Upgrading in High Availability Configurations
Agenda D
E
F
Upgrade SQL Server to SQL Server 2016 Manage database files Deploy and migrate applications
› Database Storage Options › Managing Storage for System Databases
› Managing Storage for User Databases › Moving and Copying Database Files › Configuring the Buffer Pool Extension › Configuring the Stretch Database
Agenda D
Upgrade SQL Server to SQL Server 2016
E
Manage database files
F
Deploy and migrate applications
› Migration to Azure SQL Database › Migration to SQL Server in an Azure VM
› Achieve scalability
Agenda G
H
I
Backup and restore Survive database corruptions Security
› Database recovery options › Planning a database backup strategy
› Backing up a user database › Restoring user databases › System databases and disaster recovery
Agenda G
H
I
Backup and restore Survive database corruptions Security
› Page Protection Options › DBCC CHECKDB
Agenda G
Backup and restore
› Data protection › Control access › Compliance
H
I
Survive database corruptions Security
MICROSOFT CERTIFIED SOLUTIONS ASSOCIATE SQL 2016 DATABASE ADMINISTRATION