Course Details
Course Outline
1 - SQL Server Components
Navigate the SQL Server PlatformLearn About the SQL Server ArchitectureGet to Know SQL Server Services and Configuration Options
2 - Installing SQL Server 2016
Describe Key Considerations for Installing SQL ServerGet Exposed to TempDB filesInstall SQL Server 2016Automate the Installation ProcessLab: Installing SQL Server
3 - Upgrading SQL Server to SQL Server 2017
Understand Upgrade RequirementsUpgrade SQL Server ServicesMigrate SQL Server Data and ApplicationsPerform a Side-by-Side Upgrade: Migrate SQL Server Data and ApplicationsLab : Upgrading SQL Server
4 - Working with Databases
Learn How Data Storage Works with SQL ServerManage Storage for System and User DatabasesMove and Copy Database FilesConfigure Buffer Pool ExtensionsLab : Managing Database Storage
5 - Performing Database Maintenance
Understand and Check Database IntegrityMaintain IndexesAutomate Routine Database MaintenanceLab: Performing Database Maintenance
6 - Database Storage Options
Get Familiar with SMB Fileshare Analyze SQL Server Storage PerformanceConfigure SQL Server Storage in Microsoft AzureWork with Stretch DatabasesLab: Implementing Stretch Database
7 - Planning to Deploy SQL Server on Microsoft Azure
Learn About SQL Server Virtual Machines in AzureGain Exposure to Azure StorageNavigate Azure SQL Authentication, Auditing and ComplianceDeploy an Azure SQL Database Lab: Plan and Deploy an Azure SQL Database
8 - Migrating Databases to Azure SQL Database
Practice Using Database Migration Testing ToolsResolve Migration Compatibility IssuesMigrate a SQL Server Database to Azure SQL DatabaseLab: Migrating SQL Server Databases to Azure
9 - Deploying SQL Server on a Microsoft Azure Virtual Machine
Deploy SQL Server on an Azure VMMove On-Premises Data Using the Deploy Database to an Azure VM WizardLab: Deploying SQL Server on an Azure Virtual Machine
10 - Managing databases in the Cloud
Manage Azure SQL Database SecurityConfigure Azure StorageImplement Azure AutomationLab: Managing Databases in the Cloud
Actual course outline may vary depending on offering center. Contact your sales representative for more information.
Who is it For?
Target Audience
If your primary job involves administering and maintaining SQL Server databases, this course is perfect for you. You’ll also benefit from this course if you develop applications that deliver content from SQL Server databases.
Prerequisites
Other Prerequisites
We want you to get the most value possible out of your SQL Server training. To maximize your time taking this course, you should have some experience with database design and working knowledge of Transact-SQL and relational databases. Basic understanding of the Microsoft Windows operating system and its core functionality will also set you up for success.
If you don’t feel you meet these prerequisites, we recommend that you complete 20761 Querying Data with Transact SQL before taking this course.