IT Technician | Networking | Servers | Cloud | Coding | Database | Web Design | IT Management | Project Management | Microsoft Office | Data Scientist | Blockchain | Python | Machine Learning | AI
Meet your Instructor:

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
High
R368k
You can earn an average
of R368,000.00 a year
Salary Indicator
SALARY PROJECTION
Average
salary after
completing
High
R368k
You can earn an average
of R368,000.00 a year
Salary Indicator
SALARY PROJECTION
Average
salary after
completing
High
R368k
You can earn an average
of R368,000.00 a year
What’s Included

- 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
Our Training Is Trusted By











