The Microsoft Certified Solutions Associate (MCSA) certification focuses on the ability to design and build technology solutions, which may include integrating multiple technology products, and span multiple versions of a single technology, whether on-premises or in the cloud.
An individual can choose to become a certified Associate in one or several Microsoft technology specialisations. This certification bundle is ‘SQL 2016 Database Administration’ focused.
By gaining this MCSA certification you can prove your mastery of the primary set of SQL 2016 Database Administration skills required to reduce IT costs and deliver more business value.
An example of an MCSA certification you can gain through this course bundle.
Do you have more questions about the MCSA? Click here to read Microsoft’s FAQs.
Considering upgrading to an MCSE? Watch this video to find out what it means to have an MCSE certification.
What’s included in this certification bundle?
This bundle contains two separate MCSA certification courses and two official Microsoft MCSA certification exams, that are both valid for 12 months from the time of purchase. As part of this bundle, you will get access to a MeasureUP practice test for each Microsoft certification course.
If you’re looking to get ahead of the crowd and don’t have any technical experience, then you might want to consider adding live labs to your course.
Certification courses included:
Click on a course title to see a full breakdown of the syllabus for that course.
Module 1: Encryption
1.2 Exam Objectives and Lab Setup
1.3 Restoring AdventureWorks 2016 Database Lab Part 1
1.4 Restoring AdventureWorks 2016 Database Lab Part 2
1.5 Restoring AdventureWorks 2016 Database Lab Part 3
1.6 Configuring Encryption
1.7 Cell-Level Encryption Part 1
1.8 Cell-Level Encryption Part 2
1.9 Cell-Level Encryption Lab Part 1
1.10 Cell-Level Encryption Lab Part 2
1.11 Transparent Data Encryption
1.12 Transparent Data Encryption Lab
1.13 Always Encrypted
1.14 Always Encrypted Lab
1.15 Backup Encryption
1.16 Backup Encryption Lab
1.17 Connection Encryption
1.18 Encryption Troubleshooting
Module 2: Configure Data Access and Permissions
2.1 Create and Maintain Users
2.2 Create and Maintain Users Lab Part 1
2.3 Create and Maintain Users Lab Part 2
2.4 Configure and Maintain Custom Roles
2.5 Configure and Maintain Custom Roles Lab
2.6 Manage Database Object Permissions Part 1
2.7 Manage Database Object Permissions Part 2
2.8 Manage Database Object Permissions Lab Part 1
2.9 Manage Database Object Permissions Lab Part 2
2.10 Configuring User Options for Azure SQL Database
2.11 Configuring Row-Level Security
2.12 Configureing Dynamic Data Masking
2.13 Configure=ing Dynamic Data Masking Lab
Module 3. Configure Auditing
3.1 Manage a SQL Server Audit
3.2 Manage a SQL Server Audit Lab
3.3 Query the SQL Server Audit Log
3.4 Manage an Azure SQL Server Audit
Module 4: Develop a Backup Strategy
4.1 Backup Types Part 1
4.2 Backup Types Part 2
4.3 Manage, Backup, and Restore Databases Lab Part 1
4.4 Manage, Backup, and Restore Databases Lab Part 2
4.5 Backup Very Large Databases Part 1
4.6 Backup Very Large Databases Part 2
4.7 Backup Very Large Databases Part 3
4.8 Backup Very Large Databases Part 4
4.9 Managing Very Large Databases Lab Part 1
4.10 Managing Very Large Databases Lab Part 2
4.11 Managing Very Large Databases Lab Part 3
4.12 Configure=ing Alerting for Failed Backups
4.13 Configure=ing Alerting for Failed Backups Lab Part 1
4.14 Configure=ing Alerting for Failed Backups Lab Part 2
4.15 Back up Databases to Azure
4.16 Manage Transaction Log Backups
4.17 Configuring Database Recovery Models
4.18 Set Database Recovery Model Lab
4.19 Configure=ing Backup Automation
4.20 Configuring Backup Automation Lab
Module 5: Restore Databases
5.1 Perform Piecemeal Restores
5.2 Restore Databases Lab Part 1
5.3 Restore Databases Lab Part 2
5.4 Restore Databases Lab Part 3
5.5 Perform Page Recovery
5.6 Perform Point-in-Time Recovery
5.7 Perform Point-in-Time Recovery Lab
5.8 Restore File Groups
5.9 Develop a Plan to Automate and Test Restores
Module 6: Manage Database Integrity
6.1 Implement Database Consistency Checks
6.2 Implement Database Consistency Checks Lab
6.3 Identify Database Corruption
6.4 Recover From Database Corruption
Module 1: Deploy a Microsoft Azure SQL Database
1.2 Introducing the Azure SQL Database Part 1
1.3 Introducing the Azure SQL Database Part 2
1.4 Setting Up Azure Lab
1.5 Chose a Service Tier Part 1
1.6 Chose a Service Tier Part 2
1.7 Create Servers and Databases Part 1
1.8 Creating a Azure SQL Server and Database Lab
1.9 Create Servers and Databases Part 2
1.10 Create Servers and Databases Part 3
1.11 Connecting SSMS to Azure SQL Lab Part 1
1.12 Connecting SSMS to Azure SQL Lab Part 2
1.13 Create a Sysadmin Account
1.14 Creating Azure SQL Logins and Users Lab
1.15 Configure=ing Elastic Pools
1.16 Creating and configuring an Elastic Pool Lab
Module 2: Plan for SQL Server Installation
2.1 Plan for an IaaS or On-Premises Deployment Part 1
2.2 Plan for an IaaS or On-Premises Deployment Part 2
2.3 Select the Appropriate Size for a Virtual Machine
2.4 Plan Storage Pools Based on Performance Requirements Part 1
2.5 Plan Storage Pools Based on Performance Requirements Part 2
2.6 Evaluate Best Practices for Installation
2.7 Design a Storage Layout for a SQL Server Virtual Machine
Module 3: Deploy SQL Server Instances
3.1 Deploy a SQL Server Instance in IaaS and On-Premises
3.2 Restoring AdventureWorks 2016 Database Lab
3.3 Provision an Azure Virtual Machine to Host a SQL Server Instance
3.4 Provisioning an Azure Virtual Machine to Host a SQL Server Lab
3.5 Manually Install SQL Server on an Azure Virtual Machine
3.6 Installing SQL 2016 Lab Part 1
3.7 Installing SQL 2016 Lab Part 2
3.8 Automate the Deployment of SQL Server Databases
3.9 Exploring Azure SQL Database Automation Lab
3.10 Deploy SQL Server by Using Templates
3.11 Managing JSON Templates Lab
Module 4: Deploy SQL Server Databases to Azure Virtual Machines
4.1 Migrate an On-Premises SQL Server Database to an Azure Virtual Machine
4.2 Migrate an On-Premises SQL Server Database to an Azure Virtual Machine Lab Part 1
4.3 Migrate an On-Premises SQL Server Database to an Azure Virtual Machine Lab Part 2
4.4 Migrate an On-Premises SQL Server Database to an Azure Virtual Machine Lab Part 3
4.5 Migrate an On-Premises SQL Server Database to an Azure Virtual Machine Lab Part 4
4.6 Generate Benchmark Data for Performance Needs
4.7 Generating Benchmark Data Lab Part 1
4.8 Generating Benchmark Data Lab Part 2
4.9 Perform Performance Tuning on Azure IaaS
4.10 Perform Performance Tuning on Azure IaaS Lab Part 1
4.11 Perform Performance Tuning on Azure IaaS Lab Part 2
4.12 Support Availability Sets in Azure Part 1
4.13 Support Availability Sets in Azure Part 2
4.14 Manage High Availability Lab Part 1
4.15 Manage High Availability Lab Part 2
4.16 Manage High Availability Lab Part 3
4.17 Manage High Availability Lab Part 4
4.18 Manage High Availability Lab Part 5
Module 5: configure Secure Access to Microsoft Azure SQL Databases
5.1 Configuring Firewall Rules
5.2 Creating Firewall Rules Lab
5.3 Configuring Always Encrypted for Azure SQL Database
5.4 Implementing Always Encrypted Lab
5.5 Configuring Cell-Level Encryption
5.6 Cell-Level Encryption Lab
5.7 Configure=ing Dynamic Data Masking
5.8 Dynamic Data Masking Lab
5.9 Configuring Transparent Data Encryption (TDE)
5.10 Transparent Data Encryption (TDE) Lab
Module 6: Configure SQL Server Performance Settings
6.1 Configuring SQL Performance Settings
6.2 Configuring SQL Performance Settings Lab
6.3 Configuring Max Server Memory
6.4 Configuring SQL Memory Lab
6.5 Configuring Database Performance Settings
6.6 Configuring Database Performance Settings Lab
6.7 Configuring Operators and Alerts
6.8 Configuring alerts in Azure and On-Premise SQL Server Lab
Module 7: Manage SQL Server Instances
7.1 Create Databases
7.2 Creating Databases Lab
7.3 Manage Files and File Groups
7.4 Managing Files and File Groups Lab
7.5 Manage System Database Files
7.6 Manage System Database Files Lab
7.7 Configuring tempDB
7.8 Configuring tempDB Lab
Module 8: Manage SQL Storage
8.1 Manage SMB File Shares
8.2 Manage SMB File Shares Lab
8.3 Manage Stretch Databases
8.4 Configuring Azure Storage
8.5 Change Service Tiers
8.6 Change Service Tiers Lab Part 1
8.7 Review Wait Statistics
8.8 Manage Storage Pools
8.9 Recover from Failed Storage
8.10 Managing Storage Lab Part 1
8.11 Managing Storage Lab Part 2
Module 9: Perform Database Maintenance
9.1 Monitoring Tools
9.2 Using Monitoring Tools Lab Part 1
9.3 Using Monitoring Tools Lab Part 2
9.4 Azure Performance Tuning
9.5 Automate Maintenance Tasks
9.6 Update Statistics and Indexes
9.7 Update Statistics and Indexes Lab Part 1
9.8 Update Statistics and Indexes Lab Part 2
9.9 Verify Database Integrity
9.10 Verify Database Integrity Lab
9.11 Recover from Database Corruption
9.12 Recover from Database Corruption Lab
Certification exams included:
- Microsoft 70-764 SQL 2016 Administering an SQL Database Infrastructure (MCSA: 1 of 2 exams)
- Microsoft 70-765 Provisioning SQL Databases (MCSA: 2 of 2 exams)
MeasureUP practice tests included:
- Microsoft 70-764 SQL 2016 Administering an SQL Database Infrastructure
- Microsoft 70-765 Provisioning SQL Databases
Salary and job prospect information
We use two excellent third-party resources to allow you to check your earning potential and job prospects before starting this course.
The first is IT JobsWatch, which allows you to check what employers are paying people on average with specific certifications, such as the one contained in this bundle. Click here and enter the name of the certification you would like to see salary information on.
The second is Payscale, which also does the above, but allows you to see what types of job titles are paying more based around the certification you enquire about. Click here and enter the name of the certification you would like to see salary and job title information on.
How is each course taught?
All courses are online and self-paced, meaning you do it in your own home, in your own time, at your own pace. Each lesson is pre-recorded allowing you to pause, fast-forward, skip sections, or go back to another lesson if you need to. The lessons are multi-media based, which means video and audio are used to teach the lessons. Most courses are also interactive, prompting the learner to participate. This involves answering on-screen questions at the end of each course through the practice exam.
How long will it take me to complete each course?
As mentioned above, our courses are self-paced. Some people finish their course faster than others. Each certification course is between 12-16 hours.
What do I need?
This is an online course with 24/7 access. You can do it from any where in the world, any time of the day providing you have an internet connection. No apps are required to access the courses. You simply do it from your browser. For the best user experience, we recommend Google Chrome.
MeasureUP practice tests
As part of this course, you will get access to MeasureUP practice tests to help prepare you for the Microsoft exams as part of this bundle. MeasureUP practice tests are endorsed by Microsoft and used as the official practice tests of Microsoft certification exams.
Features of MeasureUP practice tests:
Watch this video to learn more about MeasureUP practice tests.
How do I book my exams?
When you’re ready to sit your exams, email [email protected] with your request along with the title of the exam you wish to take. We will then send you an email with instructions on how to complete your exam booking.
With Hudson’s e-learning system, certification has never been simpler! You can be starting your IT career or taking your current IT skills to the next level in just a few short weeks. Our learning system gives you all of the benefits of a live class at just a fraction of the cost. Courses include:
We only use the industry’s finest instructors in the IT industry. They have a minimum of 15 years real-world experience and are subject matter experts in their fields. Unlike a live class, you can fast-forward, repeat or rewind all your lectures. This creates a personal learning experience and gives you all the benefit of hands-on training with the flexibility of doing it around your schedule 24/7.
Our courseware includes instructor-led demonstrations and visual presentations that allow students to develop their skills based on real world scenarios explained by the instructor. We always focus on real world scenarios and skill-set development.
Our custom practice exams prepare you for your exams differently and more effectively than the traditional exam preps on the market. You will have practice quizzes after each module to ensure you are confident on the topic you have completed before proceeding.
This will allow you to gauge your effectiveness before moving to the next module in your course. Hudson courses also include practice exams designed to replicate and mirror the environment in the testing center. These exams are on average 100 questions to ensure you are 100% prepared before taking your certification exam.
Hudson has designed a world class Learning Management System (LMS) This system allows you to interact and collaborate with other students and staff, form study groups, engage in discussions in our [email protected] Forums, rate and “like” different courses and stay up to date with all the latest industry knowledge through our forums, student contributions and announcement features. This LMS is unmatched in the industry and makes learning fun and enjoyable.
Hudson knows that education is not a one size fits all approach. Students learn in different ways through different tools. That is why we provide Flash Cards and Education Games throughout our courses. This will allow you to train in ways that keep you engaged and focused. Each course will have dozens of Flash Cards so you can sharpen your skill-sets throughout your training as well as educational games designed to make sure your retention level of the materials is extremely high.
Hudson’s self-paced training programs are designed in a modular fashion to allow you the flexibility to work with expert level instruction anytime 24/7. All courses are arranged in defined sections with navigation controls allowing you to control the pace of your training. This allows students to learn at their own pace around their schedule.
If you’re looking to get ahead of the crowd and don’t have any technical experience, then you might want to consider adding live labs to your course. Because many IT jobs take place at the virtual level (i.e. behind a keyboard and mouse), the experience you’ll gain through a live lab is very similar to experience you’ll gain in the workplace. Consequently many employers regard live lab experience as a valued asset on a CV.
Live labs are also a great tool for experienced technicians as they allow individuals to put their newly acquired course skills to practice. To find out more about our range of live labs, including costs, and how they can enhance your skills, click here.