Learners

Certificates

Courses

Exact matches only

Search in title

Search in content

Search in excerpt

Search in posts

Search in pages

Meet your Instructor:

Simon Tavasoli
Instructor: Technology and Developer

Meet your Mentor:

Carl Mullin
Mentor: Business/Technology and Developer

MCSE Data Management & Analytics

Overview

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.

MCSA SQL 2016 Database Developer (70-761 & 70-762)

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

Machine Learning (70-773 & 70-774)

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

MCSA SQL 2016 Database Admin (70-764 & 70-765)

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

Electives (Select 1)

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.

How our courses work

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.