MCSA/MCSE SQL Data Management and Analysis Professional

(MTA SOFTWARE DEVELOPMENT, AZURE DEVELOPER ASSOCIATE, MTA PYTHON, MTA JAVASCRIPT, AZURE DATABASE ADMINISTRATOR, AZURE DATA ANALYST)

Certificate of Completion
360 Clock Hours
18 Weeks

The objective for the MCSA/MCSE SQL Data Management and Analysis Professional is to teach individuals how to design, implement, and administer a SQL Database Infrastructure. The student will also learn how to write Transact SQL code to access data from a SQL database, learn concepts for building enterprise-scale data solutions, and leveraging business intelligence data both on-premises and in cloud environments. Azure compute, storage, and security is covered in this program along with cloud-native and hybrid data platform solutions built on Microsoft Azure using SQL.  Students will learn to write basic Transact-SQL queries and learn how to properly maintain a SQL Database. Students will also learn how to enable businesses to maximize the value of their data assets by using Microsoft Power BI. With Power, BI students will create data models, clean and transform data, and create easy-to-comprehend data visualizations.  A Certificate of Completion will be awarded upon successful completion of this program. Upon successful program completion, graduates will possess the education and skills necessary to obtain an entry-level database administrator position in a medium to large sized organization.

Program Description

The core training for this program is defined by the competencies emphasized in attaining the Microsoft Azure Developer Associate,  Microsoft Azure Database Administrator, and Microsoft Azure Database Analyst certifications. These certifications ensure that the holder possesses competencies in creating, developing, maintaining, and deploying web applications and SQL Databases. This program will prepare students for a position as either a full stack web database administrator, database developer, or data analyst. Students in the MCSA/MCSE SQL Data Management and Analysis program will be provided with hands-on learning in order to ensure that they receive ample experience in both structured learning and “real world” cloud environments.

Please Note: In order to achieve the MTA Software Development,  MTA JavaScript, MTA Python, Azure Developer Associate, Azure Database Administrator, and Azure Data Analyst covered within the Full Stack Web Developer program, all students must sit for and pass the following exams:

  • Exam: 98-361: Software Development Fundamentals Exam
  • Exam: AZ-204: Developing Solutions for Microsoft Azure
  • Exam: 98-382: Introduction to Programming Using JavaScript
  • Exam: 98-381: Introduction to Programming Using Python
  • Exam: DP-300: Administering Relational Databases on Microsoft Azure
  • Exam: DA-100: Analyzing Data with Microsoft Power BI

Course Outline

Application Architect program (6 weeks):
Exam: 98-361: Software Development Fundamentals Exam – 3 weeks
Exam: AZ-204: Developing Solutions for Microsoft Azure – 3 weeks

Application Architect program  (6 weeks):
Exam: 98-382: Introduction to Programming Using JavaScript – 3 weeks
Exam: 98-381: Introduction to Programming Using Python – 3 weeks

Application Architect program (6 weeks):
Exam: DP-300: Administering Relational Databases on Microsoft Azure – 3 weeks
Exam: DA-100: Analyzing Data with Microsoft Power BI – 3 weeks