Facebook Instagram Linkedin Trustpilot
0
Learners
0
Certificates
0
Courses

Generic selectors
Exact matches only
Search in title
Search in content
Search in posts
Search in pages

Meet your Instructor:

 width=

Simon Tavasoli
Instructor: Technology and Developer

Meet your Mentor:

Carl Mullin
Mentor: Business/Technology and Developer

MCSE Data Management & Analytics

Please select either the Database Developer, Database Administrator or Machine Learning courses and 1 x elective. Please select either the Database Developer, Database Administrator or Machine Learning courses and 1 x elective.

70-761: Querying Data with Transact-SQL

T-SQL Querying

Querying and Manipulating Data

Filter and Modify Data in SQL Server 2016

Using Functions in SQL Server 2016

Aggregating Data in SQL Server 2016

Subqueries and Predicate

Operators and Expressions in SQL Server 2016

Database Programmability Objects and Non-Relational Data

MCSA SQL 2016 Database Developer (70-762):

SQL Server 2016 Database Objects

SQL Server 2016 Indexes and Views

Columnstore Indexes

Programmability Objects

Triggers and Functions

Managing Database Concurrency

Optimize SQL Database Objects and Infrastructure

Analyzing Big Data with Microsoft R

Getting Started with Microsoft R

Packages and Data Types

The R Language and Big Data Processing

Importing and Manipulating Data

Modifying and Summarizing Data

Data Visualization and Predictive Analytics

Regression Analysis

Decision Tree and Classification Analysis

Cluster Analysis and Ensemble Learning

Machine Learning (70-774):

Perform Cloud Data Science with Azure Machine Learning

Cloud Data Science: Introduction to Azure Machine Learning

Cloud Data Science: Deploying Models with Azure Machine Learning Studio

Cloud Data Science: Consume Models and APIs Using Azure Machine Learning Studio

Cloud Data Science: Importing and Exporting in Azure Machine Learning Studio

Cloud Data Science: Summarize Data with Azure Machine Learning Studio

Cloud Data Science: Data Cleanup with Azure Machine Learning Studio

Cloud Data Science: Transforming Data in Azure Machine Learning Studio

Cloud Data Science: Using Algorithms in Azure Machine Learning Studio

Cloud Data Science: Optimize and Validate Models in Azure Machine Learning Studio

Cloud Data Science: Azure AI Gallery and Azure Machine Learning

Cloud Data Science: Microsoft Cognitive Toolkit and Azure Machine Learning

Cloud Data Science: Virtual Machines & HDInsight

Cloud Data Science: SQL Server & Azure Machine Learning

Encryption

Data Access and Permissions

Auditing

Backing Up Databases

Restoring Databases

Managing Database Integrity

Monitoring Database Activity and Queries

Monitoring SQL Server Instances

Managing Indexes and Statistics

High Availability and Disaster Recovery

MCSA SQL 2016 Database Admin (70-765):

Components of a SQL Server 2016 Installation

Installing and Upgrading SQL Server 2016

SQL Server Virtual Machines on Azure

SQL Server Instances and Storage Considerations

Azure SQL Database Encryption

SQL Server Performance Settings

Deploying Applications to Microsoft Azure SQL Databases

Azure Virtual Machines

Migrating Client Applications

70-473 Designing and Implementing Cloud Data Platform Solutions

70-475 Designing and Implementing Big Data Analytics Solutions

70-464 Developing Microsoft SQL Server 2012 Databases

70-465 Designing Database Solutions for Microsoft SQL Server

70-467 Designing Business Intelligence Solutions with Microsoft SQL Server

70-762 Developing SQL Databases

70-773 Analyzing Big Data with Microsoft R

70-774 Perform Cloud Data Science with Azure Machine Learning

70-775 Perform Data Engineering on Microsoft HD Insight

Course Fee:    R6 495.00 or R6 995.00 on terms with R2 927.00 deposit and 6 monthly installments of R594.66.

Certification:

International exams are optional and can be written at any Pearson Vue Testing Centre in South Africa.  Discounted international exam vouchers can be purchased through IT Academy.

Courses are accessible on a Computer, Laptop, Tablet or Smartphone. Courses are designed in video with audio, printable, includes One-on-One Mentoring, Free Virtual-LABS with feedback and exam preps. Learners are assessed after each lecture, all assessments can be retaken at no additional cost. Receive a .pdf and original Certificate within 1 week which can be added to your CV. International exams are optional and can be written at anytime, Click here to view Centres in your area. e-Mail info@it-academy.co.za to arrange your exam booking.

One-on-One Mentoring

Free Virtual-LABS

Mobile Ready (Tablet/Smartphone access)

100% Pass Rate / Course Mastery Certificate

Discounted International Exam Vouchers

Free Exam Preps

Printable

12 Month Subscription

Student Card

Payment Terms

Your Quick Course Guide

Certification: Microsoft

Study Time: 12 Months to complete 80 hours eg Study 1 hour per day and complete your courses in less than 3 months | Full Time or Part Time

Vendor: Microsoft

Provider: IT Academy

Student support: One-on-One Mentoring

Pre-requisite: MTA 98-364 Database Fundamentals included or Databse experience

Assessment: 70-761 & 70-762 or 70-764 & 70-765 or 70-773 & 70-774 & 1 x elective

Resources: Laptop, Tablet or Smartphone & Internet Connection

Expertise Level: Beginners

Register

Anytime – 24/7 Access

Salary Indicator

SALARY PROJECTION

Average
salary after
completing

Junior
R204k
Average Salary
You can earn
R368K
Senior
R532k

High

Source: Payscale

R368k

You can earn an average
of R368,000.00 a year

Salary Indicator

SALARY PROJECTION

Average
salary after
completing

Junior
R204k
Average Salary
You can earn
R368K
Senior
R532k

High

Source: Payscale

R368k

You can earn an average
of R368,000.00 a year

Salary Indicator

SALARY PROJECTION

Average
salary after
completing

Junior
R204k
Average Salary
You can earn
R368K
Senior
R532k

High

Source: Payscale

R368k

You can earn an average
of R368,000.00 a year

What’s Included

Replace-trainer-img
  • One-on-One Mentoring
  • Free Virtual-LABS
  • Mobile Ready (Tablet/Smartphone access)
  • 100% Pass Rate / Course Mastery Certificate
  • Discounted International Exam Vouchers
  • Free Exam Preps
  • Printable
  • 12 Month Subscription
  • Student Card
  • Payment Terms

Testimonials

How Our Courses Work

Access your On-Demand, Cloud-Based Learning Anytime, Anywhere.

Courses are accesssible on a Laptop, Tablet or Smartphone.

Assessments after each lecture which can be retaken.

One-on-One Mentoring, Free Virtual-LABS with feedback.

IT Academy Course Mastery Certificate:

Receive a .pdf and original Certificate within 1 week which can be added to your CV.
Enquire about NQF Certification.

International Certificate:

Optional, can be written at anytime, click here to view Centres in your area. e-Mail info@it-academy.co.za to arrange your exam booking.

IT Academy Accreditation/Partners: CompTIA (512759) / Microsoft (1204038185) / MICT Seta (ACC2011/01/684)

Top Skills in demand by Companies in South Africa –
Software Development, Security, Data Analyst & Networking

What Sets Us Apart

  • Official Partnerships

Partners with IT certification vendors Cisco, CompTIA, Microsoft & MICT Seta

  • IT Experts

Courses are designed and led by Certified Professionals, Mobile Access

  • Award Winning

e-Learning content delivered via Video, Quizzes, Virtual labs & Mentoring

  • Virtual Practice Labs

Learn, Practice writing Code with instant feedback in a Live Environment

  • Live Mentoring

Free One-on-One Live Mentoring with Certified IT Experts

  • Practice Tests

Take Practice Tests designed to mimic the actual exam

How Do I Register?

Select An Individual Or Bundle Course.

Complete The Registration Form.

Start Today!

Select A Payment Plan.

Select An Individual Or Bundle Course.

Complete The Registration Form.

Select A Payment Plan.

Start Today!

Our Training Is Trusted By

Excellent

Based On 173 Reviews


What past Students say about their experience with IT Academy