SQL for Beginners with Official Microsoft Exams

SQL for Beginners with Official Microsoft Exams

From: £139.83 Inc. VAT per month for 6 months

Clear

Description

If you’ve ever considered having a career involving SQL, but felt you lacked the knowledge or skills to launch your career, this might be what you’re looking for. This course bundle is aimed at absolute beginners who want to start a career in SQL or just develop their skills in this area. The course assumes you have no technical knowledge of SQL.
 
The course starts off with a series of beginner level courses in SQL, then advances to higher level Microsoft certification courses. The purposes of the beginner level courses is not only to give you an introduction to SQL, but to prepare you to progress to the next study level involving the Microsoft MCSA courses. By completing the two MCSA exams from these courses, you’ll earn the globally recognised Microsoft MCSA in SQL 2016 Database Administration certification. Scroll down to read more about the MCSA.
 

Upon completion of this course, you’ll receive a Microsoft MCSA ‘Acclaim’ badge in SQL 2016 Database Administration that you can add to your CV or social media profile for prospective employers to see. As explained above, you’ll also receive a Microsoft certification validating your SQL skills. Scroll further down the page to see an example of a Microsoft MCSA certification.

 

Watch this video to understand how ‘Acclaim’ badges can help you stand out from the crowd.

 
What is an MCSA?
 

The Microsoft Certified Solutions Associate (MCSA) is the second level of technology certification a learner can gain from Microsoft. From here, a learner can progress onto more advanced Microsoft certifications such as the Microsoft Certified Solutions Expert (MCSE), and Microsoft Certified Solutions Developer (MCSD). Click here to view our range of higher level Microsoft certification courses for future reference.

 

Learn about Microsoft certifications and how employers value them.

 
What is SQL?
 
The simple version… SQL stands for Structured Query Language. It is the main programming language used to interact with a database. Companies like Amazon use databases to store product information, like prices, brand names, and clothing sizes. SQL talks to the database.
 

As part of this course, you’ll learn about Microsoft SQL Server.

 
What’s included in this course bundle?
 
This bundle contains 5 beginner level courses in SQL; and 2 Microsoft MCSA certification courses.The knowledge and skills gained on these courses will prepare you to take the MCSA certification exams. This course bundle includes the official Microsoft MCSA certification exams. The course material and exams are valid for 12 months from the time of enrolment. As part of this bundle, you will get access to a MeasureUP practice test for each certification course. This will help prepare you to pass the final exams.
 
Certification courses included:
 
Click on a course title to see a breakdown of the topics covered. The courses should be completed in the order listed below.
 


  • Getting Started
  • Advanced Search Functions
  • Searching Multiple Tables
  • Creating and Structuring Databases
  • Special Data Functions and Instructions
  • Working with Dates
  • SQL Functions
  • SQL – Basics Training – Assessments



  • Section 1: Relational Databases
  • Section 2: SQL Querying
  • Section 3: Your First Queries
  • Section 4: Filtering Your Results
  • Section 5: Consolidating Your Data
  • Section 6: Grouping Your Data
  • Section 7: Joining Tables
  • Section 8: Subqueries
  • Section 9: Manipulating Your Data
  • Section 10: Transaction Control
  • Section 11: Creating Database Objects and Adding Business Logic
  • Section 12: Lab Solutions



Module 1: T-SQL Querying Concepts

  • Lesson 1: SQL Dialects
  • Lesson 2: Formatting
  • Lesson 3: ASCII vs Unicode
  • Lesson 4: Data Types
  • Lesson 5: NULL
  • Module Summary
  • Knowledge Check

Module 2: Select, From, Where and Order By Clauses

  • Lesson 1: Getting Started
  • Lesson 2: Case-Sensitive Collation
  • Lesson 3: Aliasing Columns and Tables
  • Lesson 4: Filtering Records with the Where Clause
  • Lesson 5: Sorting Result Sets
  • Module Summary



  • Module 1: Using the SQL Server Import and Export Wizard | Importing and Exporting Data
  • Module 2: Creating a Simple ETL Package | Create Project and Basic Package



  • Module 1: Using the SQL Server Import and Export Wizard | Importing and Exporting Data
  • Module 2: Creating a Simple ETL Package | Create Project and Basic Package
  • Module 2: Creating a Simple ETL Package | Adding Looping
  • Module 2: Creating a Simple ETL Package | Adding Logging
  • Module 2: Creating a Simple ETL Package | Adding Error Flow Redirection
  • Module 2: Creating a Simple ETL Package | Adding Package Deployment Configuration
  • Module 2: Creating a Simple ETL Package | Using Project Deployment Parameters
  • Module 3: Deploying Packages Using The Package Deployment Model | Preparing to Create the Deployment Bundle
  • Module 3: Deploying Packages Using The Package Deployment Model | Creating the Deployment Bundle
  • Module 3: Deploying Packages Using The Package Deployment Model | Installing Packages




Module 1: Encryption
1.1 Introduction
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.1 Introduction
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
9.13 Conclusion

Certification exams included:
 

  1. Microsoft 70-764 SQL 2016 Administering an SQL Database Infrastructure (MCSA: 1 of 2 exams)
  2. Microsoft 70-765 Provisioning SQL Databases (MCSA: 2 of 2 exams)

 
Live practice labs included:
 

  1. Microsoft 70-764 SQL 2016 Administering an SQL Database Infrastructure*

 
*This live practice lab contains exercises to familiarise yourself with SQL. It will also allow you to test out your SQL skills. For more information on live practice labs, click here.
 
MeasureUP practice tests included:
 

  1. Microsoft 70-764 SQL 2016 Administering an SQL Database Infrastructure (MCSA: 1 of 2 exams)
  2. Microsoft 70-765 Provisioning SQL Databases (MCSA: 2 of 2 exams)

 

An example of an MCSA certification you can gain through this course.

 
How does this course bundle work?
 
This course bundle is made up of four main resources as shown below. Each certification course has as its own set of resources, i.e. 1 x online course, 1 x practice lab (with the exception of the Microsoft 70-765 Provisioning SQL Databases course), 1 x MeasureUP practice exam, 1 x official exam. Each resource is designed to work in conjunction with each other to ensure the successful path to certification. You will complete one course and exam, then repeat the process for the remaining courses. Once you have passed the exams, you will receive an MCSA certification from Microsoft. Read below to learn more about the resources in this course.
 
  Video Learning
Access to video based online learning material. Tutors use diagrams and illustrations to teach the classes, as well as giving demonstrations of equipment. Lessons are pre-recorded allowing you to  fast-forward, rewind and pause at any time throughout the lessons. Videos can be viewed on different devices including a desktop computer, laptop, tablet, and smart phone.
 
 Practice Labs
The hands-on live practice labs allow you to experience practical application of course concepts in an authentic online environment 24/7, all from the comfort of your home or office. The lab environment allows you to test and apply your skills as you learn. These labs also come with tasks challenging what you have learnt. To learn more about practice labs, click here.
 
 MeasureUP Practice Exams
 
After working your way through each text book and practice labs, you should be ready to start revising for your official exams. To do this, we provide you with MeasureUP practice tests. MeasureUP are the official provider to Microsoft for practice tests. These are the closest experience to the actual exam you’ll be taking. Scroll down to learn more about MeasureUP and the practice tests.
 
 Official Microsoft Exams
 
Having confidently passed the practice tests, you will be ready to sit the official Microsoft exams – which we will book on your behalf. These are known as an ‘online, web-proctored exams’. This means they can be taken at home. One of the requirements of taking these exams is that you must have a web camera so a proctor can observe you during the exams. This is to ensure no cheating takes place.
 
How long will it take me to complete this course?
 

This course bundle comprises of 50+ hours of video tutorials, as well as 25+ hours of live practice lab material; and 50+ hours of practice test material. How soon you can complete the course is dependent on several factors such as the amount of time you can dedicate to the course each week, and how quickly you absorb information. Learners can complete a course within this bundle from anywhere between 1-6 hours. Revision for each exam will take a minimum of 2 weeks. We recommend you spend at least 8 hours on the course per week to be able to finish it within 12 months or sooner. You can cut this duration in half or less by doubling the recommended study hours. You will have full access to the course material and resources for 12 months and must take your exams within this period.

 
What do I need?
 
Your course can be done from any where in the world. If you decide to move to a different city or even country, you can continue with the course from wherever you are. All you need is a device such as a desktop computer, laptop, tablet, smart phone, and an internet connection.

 
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:
 

  • Questions are similar to exam questions, allowing you to test your knowledge of exam objectives
  • Detailed explanations for both correct and distractor answers reinforce the material
  • ‘Study Mode’ covers all objectives ensuring topics are covered
  • ‘Certification Mode’ (timed) prepares students for exam taking conditions
  • Instant, drill-down score reports tell you exactly the areas to focus on

 

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.
 
Non-cancellation of course
 
Please note that this course is not covered by our standard 7 day guarantee/cancellation/refund policy.

Additional information

Payment options

4 monthly installments, 5 monthly installments, 6 monthly installments, Single payment