This program will showcase an individual’s expertise in SQL Administration, building enterprise data solutions and effectively using business intelligence data. The path forward is to obtain a MCSA – SQL then complete with an MCSE in data management/data analytics.
MCSA/MCSE - Data Management & Analytics Program Details
20761 Querying Data with Transact SQL
The main purpose of this course is to give students a good understanding of the Transact-SQL language which is used by all SQL Server-related disciplines; namely, Database Administration, Database Development and Business Intelligence.
20762 Developing SQL Databases
This course provides students with the knowledge and skills to develop a Microsoft SQL Server 2016 database. The course focuses on teaching individuals how to use SQL Server 2016 product features and tools related to developing a database
20467 Designing Business Intelligence Solutions with Microsoft SQL Server
This course teaches students how to implement self-service Business Intelligence (BI) and Big Data analysis solutions using the Microsoft data platform. The course discusses the rationale for self-service BI, and describes how to use Microsoft SQL Server Reporting Services, Microsoft Excel, Microsoft SharePoint Server, and Microsoft Office 365 Power BI to create self-service data models and reports.
20778 Analyzing Data with Power BI
The main purpose of the course is to give students a good understanding of data analysis with Power BI. The course includes creating visualizations, the Power BI Service, and the Power BI Mobile App.
After successfully completing one of our programs, you may qualify for the following career opportunities.
- Data Architect
- Database Administration Manager
- Information Systems Manager
- Management Information Systems Director
According to the Bureau of Labor Statistics, areas of employment aligned with this program are projected to grow 11 percent through to 2024.
Common Job Responsibilities
- Collects and stores data on sales numbers, market research, logistics, linguistics, or other behaviors.
- Brings technical expertise to ensure the quality and accuracy of that data.
- Processes, designs, and presents data in ways to help organizations make better business decisions.
- May maintain the administration functions.