LGIT Smart Solutions

Uplifting: Business - People - Community

Data Management & Analytics

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
- SQL BI
- Machine Learning
- BI Reporting
- Big Data Engineering

Data-path.pdf (263.19KB)
Data-path.pdf (263.19KB)

 

Course

Title

Level

Classroom

Virtual


Beginners




40364

MTA: Database Administration Fundamentals


3 days

30 days

10985

Introduction to SQL 2016 Databases

200

3 days

90 days


MCSA - Database Development




20761

Querying Data with Transact-SQL 2016

200

5 days

90 days

20762

Developing SQL 2016 Databases

300

5 days

90 days


MCSA - Database Admin




20764

Administering a SQL 2016 Database Infrastructure

300

5 days

90 days

20765

Provisioning SQL 2016 Databases

200

5 days

90 days


MCSA - SQL 2016 BI




20767

Implementing a SQL 2016 Data Warehouse

300

5 days

90 days

20768

Developing SQL 2016 Data Models

200

3 days

90 days


MCSA - Machine Learning




20773

Analyzing Big Data with Microsoft R (new)

300

3 days

90 days

20774

Cloud Data Science with Azure Machine Learning (new)

300

5 days

90 days


MCSA - BI Reporting




20778

Analyzing Data with Power BI

300

3 days

90 days

20779

Analyzing and Visualizing Data with Microsoft Excel

300

3 days

90 days


MCSA - Big Data Engineering




20775

Perform Data Engineering on Microsoft HD Insight (new)

300

5 days

90 days

20776

Engineering Data with Microsoft Cloud Service

300

5 days

90 days


MCSA - SQL Server 2014




20461

Querying SQL Server 2014

200

5 days

90 days

20462

Administering SQL Server 2014 Databases

200

5 days

90 days

20463

Implementing a Data Warehouse with SQL Server 2014

300

5 days

90 days


Other SQL Server 2016




10986

Updating Your Skills to SQL Server 2016

300

5 days

90 days

10987

Performance Tuning and Optimizing SQL 2016 Databases

300

4 days

90 days

10988

Managing SQL Business Intelligence Operations

300

3 days

90 days

10990

Analyzing Data with SQL Server Reporting Services

300

3 days

90 days

10994

Data Analysis Fundamentals using Excel

200

2 days

90 days