Microsoft Certified Solutions Associate (MCSA)

COURSE LENGTH

1500 Clock Hours

How it Works

Flexible Schedule

Our classes are available from the comfort of your home. You simply register, get started on the cohort day, and complete the weekly requirements.

No Risk... No Upfront Cost

We offer you the ability to pay zero tuition upfront.

Job Placement

We actively search for the highest paying industries on the planet. When you graduate, we work to ensure you get placed in a job immediately.

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.

What can you achieve as a Microsoft Certified Solutions Associate specialist?

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 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

Feature of The MCSA Courses

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.

Here’s what you will learn

Course Details

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.

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

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.

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

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.

Covers administering a Microsoft SQL database infrastructure, provisioning SQL databases, and development, extensions and deployment for Microsoft Dynamics 365 for finance and operations.

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.

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.

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

Covers installing and configuring windows server 2012, administering windows server 2012, and configuring advanced windows server 2012 services.

Take the First Step to
Secure Your Future

Speak with an Enrollment Counsellor today

Shopping Basket

Fill out the form below for an expert advice on your course