Basket
{{item.CourseTitle}}
Price: {{item.ItemPriceExVatFormatted}} {{item.Currency}}
Aron Mesterbasic
Taught by your official Microsoft Certified Trainer (MCT), you’ll use Microsoft Official Curriculum (MOC) and practice tests. You'll also use Readynez's unique Lecture | Lab | Review technique, which will immerse you in topics like: - Provision a Database Server - Upgrade SQL Server - Configure SQL Server
Your course package is designed to provide maximum learning and convenience. This is included in the price of your course:
Your expert instructor will get you ready for the following exam and certifications, which are included in your course package and covered by the Certification guarantee.
You´ll have the perfect starting point for your training with these prerequisites:
- 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
Using our engaging learning methodology including a variety of tools, we’ll cover the entire curriculum.
Course 20765B: Provisioning SQL Databases
Module 1: SQL Server 2016 Components
Describe the SQL Server platform, SQL Server services, and SQL Server configuration options.
Lessons
- Introduction to the SQL Server Platform
- Overview of SQL Server Architecture
- SQL Server Services and Configuration Options
Lab : SQL Server Versions ( Discussion session)
After completing this module, you will be able to:
- Describe the SQL Server platform and architecture
- Describe the SQL Server services and configuration.
Module 2: Installing SQL Server 2016
This modules describes the process to install SQL Server 2016.
Lessons
- Considerations for installing SQL Server
- TempDB Files
- Installing SQL Server 2016
- Automating Installation
Lab : Installing SQL Server
After completing this module, you will be able to:
- Describe the considerations when installing SQL Server 2016
- Be able to install SQL Server
- Be able to automate the installation
Module 3: Upgrading SQL Server to SQL Server 2017
This module describes the process for upgrading to SQL Server 2017.
Lessons
- Upgrade Requirements
- Upgrade SQL Server Services
- Side by Side Upgrade: Migrating SQL Server Data and Applications
Lab : Upgrading SQL Server
- Create the Application Logins
- Restore the backups of the TSQL Database
- Orphaned Users and Database Compatibility Level
After completing this module, you will be able to:
- Describe the upgrade requirements for SQL Server.
- Upgrade SQL Server.
- Migrate SQL Server data and applications.
Module 4: Working with Databases
This module describes the preinstalled system databases, the physical structure of databases and the most common configuration options related to them.
Lessons
- Overview of SQL Server Databases
- Creating Databases
- Database Files and Filegroups
- Moving Database Files
- Buffer Pool Extension
Lab : Managing Database Storage
After completing this module, you will be able to:
- Describe Data Storage with SQL Server.
- Manage Storage for System Databases.
- Manage Storage for User Databases.
- Move and Copy Database Files.
- Describe the Side-by-Side Upgrade: Migrating SQL Server Data and Applications process.
- Describe and use Buffer Pool Extensions.
Module 5: Performing Database Maintenance
This module covers database maintenance.
Lessons
- Ensuring Database Integrity
- Maintaining Indexes
- Automating Routine Database Maintenance
Lab : Performing Ongoing Database Maintenance
After completing this module, you will be able to:
- Describe how to ensure database integrity
- Be able to maintain indexes
- Be able to automate routine database maintenance
Module 6: Database Storage Options
At the end of this module you will be able to describe the database storage options.
Lessons
- SQL Server storage Performance
- SMB Fileshare
- SQL Server Storage in Azure
- Stretch Databases
Lab : Implementing Stretch Database
After completing this module, you will be able to:
- Explain the elements impacting storage performance
- Describe SMB fileshare
- Describe SQL Server storage in Azure
- Describe Stretch Databases
Module 7: Deploying SQL Server on Microsoft Azure
This module describes the options available to run SQL Server on Azure.
Lessons
- SQL Server Virtual Machines in Azure
- Azure storage
- Azure SQL Authentication
- Deploying an Azure SQL Database
Lab : Plan and Deploy an Azure SQL Database
After completing this module, you will be able to:
- Describe SQL Server Virtual Machines in Azure.
- Describe Azure Storage.
- Explain Azure SQL Authentication, auditing and compliance.
- Deploy an Azure SQL Database.
Module 8: Migrating Databases to Azure SQL Database
This module describes how to migrate databases to Azure SQL Database.
Lessons
- Database Migration Testing Tools
- Database Migration Compatibility Issues
- Migrating a SQL Server Database to Azure SQL Database
Lab : Migrating SQL Server Databases to Azure
After completing this module, students will be able to:
- Describe various database migration testing tools.
- Explain database migration compatibility issues.
- Migrate a SQL Server database to Azure SQL database.
Module 9: Deploying SQL Server on a Microsoft Azure Virtual Machine
This module describes how to deploy SQL Server on Microsoft Azure VMs.
Lessons
- Deploying SQL Server on an Azure VM
- The Deploy Database to a Microsoft Azure VM
Lab : Deploying SQL Server on an Azure Virtual Machine
After completing this module, students will be able to:
- Deploy SQL Server on an Azure VM.
- Use The Deploy Database to a Microsoft Azure VM Wizard.
Module 10: Managing databases in the Cloud
This module describes how to manage SQL Server on Azure.
Lessons
- Managing Azure SQL Database Security
- Configure Azure storage
- Azure Automation
Lab : Managing Databases in the Cloud
After completing this module, students will be able to:
- Manage Azure SQL Database Security.
- Configure Azure storage.
- Implement Azure Automation.
The Virtual Classroom is an online room, where you will join your instructor and fellow classmates in real time. Everything happens live and you can interact freely, discuss, ask questions, and watch your instructor present on a whiteboard, discuss the courseware and slides, work with labs, and review.
Yes, you can sit exams from all the major Vendors like Microsoft, Cisco etc from the comfort of your home or office.
With Readynez you do any course form the comfort of your home or office. Readynez provides support and best practices for your at-home classroom and you can enjoy learning with minimal impact on your day-to-day life. Plus you'll save the cost and the environmental burden of travelling.
Well, learning is limitless, when you are motivated, but you need the right path to achieve what you want. Readynez consultants have many years of experience customizing learner paths and we can design one for you too. We are always available with help and guidance, and you can reach us on the chat or write us at info@readynez.com.