MTA (Microsoft Technology Associate) Windows Server Administration Training Courses

1. Core Database Concepts

• Database Concepts
• Data Manipulation Language (DML)
• Data Definition Language (DDL)

2. Creating Database Objects

• Key Terms
• Data Types
• Creating and Using Tables
• Creating Views
• Creating Stored Procedures

3. Manipulating Data

• Using Queries to Select Data
• Using Queries to Insert Data
• Updating Data and Databases
• Deleting Data

4. Data Storage

• Normalizing a Database
• Primary, Foreign, and Composite Keys
• Clustered and Non-Clustered Indexes

5. Administering a Database

• Securing Databases
• Backing Up and Restoring Databases

1. Server

• What a Server Does
• Installing Windows Server 2008 RS

2. Managing Windows Server 2008 R2

• Performing Initial Configuration Tasks
• Using the Control Panel
• Configuring IP Address Settings
• Managing Devices and Device Drivers
• Using Microsoft Management Console and Administrative Tools
• Installing Programs, Roles, and Features
• Managing Services
• Registry
• Managing Server Core

3. Storage

• Storage Technologies
• Network Attached Storage and Storage Area Networks
• Disk Structure
• Using Disk Management Tools

4. Monitoring and Troubleshooting Servers

• Troubleshooting Methodology
• Booting the System
• Performance
• Business Continuity
• Backups
• Performing Server Repair

5. Essential Services

• Naming Resolution
• DHCP Services
• Directory Services with Active Directory

6. File and Print Services

• New Technology File System (NTFS)
• Sharing Drives and Folders
• Looking at Printers
• Enabling Auditing

7. Popular Windows Network Services and Applications

• Web Server
• Remote Access
• Remote Administration
• Server Virtualization

1. Windows Applications

• Windows Application Types
• Windows GUI
• Windows Non-GUI
• Windows Win32
• Windows Application User Interface Types
• Single Document User
• Multiple Document
• Navigation User
• Windows Application User Interface Design Principles
• Design Principles
• Applying Specific Design Principles

2. Creating a Windows Application Project in Visual Studio

• Windows Forms Application
• Windows Presentation Foundation Application
• Windows Service Application

3. Creating a Windows Forms User Interface

• Windows Forms
• Setting Windows Forms Properties
• Adding Multiple Windows Forms
• Creating Windows Forms Inheritance
• Instantiating and Inheriting Windows Forms
• Extending Inherited Windows Forms
• Windows Forms Controls
• Container Controls
• Menu and Toolbar Controls
• Input Controls
• Advanced Input Controls
• Component Controls
• Dialog Controls
• Creating Custom Windows Forms Controls
• Creating a Custom Control Library
• Inheriting a Custom Control Library

4. Controlling Application Execution

• Events in Windows Forms
• Creating Windows Forms Events
• Raising Windows Forms Events
• Events in WPF
• Creating Routed Events
• Windows Service Applications
• Understanding the Windows Service Applications
• Debugging Windows Services Applications
• Windows Application Debugging
• Debugging a Windows Service Application

5. Validating User Input

• Windows User Input Model
• Analyzing User Input Needs
• Handling Input Device User Inputs
• Keyboard User Inputs
• Mouse User Inputs
• Stylus User Inputs
• Control User Inputs
• Handling Exceptions
• Exception Class
• Trapping Exceptions
• Throwing Exceptions

6. Integrating Data

• Data in Windows Applications
• Active Data Objects (ADO.NET)
• Connecting Data to Windows Applications
• Data in Windows Forms
• Creating Windows Forms Data Controls
• Validating Data in Windows Forms
• Data in WPF
• WPF Binding
• Using WPF Specialized Binding
• Using WPF Database Binding

7. Packaging and Deploying Windows Applications

• Windows Application Distribution
• Windows Application Distribution Options
• Setup Wizard Template
• Windows Application Setup and Deployment Project Templates
• Windows Application Setup and Deployment Project Components
• Setup Project
• Merge Module Project
• ClickOnce Deployment