SQL Server 2016: Provision a Database
Offered By: LinkedIn Learning
Course Description
Overview
Learn the key skills you need to provision SQL Server instances both on premises and using the cloud-based Azure service.
Syllabus
Introduction
- Welcome
- Using the exercise files
- What you should know
- Create servers and databases
- Choose a service tier
- Create a server admin account
- Configure elastic pools
- Plan for an IaaS or on-premises deployment
- Size a virtual machine
- Performance-based storage pools
- Evaluate best practices for installation
- Provision an Azure VM
- Storage layouts for a SQL Server VM
- Install SQL Server on an Azure VM
- Automate the deployment of SQL Server
- Deploy SQL Server using templates
- Configure firewall rules
- Enable transparent data encryption
- Enable Always Encrypted
- Configure dynamic data masking
- SQL database performance settings
- Configure max server memory
- Configure the database scope
- Create operators and alerts
- Create databases
- Install Management Studio
- Manage user database files
- Manage system database files
- Configure tempdb
- Support multiple tenants
- Migrate SQL Server to Azure SQL Database
- Migrate data to Azure SQL Database
- Migrate SQL Server databases to Azure VM
- Generate benchmark data
- Support availability sets in Azure
- Configure application connection strings
- Manage traffic
- Application retry logic
- Next steps
Taught by
Adam Wilbert
Related Courses
iOS Persistence and Core DataUdacity Data Migration to SAP S/4HANA
SAP Learning Deep Dive into Amazon Glacier
Amazon via Independent Upgrade2Success – Making SAP ERP HCM Migration Easier
SAP Learning Migrating Your Business Data to SAP S/4HANA – New Implementation Scenario
SAP Learning