Microsoft Certified Solutions Associate (MCSA) - American Tech Institute

Microsoft Certified Solutions Associate

Course Description:

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
  • Prepare for the correlating industry exams

Admission Requirements

The applicants must have High school diploma or GED


1500 Clock Hours

Core Programs include:
Windows Server Pro: Install and Configure

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.

Windows Server Pro: Manage and Administer

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.

Windows Server Pro: Advanced Services

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.


Clock Hours: 135
Covers data analysis, data visualization, modeling, dashboards, and direct connectivity to data sources in Excel and Power BI.

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.

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.

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.

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

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.

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.

Clock Hours: 135
Covers universal windows platform applications,  functionality, and  implementation process of these apps across Windows devices.

Clock Hours: 140
Covers programming in HTML5 with JavaScript and CSS3, programming in C#, and developing ASP.NET MVC Web Applications

Clock Hours: 135
Covers installing and configuring windows server 2012, administering windows server 2012, and configuring advanced windows server 2012 services.

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