IT PROGRAMS

MCSA Windows Server 2012 A- Installing and Configuring Windows Server 2012. 70-410 B- Administering Windows Server 2012. 70-411 C- Configuring Advanced Windows Server 2012 Services. 70-412 A- Installing and Configuring Windows Server 2012 Install and Configure Servers (17%) Install servers This objective may include but is not limited to: Plan for a server installation; plan for server roles; plan for a server upgrade; install Server Core; optimize resource utilization by using Features on Demand; migrate roles from previous versions of Windows Server Configure servers This objective may include but is not limited to: Configure Server Core; delegate administration; add and remove features in offline images; deploy roles on remote servers; convert Server Core to/from full GUI; configure services; configure NIC teaming Configure local storage This objective may include but is not limited to: Design storage spaces; configure basic and dynamic disks; configure MBR and GPT disks; manage volumes; create and mount virtual hard disks (VHDs); configure storage pools and disk pools   Configure Server Roles and Features (16%) Configure file and share access This objective may include but is not limited to: Create and configure shares; configure share permissions; configure offline files; configure NTFS permissions; configure access-based enumeration (ABE); configure Volume Shadow Copy Service (VSS); configure NTFS quotas Configure print and document services This objective may include but is not limited to: Configure the Easy Print print driver; configure Enterprise Print Management; configure drivers; configure printer pooling; configure print priorities; configure printer permissions Configure servers for remote management This objective may include but is not limited to: Configure WinRM; configure down-level server management; configure servers for day-to-day management tasks; configure multi-server management; configure Server Core; configure Windows Firewall   Configure Hyper-V (17%) Create and configure virtual machine settings This objective may include but is not limited to: Configure dynamic memory; configure smart paging; configure Resource Metering; configure guest integration services Create and configure virtual machine storage This objective may include but is not limited to: Create VHDs and VHDX; configure differencing drives; modify VHDs; configure pass-through disks; manage snapshots; implement a virtual Fibre Channel adapter Create and configure virtual networks This objective may include but is not limited to: Implement Hyper-V Network Virtualization; configure Hyper-V virtual switches; optimize network performance; configure MAC addresses; configure network isolation; configure synthetic and legacy virtual network adapters   Deploy and Configure Core Network Services (16%) Configure IPv4 and IPv6 addressing This objective may include but is not limited to: Configure IP address options; configure subnetting; configure supernetting; configure interoperability between IPv4 and IPv6; configure ISATAP; configure Teredo Deploy and configure Dynamic Host Configuration Protocol (DHCP) service This objective may include but is not limited to: Create and configure scopes; configure a DHCP reservation; configure DHCP options; configure client and server for PXE boot; configure DHCP relay agent; authorize DHCP server Deploy and configure DNS service This objective may include but is not limited to: Configure Active Directory integration of primary zones; configure forwarders; configure Root Hints; manage DNS cache; create A and PTR resource records   Install and Administer Active Directory (18%) Install domain controllers This objective may include but is not limited to: Add or remove a domain controller from a domain; upgrade a domain controller; install Active Directory Domain Services (AD DS) on a Server Core installation; install a domain controller from Install from Media (IFM); resolve DNS SRV record registration issues; configure a global catalog server Create and manage Active Directory users and computers This objective may include but is not limited to: Automate the creation of Active Directory accounts; create, copy, configure, and delete users and computers; configure templates; perform bulk Active Directory operations; configure user rights; offline domain join; manage inactive and disabled accounts Create and manage Active Directory groups and organizational units (OUs) This objective may include but is not limited to: Configure group nesting; convert groups including security, distribution, universal, domain local, and domain global; manage group membership using Group Policy; enumerate group membership; delegate the creation and management of Active Directory objects; manage default Active Directory containers; create, copy, configure, and delete groups and OUs   Create and Manage Group Policy (16%) Create Group Policy objects (GPOs) This objective may include but is not limited to: Configure a Central Store; manage starter GPOs; configure GPO links; configure multiple local group policies; configure security filtering Configure security policies This objective may include but is not limited to: Configure User Rights Assignment; configure Security Options settings; configure Security templates; configure Audit Policy; configure Local Users and Groups; configure User Account Control (UAC) Configure application restriction policies This objective may include but is not limited to: Configure rule enforcement; configure Applocker rules; configure Software Restriction Policies Configure Windows Firewall This objective may include but is not limited to: Configure rules for multiple profiles using Group Policy; configure connection security rules; configure Windows Firewall to allow or deny applications, scopes, ports, and users; configure authenticated firewall exceptions; import and export settings   B- Administering Windows Server 2012 Deploy, Manage, and Maintain Servers (17%) Deploy and manage server images. This objective may include but is not limited to: Install the Windows Deployment Services (WDS) role; configure and manage boot, install, and discover images; update images with patches, hotfixes, and drivers; install features for offline images Implement patch management. This objective may include but is not limited to: Install and configure the Windows Server Update Services (WSUS) role; configure group policies for updates; configure client-side targeting; configure WSUS synchronization; configure WSUS groups Monitor servers. This objective may include but is not limited to: Configure Data Collector Sets (DCS); configure alerts; monitor real-time performance; monitor virtual machines (VMs); monitor events; configure event subscriptions; configure network monitoring   Configure File and Print Services (15%) Configure Distributed File System (DFS). This objective may include but is not limited to: Install and configure DFS namespaces; configure DFS Replication Targets; configure Replication Scheduling; configure Remote Differential Compression settings; configure staging; configure fault tolerance Configure File Server Resource Manager (FSRM). This objective may include but is not

Program Description Comp-70680: Microsoft Windows 7 In this Windows 7 training course, you will gain the knowledge and skills you need to successfully administer, maintain, and troubleshoot Windows 7 computers.   Comp-70640: Windows Server 2008 - Active Directory Configuration In this comprehensive course you will not only discuss the crucial concepts and best practices of Active Directory, but you will also discover through hands-on exercises the Active Directory roles available in Windows Server 2008 and Windows Server 2008 R2. You will gain the knowledge and skills to configure Active Directory Domain Services (AD DS) in Windows Server 2008 and Windows Server 2008 R2 distributed environments, and you will create and configure Group Policies, perform backup and restore, and monitor and troubleshoot Active Directory-related issues.   Comp-70642: Windows Server 2008 - Network Infrastructure Configuration Gain the knowledge and skills necessary to configure and troubleshoot Windows Server 2008 and Windows Server 2008 R2 SP1 network infrastructures. This course covers the networking technologies most commonly used with Windows Server 2008 and Windows Server 2008 R2 SP1, such as DNS, DHCP, IPv4 and IPv6 network addressing, Network Policy Server and Network Access Protection, and configuring secure network access. You will learn to implement fault-tolerant storage technologies, network storage and routing and remote access, monitoring, and compliance updates.   Comp-70646: Application Infrastructure Configuration In this course, student will be able to plan and implement a Windows Server 2008 and Windows Server 2008 R2 environment. It incorporates both the planning of the server infrastructure and key aspects of the implementation, management and maintenance of Active Directory and Network Infrastructure. It is the primary training resource for Exam 70-646 preparation (MCITP: Server Administrator certification). It covers the most important job tasks for Server Administrators who are responsible for the planning, operations, and day-to-day maintenance of Windows Server 2008 and Windows Server 2008 R2 servers in the enterprise.

SQL Server Database Specialist Program Length Total Contact Hours Program Cost Clock Hours 450 Theory Hours 150 Tuition $ 12,500 Credit Hours Lab Hours 300 Registration Fees $ 100 Externship Hours Books & Supplies $ 1000 Material Cost $ 500 Exam Cost $ 900 Total Hours 450 Total Program Cost $ 15,000   Course Number Course Title Clock Hours Lab Hours COMP-70-761 Querying Data with Transact-SQL 70-761 30 COMP-70-762 Developing SQL Databases 70-762 30 COMP-70-764 Administering a SQL Database Infrastructure 70-764 30 COMP-70-765 Provisioning SQL Databases 70-765 30 COMP-70-467 Designing Business Intelligence Solutions with Microsoft SQL Server 70-467 30  Total of Theory Hours  150 COMP-70-761 Querying Data with Transact-SQL 70-761 60 COMP-70-762 Developing SQL Databases 70-762 60 COMP-70-764 Administering a SQL Database Infrastructure 70-764 60 COMP-70-765 Provisioning SQL Databases 70-765 60 COMP-70-467 Designing Business Intelligence Solutions with Microsoft SQL Server 70-467 60 Total Lab Hours 300   Total Hours Theory and Labs 450     Program Objective In the training, the student will acquire skills in Database Development, Database Administration and Business Intelligence. These courses will prepare the students to be able to design, Install, Program, Manage and troubleshoot Microsoft SQL Server 2016 Databases Program Description Querying Data with Transact-SQL 70-761 Developing SQL Databases 70-762 Administering a SQL Database Infrastructure 70-764 Provisioning SQL Databases 70-765 Designing Business Intelligence Solutions with Microsoft SQL Server 70-467 1- Querying Data with Transact-SQL 70-761 Introduction to Microsoft SQL Server 2016 Introduction to T-SQL Querying Writing SELECT Queries Querying Multiple Tables Sorting and Filtering Data Working with SQL Server 2016 Data Types Using DML to Modify Data Using Built-In Functions Grouping and Aggregating Data Using Subqueries Using Table Expressions Using Set Operators Using Windows Ranking, Offset, and Aggregate Functions Pivoting and Grouping Sets Executing Stored Procedures Programming with T-SQL Implementing Error Handling Implementing Transactions  2- Developing SQL Databases 70-762 Introduction to Database Development Designing and Implementing Tables Advanced Table Designs Ensuring Data Integrity through Constraints Introduction to Indexes Designing Optimized Index Strategies Column store Indexes Designing and Implementing Views Designing and Implementing Stored Procedures Designing and Implementing User-Defined Functions Responding to Data Manipulation via Triggers Using In-Memory Tables Implementing Managed Code in SQL Server Storing and Querying XML Data in SQL Server Storing and Querying Spatial Data in SQL Server Storing and Querying BLOBs and Text Documents in SQL Server SQL Server Concurrency Performance and Monitoring 3- Administering a SQL Database Infrastructure 70-764 SQL Server Security Assigning Server and Database Roles Authorizing Users to Access Resources Protecting Data with Encryption and Auditing Recovery Models and Backup Strategies Backing Up SQL Server Databases Restoring SQL Server 2016 Databases Automating SQL Server Management Configuring Security for SQL Server Agent Monitoring SQL Server with Alerts and Notifications Introduction to Managing SQL Server by using PowerShell Tracing Access to SQL Server with Extended events Monitoring SQL Server Troubleshooting SQL Server Importing and Exporting Data 4- Provisioning SQL Databases 70-765 SQL Server 2016 Components Installing SQL Server 2016 Upgrading SQL Server to SQL Server 2016 Working with Databases Performing Database Maintenance Database Storage Options Planning to Deploy SQL Server on Microsoft Azure Migrating Databases to Azure SQL Database Deploying SQL Server on a Microsoft Azure Virtual Machine Managing databases in the Cloud 5- Designing Business Intelligence Solutions with Microsoft SQL Server 70-467 Plan business intelligence infrastructure Plan for performance Plan for scalability Plan and manage upgrades Maintain server health Design BI Infrastructure Design a security strategy Design a SQL partitioning strategy Design a high availability and disaster recovery strategy Design a logging and auditing strategy Design a reporting Solution Design a Reporting Services dataset Manage Excel Services/reporting for SharePoint Design a data acquisition strategy Plan and manage reporting services configuration Design BI reporting solution architecture Design BI data models Design the data warehouse Design a schema Design cube architecture Design fact tables Design BI semantic models Design and create MDX calculations Design an ETL solution Design SSIS package execution Plan to deploy SSIS solutions Design package configurations for SSIS packages