American Tech Institute site
Our classes are available from the comfort of your home. You simply register, get started on the cohort day, and complete the weekly requirements.
We offer you the ability to pay zero tuition upfront.
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.
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.
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.