LGIT Smart Solutions

Uplifting: Business - People - Community

Data Management & Analytics

Download: Data Roadmap
Data & Analytics Certification
Data-path.pdf (688.64KB)
Download: Data Roadmap
Data & Analytics Certification
Data-path.pdf (688.64KB)

Demonstrate your essential skills and breakthrough insights in developing and maintaining the next wave of mission-critical environments. 

There are several MCSA certifications that can serve as pre-requisite for the MCSE Data Management and Analytics.

- Database Development
- Database Admin
- Data Science
- BI Reporting
- Big Data Engineering
- Cloud Database Development



Certifications & Courses 

MCSA: SQL 2016 Database Development

Course 20761 and exam 70-761 - Querying SQL Server 2016 (online training available)

Course 20762 and exam 70-762 - Developing SQL 2016 Databases (online training available)

MCSA: SQL 2016 Database Admin

Course 20764 and exam 70-764 - Administering a SQL 2016 Database Infrastructure (online training available)

Course 20765 and exam 70-765 - Provisioning SQL 2016 Databases  (online training available)


Course 20767 and exam 70-767 - Implementing a SQL 2016 Data Warehouse (online training available)

Course 20768 and exam 70-768 - Developing SQL 2016 Data Models (coming soon)

MCSA: Data Science

Course 20773 and exam 70-773 - Analysing Big Data with Microsoft R (online training available)

Course 20774 and exam 70-774 - Cloud Data Science with Azure Machine Learning (online training available)

MCSA: BI Reporting

Course 20778 and exam 70-778 - Analyzing Data with Power BI (online training available)

Course 20768 and exam 70-768 - Developing SQL 2016 Data Models (coming soon)

MCSA: Big Data Engineering

Course 20775 and exam 70-775 - Perform Data Engineering on Microsoft HD Insight

Course 20776 and exam 70-776 - Engineering Data with Microsoft Cloud Service

MCSA: Cloud Database Development

Course 20777 and exam 70-777 - Implementing NoSQL Solutions with DocumentDB and Azure Search

Course 20473 and exam 70-473 - Designing and Implementing Cloud Data Platform Solutions

MCSA: SQL Server 2014

Course 20461 and exam 70-461 - Querying SQL Server 2014 (online training available)

Course 20462 and exam 70-462 - Administering SQL Server 2014 Databases  (online training available)

Course 20463 and exam 70-463 - Implementing a Data Warehouse with SQL Server 2014 (online training available)


Still a Beginner?

Don't stress!  We can help you obtain the Foundation Skills you need.

Available Foundation Courses:

  • Course 40364: Database Administration Fundamentals (Exam and MTA Certification available)
  • Course 10985: Intro to SQL Server 2016 Databases (online training available)

Please Contact Us to enquire about the online Database Foundation courses.


MTA: Foundation Certifications

Microsoft Technology Associate (MTA) is an introductory Microsoft certification for individuals considering a career in technology. MTA certification addresses a wide spectrum of fundamental database concepts, assesses and validates your core  database knowledge, and enhances your credibility.

Note MTA exams do not qualify for MCP certification, nor are they a prerequisite for MCSA or MCSD certification.