Microsoft Certified Solutions Associate
(MCSA)
This program is composed of ten courses: BI Reporting, Dynamics 365 for Operations, SQL 2016 BI Development, SQL 2016 Database Administration, SQL 2016 Database Development, SQL Server 2012/2014, Universal Windows Platform, Web Applications, Windows Server 2012, and Windows Server 2016. Each course leads to eligibility for an industry certification. TATI does not guarantee a student a passing score on the designated industry certification exams.
Learning Objectives
Upon satisfactorily completing the Microsoft Certified Solutions Associate program, the student will be able to:
- Analyze data with both Power BI and Excel
- Demonstrate understating of Power Platform; cloud concepts; licensing options;
and deployment and release options - Demonstrate a working knowledge of Microsoft 365 and the benefits of adopting
cloud services, the Software as a Service (SaaS) cloud model, and implementing
Microsoft 365 cloud service - Demonstrate understanding of cloud concepts, core Azure Services, Azure pricing and support, and the fundamentals of cloud security, privacy, compliance, and
trust - Prepare for the correlating industry exams
Admission Requirements
The applicants must have High school diploma or GED
COURSE LENGTH
1500 Clock Hours
- Windows Server Pro: Install and Configure
- Windows Server Pro: Manage and Administer
- Windows Server Pro: Advanced Services

This course prepares students for Server Pro: Install and Configure certification exam and Microsoft’s Installing and Configuring Windows Server 2012 certification exam. Through this course, students gain valuable experience with designing, implementing, and managing a Windows Server 2012 environment.
Server Pro: Manage and Administer features an expanded corporate network that elevates each student’s knowledge of server administration. This course prepares students for Server Pro: Manage and Administer certification exam and Microsoft’s Administering Windows Server 2012 certification exam.
Server Pro: Advanced Services is the capstone course of our MCSA program. The advanced lab simulations in this course allow students to practice complex tasks that they would be expected to perform on servers at a midsize business. This course prepares students for Window’s Server Pro: Advanced Services exam and Microsoft’s Configuring Advanced Windows Server 2012 Services exam.
- MCSA101 BI Reporting
Clock Hours: 135
Covers data analysis, data visualization, modeling, dashboards, and direct connectivity to data sources in Excel and Power BI.
- MCSA102 Dynamics 365 for Operations
Clock Hours: 135
Covers administering a Microsoft SQL database infrastructure, provisioning SQL databases, and development, extensions and deployment for Microsoft Dynamics 365 for finance and operations.
- MCSA103 SQL 2016 BI Development I
Clock Hours: 140
Covers data warehousing solution, hardware considerations for building a data warehouse, data warehouse design, column store indexes, Azure SQL Data Warehouse, SQL Server Integration Services (SSIS), debug SSIS packages, ETL solution, data quality services, Master Data Services model, BI and common BI scenarios.
- MCSA104 SQL 2016 BI Development II
Clock Hours: 135
Covers BI solution, analysis services, dimensions in a cube, measures and measure groups in a cube, MDX syntax, customize a cube, tabular databases and models, and data mining.
- MCSA105 SQL 2016 Database Administration
Clock Hours: 135
Covers authentication and authorization, assigning server and database roles, data protection Describe recovery models and backup strategies, database management, SQL server management and security, alerts and notifications, access to SQL Server, SQL Server infrastructure, import and export data
- MCSA 106 SQL 2016 Database Development
Clock Hours: 135
Covers Microsoft SQL Server 2016 architecture, Transact-SQL, SELECT queries, Query multiple tables, Sorting and filtering data, data types in SQL Server, built-in functions, group and aggregate data, subqueries, table expressions, set operators, window ranking, offset and aggregate functions, pivoting and grouping sets, stored procedures, TSQL programming, error handling, and transactions.
- MCSA107 SQL Server 2012/2014
Clock Hours: 135
Covers querying Microsoft SQL server 2012/2014, administering Microsoft SQL server 2012/2014 databases, and Implementing a data warehouse with Microsoft SQL server 2012/2014.
- MCSA108 Universal Windows Platform
Clock Hours: 135
Covers universal windows platform applications, functionality, and implementation process of these apps across Windows devices.
- MCSA109 Web Applications
Clock Hours: 140
Covers programming in HTML5 with JavaScript and CSS3, programming in C#, and developing ASP.NET MVC Web Applications
- MCSA110 Windows Server 2012
Clock Hours: 135
Covers installing and configuring windows server 2012, administering windows server 2012, and configuring advanced windows server 2012 services.
- MCSA111 Windows Server 2016
Clock Hours: 140
Covers nano server, server installation and upgrade, storage options, partition table formats, disks and volumes, file systems, and drive hardware, enterprise storage solutions, storage spaces and data deduplication, Microsoft Hyper-V, disaster recovery technologies, failover cluster, Network Load Balancing (NLB), deployment images, and virtual
machine.