This three-day instructor-led course provides students with the knowledge and skills to provision a Microsoft SQL Server 2016 database. The course covers SQL Server 2016 provision both on-premise and in Azure, and covers installing from new and migrating from an existing install.

• Module 1: SQL Server 2016 Components
• Module 2: Installing SQL Server 2016
• Module 3: Upgrading SQL Server to SQL Server 2016
• Module 4: Deploying SQL Server on Microsoft Azure
• Module 5: Working with Databases
• Module 6: Database Storage Options
• Module 7: Performing Database Maintenance

• Basic knowledge of the Microsoft Windows operating system and its core functionality.
• Working knowledge of Transact-SQL.
• Working knowledge of relational databases.
• Some experience with database design
• These prerequisites can be achieved by attending course 20761A – Querying Data with Transact-SQL.

• Exam code: 70-765
• This exam is intended for architects, senior developers, infrastructure specialists, and development leads. Candidates have a working knowledge of the various cloud service models and service model architectures, data storage options, and data synchronization techniques. Candidates also have a working knowledge of deployment models, upgrading and migrating databases, and applications and services, in addition to integrating Azure applications with external resources.

Gregor Papež, MCT