Menu
    All Courses
  • Home
  • About Us
  • Become a Partner
  • Contact Us
  • Careers
  • Terms of Use
  • Privacy Policy
  • Blog
  1. Home
  2. Microsoft
  3. Microsoft
  4. Short
  5. SQL for Beginners with Official Microsoft Exams
Enquire Now

SQL for Beginners with Official Microsoft Exams

Study Method
Online
Institution
Hudson
Recognition
Microsoft Partner
Start Date
Enrol anytime
Course Fees
£954
Hudson Courses

Course overview

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 are 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.

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.

Expand all and read more

Recognition

Study method

  • Online
  • Blended
  • Christmas Deal
  • In-class

Duration study load

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. 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 will have full access to the course material and resources for 12 months and must take your exams within this period.

Course features

  • Expert instructor-led training
  • Visual demonstrations & multimedia presentations
  • Quizzes & exam simulators
  • Flash cards & educational games
  • Navigation & controls

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

Assessment

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 (MCSA: 1 of 2 exams)
  • Microsoft 70-765 Provisioning SQL Databases (MCSA: 2 of 2 exams)

Materials

Your course can be done from anywhere 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, smartphone, and an internet connection.

Delivery

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 smartphone.

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.

MeasureUP Practice Exams

After working your way through each textbook and practice lab, 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.

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.

Courses included in this bundle

  1. SQL Basics (no exam)
  2. SQL Database for Beginners (no exam)
  3. Introduction to Transact SQL (no exam)
  4. Introduction to SQL Server Integration Services (no exam)
  5. SQL Server Integration Services (no exam)
  6. Microsoft 70-764 SQL 2016 Administering an SQL Database Infrastructure (1 exam)
  7. Microsoft 70-765 Provisioning SQL Databases (1 exam)

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).

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.

Subjects

Modules
Course 1
SQL Basics (no exam)
  • 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
Course 2
SQL Database for Beginners (no exam)
  • 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
Course 3
Introduction to Transact SQL (no exam)

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
Course 4
Introduction to SQL Server Integration Services (no exam)
  • 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
Course 5
SQL Server Integration Services (no exam)

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
  • Creating a Simple ETL Package | Adding Logging
  • Creating a Simple ETL Package | Adding Error Flow Redirection
  • Creating a Simple ETL Package | Adding Package Deployment Configuration
  • Creating a Simple ETL Package | Using Project Deployment Parameters

Module 3

  • Deploying Packages Using The Package Deployment Model | Preparing to Create the Deployment Bundle
  • Deploying Packages Using The Package Deployment Model | Creating the Deployment Bundle
  • Deploying Packages Using The Package Deployment Model | Installing Packages
Course 6
Microsoft 70-764 SQL 2016 Administering an SQL Database Infrastructure (1 exam)
  • Module 1: Encryption
  • Module 2: Configure Data Access and Permission
  • Module 3. Configure Auditing
  • Module 4: Develop a Backup Strategy
  • Module 5: Restore Databases
  • Module 6: Manage Database Integrity

 

 

Course 7
Microsoft 70-765 Provisioning SQL Databases (1 exam)
  • Module 1: Deploy a Microsoft Azure SQL Database
  • Module 2: Plan for SQL Server Installation
  • Module 3: Deploy SQL Server Instances
  • Module 4: Deploy SQL Server Databases to Azure Virtual Machines
  • Module 5: configure Secure Access to Microsoft Azure SQL Databases
  • Module 6: Configure SQL Server Performance Settings
  • Module 7: Manage SQL Server Instances
  • Module 8: Manage SQL Storage Module 9: Perform Database Maintenance

 

Want more information about the subjects for this course?
Get the course guide

Payment options

Course fees – £954

  • Option to pay in 4, 5 or 6 monthly instalments
  • No government funding available for this course
Find out more about the payment options for this course
Get the course guide

About Hudson

In the confusing world of e-learning, Hudson is quite simply one of the best at what they do. Why? Because they offer first-class customer service. The Hudson Learning Center puts their customers’ needs before anything else. If there’s something they can do to help you, Hudson will climb mountains to do it.

The Hudson online courses, certifications, and diplomas are highly effective, offering a whole range of features designed to get you certified faster. Some of these incredible features include video and audio based training so you can see and hear your tutor, 24/7 online tutor support, and online labs to practice your skills in a simulated environment.

Come and give Hudson a try. They’ll change the way you think about learning.

Reviews
Trustpilot

Recognition

Study method

  • Online
  • Blended
  • Christmas Deal
  • In-class

Want to know more about this course?
Complete the form and learn about:

  • Pricing and payment options
  • Start dates
  • Subjects
  • Study method
  • How to get help and contact information
  • Everything you need to know before enrolling!

Want to know more about this course?

Get your free course guide now! Complete this easy form and you'll also receive a course consultation with Hudson.

By submitting this enquiry I accept the "Privacy Policy" and "Terms of Use"

Receive a consultation from a course expert

See student testimonials below

"I found the website easy to use and the contact I received after my enquiry was good. Not too pushy but there if I needed them." - Dimity G.
"All details and info was there and my query was answered quickly." - Soula M.
"Gave me everything I needed and someone called me, pretty much straight away." - Marlon T.
Copyright © 2018 Coursesonline.co.uk Contact About Privacy Terms Become a Partner Blog Sitemap
VAT No: 301 5420 62 Company No: 11182409

Coursesonline.co.uk uses cookies. By continuing you are agreeing to our use of cookies. Learn more.

Coursesonline.co.uk
Privacy Overview

This website uses cookies so that we can provide you with the best user experience possible. Cookie information is stored in your browser and performs functions such as recognising you when you return to our website and helping our team to understand which sections of the website you find most interesting and useful.

Strictly Necessary Cookies

Strictly Necessary Cookie should be enabled at all times so that we can save your preferences for cookie settings.

If you disable this cookie, we will not be able to save your preferences. This means that every time you visit this website you will need to enable or disable cookies again.

Additional Cookies

This website uses additional cookies to collect anonymous information such as the number of visitors to the site, and the most popular pages.

Keeping this cookie enabled helps us to improve our website.

Please enable Strictly Necessary Cookies first so that we can save your preferences!

Cookie Policy

More information about our Cookie Policy