Microsoft Office & Azure Training and Certification in Los Angeles

ABCO Technology offers Microsoft Office and Microsoft Azure training in Los Angeles. ABCO Technology, which is one of the few Microsoft training companies in Los Angeles to offer an excellent way to improve your knowledge of technology and receive certification needed for many computer sciences or computer security career paths. We provide an intensive and intuitive grading process focused on the student’s success, and ability to build strength in a respective area of the technology field.

Microsoft Office training programs in Los Angeles includes the following courses: Microsoft Word Beginner, Intermediate, and Advanced courses, Microsoft Excel Beginner, Intermediate and Advanced courses, Microsoft PowerPoint Beginner and Advanced classes, Microsoft Outlook Beginner and Advanced classes, as well as Microsoft Azure training programs. Upon successfully completing the instructor-led and hands-on Microsoft Office and Microsoft Azure courses and training at ABCO Technology, students are prepared to pass the Microsoft Office and Microsoft Azure training programs for which leads to Microsoft Office and Microsoft Azure specialist certification.

Receive the Best Microsoft Office Training in Los Angeles

Through careful instruction, ABCO Technology is able to guide students to have productive skills that are useful to them over the course of their future careers in computer science or computer security. ABCO Technology offers some of the best Microsoft training in Los Angeles, CA, and provides users with ample support and numerous opportunities to expand their knowledge in order to be successful.

Obtain Microsoft Technical Certifications

If you are interested in Microsoft certified technical work, then look no further than ABCO Technology to start your career by obtaining quality education today. Microsoft training in Los Angeles has never been easier.

What type of Microsoft experience can you gain?

Our program allows participants to partake in MCITP Win 2008 Server and Enterprise Administrator, MCSA 2012 Server Infrastructure, MCTS Windows Developer Using Visual Studio 2005, Microsoft Certification, Microsoft IT certification, Microsoft Azure, as well as others.

Who can receive Microsoft Office certification?

The requirement to enroll in our Microsoft programs is students must have a High School Diploma or GED from an accredited institution. Students enrolling in our program should have basic computer operational skills such as the ability to surf the internet, access email, download attachments, organize files and folders, and navigate the basic functions of an operating system. As one of the best Microsoft training programs in Los Angeles, our certifications are open to military service members, students of any institution, or anyone willing to get certified. Call 310-216-3067 to get in touch with a knowledgeable ABCO Admissions Advisor.

How will Microsoft Office Specialist Certification help me?

As the global shift to online proficiency takes place, being able to use office programs is more important now than ever. Having the skills to utilize office tools such as Microsoft Word, Excel, PowerPoint and Outlook will enable you to collaborate with others in a workspace that takes place in a daily workplace and online. This will improve your basic understanding of computer programs that are similar to Microsoft Office. In addition, employers value these skills that potential employees already possess because it will save them time in training a prospective candidate to perform a task on a computer program. Getting Microsoft certified is an advantageous step, but certainly not one you will regret later down the road.

Why ABCO Technology for Microsoft Technical Certification?

ABCO Technology provides its students with the tools, opportunities, and support needed to showcase their knowledge and skills throughout the entire certification. Our knowledgeable instructor’s aid students in understanding the fundamentals and advanced skills that accompany learning and facilitating Microsoft Office.

What is Microsoft Office used for?

Microsoft Office is a broad user platform for creative and business-related purposes. It has a very broad user base and can be used by anyone from any device with Microsoft capabilities. Being proficient in Microsoft applications such as Word, Excel, PowerPoint is a highly sought-after skill, as more and more businesses conduct business online and use Microsoft Office on a regular basis.

Earn the Microsoft Azure Certification in Los Angeles

ABCO Technology offers Microsoft Azure Certification through a rigorous course of study, while obtaining unequaled Microsoft Azure training in Los Angeles aimed for students to gain unrivaled expertise in developing, deploying, and managing scalable applications worldwide on the cloud.

ABCO Technology offers certification training for students in Los Angeles, which results in becoming a Microsoft Azure Certified engineer thereafter completing the training program and course.

The training in the Microsoft Azure Certification program provides students of ABCO Technology the fluency in navigating Microsoft Azure, which is a subscription-based cloud service, Platform as a Service (PAAS), and Software as a Service (SAAS) facilitating access to storage of shared resources alongside a wide variety of web services on the cloud. The Microsoft Azure Certification is tailored to accelerate a computer science or computer security career of a student and an experienced developer to gain cloud expertise and relevant skillset to be a competitive asset in their field.

The Microsoft Azure training classes consists of cloud and data fundamentals, as well as acquiring the proper tools to build a multi-cloud strategy and new opportunities to create company efficiencies.

ABCO Technology offers a wide variety of possibilities for all students keen to earn Microsoft Azure Certification in world-renowned top cities of the United States of America. ABCO Technology provides top-rated Microsoft Azure courses and training to students and professionals seeking to solidify a rewarding computer science or computer security career paths.

The combination of our online-based and hands-on Microsoft Azure Certification courses and training can boost a students’ networking, analytics, computing, and data storage knowledge needed to excel in the IT sector. The major components of the Microsoft Azure Certification are skill development, methodological training, and evolving solutions pertaining to cloud services for which ensures security and privacy in varying IT enterprises.

The Microsoft Azure courses and training are successful in improving productivity and scalability of professional teams’ of developers’ platform vis-à-vis on the cloud. Students gain mastery of Microsoft Azure through the completion of the courses and training online and/or in Los Angeles. Students earn a certificate upon the successful completion the Microsoft Azure Certification.

Microsoft Azure Specialist Certification brings students of all levels from beginners to experienced developers comprehensive Microsoft Azure training courses intended to advance in their profession. Look no further for Microsoft Azure classes near you, as ABCO Technology offers quality education in Los Angeles and online. ABCO Technology provides the ease of access to quality education both locally and from anywhere worldwide.

The Microsoft Azure training courses provides students the understanding of fundamental cloud computing concepts, as well as successfully leveraging the conditions on the cloud propelling a profitable career, while innovatively advancing the evolution of the cloud environment.

Enroll in ABCO Technology’s Microsoft Azure Certification courses and training near me available online, or in Los Angeles to see if a computer science or computer security career paths specializing on the cloud environment is right for you or advance in your professional field by earning a certification in Microsoft Azure.

Accreditations and Affiliations

ABCO Technology is a private-for-profit and accredited institution granted to operate by the State of California Bureau for Private and Postsecondary Education. ABCO Technology is in compliance with the Bureau’s standards established under the law for occupational instruction by private-for-profit postsecondary educational institutions and does not imply any endorsement or recommendation by the State of California. Moreover, Institutional approval must be reapproved every five years and is subject to continuing review. California statutes require that a student who successfully completes a course of study is awarded an appropriate diploma or certificate verifying the fact. ABCO Technology is a leading educational institution for today’s evolving IT solutions.

MCITP Database Administrator Microsoft SQL

MCITP Exam 070 431

Database Administrator is the premier certification for database server administrators. This certification demonstrates that you can keep up with your enterprise business solutions 24 hours a day, 7 days a week. Database administrators install or configure Microsoft SQL Server and manage or maintain databases or multidimensional databases, user accounts, database availability, recovery, and reporting. In addition MCITP: Database Administrators also design or implement security or server automation and monitor and troubleshoot SQL Server activity. Database administrators are typically employed by mid-size to large organizations.

Course Objectives

After completing this course, students will be able to:

Install and configure SQL Server 2005
Create database and database files
Create data types and tables
Generate basic SQL Server 2005 queries and XML reports
Manage SQL security

Course Benefits

This course is intended for IT Professionals wanting to become skilled on SQL Server 2005 product features and technologies for maintaining a database.

Course Duration: 40 hrs

MCITP Exam 070 443

This course provides database administrators working in enterprise environments with the knowledge and skills to design a Microsoft SQL Server 2005 database infrastructure. The course focuses on the development of strategies for data archiving, consolidation, distribution, and recovery. The course also covers the importance of capacity analysis and emphasizes the trade offs that need to be made during design. This is the first course in the database administration curriculum and will server as the entry point in working in a Microsoft Environment.

Course Objectives

This course will cover the following elements:

Installing and configuring
Implementing high availability and disaster recovery
Supporting data consumers
Maintaining databases
Monitoring and troubleshooting SQL server performance
Creating and implementing database objects
Designing a database server infrastructure
Designing security for a database server solution
Designing a physical database
Designing a database solution for high availability
Designing a data recovery solution for a database
Designing a strategy for data archiving

Prerequisites

To ensure your success it is recommended that you have completed the following course or have equivalent knowledge:

Exam 070 - 431

OR Have working knowledge of the following:

Understand what RAID levels mean and how they differ from Storage Area Networks (SAN)
Understand how replication works and how it is implemented
Be familiar with reading user requirements and business-need documents.
Having knowledge of how queries execute. Must be able to read a query execution plan and understand what the system is doing.
Have basic knowledge of the dependencies between system components
Be able to design a database to third normal form (3NF).
Know the trade offs when backing out of the fully normalized design (denormalization) and design for performance and business requirements in addition to being familiar with design models, such as Star and Snowflake schema.
Have monitoring and troubleshooting skills
Have knowledge of the operating system and platform.
How operating systems integrate with the database, what the platform or operating system can do.
How the interaction between the operating system and the database works
Have knowledge of application architecture. How applications can be designed in three layers, what applications can do, interaction between applications and the database, interacting between the database and the platform or operating system.
Must know how to use Data Modeling Tool, Microsoft Office Visio (to create infrastructure diagrams)
Be familiar with SQL Server 2005 features, tools and technologies
Have a Microsoft Certified Technology Specialist: Microsoft SQL Server 2005 credential or equivalent experience.

Course Benefits

Upon successful completion the student will be able to:

Design for capacity requirements
Specify software versions and hardware configurations
Design physical storage
Design instances
Design a database consolidation strategy
Analyze business requirements
Integrate database security with enterprise-level authentication systems
Develop Microsoft Windows server-level security policies
Analyze the rise of attacks to the server environment and specify mitigation
Design database-level security
Design object-level security
Develop a strategy for migration to a highly available environment
Design a highly available database storage solution
Design a database-clustering solution
Design database mirroring
Design a high-availability solution that is based on replication
Design log shipping
Specify data recovery technologies based on business requirement
Design backup strategies
Create a disaster recovery plan
Select archiving techniques based on business requirements
Design backup strategies
Create a disaster recovery plan
Select archiving techniques based on business requirements
Design the format of archival data
Specify what data to archive
Plan for data archival and access
Design the topology of replication for archiving data
Design the type of replication for archiving data

Course Duration: 40 Hrs

MCITP Exam 70 444

This five day instructor-led course provides students with the knowledge and skills to administer and automate Microsoft SQL Server 2005 databases and servers. This course focuses on the need to maintain administration and automation information.

Course Objectives

The course will cover the following elements:

Optimizing the performance of database servers and database
Optimizing and implementing a data recovery plan for a database
Designing a strategy to monitor and maintain a database solution
Designing a database data management strategy
Designing a strategy to manage and maintain database security

Prerequisites

This course is intended for current professional database administrators who have three or more years of on-the-job experience administering SQL Server database solutions in an enterprise environment.

Course Benefits

Upon successful completion of the course the student will be able to:

Troubleshoot physical server performance
Troubleshoot instance performance
Troubleshoot database performance
Troubleshoot and maintain query performance
Troubleshoot concurrency issues
Diagnose causes of failures
Diagnose Database failures, physical server failures and SQL server failures
Plan for fault-tolerance
Recover from a failure of SQL Server 2005
Recover from a database disaster
Salvage good data from a damaged database by suing restoration techniques
Define and implement monitoring standards for a physical server
Choose the appropriate information to monitor
Create and implement a maintenance plan
Design a strategy to manage reporting services
Design and manage SQL server integrating services (SSIS) packages
Enforce data quality according to business requirements
Design data integrity
Design a strategy to manage data across linked servers
Design a strategy to manage replication
Optimize a database control strategy to meet business requirements
Perform a security audit of the existing security infrastructure based on the security plan
Maintain a server-level security strategy
Maintain a user-level security strategy
Prepare for response to threats and attacks

Course Duration: 40 hours

MCITP Win 2008 Server And Enterprise Administrator

MCITP 70 680 Windows 7 Configuration

Windows 7 exam examines your ability to operate in computing environments that use Microsoft Windows 7 as a desktop operating system. You will be able to install, deploy, and upgrade to Windows 7, including ensuring hardware and software compatibility. Additionally, candidates will be able to configure pre-installation and post-installation system settings, Windows security features, network connectivity applications included with Windows 7, and mobile computing. Candidates will also be able to configure and maintain systems, including monitoring for and resolving performance and reliability issues. Course Objectives This course will cover the following elements:

Performing a clean installation
Upgrading to Windows 7
Migrating user profiles
Capturing a system image
Preparing a system for deployment
Deploying images-automatically
Configuring application compatibility
Configuring application restrictions
Configuring Internet Explorer
Configuring 1Pv4 network settings
Configuring IPv6 network settings
Configuring network settings
Configuring Windows firewall
Configuring remote management
Configuring remote management
Configuring shared resources
Configuring file and folder access
Configuring user account control (UAC)
Configure authentication and authorization
Configuring branch cache
Configuring remote connections
Configuring updates to Windows 7
Managing disks volumes
Monitoring systems
Configuring performance settings
Configuring backups
Configuring file recovery options

Prerequisites Information Technology Field experience and one year working with any Windows operating system. Course Track

Microsoft Certified IT Professional: Windows 7 Configure
Microsoft Certified IT Professional: Enterprise Administrator
Microsoft Certified IT Professional: Enterprise Desktop Administrator 7
Microsoft Certified IT Professional: Enterprise Desktop Support Technician

Course Benefits Upon successful completion students will be able to:

Identify hardware requirements for clean Windows 7 installation
Setup Windows 7 as a sole operating system.
Setup as dual boot, boot from the source of installation
Upgrade from previous versions of Windows, including but not limited to: Windows Vista, migrate from Windows XP, upgrade from lower version of Windows 7
Migrate from one machine to another
Migrate from previous versions of Windows side-by-side vs. wipe and load
Prepare system for capture, create a WIM file, automate capture, conduct a manual capture
Prepare a system image for deployment, inserting an application into a system image; inserting a driver into a system image; inserting an update into a system image; configuring tasks to run after deployment
Deploy a system image-automated deployment methods; manually deploying a customized image
Configure devices - updating, disabling and uninstalling drivers; signed drivers; conflicts between drivers; configuring driver settings; resolving problem device drivers
Configuring application compatibility- configuring compatibility mode; implementing shims; compatibility issues with internet explorer
Configure application restrictions - setting software restriction policies; set application control policies; set group policy or local security policy
Configure IPv4 network settings - connect to a network; configure name resolution; set up a connection for a network; resolving connectivity issues; APIPA
Configure IPv6 network settings - configuring name resolution; Connect to a network; set up a connection to a network; resolve connectivity issues; link local multicast name resolution
Configure networking settings - adding physically connected (wired) or wireless device; connecting to a wireless network; configuring security settings on the client; set preferred wireless networks configuring network adapters; configuring location - aware printing.
Configure network adapters; configure rules for multiple profiles; Allow or deny an application; implement network specific rules; configure notifications; configure authenticated exceptions.
Configure remote management - remote management methods; configure remote management tools; execute power shell commands.
Configure shared resources - folder visualization; shared folder permissions; printers and queues; configuring home group settings
Configure file and folder access - encrypting files and folders by using EFS; configuring NTFS permissions; resolving effective permissions issues; copying files Vs. moving files
Configure user account to control (UAC) configuring local security policy; configuring admin Vs. standard UAC prompt behaviors; configuring secure desktop.
Configure authentication and authorization - resolving authentication issues; configuring rights; managing credentials; managing certificates; smart cards with PIV; elevating user privileges; multi-factor authentication.

Course Duration: 36 Hours

Microsoft Exam 70 620

This course covers how to install, upgrade, and configure the Windows Vista operating system as well as how to support end-users with network connectivity, security, application, installation and compatibility issues and log-on problems that include account issues and password resets. Course Objectives This course will cover the following elements:

Installing and upgrading Windows Vista
Configuring and troubleshooting post-installing system settings
Configuring Windows security features
Configuring network connectivity
Configuring applications included with Windows Vista
Maintaining and optimization systems that run Windows Vista
Configuring and troubleshooting mobile computer

Course Benefits Will have knowledge and skills required to deploy and support the Windows Vista operating system. Will assist administrators with the day-to-day operations management of Windows server 2008. Course Duration: 40 hours

Microsoft Exam 70 640

Microsoft Certified Technology Specialist (MCTS) certification is recognized internationally as the best method to demonstrate your knowledge of Microsoft technologies. IN this course you will gain key Active Directory configuration and administration knowledge to prepare for the Microsoft Exam.

Course Objectives

This course will cover the following elements:

Domain name system (DNS) for active directory
Active directory infrastructure
Active directory server roles
Creating and maintaining active directory objects
Maintaining the active directory environment
Configuring active directory certificate services

Course Benefits

Upon successful completion of this course the student will be able to:

Build a domain structure
Implement users, groups, and organization units (OUs)
Assemble domains into forest
Identify updated features
Deploy and analyze the AD using server manager
Automate administration via PowerShell cmdlets
Implementing a domain or forest
Setting up a domain controller
Raise the forest and domain functionality level
Simplify logins through multiple User Principal Names (UPs)
Optimize global catalog
Place operations masters on an appropriate server
Connect domains and forests with appropriate trusts
Define site subnets
Minimize network traffic with bridgehead servers
Schedule and trigger manual replication
Monitor topologies with RepIMon
Create Zones
Support forward and reverse lookups
Secure records
Scavenge stale records
Fine tune the DNS server
Forward DNS queries
Delegate zones
Limit zone transfers and replication
Restrict replication scope
Facilitate incremental zone transfers
Create application directory partitions
Install AD certificate services
Determine the appropriate deployment model
Back up the servers private key
Manage certificates
Roll out and secure templates
Revoke certificates
Configure active directory roles and services
Design an LDS instance
Mount and view snapshots
Enable self-enrollment
Delegate administrative responsibility
Implement read-only domain controller (RODC)
Secure server features
How to cache credentials
Utilize active directory federation services (ADFS)
Exchange certificates with agents
Create federation trust
Create and maintain AD objects
Optimize security principals
Automate account creation
Manage service accounts
Develop fine-grained password policies
Leverage group policy objects (GPO)
Target GPO settings
Publish and assign software
Specify allowable applications with AppLocker
Maintain the active directory environment
Backup and recover AD objects
Enable the AD recycle bin
Restart AD services
Monitor the active directory
Centralize even logs through subscriptions
Run AD services

Course Duration: 40 hours

Microsoft Exam 70 642

Windows Server 2008 Network Infrastructure Configuration training course covers network and application infrastructure concepts and configurations provided by Windows Server 2008. Learn how to configure and troubleshoot a Windows Server 2008 network infrastructure and to secure servers and maintain update compliance. Upon completion of this course you will acquire a fundamental understanding of Windows Server 2008 to pursue advanced topics for certification in the network and applications infrastructure areas.

Course Objectives

This course covers the following elements:

Configuring IP addressing and services
Configuring name resolution
Configuring network access
Configuring file and print services
Monitoring and managing network infrastructure

Course Benefits

Upon successful completion of this course you will be able to:

Network and applications infrastructure concepts and configurations provided by Windows Server 2008
Configure and troubleshoot a Windows Server 2008 network infrastructure
Secure servers and maintain update compliance
Configure IPv4 and IPv6 addressing
Configure dynamic host configuration protocol (DHCP)
Configure routing
Configure IPsec
Configure a domain name system (DNS) server
Configure DNS zones
Configure DNS records
Configure DNS replication
Configure name resolution for client computers
Configure remote access
Configure network access protection (NAP)
Configure network authentication
Configure wireless access
Configure firewall settings
Configure a file server
Configure distributed file system (DFS)
Configure shadow copy services
Configure backup and restore
Manage disk quotas
Configure and monitor print services
configure windows server update services (WSUS) server settings
Capture performance data
Monitor event logs
Gather network data

Course Duration: 40 hours

Microsoft Exam 70 643

This course covers common tasks required to administer and support Microsoft Windows Server 2008 applications infrastructure in a network environment including deploying servers, configuring terminal services, configuring a web services infrastructure, configuring network application services. Course Objectives The course covers the following elements:

Deploying servers
Configuring terminal services
Configuring a web services infrastructure
Configuring Network Application Services

Course Benefits Upon successful completion of this course you will be able to:

Deploy images by using Windows deployment services
Configure Microsoft Windows activation
Configure Windows Server hyper-V and virtual machines
configure high availability
Configure storage
Configure Windows Server 2008 terminal services RemoteApps (TS RemoteApp)
Configure terminal services gateway
Configure terminal services gateway
Configure terminal services load balancing
Configure and monitor terminal services resources
Configure terminal services licensing
Configure terminal services client connections
Configure terminal services server options
Configure web applications
Manage web sites
Configure a file transfer protocol (FTP) server
Configure simple mail transfer protocol (SMTP)
Manage internet information services (IIS)
Configure web site authentication and permissions
Configure Windows media server
Configure digital rights management (DRM)
Configure Microsoft Windows SharePoint Services server options
Configure Windows SharePoint Services e-mail integration

Course Duration: 40 hours

Microsoft Exam 70 647

The enterprise administrator is responsible for the overall Windows Server 2008 environment and architecture. The enterprise administrator translates business goals into technology designs mid-range to long-term strategies. Enterprise administrators also make key decisions and recommendations in the areas listed below.

Course Objectives

The course will cover the following elements:

Planning network and application services
Designing core identity and access management components
Designing support identity and access management components
Designing for business continuity and data availability

Course Benefits

Upon successful completion of this course you will be able to:

Plan for name resolution and IP addressing
Design for network access
Plan for application delivery
Plan for terminal services
Design active directory forests and domains
Design the active directory physical topology
Design the active directory administrative model
Design the enterprise-level group policy strategy
Plan for domain or forest migration, upgrade and restructuring
Design the branch office deployment
Design and implement public key infrastructure
Plan for interoperability
Plan for business continuity
Design for business continuity
Design for software updates and compliance management
Design the operating system visualization strategy
Design for data management and data access.

Course Duration: 40 hours

MCSA 2012 Server Infrastructure

Administering Windows Server 2012 Exam 411

This exam is part two, of a series of three exams, which validate the skills and knowledge necessary to administer a Windows Server 2012 Infrastructure in an enterprise environment. This exam will validate the administration tasks necessary to maintain a Windows Server 2012 infrastructure, such as user and group management, network access, and data security. This exam along with the other two exams will collectively validate the skills and knowledge necessary for implementing, managing, maintaining, and provisioning services and infrastructure in a Windows Server 2012 environment.

Course Objectives

Implementing a Group Policy Infrastructure
Managing User and Service Accounts
Maintaining Active Directory Domain Services
Configure and Troubleshoot DNS
Configure and Troubleshoot Remote Access
Installing, Configuring, and Troubleshooting the Network Policy Server role
Optimizing File Services
Increasing File System Security
Implementing Update Management

Prerequisites

Candidates for this exam are Information Technology (IT) Professionals who have Windows Server 2012 operating system knowledge and experience and want to validate the skills and knowledge necessary to administer a Windows Server 2012 infrastructure.

Course Track

Deploy, Manage, and Maintain Servers
Configure File and Print Services
Configure Network Services and Access
Configure a Network Policy Server Infrastructure
Configure and Manage Active Directory
Configure and Manage Group Policy

Course Benefits

This exam is part two, of a series of three exams, which validate the skills and knowledge necessary to administer a Windows Server 2012 Infrastructure in an enterprise environment. This exam will validate the administration tasks necessary to maintain a Windows Server 2012 infrastructure, such as user and group management, network access and data security. This exam along with the other two exams will collectively validate the skills and knowledge necessary for implementing, managing, maintaining and provisioning services and infrastructure in a Windows Server 2012 environment

Course Duration

6 weeks or 40 hours Lecture and Lab

Course Guide

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 limited to: Install the FSRM role; configure quotas; configure file screens; configure reports
Configure file and disk encryption.: This objective may include but is not limited to: Configure Bitlocker encryption; configure the Network Unlock feature; configure Bitlocker policies; configure the EFS recovery agent; manage EFS and Bitlocker certificates including backup and restore
Configure advanced audit policies.: This objective may include but is not limited to: Implement auditing using Group Policy and AuditPol.exe; create expression-based audit policies; create removable device audit policies

Configure Network Services and Access (17%)

Configure DNS zones.: This objective may include but is not limited to: Configure primary and secondary zones; configure stub zones; configure conditional forwards; configure zone and conditional forward storage in Active Directory; configure zone delegation; configure zone transfer settings; configure notify settings
Configure DNS records.: This objective may include but is not limited to: Create and configure DNS Resource Records (RR) including A, AAAA, PTR, SOA, NS, SRV, CNAME, and MX records; configure zone scavenging; configure record options including Time To Live (TTL) and weight; configure round robin; configure secure dynamic updates
Configure VPN and routing.: This objective may include but is not limited to: Install and configure the Remote Access role; implement Network Address Translation (NAT); configure VPN settings; configure remote dial-in settings for users; configure routing
Configure DirectAccess.: This objective may include but is not limited to: Implement server requirements; implement client configuration; configure DNS for Direct Access; configure certificates for Direct Access

Configure a Network Policy Server Infrastructure (14%)

Configure Network Policy Server (NPS).: This objective may include but is not limited to: Configure multiple RADIUS server infrastructures; configure RADIUS clients; manage RADIUS templates; configure RADIUS accounting; configure certificates
Configure NPS policies.: This objective may include but is not limited to: Configure connection request policies; configure network policies for VPN clients (multilink and bandwidth allocation, IP filters, encryption, IP addressing); manage NPS templates; import and export NPS policies
Configure Network Access Protection (NAP).: This objective may include but is not limited to: Configure System Health Validators (SHVs); configure health policies; configure NAP enforcement using DHCP and VPN; configure isolation and remediation of non-compliant computers using DHCP and VPN; configure NAP client settings

Configure and Manage Active Directory (19%)

Configure service authentication.: This objective may include but is not limited to: Create and configure Service Accounts; create and configure Group Managed Service Accounts; create and configure Managed Service Accounts; configure Kerberos delegation; manage Service Principal Names (SPNs)
Configure Domain Controllers.: This objective may include but is not limited to: Configure Universal Group Membership Caching (UGMC); transfer and seize operations masters; install and configure a read-only domain controller (RODC); configure Domain Controller cloning
Maintain Active Directory.: This objective may include but is not limited to: Back up Active Directory and SYSVOL; manage Active Directory offline; optimize an Active Directory database; clean up metadata; configure Active Directory snapshots; perform object- and container-level recovery; perform Active Directory restore
Configure account policies.: This objective may include but is not limited to: Configure domain user password policy; configure and apply Password Settings Objects (PSOs); delegate password settings management; configure local user password policy; configure account lockout settings

Configure and Manage Group Policy (18%)

Configure Group Policy processing.: This objective may include but is not limited to: Configure processing order and precedence; configure blocking of inheritance; configure enforced policies; configure security filtering and WMI filtering; configure loopback processing; configure and manage slow-link processing; configure client-side extension (CSE) behavior
Configure Group Policy settings.: This objective may include but is not limited to: Configure settings including software installation, folder redirection, scripts, and administrative template settings; import security templates; import custom administrative template file; convert administrative templates using ADMX Migrator; configure property filters for administrative templates
Manage Group Policy objects (GPOs).: This objective may include but is not limited to: Back up, import, copy, and restore GPOs; create and configure Migration Table; reset default GPOs; delegate Group Policy management
Configure Group Policy preferences.: This objective may include but is not limited to: Configure Group Policy Preferences (GPP) settings including printers, network drive mappings, power options, custom registry settings, Control Panel settings, Internet Explorer settings, file and folder deployment, and shortcut deployment; configure item-level targeting

Installing Configuring Windows Server 2012 Exam410

This exam is part one of a series of three exams, which validate the skills and knowledge necessary to implement a core Windows Server 2012 Infrastructure into an existing enterprise environment. This exam will validate the initial implementation and configuration of the Windows Server 2012 core services, such as Active Directory and the networking services. This exam along with the remaining two exams will collectively validate the skills and knowledge necessary for implementing, managing, maintaining, and provisioning services and infrastructure in a Windows Server 2012 environment.

Course Objectives

Installing and Configuring Windows Server 2012
Introduction to Active Directory Domain Services
Managing Active Directory Domain Services Objects
Automating Active Directory Domain Services Administration
Implementing Networking Services
Implementing Local Storage
Implementing File and Print Services
Implementing Group Policy
Implementing Server Virtualization with Hyper-V

Prerequisites

CompTia A+ Certification

MCSA Windows Server 2008
Knowledge of Network Fundamentals

Course Track

Install and Configure Servers
Configure Server Roles and Features
Configure Hyper-V
Deploy and Configure Core Network Services
Install and Administer Active Directory
Create and Manage Group Policy
Create and Manage Group Policy

Course Benefits

Course Duration

6 Weeks or 40 Hours including Lecture and Hands-on Lab
32 Hours of Practicum

Course Guide

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

MCTS Windows Developer Using Visual Studio 2005

MCPD Exam 70 526

This instructor-led workshop provides students with the knowledge and skills to develop Microsoft Windows Forms applications using Microsoft Visual Studio 2005. The workshop focuses on user interfaces, program structure, and implementation details.

Course Objectives

Developing applications that use system types and collections.
Implementing service processes, threading, and application domains in a .NET Framework application.
Embedding configuration, diagnostic, management, and installation features into a .NET Framework application.
Implementing serialization and input/output functionality in a .NET Framework application.
Improving the security of the .NET Framework applications by using the .NET Framework 2.0 security features.
Implementing interoperability, reflection, and mailing functionality in a .NET Framework application.
Implementing globalization, drawing, and text manipulation functionality in a .NET Framework application.

Course Benefits

After completing this class, students will be able to:

Create a simple Windows Forms application.
Configure standard controls.
Build menus.
Display and edit data by using data-bound controls.
Provide user assistance and enhance usability.
Create consistent applications by using dialogs and forms inheritance.
Add print and report functionality to a Windows Forms application.
Perform asynchronous tasks by using the BackgroundWorker component.
Deploy a Windows Forms application by using ClickOnce.

Course Duration: 40 hours

MCPD Exam 70 548

Candidates for this class work on a team in a medium or large development environment that uses Microsoft Visual Studio .NET 2003 Enterprise Developer or Visual Studio 2005. Candidates should have at least two years of experience developing Microsoft Windows-based applications by using the Microsoft .NET Framework. Candidates should have a working knowledge of Visual Studio 2005.

Course Objectives

Developing applications that use system types and collections.
Implementing service processes, threading, and application domains in a .NET Framework application.
Embedding configuration, diagnostic, management, and installation features into a .NET Framework application.
Implementing serialization and input/output functionality in a .NET Framework application.
Improving the security of the .NET Framework applications by using the .NET Framework 2.0 security features.
Implementing interoperability, reflection, and mailing functionality in a .NET Framework application.
Implementing globalization, drawing, and text manipulation functionality in a .NET Framework application.

Prerequisites

Candidates should have at least three to four years of on-the-job experience dedicated to Windows-based application development and should have worked in the following phases of the application life cycle:

Technical envisioning and planning
Design and development
Stabilizing and releasing

Course Benefits

After completing this class, students will be able to:

Envisioning and Designing an Application
Designing and Developing a User Interface
Designing and Developing a Component
Designing and Developing an Application Framework
Testing and Stabilizing an Application
Deploying and Supporting an Application

Course Duration: 40 hours

Microsoft Certification

Designing Data Tier For Microsoft SQL Server 2005

This course provides students with the knowledge and skills to design the data tier for Microsoft SQL Server 2005. The class focuses on teaching database developers working in enterprise environments to understand and decide how application developers are going to access and consume their data. This is a major failure point of database solutions today.

Course Objectives

This course will cover the following elements:

Choose data access technologies and an object model to support an organization's business needs
Design query strategies using multiple active result sets (MARS)
Design caching strategies for database applications
Design a scalable data tier for database applications

Prerequisites

To ensure your success before students attend this course should:

Have experience reading user requirements and business-need documents
Have basic knowledge of the Microsoft .NET framework, .NET concepts, ADO.NET and services oriented architecture (SOA)
Be familiar with the tasks that application developers typically perform
Understand transact-SQL syntax and programming logic
Have experience with professional-level database database design and know the trade offs when backing out of the fully normalized design (denormalization) and designing for performance and business requirements, in addition to being familiar with design models such as Star and Snowflake schemas
Have basic monitoring and troubleshooting skills.
Know how to use SQL Profiler and dynamic management views
Have basic knowledge of the operating system and platform
Know how the operating system integrates with the database
Know what the platform or operating system can do, and how interacting between the operating system and the database works
Have basic knowledge of application architecture
Know how applications can be designed in three layers
Know how the interaction between applications and database works
Know how to use a data modeling tool
Be familiar with SQL Server 2005 features, tools and technologies
Have a Microsoft Certified Technology Specialist: Microsoft SQL Server 2005 credential or equivalent experience

In addition it is recommended that students have knowledge of the following;

Writing Queries using Microsoft SQL Server 2005 Transact-SQL
Implementing a Microsoft SQL Server 2005 Database
Maintaining a Microsoft SQL Server 2005 Database

Course Benefits

Upon successful completion of this course students will be able to:

Describe a typical database system and the role that data technologies play in that system
Select appropriate technologies for accessing data stored in SQL Server 2005
Explain how build a data access layer
Explain how to design SQL Server objects that use the In-Process data provider
Describe the data object models for administering SQL Server 2005 components and objects
Describe the various types of exceptions that can be detected in a SQL Server 2005 system and how they affect applications and users
Design strategies to detect exceptions at the appropriate layer
Design strategies to log and communicate exceptions according to business requirements
Explain when cursors are appropriate and when they are not
Explain the considerations for selecting server-side cursors
Explain the considerations for selecting client-side cursors
Explain why MARS is useful, as compared to the set-based execution of Microsoft SQL Server 2000
Explain when multiple simultaneous reads can be beneficial for an application and explain the implications of using this technique
Explain why caching data outside of SQL Server works and how to manage conflicts that these technologies might produce
Explain the various ways to cache frequently used data, objects and results in the appropriate tier to improve performance
Identify when to scale database applications and what layer to scale
Select an appropriate technology to avoid concurrency problems and to improve applications performance
Evaluate whether scaling out or scaling up is appropriate of the scalability requirements of your database system
Explain how to improve middle tier processing by using multiple instances of Web services and object pooling
Explain how to improve response time and availability by scaling out front-end systems

Course Duration: 40 Hours

Designing Managing Windows 2003 Directory

EXAM 70-294

This course provides students with the knowledge and skills to successfully plan, implement, and troubleshoot a Microsoft Windows Server™ 2003 Active Directory® directory service infrastructure. The course focuses on a Windows Server 2003 directory service environment, including forest and domain structure, Domain Name System (DNS), site topology and replication, organizational unit structure and delegation of administration, Group Policy, and user, group, and computer account strategies.

Course Objectives

This course will cover the following elements:

Describe the logical and physical components of Active Directory
Create and configure a forest and domain structure by using an Active Directory infrastructure design
Plan and implement an organization unit structure
Plan and an implement an organizational unit structure
Plan and implement an organizational unit structure
Plan and implement Active Directory strategy to centrally manage users and computers in an enterprise
Deploy, manage, and troubleshoot software that is deployed using Group Policy
Implement sites to manage and monitor Active Directory replication
Plan and implement the placement of domain controllers, global catalog servers and DNS servers that are integrated with Active Directory
Plan and manage operations manage masters
Back up, restore, and maintain Active Directory
Plan and implement an Active Directory infrastructure that is based on a directory service design that an enterprise architect provides

Prerequisites

None.

Course Benefits

Upon successful completion the student will be able to:

Understand the Active Directory Infrastructure
Understand the architecture of Active Directory
Understand how Active Directory works
Examine Active Directory
Understand the Active Directory design, planning and implementation process
Implement an Active Directory Forest and Domain Structure
Create a forest and domain structure
Examine and configure Active Directory integrated DNS
Raise forest and domain functional levels
Create trust relationships
Secure trusts using SID filtering
Implement an Organizational Unit Structure
Manage organizational units
Delegate administration control for organizational units
Plan an organizational unit strategy
Implement User, Group and Computer Accounts
Understand accounts
Create and manage multiple accounts
Implement user principals name suffixes
Move objects in Active Directory
Plan an account strategy
Plan an Active Directory audit strategy
Implement group policy
Create and configure group policy objects (GPOs)
Configure when group police is applied
Manage GPOs
Verify and troubleshoot group policy
Delegate administrative control group policy
Plan a group policy strategy for the enterprise
Deploy and manage software by using group policy
Overview of managing software deployment
Deploy software
Configure software deployment
Maintain software deployment
Troubleshoot software deployment
Plan a software deployment strategy
Implement sites to manage Active Directory replication
Overview Active Directory replication
Create and configure sites
Manage site topology
Troubleshoot replication failures
Plan a site
Implement placement of domain controllers
Implement the global catalog in Active Directory
Determining the placement of domain controllers in Active Directory
Plan the placement of domain controllers
Mange operations masters
Overview of operations masters roles
Transfer and seizing operations master roles
Plan the placement of domain controllers
Maintaining Active Directory availability
Overview of Active Directory maintenance
Move and defrag the Active Directory database
Back up Active Directory
Restore Active Directory
Plan for monitoring Active Directory
Plan and implement an Active Directory infrastructure
Create the Active Directory implementation plan for Tailspin Toys
Implement the Active Directory infrastructure for Tailspin Toys

Course Duration: 40 Hours

Designing Microsoft SQL Server 2005 Databases

This course provides students with the knowledge and skills to design databases for Microsoft SQL ServerT 2005 using business requirements to guide their decisions (beyond structured third normal form [3NF] modeling techniques). Students will also learn to incorporate security requirements throughout their design.

Course Objectives

This course will cover the following elements:

Database design from a systematic perspective, gathering database requirements and formulating a conceptual design
Analyze and evaluate a logical database design
Apply best practices for creating a physical database design
Apply best practices when designing for database scalability
Design a database access strategy
Use best practices to model database dependencies

Prerequisites

To ensure your success before students attend this course should:

Have experience reading users requirements and business-need documents
Have experience reading mission statements or business analysis reports
Have experience reading and drawing business process flow charts
Have experience reading and drawing entity relationship (ER) diagrams
Understand transact-SQL syntax and programming logic
Be able to design a database to 3NF and know the trade offs when backing out of the fully normalized design
Be able to design a database to 3NF an know the trade offs when backing out the fully normalized design (denormalization) and designing for performance and business requirements in addition to being familiar with design models, such as Star and Snowflake schema
Have basic knowledge of the operating system and platform.
Understand how the operating system integrates with the database, what the platform or operating system is capable of
Understand how interaction between the operating system and the database works
Have basic knowledge of application architecture works
How applications can be designed in three layers, what applications can do, how interaction between the application and the database works
Understand how the interaction between the database and the platform or operating system works
Know how to use a data modeling tool
Be familiar with SQL Server 2005 features, tools and technologies
Have a Microsoft Certified Technology Specialist: Microsoft SQL Server 2005 credential or equivalent experience

In addition it is recommended that the student have knowledge of the following:

Writing Queries using Microsoft SQL Server 2005 Transact-SQL
Implementing a Microsoft SQL Server 2005 Database
Maintaining a Microsoft SQL Server 2005 Database

Course Benefits

Upon successful completion a student will be able to:

Overview database design
Gather database requirements
Create conceptual database design
Apply a systematic approach to database design
Devise an appropriate strategy for gathering database requirements for specified project
Formulate requirements into a conceptual model that serves as a basis for defining entities, attributes and relationships
Build a logical database model
Design for OLTP activity
Design for data warehousing
Evaluate logical models
Apply best practices to the task of building a new logical database model
Apply guidelines for normalization when designing an OLTP model
Apply guidelines for designing a database warehouse database
Evaluate an existing logical model of a database
Apply guidelines for designing physical database objects
Apply best practices when designing constraints
Include security best practices in the design of databases
Apply best practices when designing database and server options
Apply best practices when evaluating the physical model
Apply best practices for designing indexes
Apply guidelines when planning for table optimization
Apply guidelines in choosing additional optimization techniques
Apply best practices when designing for secure data access
Apply guidelines for designing user-defined functions
Apply best practices for designing stored procedures
Apply guidelines for modeling local database dependencies
Apply guidelines for modeling remote database dependencies

Course Duration: 40 Hours

Designing Security For Windows Server 2003

This course provides you with the knowledge and skills to design a secure network infrastructure. Topics include assembling the design team, modelling threats, and analyzing security risks in order to meet business requirements for securing computers in a networked environment.

Course Objectives

The following elements will be covered in this course:

Plan a framework for network security
Identify threats to network security
Analyze security risks
Design security for physical resources
Design security for computers
Design security accounts and services
Design security for authentication
Design security for data
Design security for data transmission
Design security for network perimeters
Design security for network perimeters
Design an incident response procedure
In addition, this course contains three teachable appendices that cover:
- Design an acceptable use policy
- Designing policies for managing networks
- Designing an operations framework for managing security

Prerequisites

None.

Course Benefits

Upon successful completion students will be able to:

Describe common elements of security policies and procedures
Create a security design framework by using the MSF process model
Create a security design team
Explain common network vulnerabilities and how attackers can exploit them
Predict threats to security by using a threat model
Explain the purpose and operations of risk management
Create a risk management plan
Create a plan for physical security
Create a design for physical security of network resources
Create a security plan for network hosts
Create a design for the security of network hosts
Create a security plan for accounts
Create a security plan for services
Create a design for security of accounts and services
Create a security plan for authentication
Create a security plan for data
Create a design for security data
Create a security plan for data transmission
Create a design for security of data transmission
Create a security plan for data transmission
Create a design for security of data transmission
Create a security plan for the perimeter of a network
Create a design for security of network perimeters
Describe auditing and incident response
Design and audit policy
Design an incident response procedure
Analyze risks that users introduce
Design an incident response procedure
Analyze risks to managing networks
Design security for managing networks
Analyze risks to ongoing network operations
Designing a framework for ongoing network operations

Course Duration: 40 Hours

Implementing Windows 2003 Network Infrastructure

This course will provide students with the knowledge and skills necessary to plan and maintain a Windows® Server 2003 network infrastructure.

Course Objectives

This course will cover the following elements:

Describe the transmission control protocol / internet protocol (TCP / IP) protocol architecture
Convert internet protocol (IP) address between decimal and binary
Calculate a subnet mask
Create subnets using variable length subnet mask (VLSM) and classless inter domain routing (CIDR)
Configure a host to use a static IP address
Assign IP address in a multiple subnet network
Describe the IP routing process
Configure a host to obtain an IP address automatically
Configure a host so that automatic private IP address configuration is disabled
Configure a host to use name servers
Isolate common connectivity issues

Prerequisites

None.

Course Benefits

Upon successful completion a student will be able to:

Describe the architecture of the OSI reference model and the function of each layer
Describe the four layers of the TCP / IP protocol sutie
Capture and view frames by using Network Monitor
Explain how to configure IP addressing for simple TCP / IP networks
Explain how to configure IP addressing for complex TCP / IP networks
Describe routing protocols and how they are used
Overcome limitations that are caused by class-based routing
Configure a client to use static IP address
Configure a client to obtain an IP address automatically by using DHCP
Configure a client to obtain an IP address automatically by using Alternate Configuration
Describe how name resolution occurs
Describe how host names are used and resolved
Describe how NetBIOS names are used and resolved
Determine the causes of connectivity issues
Describe utilities and tools to resolve connectivity issues
Describe the client startup communication process

Course Duration: 40 Hours

Installing And Configuring Windows Server 2003

This course provides students with the knowledge and skills that are needed to manage Microsoft Windows XP Professional and Windows 7 computers in a Microsoft Windows Server 2003 environment.

Course Objectives

This course will cover the following elements:

Install and configure Windows 2003 Server
Design a Windows 2003 Server Active Directory Forest
Install and configure server hardware devices
Troubleshoot server hardware devices
Monitor server hardware
Mange storage

Prerequisites

None.

Course Benefits

Upon successful completion of this course students will be able to:

Install and configure different versions and editions of Windows Server
Compare different editions of Windows Server
Overview installation and server roles
Understand the basics of active directory
Understand domains, trees and forests
Organizational units (OUs)
Understand group policy and delegation
Install hardware, devices and drivers
Define devices and drivers
Utilize device manager
Understand driver query
Utilize driver signing options
Identify unsigned device drivers
Configure hardware, devices and drivers
Update drivers
Roll back drivers
Uninstall drivers
Understand resource configuration
Disable and enable devices
Troubleshoot hardware devices and drivers
Recover from device disaster
Device manager status codes
Diagnose and resolve hardware settings issues
Diagnose and resolve server hardware issues
Diagnose and resolve hardware driver upgrades issues
Understand disk storage options
Understand the types of disks
Understand mounted volumes
Understand fault tolerance
Understand separation of data
Understand basic versus dynamic
Configure disks and volumes
Look at the disk manager
Configure disks and volumes
Manage disks and volumes
Manage disks and volumes from the command prompt
Implement Raid
Implement disk fault tolerance
Implement striped volumes
Implement mirrored volumes
Implement 5 volumes
Recover from failure
Use even viewer
Use logs available in the even viewer
Utilize other logs
Configure the even viewer logs

Course Duration: 40 Hours

Installing And Managing 2003 Exchange Server

This course provides students with the knowledge and skills that are needed to update and support a reliable, secure messaging infrastructure. This infrastructure is used for creating, storing, and sharing information by using Microsoft Exchange Server 2003 in a medium-sized to large-sized (250 to 5,000 seats) messaging environment.

Course Objectives

This course will cover the following elements:

Perform an installation of Exchange Server 2003 and verify that the installation was successful
Configure and manage Exchange Server 2003
Secure Exchange Server 2003
Manage recipients
Manage address lists
Implement and manage access to Exchange Server mailboxes for internet protocol clients
Manage client configuration and connectivity
Mange routing
Mange mobile devices with Exchange Server 2003
Manage data storage and hardware resources
Plan for disaster and disaster recovery
Backup and restore Exchange Server
Perform preventive maintenance
Migrate users from Exchange Server 5.5 to separate Exchange Server 2003 organization

Prerequisites

None.

Course Benefits

Upon successful completion the student will be able to:

Describe the various technologies that are involved in implementing and maintaining an Exchange Server messaging environment
Identify the client applications that are used to connect to Exchange Server and describe the improvements introduced with Microsoft Office Outlook 2003
Prepare to install Exchange Server 2003
Exchange Server 2003 installation tasks
Explore the exchange management tools
Apply a security configuration wizard security policy
Reduce the attack surface on Exchange Servers
Configure Exchange Server 2003 to reduce the amount of unsolicited commercial email and spam
Configure an administrative group structure
Describe Exchange Server recipients and explain the messaging capability of various active directory groups
Manage mailboxes
Manage mail-enabled groups
Explain where and how active directory stores Exchange Server related information
Manage the communication mechanisms that exist between Exchange Servers and active directory domain controllers
Create and manage recipient policies and the recipient update process
Create and manage address lists
Mange public folder data
Manage network and user access to public folders
Manage public folder replication
Configure full text indexing
Describe the features of Outlook Web Access (OWA) in Exchange Server 2003
Secure an Outlook Web Access deployment
Explain the purpose of font-end and back end-servers and describe their supporting technologies
Implement a front-end and back-end server topology
Secure a front-end and back-end server topology
Select the appropriate Exchange Server client for messaging environment
Connect Outlook 2003 to an Exchange Server securely from the internet
Secure Exchange Server email content by suing secure / multipurpose internet mail extensions (S / MIME)
Implement and manage remote mobile access to Exchange Server 2003
Explain message flow in Exchange Server 2003
Configure SMTP virtual server settings by using the exchange system manager
Explain how message routing works in an Exchange Server organization
Explain how Exchange Server maintains routing information
Create, delete and manage stores and storage groups
Manipulate all files used in the data storage process
Manage disk spaces used by Exchange Server databases
Optimize the use of hardware resources on Exchange Servers
Create a plan for disaster recovery in an Exchange Server environment
Back up severs running Exchange Server 2003
Restore Exchange Server 2003 data
Restore Exchange Server 2003 server
Perform daily Exchange Server maintenance
Perform scheduled Exchange Server 2003 maintenance
Perform on demand Exchange Server 2003 maintenance
Select the appropriate migration strategy
Perform all necessary pre-migration steps
Migrate mailboxes and public folders to Exchange Server 2003

Course Duration: 40 hours

Maintaining A Microsoft SQL Server 2005 Database

Certification 70-431

This course provides students with product knowledge and skills needed to maintain a Microsoft SQL ServerT 2005 database. This course focuses on teaching individuals how to use SQL Server 2005 product features and tools related to maintaining a database.

Course Objectives

This course will cover the following elements:

Install and configure SQL Server 2005
Manage database files
Backup and restore databases
Mange security
Monitor SQL Server
Transfer data into and out of SQL Server
Automate administrative tasks
Replicate data between SQL Server instances
Maintain high availability

Prerequisites

To ensure your success before students attend this course should:

Basic knowledge of the Microsoft Windows operating system and its core functionality
Working knowledge of Transact-SQL
Working knowledge of relational databases
Some experience with database design

Course Benefits

Upon success full completion the student will be able to:

Explain how to prepare the hardware and other resources necessary to install SQL Server 2005
Install SQL Server 2005
Mange and configure a SQL Server 2005 installation
Plan how to implement a database that meets an organizations requirements
Create a SQL Server database
Mange a SQL Server database
Plan a backup strategy for a database
Back up users databases
Restore users databases from backups
Restore data in a user database while it is online
Recover data for user database from database snapshot
Restore and recover systems databases
Describe how SQL Server manages security
Protect SQL Server databases
Use keys and certificates to protect SQL Server objects
Examine the current activity in a SQL Server instance
Use system monitor to obtain performance data about your computer and the instances of SQL Server running on your computer
Use SQL Server profiler to trace server database activity
Implement DDl triggers that enable you to audit changers to the structure of database objects
Use event notifications to capture and monitor significant events for SQL Server instance
Describe the problems surrounding data transfer and the tools that SQL Server 2005 provides to perform data transfer
Describe the purpose of SQL Server integration services
Use SQL Server integration services to transfer data into a SQL Server database
Describe the features of SQL Server integration services
Define SQL Server 2005 administrative tasks and schedule these tasks to run automatically
Configure SQL Server agent to support automatic task scheduling
Script tasks by using SQL Server jobs, and define operators for managing these jobs
Define alerts to warn operators about events raised by SQL Server
Define and manage administrative tasks that span multiple servers
Describe replication and its components
Configure and implement replication
Use replication to meet the requirements of some common scenarios
Describe the factors affecting database availability
Explain how to implement clustering to support fast fail-over of computers running Microsoft SQL Server instances
describe how to use SQL Server mirroring to implement a software solution for fast-failover
Describe how to implement log shipping to support fast recovery of a standby SQL Server database
Explain how to use peer-to-peer replication to implement high availability in a distributed environment

Course Duration: 40 Hours

Windows XP Professional

This course offers the basic fundamentals to operate Windows XP operating system.

Course Objectives

This course will cover the following elements:
Plan and perform an installation of Windows XP Professional
Install and support hardware devices and drivers on computers running Windows XP Professional
Identify and resolve boot process issues on computers running Windows XP Professional
Configure desktop settings for computers running Windows XP
Configure security settings for Microsoft Internet Explorer and application application compatibility for computers running Windows XP Professional
Configure computers to run Windows XP Professional in a Windows networking environment
Configure and support computers running Windows XP Professional for mobile computing

Prerequisites

None.

Course Benefits

Upon successful completion the student will be able to: Comfortably use the utilities and features offered on Windows XP Professional operating system.

Course Duration: 40 hours

Microsoft IT Certification

Enterprise Messaging Administrator 2007

When you earn the MCITP: Enterprise Messaging Administrator certification, you demonstrate your professional expertise in using Microsoft Exchange Server 2007 to excel in a specific job role. This certification helps validate the knowledge and skills that are associated with performing as the lead engineer for messaging solutions within an enterprise organization, as well as the ability to design and deploy messaging solutions with Exchange Server 2007. To achieve the MCITP: Enterprise Messaging Administrator certification, you must successfully complete three exams: one Microsoft Certified Technology Specialist (TS) on Microsoft Exchange Server 2007 prerequisite exam and two Professional Series (PRO) exams.

Required Exams

Exam 70-236 TS: Exchange Server 2007, Configuring Exam 70-237 PRO: Designing Messaging Solutions with Microsoft Exchange Server 2007 Exam 70-238 PRO: Deploying Messaging Solutions with Microsoft Exchange Server 2007

Enterprise Messaging Administrator 2010

When you earn the MCITP: Enterprise Messaging Administrator certification, you demonstrate your professional expertise in using Microsoft Exchange Server 2010 to excel in a specific job role. This certification helps validate the knowledge and skills that are associated with performing as the lead engineer for messaging solutions within an enterprise organization, as well as the ability to design and deploy messaging solutions with Exchange Server 2010. To achieve the MCITP: Enterprise Messaging Administrator certification, you must successfully complete two exams: one Microsoft Certified Technology Specialist (TS) on Microsoft Exchange Server 2010 prerequisite exam and one Professional Series (PRO) exam.

Required Exams

Exam 70-662 TS: Microsoft Exchange Server 2010, Configuring Exam 70-663 PRO: Designing and Deploying Messaging Solutions with Microsoft Exchange Server 2010 Note This certification will be retired when Microsoft discontinues mainstream support for the related technology.

Microsoft Exam 70 236

This instructor-led course offers Microsoft Exchange 2000 Server or Microsoft Exchange Server 2003 administrators with the skills they need to manage a Microsoft Exchange Server 2007 infrastructure. This course focuses on the new features and administrative tasks in Exchange Server 2007. The student will learn skills that enable them to deploy and manage an Exchange Server 2007 environment. This course's aim is not to provide detailed design skills, but will cover planning skills at a level sufficient to enable decision making during the implementation process.

Course Objectives

This course will cover the following elements:

Installing Exchange Server 2007
Configuring the mailbox and hub transport roles
Configuring connectors, connectivity, and routing
Working with recipients, groups, and mailboxes
Configuring and managing public folders
Configuring security, compliance and policies
Configuring highly available exchange server solutions
Monitoring and reporting
Disaster recovery operations for exchange server

Prerequisites

Must have completed the following certification to be eligible to take the course:

MCITP Server Administrator Certification

3 years + of work experience on Windows Server Environment

Course Benefits

Upon completion of this course, the student will be able to meet these overall objectives:

Features and the deployment architecture in Exchange Server 2007
Plan and implement an Exchange Server 2007 deployment
Administer Exchange Server 2007
Implement client access services in Exchange Server 2007
Manage message routing in an Exchange Server 2007 organization
Configure messaging security with Exchange Server 2007
Implement high availability and disaster recovery solutions in Exchange Server 2007
Implement Unified Messaging In Exchange Server 2007

Course Duration: 40 Hours

Microsoft Exam 70 237

Designing Messaging Solutions with Microsoft Exchange Server 2007 teaches students how to design a messaging infrastructure, as well as how to assess an existing infrastructure and determine technical and business requirements for both new Microsoft Exchange Server 2007 deployments and migrations. They will learn how to identify risks and create mitigation plans to maintain the business continuity of the messaging system and how to design a backup strategy, disaster recovery procedures, and testing.

Course Objectives

The course covers the following elements:

Designing and planning messaging services
Designing and planning server high availability
Designing recovery and messaging services to meet business demands
Designing and planning coexistence and migrations
Defining policies and security procedures

Prerequisites

Must have completed the following certification to be eligible to take the course:

MCITP Server Administrator Certification

3 years + of work experience on Windows Server Environment

Course Benefits

After completing this course, students will be able to:

Gather business and technical requirements for a messaging
infrastructure
Design an Active Directory directory service and message routing infrastructure
Design the hardware and system configuration for Exchange servers
Design security for the messaging environment
Design strategies for coexistence and interoperability
Design a strategy for upgrading to Exchange Server 2007
Design messaging policies
Obtain approval for a messaging infrastructure design

Course Duration: 40 Hours

Microsoft Exam 70 238

In this course, you examine the planning requirements for the implementation of messaging security and compliance in a Microsoft Exchange Server 2007 solution. You explore the various options for implementing security to meet the business and legal requirements of an organization.

Course Objectives

The course covers the following elements:

Planning an upgrade to Exchange Server 2007
Planning a migration to Exchange Server 2007
Planning Exchange Server 2007 Interoperability
Planning a highly available Exchange Server 2007 implementation
Planning a backup and recovery solution for Exchange Server 2007
Planning the Exchange Server 2007 storage group deployment
Planning the Exchange Server 2007 server role deployment
Planning the deployment of exchange server 2007 services
Planning antivirus and anti-spam for Exchange Server 2007
Planning Exchange Server 2007 security
Planning Exchange Server 2007 compliance
Planning for Exchange Server 2007 compliance
Planning for Exchange Server 2007 messaging infrastructure improvements and maintenance

Prerequisites

Must have completed the following certification to be eligible to take the course: MCITP Server Administrator Certification OR 3 years + of work experience on Windows Server Environment

Course Benefits

After completing this course, students will be able to:

Plan the implementation of antivirus and anti-spam solutions
Plan the implementation of transport rules
Plan the implementation of journal rules
Plan the implementation of messaging compliance
Plan the implementation of a secure network layer

Course Duration: 40 hours

Microsoft Learning

Configuring Advanced Windows Server 2012 Exam 412

This exam is part three of a series of three exams, which validate the skills and knowledge necessary to administer a Windows Server 2012 Infrastructure in an enterprise environment. This exam will validate the advanced configuring tasks necessary to deploy, manage, and maintain a Windows Server 2012 infrastructure, such as fault tolerance, certificate services, and identity federation. This exam along with the other two exams will collectively validate the skills and knowledge necessary for implementing, managing, maintaining, and provisioning services and infrastructure in a Windows Server 2012 environment.

Course Objectives

Implementing Advanced Network Services
Implementing Advanced File Services
Implementing Dynamic Access Control
Implementing Network Load Balancing
Implementing Failover Clustering
Implementing Disaster Recovery
Implementing AD CS
Implementing AD FS

Prerequisites

Course Track

Configure and Manage High Availability
Configure File and Storage Solutions
Implement Business Continuity and Disaster Recovery
Configure Network Services
Configure the Active Directory Infrastructure
Configure Identity and Access Solutions

Course Benefits

This exam measures your ability to accomplish the technical tasks listed below.The percentages indicate the relative weight of each major topic area on the exam.The higher the percentage, the more questions you are likely to see on that content area on the exam. The information after “This objective may include but is not limited to” is intended to further define or scope the objective by describing the types of skills and topics that may be tested for the objective. However, it is not an exhaustive list of skills and topics that could be included on the exam for a given skill area.

Course Duration

6 weeks or 40 Hours with Lecture and Hands-on Lab
32 Hours of Practicum

Course Guide

Configure and Manage High Availability (16%)

Configure Network Load Balancing (NLB).: This objective may include but is not limited to: Install NLB nodes; configure NLB prerequisites; configure affinity; configure port rules; configure cluster operation mode; upgrade an NLB cluster
Configure failover clustering.: This objective may include but is not limited to: Configure Quorum; configure cluster networking; restore single node or cluster configuration; configure cluster storage; implement Cluster Aware Updating; upgrade a cluster
Manage failover clustering roles.: This objective may include but is not limited to: Configure role-specific settings including continuously available shares; configure VM monitoring; configure failover and preference settings
Manage Virtual Machine (VM) movement.: This objective may include but is not limited to: Perform Live Migration; perform quick migration; perform storage migration; import, export, and copy VMs; migrate from other platforms (P2V and V2V)

Configure File and Storage Solutions (15%)

Configure advanced file services.: This objective may include but is not limited to: Configure NFS data store; configure BranchCache; configure File Classification Infrastructure (FCI) using File Server Resource Manager (FSRM); configure file access auditing
Implement Dynamic Access Control (DAC).: This objective may include but is not limited to: Configure user and device claim types; implement policy changes and staging; perform access-denied remediation; configure file classification
Configure and optimize storage.: This objective may include but is not limited to: Configure iSCSI Target and Initiator; configure Internet Storage Name server (iSNS); implement thin provisioning and trim; manage server free space using Features on Demand

Implement Business Continuity and Disaster Recovery (16%)

Configure and manage backups.: This objective may include but is not limited to: Configure Windows Server backups; configure Windows Online backups; configure role-specific backups; manage VSS settings using VSSAdmin; create System Restore snapshots
Recover servers.: This objective may include but is not limited to: Restore from backups; perform a Bare Metal Restore (BMR); recover servers using Windows Recovery Environment (Win RE) and safe mode; apply System Restore snapshots; configure the Boot Configuration Data (BCD) store
Configure site-level fault tolerance.: This objective may include but is not limited to: Configure Hyper-V Replica including Hyper-V Replica Broker and VMs; configure multi-site clustering including network settings, Quorum, and failover settings

Configure Network Services (17%)

Implement an advanced Dynamic Host Configuration Protocol (DHCP) solution.: This objective may include but is not limited to: Create and configure superscopes and multicast scopes; implement DHCPv6; configure high availability for DHCP including DHCP failover and split scopes; configure DHCP Name Protection
Implement an advanced DNS solution.: This objective may include but is not limited to: Configure security for DNS including DNSSEC, DNS Socket Pool, and cache locking; configure DNS logging; configure delegated administration; configure recursion; configure netmask ordering; configure a GlobalNames zone
Deploy and manage IPAM.: This objective may include but is not limited to: Configure IPAM manually or by using Group Policy; configure server discovery; create and manage IP blocks and ranges; monitor utilization of IP address space; migrate to IPAM; delegate IPAM administration; manage IPAM collections

Configure the Active Directory Infrastructure (18%)

Configure a forest or a domain.: This objective may include but is not limited to: Implement multi-domain and multi-forest Active Directory environments including interoperability with previous versions of Active Directory; upgrade existing domains and forests including environment preparation and functional levels; configure multiple user principal name (UPN) suffixes
Configure trusts.: This objective may include but is not limited to: Configure external, forest, shortcut, and realm trusts; configure trust authentication; configure SID filtering; configure name suffix routing
Configure sites.: This objective may include but is not limited to: Configure sites and subnets; create and configure site links; manage site coverage; manage registration of SRV records; move domain controllers between sites
Manage Active Directory and SYSVOL replication.: This objective may include but is not limited to: Configure replication to Read-Only Domain Controllers (RODCs); configure Password Replication Policy (PRP) for RODCs; monitor and manage replication; upgrade SYSVOL replication to Distributed File System Replication (DFSR)

Configure Identity and Access Solutions (15%)

Implement Active Directory Federation Services 2.1 (AD FSv2.1).: This objective may include but is not limited to: Implement claims-based authentication including Relying Party Trusts; configure Claims Provider Trust rules; configure attribute stores including Active Directory Lightweight Directory Services (AD LDS); manage AD FS certificates; configure AD FS proxy; integrate with Cloud Services
Install and configure Active Directory Certificate Services (AD CS).: This objective may include but is not limited to: Install an Enterprise Certificate Authority (CA); configure CRL distribution points; install and configure Online Responder; implement administrative role separation; configure CA backup and recovery
Manage certificates.: This objective may include but is not limited to: Manage certificate templates; implement and manage certificate deployment, validation, and revocation; manage certificate renewal; manage certificate enrollment and renewal to computers and users using Group Policies; configure and manage key archival and recovery
Install and configure Active Directory Rights Management Services (AD RMS).: This objective may include but is not limited to: Install a licensing or certificate AD RMS server; manage AD RMS Service Connection Point (SCP); manage AD RMS client deployment; manage Trusted User Domains; manage Trusted Publishing Domains; manage Federated Identity support; manage RMS templates; configure Exclusion Policies

Designing A Server Infrastructure 2012 Exam 413

This certification is intended for IT Professional who need to validate their skills and knowledge necessary for planning, designing, and deploying a Windows Server 2012 highly virtualized infrastructure including the Active Directory, storage, security, and networking services necessary. Candidate’s should have experience with previous Windows Server Operating systems and have their Windows 2012 Server certification (MCSA) or equivalent skills.

Course Objectives

Plan and Deploy a Server Infrastructure
Design and implement Network Infrastructure Services
Design and Implement Network Access Services
Design and Implement an Active Directory Infrastructure (Logical)
Design and Implement an Active Directory Infrastructure (Physical)

Prerequisites

CompTia A+ Certification
MCSA Windows Server 2008

Knowledge and understanding of Networks and Systems

Course Benefits

This exam is part one of a series of two exams, which validate the skills and knowledge necessary to design, implement, and maintain a Windows Server 2012 Infrastructure in an enterprise scaled, highly virtualized environment. This exam will validate the planning, configuration, and implementation of the Windows Server 2012 services, such as server deployment, server virtualization, and network access and infrastructure. This exam along with 70-414 will collectively validate the skills and knowledge necessary for designing, deploying, and maintaining infrastructure services in a Windows Server 2012 environment.

Course Duration

6 weeks or 40 Hours Lecture and Lab with 32 Hours of Practicum for additional practice.

Course Guide

Plan and Deploy a Server Infrastructure (20%)

Design an automated server installation strategy.: This objective may include but is not limited to: Design considerations including images and bare metal/virtual deployment; design a server implementation using Windows Assessment and Deployment Kit (ADK); design a virtual server deployment
Plan and implement a server deployment infrastructure.: This objective may include but is not limited to: Configure multicast deployment; configure multi-site topology and distribution points; configure a multi-server topology; configure autonomous and replica Windows Deployment Services (WDS) servers
Plan and implement server upgrade and migration.: This objective may include but is not limited to: Plan for role migration; migrate server roles; migrate servers across domains and forests; design a server consolidation strategy; plan for capacity and resource optimization
Plan and deploy Virtual Machine Manager services.: This objective may include but is not limited to: Design Virtual Machine Manager service templates; define operating system profiles; configure hardware and capability profiles; manage services; configure image and template libraries; manage logical networks
Plan and implement file and storage services.: This objective may include but is not limited to: Planning considerations include iSCSI SANs, Fibre Channel SANs, Virtual Fibre Channel, storage spaces, storage pools, and data de-duplication; configure the iSCSI Target server; configure the Internet Storage Name server (iSNS); configure Network File System (NFS); install Device Specific Modules (DSMs)

Design and Implement Network Infrastructure Services (20%)

Design and maintain a Dynamic Host Configuration Protocol (DHCP) solution.: This objective may include but is not limited to: Design considerations including a highly available DHCP solution including split scope, DHCP failover, and DHCP failover clustering, DHCP interoperability, and DHCPv6; implement DHCP filtering; implement and configure a DHCP management pack; maintain a DHCP database
Design a name resolution solution strategy.: This objective may include but is not limited to: Design considerations including secure name resolution, DNSSEC, DNS Socket Pool, cache locking, disjoint namespaces, DNS interoperability, migration to application partitions, IPv6, Single-Label DNS Name Resolution, zone hierarchy, and zone delegation
Design and manage an IP address management solution.: This objective may include but is not limited to: Design considerations including IP address management technologies including IPAM, Group Policy based, and manual provisioning, and distributed vs. centralized placement; configure role-based access control; configure IPAM auditing; migrate IPs; manage and monitor multiple DHCP and DNS servers; configure data collection for IPAM

Design and Implement Network Access Services (17%)

Design a VPN solution.: This objective may include but is not limited to: Design considerations including certificate deployment, firewall configuration, client/site to site, bandwidth, protocol implications, and VPN deployment configurations using Connection Manager Administration Kit (CMAK)
Design a DirectAccess solution.: This objective may include but is not limited to: Design considerations including topology, migration from Forefront UAG, DirectAccess deployment, and enterprise certificates
Implement a scalable remote access solution.: This objective may include but is not limited to: Configure site-to-site VPN; configure packet filters; implement packet tracing; implement multi-site Remote Access; configure Remote Access clustered with Network Load Balancing (NLB); configure DirectAccess
Design a network protection solution.: This objective may include but is not limited to: Design considerations including Network Access Protection (NAP) enforcement methods for DHCP, IPSec, VPN, and 802.1x, capacity, placement of servers, firewall, Network Policy Server (NPS), and remediation network
Implement a network protection solution.: This objective may include but is not limited to: Implement multi-RADIUS deployment; configure NAP enforcement for IPSec and 802.1x; deploy and configure the Endpoint Protection client; create anti-malware and firewall policies; monitor for compliance

Design and Implement an Active Directory Infrastructure (Logical) (22%)

Design a forest and domain infrastructure.: This objective may include but is not limited to: Design considerations including multi-forest architecture, trusts, functional levels, domain upgrade, domain migration, forest restructure, and Hybrid Cloud services
Implement a forest and domain infrastructure.: This objective may include but is not limited to: Configure domain rename; configure Kerberos realm trusts; implement a domain upgrade; implement a domain migration; implement a forest restructure; deploy and manage a test forest including synchronization with production forests
Design a Group Policy strategy.: This objective may include but is not limited to: Design considerations including inheritance blocking, enforced policies, loopback processing, security, and WMI filtering, site-linked Group Policy Objects (GPOs), slow-link processing, group strategies, organizational unit (OU) hierarchy, and Advanced Group Policy Management (AGPM)
Design an Active Directory permission model.: This objective may include but is not limited to: Design considerations including Active Directory object security and Active Directory quotas; customize tasks to delegate in Delegate of control wizard; deploy administrative tools on the client computer; delegate permissions on administrative users (AdminSDHolder); configure Kerberos delegation

Design and Implement an Active Directory Infrastructure (Physical) (21%)

Design an Active Directory sites topology.: This objective may include but is not limited to: Design considerations including proximity of domain controllers, replication optimization, and site link; monitor and resolve Active Directory replication conflicts
Design a domain controller strategy.: This objective may include but is not limited to: Design considerations including global catalog, operations master roles, Read-Only Domain Controllers (RODCs), partial attribute set, and domain controller cloning
Design and implement a branch office infrastructure.: This objective may include but is not limited to: Design considerations including RODC, Universal Group Membership Caching (UGMC), global catalog, DNS, DHCP, and BranchCache; implement confidential attributes; delegate administration; modify filtered attributes set; configure password replication policy; configure hash publication

Implementing Adv. Server Infrastructure Exam 414

Course Objectives

Manage and Maintain a Server Infrastructure
Plan and Implement a Highly Available Enterprise Infrastructure
Plan and Implement a Server Virtualization Infrastructure
Design and Implement Identity and Access Solutions

Prerequisites

Knowledge of Windows Server Platforms
Windows MCSA Certification

Course Track

Manage and Maintain a Server Infrastructure
Plan and Implement a Highly Available Enterprise Infrastructure
Plan and Implement a Server Virtualization Infrastructure
Design and Implement Identity and Access Solutions

Course Benefits

This course is part two, of a series of two courses, which validate the skills and knowledge necessary to design, implement and maintain a Windows Server 2012 Infrastructure in an enterprise scaled, highly virtualized environment. This course will validate the planning, configuration, and management of the Windows Server 2012 services, such as identity and access, high availability, and the server infrastructure. This course along with course 70-413 will collectively validate the skills and knowledge necessary for designing, deploying, and maintaining services and infrastructure in a Windows Server 2012 environment.

Course Duration

6 weeks or 40 Hours Lecture and Lab Hands-on

Course Guide

Manage and Maintain a Server Infrastructure (27%)

Design an administrative model.: This objective may include but is not limited to: Design considerations including user rights, built-in groups, and end-user self-service portal; design a delegation of administration structure for Microsoft System Center 2012
Design a monitoring strategy.: This objective may include but is not limited to: Design considerations including monitoring servers using Audit Collection Services (ACS), performance monitoring, centralized monitoring, and centralized reporting; implement and optimize System Center 2012 - Operations Manager management packs; plan for monitoring Active Directory
Design an updates infrastructure.: This objective may include but is not limited to: Design considerations including Windows Server Update Services (WSUS), System Center 2012 - Configuration Manager, and cluster-aware updating; design and configure Virtual Machine Manager for software update management; update VDI desktop images
Implement automated remediation.: This objective may include but is not limited to: Create an Update Baseline in Virtual Machine Manager; implement a Desired Configuration Management (DCM) Baseline; implement Virtual Machine Manager integration with Operations Manager; configure Virtual Machine Manager to move a VM dynamically based on policy; integrate System Center 2012 for automatic remediation into your existing Enterprise Infrastructure

Plan and Implement a Highly Available Enterprise Infrastructure (26%)

Plan and implement failover clustering.: This objective may include but is not limited to: Plan for multi-node and multi-site clustering; design considerations including redundant networks, network priority settings, resource failover and failback, heartbeat and DNS settings, Quorum configuration, and storage placement and replication
Plan and implement highly available network services.: This objective may include but is not limited to: Plan for and configure Network Load Balancing (NLB); design considerations including fault-tolerant networking, multicast vs. unicast configuration, state management, and automated deployment of NLB using Virtual Machine Manager service templates
Plan and implement highly available storage solutions.: This objective may include but is not limited to: Plan for and configure storage spaces and storage pools; design highly available, multi-replica DFS namespaces; plan for and configure multi-path I/O, including Server Core; configure highly available iSCSI Target and iSNS Server
Plan and implement highly available server roles.: This objective may include but is not limited to: Plan for a highly available Dynamic Host Configuration Protocol (DHCP) Server, Hyper-V clustering, Continuously Available File Shares, and a DFS Namespace Server; plan for and implement highly available applications, services, and scripts using Generic Application, Generic Script, and Generic Service clustering roles
Plan and implement a business continuity and disaster recovery solution.: This objective may include but is not limited to: Plan a backup and recovery strategy; planning considerations including Active Directory domain and forest recovery, Hyper-V replica, domain controller restore and cloning, and Active Directory object and container restore using authoritative restore and Recycle Bin

Plan and Implement a Server Virtualization Infrastructure (26%)

Plan and implement virtualization hosts.: This objective may include but is not limited to: Plan for and implement delegation of virtualization environment (hosts, services, and VMs), including self-service capabilities; plan and implement multi-host libraries including equivalent objects; plan for and implement host resource optimization; integrate third-party virtualization platforms
Plan and implement virtualization guests.: This objective may include but is not limited to: Plan for and implement highly available VMs; plan for and implement guest resource optimization including smart page file, dynamic memory, and RemoteFX; configure placement rules; create Virtual Machine Manager templates
Plan and implement virtualization networking.: This objective may include but is not limited to: Plan for and configure Virtual Machine Manager logical networks; plan for and configure IP address and MAC address settings across multiple Hyper-V hosts including IP virtualization; plan for and configure virtual network optimization
Plan and implement virtualization storage: This objective may include but is not limited to: Plan for and configure Hyper-V host storage including stand-alone and clustered setup using SMB 2.2 and CSV; plan for and configure Hyper-V guest storage including virtual Fibre Channel, iSCSI, and pass-through disks; plan for storage optimization
Plan and implement virtual guest movement.: This objective may include but is not limited to: Plan for and configure live, SAN, and network migration between Hyper-V hosts; plan for and manage P2V and V2V
Manage and maintain a server virtualization infrastructure.: This objective may include but is not limited to: Manage dynamic optimization and resource optimization; manage Operations Manager integration using PRO Tips; automate VM software and configuration updates using service templates; maintain library updates

Design and Implement Identity and Access Solutions (21%)

Design a Certificate Services infrastructure.: This objective may include but is not limited to: Design a multi-tier Certificate Authority (CA) hierarchy with offline root CA; plan for multi-forest CA deployment; plan for Certificate Enrollment Web Services; plan for network device enrollment; plan for certificate validation and revocation; plan for disaster recovery; plan for trust between organizations
Implement and manage a Certificate Services infrastructure.: This objective may include but is not limited to: Configure and manage offline root CA; configure and manage Certificate Enrollment Web Services; configure and manage Network Device Enrollment Services; configure Online Certificates Status Protocol responders; migrate CA; implement administrator role separation; implement and manage trust between organizations; monitor CA health
Implement and manage certificates.: This objective may include but is not limited to: Manage certificate templates; implement and manage deployment, validation, and revocation; manage certificate renewal including Internet-based clients; manage certificate deployment and renewal to network devices; configure and manage key archival and recovery
Design and implement a federated identity solution.: This objective may include but is not limited to: Plan for and implement claims-based authentication including planning and implementing Relying Party Trusts; plan for and configure Claims Provider Trust rules; plan for and configure attribute stores including Active Directory Lightweight Directory Services (AD LDS); plan for and manage Active Directory Federation Services (AD FS) certificates; plan for Identity Integration with Cloud services
Design and implement Active Directory Rights Management Services (AD RMS).: This objective may include but is not limited to: Plan for highly available AD RMS deployment; manage AD RMS Service Connection Point; plan for and manage AD RMS client deployment; manage Trusted User Domains; manage Trusted publishing domains; manage Federated Identity support; manage Distributed and Archived Rights Policy templates; configure Exclusion Policies; decommission AD RMS

Upgrade To MCSA 2012 Exam 417

70-417 is an upgrade exam that is a composite of three stand-alone exams: 70-410, 70-411, and 70-412. Exam 70-417 validates skills related to the core technology features and functionality of Windows Server 2012, from the existing knowledge base of a Microsoft Certified Systems Administrator (MCSA) on Windows Server 2008.

Course Objectives

The topics from each source exam, plus the percentage of material per topic for each exam component, are noted in the following lists.

Exam 70-410: Installing and Configuring Windows Server 2012

Install and Configure Servers (25%)
Configure Server Roles and Features (24%)
Configure Hyper-V (25%)
Install and Administer Active Directory (26%)

Exam 70-411: Administering Windows Server 2012

Deploy, Manage, and Maintain Servers (20%)
Configure Network Services and Access (20%)
Configure a Network Policy Server Infrastructure (17%)
Configure and Manage Active Directory (22%)
Configure and Manage Group Policy (21%)

Exam 70-412: Configuring Advanced Windows Server 2012 Services

Configure and Manage High Availability (20%)
Configure File and Storage Solutions (19%)
Implement Business Continuity and Disaster Recovery (22%)
Configure Network Services (21%)
Configure Identity and Access Solutions (18%)

Prerequisites

Any of the above mentioned Certifications can be a prerequisite for this certification

Course Track

Install and Configure Servers
Configure Server Roles and Features
Configure Hyper-V
Install and Administer Active Directory
Deploy, Manage, and Maintain Servers
Configure Network Services and Access
Configure a Network Policy Server Infrastructure
Configure and Manage Active Directory
Configure and Manage Group Policy
Configure and Manage High Availability
Configure File and Storage Solutions
Implement Business Continuity and Disaster Recovery
Configure Network Services
Configure Identity and Access Solutions

Course Benefits

Exam 70-417 is intended for IT professionals who currently hold one of the following certifications:

MCSA: Windows Server 2008
MCITP: Virtualization Administrator
MCITP: Enterprise Messaging Administrator
MCITP: Lync Server Administrator
MCITP: SharePoint Administrator
MCITP: Enterprise Desktop Administrator

Course Duration

6 weeks or 40 Hours with Lectures and Hands-on Lab
32 Hours of practicum

Course Guide

Exam 70-410

Install and Configure Servers (25%)

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 (24%)

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 (25%)

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

Install and Administer Active Directory (26%)

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

Exam 70-411

Deploy, Manage, and Maintain Servers (20%)

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 Network Services and Access (20%)

Configure DirectAccess.: This objective may include but is not limited to: Implement server requirements; implement client configuration; configure DNS for Direct Access; configure certificates for Direct Access

Configure a Network Policy Server Infrastructure (17%)

Configure Network Access Protection (NAP).: This objective may include but is not limited to: Configure System Health Validators (SHVs); configure health policies; configure NAP enforcement using DHCP and VPN; configure isolation and remediation of non-compliant computers using DHCP and VPN; configure NAP client settings

Configure and Manage Active Directory (22%)

Configure Domain Controllers.: This objective may include but is not limited to: Configure Universal Group Membership Caching (UGMC); transfer and seize operations masters; install and configure a read-only domain controller (RODC); configure Domain Controller cloning
Maintain Active Directory.: This objective may include but is not limited to: Back up Active Directory and SYSVOL; manage Active Directory offline; optimize an Active Directory database; clean up metadata; configure Active Directory snapshots; perform object- and container-level recovery; perform Active Directory restore

Configure and Manage Group Policy (21%)

Configure Group Policy processing.: This objective may include but is not limited to: Configure processing order and precedence; configure blocking of inheritance; configure enforced policies; configure security filtering and WMI filtering; configure loopback processing; configure and manage slow-link processing; configure client-side extension (CSE) behavior

Exam 70-412

Configure and Manage High Availability (20%)

Configure failover clustering.: This objective may include but is not limited to: Configure Quorum; configure cluster networking; restore single node or cluster configuration; configure cluster storage; implement Cluster Aware Updating; upgrade a cluster
Manage failover clustering roles.: This objective may include but is not limited to: Configure role-specific settings including continuously available shares; configure VM monitoring; configure failover and preference settings
Manage Virtual Machine (VM) movement.: This objective may include but is not limited to: Perform live migration; perform quick migration; perform storage migration; import, export, and copy VMs; migrate from other platforms (P2V and V2V)

Configure File and Storage Solutions (19%)

Implement Dynamic Access Control (DAC).: This objective may include but is not limited to: Configure user and device claim types; implement policy changes and staging; perform access-denied remediation; configure file classification

Implement Business Continuity and Disaster Recovery (22%)

Configure and manage backups.: This objective may include but is not limited to: Configure Windows Server backups; configure Windows Online backups; configure role-specific backups; manage VSS settings using VSSAdmin; create System Restore snapshots
Configure site-level fault tolerance.: This objective may include but is not limited to: Configure Hyper-V Replica including Hyper-V Replica Broker and VMs; configure multi-site clustering including network settings, Quorum, and failover settings

Configure Network Services (21%)

Deploy and manage IPAM.: This objective may include but is not limited to: Configure IPAM manually or by using Group Policy; configure server discovery; create and manage IP blocks and ranges; monitor utilization of IP address space; migrate to IPAM; delegate IPAM administration; manage IPAM collections

Configure Identity and Access Solutions (18%)

Implement Active Directory Federation Services 2.1 (AD FSv2.1).: This objective may include but is not limited to: Implement claims-based authentication including Relying Party Trusts; configure Claims Provider Trust rules; configure attribute stores including Active Directory Lightweight Directory Services (AD LDS); manage AD FS certificates; configure AD FS proxy

Microsoft Office

Microsoft Access Level 1

You will create and modify new databases and their various objects.

Course Objectives

The course will cover the following elements:

Identify the elements of the Access interface
Identify the components of a database
Examine the relational database design process
Create a new database
Create a table using the design view
Manage tables
Establish table relationships
Create a new database
Create a table using the design view
Manage tables
Establish table relationships
Modify table data
Sort and filter records
Work with sub-data sheets
Create a query
Add criteria to a query
Add a calculated field to a query
Perform calculations on a record grouping
Create a form
Modify the design of a form
View and edit data suing an access form
Create a report
Add a control to a report
Format the controls in a report
Enhance the appearance of a report
Prepare a report for print

Prerequisites

To be successful in this course, you should be familiar with using personal computers and you should have used a mouse and keyboard. You should be comfortable in the Windows environment and be able to use Windows to manage information on the computer. Specifically, you should be able to launch and close programs; navigate to information stored on the computer; and manage files and folders. To ensure your success, we recommend you first take one of ABCO Technology's introductory Windows courses, such as either of the following, or have equivalent skills and knowledge:

Windows XP Professional: Level 1
Windows XP: Introduction

Course Benefits

Upon successful completion of this course, students will be able to:

Build database structure
Mange data in a table
Query a database
Design forms
Generate reports

Course Duration: 8 Hours

Microsoft Access Level 2

You will improve and customize tables, queries, forms, and reports, and share Access data with other applications.

Course Objectives

The course will cover the following elements:

Constrain data entry suing filed properties
Establish data entry formats for entering field values
Create a list of values for a field
Create query joins
Join tables with no common fields
Relate data within a table
Set the select query properties
Retrieve records based on input criteria
Create action queries
Restrict data entry in forms
Organize information with tab pages
Add command button to a form
Create a subform
Display a summary of data in a form
Change the display of data conditionally
Organize report information
Format reports
Control report pagination
Summarize report information
Add a sub-report to an existing report
Create a mailing label report
Import data into access
Export data to text file formats
Export access data to excel
Create a mail merge

Prerequisites

To ensure your success, we recommend that you first take one of ABCO Technology’s introductory courses, or the following course or have equivalent knowledge and skills.

Microsoft®Office Access® : Level 1

Course Benefits

Upon successful completion of this course, students will be able to:

Control data entry
Join tables
Create flexible queries
Improve forms
Customize reports
Share data across different applications

Course Duration: 8 Hours

Microsoft Access Level 3

You will create complex Access databases by structuring existing data, writing advanced queries, working with macros, and performing database maintenance.

Course Objectives

The course will cover the following elements:

Create sub-queries
Create unmatched and duplicate queries
Group and summarize records using criteria
Summarize data using a Crosstab query
Create a PivotTable and a PivoChart
Create a Macro
Attach a Macro
Restrict records using a condition
Validate data using a macro
Automate data entry using a macro
Include a chart in a report
Print data in columns
Cancel printing of a blank report
Publish reports as PDF
Link tables to external data sources
Manage a database
Determine object dependency
Document a database
Analyze the performance of a database

Prerequisites

To ensure your success, knowledge of basic and intermediate features of Access tables, relationships, and queries, forms, and reports is recommended. The following ABCO Technology courses or equivalent knowledge is recommended:

Microsoft® Office Access® : Level 1
Microsoft® Office Access® : Level 2

Course Benefits

Upon successful completion of this course, students will be able to:

Structure existing data
Writing advanced queries
Simplifying tasks with macros
Creating effective reports
Maintaining an access database

Course Duration: 8 Hours

Microsoft Excel Level 1

In this course you will create and edit basic Microsoft Office Excel worksheets and workbooks.

Course Objectives

The course will cover the following elements:

Perform calculations in an Excel worksheet
Modify an Excel worksheet
Modify the appearance of data within a worksheet
Manage Excel workbooks
Print the content of an Excel worksheet
Create formulas in a worksheet
Insert functions in a worksheet
Reuse formulas
Edit worksheet data
Find and replace data
Manipulate worksheet elements
Add boards and colors to cells
Align
Reuse formulas
Edit worksheet data
Find and replace data
Manipulate worksheet elements

Prerequisites

To be successful in this course, you should be familiar with using personal computers and you should have used a mouse and keyboard. You should be comfortable in the Windows environment and be able to use Windows to manage information on the computer. Specifically, you should be able to launch and close programs; navigate to information stored on the computer; and manage files and folders. To ensure your success, we recommend you first take one of ABCO's introductory Windows courses, such as either of the following, or have equivalent skills and knowledge:

Microsoft® Office Windows® XP Introduction
Microsoft® Office Windows® 2000 Introduction

Course Benefits

Upon successful completion of this course, students will be able to:

Create a basic worksheet by using Microsoft Excel 2010
Perform calculations in an Excel worksheet
Modify and Excel worksheet
Modify the appearance of data within a worksheet
Manage Excel workbooks
Print the content of an Excel worksheet
Define the Page Layout

Course Duration: 8 Hours

Microsoft Excel Level 2

In this course you will utilize advanced formulas and work with various tools to analyze data in spreadsheets. You will also organize table data, present data as charts, and enhance the look and appeal of workbooks by adding graphical objects.

Course Objectives

The course will cover the following element:

Calculating data with advanced formulas
Apply cell and range names
Calculate data across worksheets
Use specialized functions
Analyze data with logical and lookup functions
Organizing worksheet and table data
Create and modify tables
Format tables
Use functions to calculate data
Presenting data using charts
Modify charts
Analyzing data using PivotTables, Slicers and PivotCharts
Create a PivotTable report
Filter data using slicers
Inserting graphic objects
Insert and modify pictures and clip art
Draw and modify shapes
Illustrate workflow using smartart graphics
Layer and group graphic objects
Customizing and enhancing the excel environment
Customize the Excel environment
Customize workbooks
Create and use templates

Prerequisites

Before starting this course, students are recommended to take the following ABCO Technology course or have equivalent knowledge:

Microsoft® Office Excel® :Level 1.

Course Benefits

Upon successful completion of this course, students will be able to:

Use advanced formulas
Organize worksheet and table data using various techniques
Create and modify charts
Analyze data using PivotTables, Slicers and PivotCharts
Insert and modify graphic objects in a worksheet
Customize and enhance workbooks and the Microsoft Office Excel environment

Course Duration: 8 Hours

Microsoft Excel Level 3

You will automate some common Excel tasks, apply advanced analysis techniques to more complex data sets, troubleshoot errors, collaborate on worksheets and share Excel data with other applications.

Course Objectives

This course will cover the following elements:

Streamlining workflow
Update workbook properties
Create a macro
Edit a macro
Apply conditional formatting
Add data validation criteria
Collaborating with other users
Protect files
Share a workbook
Set revision tracking
Review tracked revisions
Merge workbooks
Administer digital signatures
Restrict document access
Auditing worksheets
Trace cells
Troubleshoot invalid data and formula errors
Watch and evaluate formulas
Create a data list outline
Analyzing data
Create a trendline
Create sparklines
Create scenarios
Perform a What-If analysis
Perform a statistical analysis with the analysis ToolPak
Working with multiple workbooks
Create a workspace
Consolidate data
Link cells in different workbooks
Edit links
Importing and exporting data
Export Excel data
Import a delimited text file
Integrating Excel data with the web
Publish a worksheet to the web
Import data from the web
Create a web query
Structuring workbooks with XML
Develop XML maps
Import and Export XML data

Prerequisites

To ensure your success, we recommend that you first take the following ABCO Technology courses or have equivalent knowledge:

Microsoft® Office Excel® : Level 1
Microsoft® Office Excel® : Level 2

Course Benefits

Upon successful completion of this course, students will be able to:

Enhance productivity and efficiency by streamlining the workflow
Collaborate with other workbook users
Audit worksheets
Analyze data
Work with multiple workbooks
Import and export data
Integrate Excel data with the web
Structure workbooks with XML

Course Duration: 8 Hours

Microsoft PowerPoint Level 1

You will explore the PowerPoint environment and create a presentation. You will format text on slides to enhance clarity. To enhance the visual appeal, you will add graphical objects to a presentation and modify them. You will also add tables and charts to a presentation to present data in a structured form. You will then finalize a presentation to deliver it.

Course Objectives

The course will cover the following elements:

Identifying the elements of the user interface
Viewing presentations
Saving a presentation
Selecting a Presentation type
Entering text
Editing text
Formatting text placeholders
Adding slides to a presentation
Arranging slides
Working with themes
Applying character formats
Formatting paragraphs
Inserting images into a presentation
Adding shapes
Adding visual styles to text in a presentation
Editing graphical objects
Formatting graphical objects
Grouping graphical objects on a slide
Arranging graphical objects on a slide
Applying animation effects
Inserting a table
Formatting tables
Importing tables from other Microsoft Office Applications
Inserting charts
Modifying a chart
Importing charts from other Microsoft Office Applications
Reviewing the content in a presentation
Dividing a presentation into sections
Adding transitions
Adding speaker notes
Printing a presentation
Delivering a presentation

Prerequisites

Students should be familiar with using personal computers, and have used a mouse and keyboard. They should be comfortable with the Windows environment and be able to use Windows to manage information on their computers. Specifically, they should be able to launch and close programs, navigate to information stored on the computer, and manage files and folders. Students should have completed the following courses or possess equivalent knowledge before starting with this course:

Microsoft® Office Windows® XP Introduction
Microsoft® Office Windows® XP Professional Level 1
Microsoft® Office Windows® XP Professional Level 2
Microsoft® Office Windows® 2000 Introduction

Course Benefits

Upon successful completion of this course, students will be able to:

Identify components on the PowerPoint interface
Create a presentation
Format text on slides
Add graphical objects to a presentation
Modify graphical objects in a presentation
Work with tables in a presentation
Add charts to a presentation
Prepare to deliver a presentation

Course Duration: 8 Hours

Microsoft PowerPoint Level 2

You will enhance your presentation by using features that will transform it into a powerful means of communication. You will customize the PowerPoint interface to suit your requirements and use features to create dynamic and visually appealing presentations. You will then finalize a presentation and secure it to authenticate its validity.

Course Objectives

The course will cover the following elements:

Customize the PowerPoint interface
Set options for working with PowerPoint
Set up a slide master
Create custom slide layouts
Add headers and footers
Modify the notes master
Modify the handout master
Insert SmartArt Graphics
Modify SmartArt Graphics
Add multimedia elements
Customize slide component animations
Set up a custom slide show
Annotate a presentation
Create a presenter-independent slide show
Set up a slide show to repeat automatically
Review a presentation
Publish slides to a slide library
Restrict access to a shared presentation
Share a presentation using PowerPoint Web Application
Broadcast a presentation
Convert a presentation into a video
Package a presentation
Publish a presentation to other file formats
Secure a presentation

Prerequisites

Before starting this course, students are recommended to take the following ABCO Technology course or have equivalent knowledge:

Microsoft®Office PowerPoint : Level 1

Course Benefits

Upon successful completion of this course, students will be able to:

Customize the PowerPoint environment
Customize a design template
Add SmartArt graphics to a presentation
Add special effects to a presentation
Customize a slide show
Collaborate on a presentation
Secure and distribute a presentation

Course Duration: 8 Hours

Microsoft Word Level 1

You will create, edit, and enhance standard business documents using Microsoft® Office Word.

Course Objectives

The course will cover the following elements:

Identifying the components of the Word interface
Customize the Word Interface
Display a Document in different views
Enter text in a Document
Save a Document
Select text
Modify text
Find and replace text
Modifying the appearance of text in a Word Document
Apply character formatting
Align text using tabs
Display text as list items
Modify the layout of a paragraph
Applying styles
Manage formatting
Apply boarders and shading
Inserting symbols and special characters
Add illustrations to a Document
Inserting a table
Formatting / modifying a table
Converting text to a table
Checking spelling and grammar
Using the Thesaurus
Applying a page border and color
Adding a watermark
Adding headers and footers
Controlling page layout
Preview and printing a Document

Course Benefits

Upon successful completion of this course, students will be able to:

Edit text in a Word Document
Modify the appearance of text in a Word Document
Insert special characters and graphical objects
Proof a Word Document
Control the appearance of pages in a Word Document
Printing Word Documents

Course Duration: 8 Hours

Microsoft Word Level 2

You will create complex documents and build personalized efficiency tools using Microsoft Office Word.

Course Objectives

The course will cover the following elements:

Sort a list
Renumber a list
Customize a list
Sort table data
Control cell layout
Perform calculations in a table
Create charts
Create or modify a text style
Create a custom list or table style
Apply default and customize Document themes
Resize a picture
Adjust the picture appearance settings
Wrap text around a picture
Insert and format screenshots in a Document
Create text boxes and pull quotes
Draw shapes
Add WordArt and other special effects to text
Create complex illustrations with SmartArt
Control paragraph flow
Insert section breaks
Insert columns
Link text boxes to control text flow
Create a Document based on a template
Create a template
Use the mail merge features
Merge envelopes and labels
Create a data source using Word
Automate tasks using macros
Create a macro

Prerequisites

Students should be able to use Microsoft Word 2010 to create, edit, format, save, and print basic business Documents containing text, tables, and graphics. Students can obtain this level of skill by taking the following ABCO Technology course:

Microsoft® Office Word 2010: Level 1

Course Benefits

Upon successful completion of this course, students will be able to:

Manage Lists
Customize tables and charts
Modify pictures
Create customize graphic elements
Insert content using quick parts
Control text flow
Use templates to automate Document creation
Automate the mail merge
Use macros to automate tasks

Course Duration: 8 Hours

Microsoft Word Level 3

You will create, manage, revise, and distribute documents.

Course Objectives

The course will cover the following elements:

Link a Word Document to an Excel Worksheet
Send a Document outline to Microsoft®Office PowerPoint®
Send a Document as an Email Message
Modify user information
Send a Document for review
Review a Document
Compare Document changes
Merge Document Changes
Review track changes and comments
Coauthor a Document
Create a new Document version
Compare Document versions
Insert bookmarks
Insert footnotes and Endnotes
Add captions
Add hyperlinks
Add cross-reference
Add citations and a Bibliography
Insert blank and cover pages
Insert an index
Insert a table of figures
Insert a table of authorities
Insert a table of contents
Create a master Document
Hide text
Remove personal information from a Document
Set formatting and editing restrictions
Add a digital signature to a document
Set a password for a Document
Restrict Document access
Add form fields to a Document
Protect a form
Automate a form

Course Benefits

Upon successful completion of this course, students will be able to:

Use Microsoft Word with other programs
Collaborate on Documents
Manage Document versions
Add reference marks and notes
Simplify the use of long documents
Secure a Document
Create forms

What Is Microsoft Access

What is Microsoft Access Used for?

Simply put, Microsoft Access is an information management tool that assists the user to store information for reference, reporting, and analysis. Microsoft Access can help you overcome the limiting factors found when attempting to manage large amounts of data in Microsoft Excel or other relative spreadsheet application.

The Problem

A spreadsheet application is a terrific tool for maintaining and calculating smaller sets of information. Microsoft Excel is very user friendly and easy to understand. It offers the ability and functionality to create column names, insert data, create custom formulas, and leave you on your way. You can sort, filter, and format the data quickly and easily. But spreadsheets are not ideal for handling hundreds of records where you need to have only one version of updated information for something like a customer, a contact, or a main object that you need to track. It is very easy to introduce errors into a spreadsheet, which effects analysis, summing, and reporting very challenging.

The Solution: Store Related Information Together, Eliminate Duplication

The value offered by any database is the capability to store related information in one place, and then let you connect various different things together known as “entities”. This capability allows you to store one version of the truth for any given object, such as client, a DVD, or an order. Some major benefits to using a database are: Fewer errors and inconsistencies. Keeping one updated version of an object for items that need to minimize the potential for duplication, errors, and inconsistent values. In the Excel example above, customer names, contact phone numbers, and product names are misspelled, transposed, and abbreviated in different forms. One of the benefits of utilizing Microsoft Access is the ability change a single record and have all other related items in your database automatically distribute the change. If an input user was to misspell a customer’s name six different times in an excel sheet and didn’t notice the mistake, with the utilization of a database, there would only be one customer record to change. Every other record that is relative to the customer’s name record (orders, contacts, etc.) would not need to be changed because they are all linked to.

When Should I use Microsoft Access

The following are tasks that can be performed using Microsoft Access:

Validate basic user input
Complex user input validation or events
Data arranges in a columns without repetition
Simple cross-references
Events based on user actions (when user exits a field / cell do X, when they mouse over a field / cell do Y)
Multiple users, accessing data at the same time
Frequent mass-update operations
Multiple data entry forms
Multiple data entry forms
Mail merge with Word
Reporting
Automated backups
Record-level auditing
Ability to hide the inner workings of your project from the user
Attaching files / links to fields
Sharing information on the Web

Course Objectives

Microsoft Access is an important management tool that helps you to store information for reference, reporting, and utilized for data analysis.

Course Benefits

Learn how to implement databases to store information and retrieve information.

What Is Microsoft Excel

Microsoft Excel

For administrative work the minimum requirement is Microsoft Word and Microsoft Excel. Microsoft Excel is a commercial spreadsheet application written and distributed by Microsoft for Microsoft Windows and Mac OS X. It features calculation, graphing tools, pivot tables, and a macro programming language called Visual Basic for Applications. With its powerful functions, Excel has been a very widely applied spreadsheet in many fields.

1. Manage data records like name list

The most common usage of Excel is to manage data records and name lists. You don’t have to plan in advance on how the table should look like, as the preset layout allows you to create the tables on the fly, just fill in the information, the table is developed on the go. Another more attractive point is that you have the ability to sort the list and filter the listing like a database tool.

2. Used as an analytical tool

Besides managing data, Excel is a great analytical tool for business. With the pivot table contained with Excel, you can easily analyze large amounts of data, as the pivot table can automatically sort, count, and total the data stored in one table or spreadsheet and create a second table displaying the summarized data. It has gone through many revisions. In each revision, we see its power being enhanced.

3. Create forms and consolidate results

You can use Excel to create not only a simple form that contains boxes, but also professional forms which include option buttons that allow you to select answers, and create a drop down list to select a particular answer from the list of times. Together with carts, you can use Excel to compile answers to tests or quizzes and analyze the profile of the class or your team.

4. Corporate Budgeting

A major business application of Excel is in corporate budgeting. Many companies, from big corporations to small companies use Excel for their budgeting. Despite numerous calls by suppliers of Business Performance Management Systems (BPM) to move away from Excel as a budgeting tool, 70% to 80% of all corporations still use Excel as their primary budgeting tool.

5. Inventory Management

Excel provides many functions and formulas that will not only help you manage your data records efficiently but will also allow you to analyze your data based on your constantly changing business environment. Through the use of Microsoft Excel formulas, you can create comprehensive drop down boxes to facilitate data inputs and reduce erroneous entries. And through the use of pivot tables, you could get a detailed analysis of your stock movement and also your inventory level at any point in time.

6. Finding Profit Breakeven

Finding breakeven is never easy without using Excel. To manually find out the breakeven for a project, you have to perform many calculations using different inputs, and the calculation becomes even more complex if the components include fixed cost and step up cost. But with the goal seek function in Excel, this tasks can be completed in a few seconds.

Course Objectives

You will learn the fundamentals for productively operating Microsoft Excel and utilizing the software efficiently.

Course Benefits

Upon successful completion of the this course you will be able to navigate the application and use fundamental options that will increase productivity and efficiency.

What Is Microsoft Outlook

Microsoft Outlook

Microsoft Outlook is an email client included with the Microsoft Office suite. It is designed to operate as an independent personal information manager, an internet mail client, or in conjunction with Microsoft Exchange Server in utilizing group scheduling, email, and task management. Its purpose is to manage email, calendars, contacts, tasks, to-do lists, documents, and files located on your hard drive. Outlook assists you in communicating through electronic mail, phone support, and group scheduling capabilities. Outlook also helps you share information by means of public folders, forms, and internet connectivity. Outlook offers the capability of scheduling, groupware, personal information (contacts, tasks), email, and documents all in one convenient place, not to mention the ability to create and view information using an efficient interface. Microsoft Outlook allows for the use of shortcuts which allows you to easily access information and access any private, public, or file system folders. The Outlook Journal feature helps you find a document based on creation date and name. MS Outlook is an application that is used with large corporations in conjunction with Microsoft Exchange Server which easily collaborates with a Microsoft Environment. Although you can utilize Microsoft Outlook on client computer, here are some reason why this application is utilized throughout the corporate world.

1. Outlook and Microsoft Exchange were made for each other

If your electronic mail server runs Microsoft Exchange, utilizing Outlook to handle your email is a no-brainer. Users need not be tech savvy to connect, all you have to do is enter a contact's email address, and the application will communicate with Exchange effortlessly. Utilizing this method cuts down on the IT involvement in client configuration and allows users to switch computers easily.

2. Outlook and Active Directory

Active Directory’s authentication extends to Exchange. In plain English that means that a user can simply long on to a computer, start Outlook and the Active Directory credentials are passed to the Exchange server – no typing or separate logon required. One of the benefits of incorporating Active Directory is that a user does not need to enter that information if authentication is done through AD. Outlook automatically figures out the right email address, you also have the option to bypass this functionality if the need arises. Turn on your device, log in, and your good to go. If getting through your busy work day involves the use of PDA (personal digital assistant) or smartphone, Outlook offers a sync feature. Some vendors don’t even provide a native personal information manager for their devices, but Outlook accommodates. Third party add-on applications for devices like BlackBerry and other various Windows Mobile models offer the capability to communicate with Microsoft Outlook. Other popular products that communicate with Microsoft Outlook are Skype, ACT! and much more. In fact, it is difficult to find a desktop tool that doesn’t talk to Outlook.

4. Outlook simplifies Organizing your Assets

MS Outlook offers the functionality that allows you to sort messages into folders, or redirect them upon customized criteria. There is also the option to send automatic Out of Office (OOO) messages to internal and external recipients. If you need to follow up on a message, Outlook offers flags of various colors that can be tied to reminders if you need friendly reminder. A shortcut folder known as a “Follow Up” accumulates the links of all flagged messages and displays them in a group. Beneficial if you want your boss’s messages to leap out and tap you. With a couple of clicks you can display them in a custom color of your choice in your inbox listing.

5. Incorporate Outlook with SharePoint

Microsoft SharePoint is an essential collaborative application platform that offers tools for building and managing websites, intranets and workspace. Although Microsoft realizes that many users have neither the time nor the mental bandwidth to log onto multiple servers in order to check forum discussions or to examine shared documents. Outlook users can opt to receive notifications of new or changed content by e-mail, and then click through to the SharePoint site. They can also add content to shared workspace or participate in forum discussions by email, thanks to integration with Outlook and Exchange.

6. Outlook Increases Workflow

Outlook’s messaging is not limited to electronic mail. Companies can set up workflows for functions such as voting online. As an example, consider a group that wants to decide on a location for a festive lunch; the coordinator can send a message offering several options. Recipients simply click a voting button within the e-mail message to send their response. Using MS Outlook’s forms feature, things like requests for time off can be automatically routed to approvers, and the reply returned to the user.

7. MS Outlook User Interface

Ever since Microsoft Office has lead the market in productivity software, the interface has stayed consistent and limiting the learning curve. Of course there is still a large amount of functionality to discover, but the basics are relatively intuitive to someone who has used Microsoft Office before. This saves money in training cost and loss time in readjusting to new interface and functionality. With this consistency in the overall design, the development environment has remained relatively easy for developers using Microsoft Visual Studio to interact with Outlook, either by adding functionality or to incorporate it into corporate applications

8. MS Outlook Calendar and Tasks

As a standard Outlook includes address book, calendar, task list and virtual sticky notes for those important reminders. The application is integrated; dragging and dropping an e-mail message can create an appointment or task or a note. Tasks may be delegated with mere clicks. Not only does the responsible outlet get informed of newly assigned tasks, but the delegator can get regular status reports.

9. Secure your Inbox

Microsoft has a bad reputation when it incorporates security to its user-friendly nature. There are benefits of utilizing Outlook as your electronic Post Office: it has a good junk mail filtering, blocks external content such as web bugs and downloaded images and data from foreign sites. It also disallows executable attachments and prevents the execution of ActiveX applets, by default. It also offers the ability to bypass the security features for users who love living on the edge.

10. Outlook Electronic Mail Center

One advantage to using Outlook is that there is no limit to the number of email accounts. There are no restrictions regarding email protocols, and different accounts can feed into the same set of folders, and be managed with one set of rules. There is also the possibility of sorting emails into separate folders by account.

Course Objectives

Learn how to utilize the functions and features to professionally and effectively manage electronic mail, schedule appointments manage meetings, contact information, schedule tasks and create notes.

Course Benefits

Upon completion you will be able to utilize the full functionality that Outlook has to offer.

What Is Microsoft Word

Microsoft Word

Microsoft Word is a non-free commercial word processor designed by Microsoft. It is part of the Microsoft Office suite package. Microsoft Word is currently the most common word processor on the market. Because of its wide spread use the .doc / .docx format has become almost a default for word processor documents.

What is Microsoft Word Used for?

Microsoft Word is a popular word-processing program used for creating documents such as letters, brochures, learning activities, tests, quizzes and students’ homework assignments; it has become an essential tool for anyone writing anything. There are many powerful features available in Microsoft Word to make it easier to learn for students with disabilities.

1. Create Visually Compelling Documents

With the assistance of Microsoft Word you can create compelling documents while applying formatting effects such as shadow, bevel, and glow to your document text. You can spell-check text that uses visual effects in its display, and add text effects to paragraph styles. Many of the same effects used for images are now available to both text objects and shapes, enabling you to seamlessly coordinate all of your content.

2. Turn Your Text into Compelling Diagrams

Word offers you more options to add visual impact to documents. Choose from a multitude of additional SmartArt Graphics to build impressive diagrams just by typing a bulleted list. Use SmartArt to transform basic, bullet-point text into compelling visuals that will display your content professionally.

3. Add Visual Impact to your Document

The new picture-editing tools in Word enable you to add special picture effects without additional photo-editing software. You can easily adjust pictures with color saturation and temperature control options. You also get improved tools for easier and more precise cropping and image correction, to help you turn a simple document into a digital work of art.

Course Objectives

You will learn the fundamentals of Microsoft Word and how to utilize the software efficiently.

Course Benefits

Upon successful completion of the this course you will be able to navigate the application and use fundamental options that will increase productivity and efficiency.

Microsoft SharePoint

Microsoft SharePoint Designer 2007 Level 1

You've created intranet sites using Microsoft® Windows® SharePoint® Services. There will be times when you would want to build sites that lay emphasis on your company's unique requirements and sites that align themselves with the company's unique brand identity. In this course, you will use Microsoft® SharePoint® Designer 2007 to customize your SharePoint sites and build a new subsite on the SharePoint services platform.

Course Objectives

This course will cover the following elements:

Understand SharePoint Designer
Use SharePoint to carry out common tasks
Understand Windows SharePoint services
Explore a SharePoint site
Understand the relationship between Windows SharePoint services and SharePoint server 2007
Consider complications of upgrading customized SharePoint sites
Explore a SharePoint site
Understand the relationship between Windows SharePoint services and SharePoint server 2007
Consider complications of upgrading customized SharePoint sites
Explore the SharePoint designer workspace
Use toolbars
Use task panes
Create a SharePoint site hierarchy
Delete a SharePoint Site
Explore a web page
Insert text, ScreenTips, hyperlinks, web components and images
Add client side interactivity
Create a table layout
Change the default page for web site
Reset a page to the site definitions
Create a basic meeting workspace site
Create a web part page by suing a browser
Create an ASP.NET page
Delete a web page
Create a list
Modify a built in list form page
Insert a web part zone
Add a web part and modify web part properties
Create a list view web part
Customize a list view web part

Course Benefits

Upon success full completion students will be able to:

Understand the basic functionality of SharePoint Designer, Windows SharePoint services, and SharePoint server
Move around the SharePoint site
Understand possible problems when upgrading customized SharePoint sites
Understand the different workspace elements
Work with toolbars and task panes
Create sites by using templates and edit site content
Delete sites that are no longer necessary
Create, edit, format and add content and other elements to web pages
Work with images
Create, format and edit tables
Change the default home page
Reset a page to the site definition
Create and work with a basic meeting workspace
Use browser to create different components of web part pages
Delete and restore web pages.
Create and edit libraries and lists
Change and create list views
Create and work with custom list forms
Insert web part zones
Add, edit and delete web parts
Create and customize web parts

Course Duration: 8 Hours

Microsoft SharePoint Designer 2007 Level 2

Now that you know how to create customized SharePoint sites matching your branding, you may want to extend your sites to include more functionality. With SharePoint Designer, you can extend your sites more easily than before.

Course Objectives

This course will cover the following elements:

Understand master pages
Create a web page from a master page
Customize a master page
Change the default master page
Manage content placeholders and content regions
Reset a master page to the site definition
Understand CSS and color coding options
Identify styles in CSS
Create, modify and delete styles
Use the style application toolbar
Create and attach CSS files
Understand CSS inheritance in SharePoint
Use CSS reports
Understand site definitions and templates
Create a site template
Explore a site template
Test a site template solution
Configure contributor settings Identify contributor settings
Create reports
Back up and restore sites
Explore and import sites
Copy lists and libraries between sites
Copy documents between sties
Understand usability issues
Choose color schemes
Understand accessibility standards and legal issues
Generate accessibility reports
Generate compatibility reports

Prerequisites

To ensure your success it is recommended that students complete the following courses:

Microsoft SharePoint Designer 2007: Level 1

Course Benefits

Upon successful completion students will be able to:

Understand the structure of master pages
Attach and customize master pages
Create customizable ASP.NET pages from master pages
Change the default master page
Manage content placeholders and content regions
Reset a master page to the site definition
Work with the page editor options dialog box
Identify styles used on sites and work with styles
Work with the style application toolbar
Work CSS files
Understand CSS inheritance
Use CSS reports to validate pages on sites
Work with site templates
Test site template solutions
Create, configure, and identify contributor settings
Create reports
Back up, restore, export, and import sites
Copy list, libraries, and documents between sites
Understand usability issues
Choose a user friendly color scheme
Adhere to accessibility standards and legal issues
Generate accessibility and compatibility reports

Course Duration: 16 Hours

SharePoint Application Development

Using Microsoft SharePoint, people can set up Web sites to share information with others, manage documents form start to finish and publish reports to help everyone make better decisions. The capabilities of SharePoint work together to help your company quickly respond to changing business needs. Users can share ideas and expertise, create custom solutions for specific needs, and find the right business information to make better decisions. For Information Technology, SharePoint 2010 helps you cut training and maintenance costs, save time and effort and focus on higher business priorities. This course is intended for developers who work with Microsoft.

Course Objectives

This course will cover the following elements:

Introduction to SharePoint
Understanding Lists
Working with libraries
Communicate and collaborate

Prerequisites

To ensure your success, we recommend that you first take the following have and understand of the following:

Understanding the problem-solving techniques that apply to software development
Approximately 12 months experience with ASP.NET 3.5 with Visual Studio 2008 (or later)
Approximately 1 month development experience with SharePoint 2007 or SharePoint2010 and VS20010 (includes beta releases) creating code that interacts with SharePoint Server-side APIS

Experience performing end users tasks with SharePoint 2007 or SharePoint 2010 and an understanding of the purpose and use of the following:

Lists
Documents and Libraries
Personalizing an SP page/site
Using MySites
Using SharePoint Designer

Course Benefits

Upon successful completion of this course you will be able:

Describe the SharePoint development platform and the benefits and features that it offers to developers.
Use development tools that are integrated with the SharePoint development platform, such as Visual Studio and SharePoint designer
Develop web parts for SharePoint solutions
Develop code that uses the server-side objects provided by the SharePoint development platform
Develop event receivers and manipulate application settings for SharePoint
Develop solutions that access external data by using business connectivity services
Develop workflows as part of SharePoint solutions
Develop code that uses the client-side objects provided by the SharePoint development platform
Develop server ribbon controls and client dialogs for the new user interface platform of SharePoint
Develop Microsoft silverlight applications that are integrated with SharePoint data solutions
Develop sandboxed solutions fo SharePoint
Develop code that uses the taxonomic and user profile services of the Sharepoint development platform
Develop code that uses the content management services of the SharePoint development platform

Course Duration: 40 Hours

Microsoft SQL 2012

Administering Microsoft SQL Server 2012 Databases

This instructor-led course provides students with the knowledge and skills to maintain a Microsoft SQL Server 2012 database. The course focuses on teaching individuals how to use SQL Server 2012 product features and tools related to maintaining a database. All the labs for this course can be performed using the provided virtual machines. However, if you have a Microsoft Windows Azure account and the classroom virtual machines connect to the internet you may be able to connect to your Azure server and database from the classroom. Many of the labs in this course are enabled for you to perform the lab while connected to your own Azure database in the cloud. Your instructor should be able to provide a current list of Azure enabled labs.

Course Objectives

After completing this course, students will be able to:

Plan and install SQL Server.
Describes the system databases, the physical structure of databases and the most common configuration options related to them.
Explain the concept of the transaction log and SQL Server recovery models and implement different backup strategies available with SQL Server.
Create SQL Server Backups.
Restore SQL Server databases.
Use the import/export wizards and explain how they relate to SSIS.
Work with SQL Server security models, logins and users.
Work with fixed server roles, user-defined server roles, fixed database roles and user-defined database roles.
Work with permissions and the assignment of permissions.
Work with SQL Server Audit.
Work with SQL Server Agent, jobs and job history.
Implement SQL Server agent security, proxy accounts and credentials.
Configure database mail, alerts and notifications.
Create database maintenance plans.
Work with SQL Profiler and SQL Trace stored procedures.
Introduce DMVs and the configuration of data collection.
Work with Central Management Servers and Multi-Server queries, Virtualization of SQL Server and Data-Tier Applications.
Troubleshoot SQL Server databases.

Prerequisites

In addition to their professional experience, students who attend this training should already have the following technical knowledge:

Basic knowledge of the Microsoft Windows operating system and its core functionality.
Working knowledge of Transact-SQL.
Working knowledge of relational databases.
Some experience with database design.

Students who attend this training can meet the prerequisites by attending the following courses, or obtaining equivalent knowledge and skills:

Writing T-SQL Queries for Microsoft SQL Server 2012

Course Track

Module 1: Introduction to SQL Server 2012 and its Toolset

Introduction to the SQL Server Platform
Working with SQL Server Tools
Configuring SQL Server Services

Module 2: Preparing Systems for SQL Server 2012

Overview of SQL Server Architecture
Planning Server Resource Requirements
Pre-installation Testing for SQL Server

Module 3: Installing and Configuring SQL Server 2012

Preparing to Install SQL Server
Installing SQL Server
Upgrading and Automating Installation

Module 4: Working with Databases

Overview of SQL Server Databases
Working with Files and Filegroups
Moving Database Files

Module 5: Understanding SQL Server 2012 Recovery Models

Backup Strategies
Understanding SQL Server Transaction Logging
Planning a SQL Server Backup Strategy

Module 6: Backup of SQL Server 2012 Databases

Backing up Databases and Transaction Logs
Managing Database Backups
Working with Backup Options

Module 7: Restoring SQL Server 2012 Databases

Understanding the Restore Process
Restoring Databases
Working with Point-in-time recovery
Restoring System Databases and Individual Files
Work with Point-in-time Recovery.
Restore system databases and individual files.

Module 8: Importing and Exporting Data

Transferring Data To/From SQL Server
Importing and Exporting Table Data
Inserting Data in Bulk

Module 9: Authenticating and Authorizing Users

Authenticating Connections to SQL Server
Authorizing Logins to Access Databases
Authorization Across Servers

Module 10: Assigning Server and Database Roles

Working with Server Roles
Working with Fixed Database Roles
Creating User-defined Database Roles

Module 11: Authorizing Users to Access Resources

Authorizing User Access to Objects
Authorizing Users to Execute Code
Configuring Permissions at the Schema Level

Module 12: Auditing SQL Server Environments

Options for Auditing Data Access in SQL
Implementing SQL Server Audit
Managing SQL Server Audit

Module 13: Automating SQL Server 2012 Management

Automating SQL Server Management
Working with SQL Server Agent
Managing SQL Server Agent Jobs

Module 14: Configuring Security for SQL Server Agent

Understanding SQL Server Agent Security
Configuring Credentials
Configuring Proxy Accounts

Course Benefits

This course will prepare students to pass the Microsoft Exam 70-462 which will earn them credits towards the MCSA / MCSE SQL Data Platform track. The primary audience for this course is individuals who administer and maintain SQL Server databases. These individuals perform database administration and maintenance as their primary area of responsibility, or work in environments where databases play a key role in their primary job. The secondary audiences for this course are individuals who develop applications that deliver content from SQL Server databases.

Course Duration

This course is completed in 40 hours of Hands-on instructor-led classes.

Querying Microsoft SQL Server 2012

This instructor led course provides students with the technical skills required to write basic Transact-SQL queries for Microsoft SQL Server 2012. This course is the foundation for all SQL Server-related disciplines; namely, Database Administration, Database Development, and Business Intelligence. This course helps people prepare for exam 70-461. All the labs for this course can be performed using the provided virtual machines. However, if you have a Microsoft Windows Azure account and the classroom virtual machines connect to the internet you may be able to connect to your Windows Azure server and database from the classroom. Many of the labs in this course are enabled for you to perform the lab while connected to your own Windows Azure database in the cloud. Your instructor will provide a current list of Windows Azure enabled labs. To acquire a trial Windows Azure account click here.

Course Objectives

After completing this course, students will be able to:

Write SELECT queries
Query multiple tables
Use built-in functions
Use subqueries
Execute stored procedures
Use set operators
Implement error handling
Implement transactions
Use table expressions
Sort and filter data
Use window ranking, offset and aggregate functions
Query SQL Server metadata
Program with T-SQL
Improve query performance

Prerequisites

Before attending this course, students must have:

Working knowledge of relational databases.
Basic knowledge of the Microsoft Windows operating system and its core functionality.Before attending this course, students should have:
Basic understanding of virtualization technology (Classroom labs utilize virtual machines)

Course Track

Module 1: Introduction to Microsoft SQL Server 2012

Introducing Microsoft SQL Server 2012
Getting Started with SQL Server Management Studio

Module 2: Getting Started with SQL Azure

Overview of SQL Azure
Working with SQL Azure

Module 3: Introduction to T-SQL Querying

Introducing T-SQL
Understanding Sets
Understanding Predicate Logic
Understanding the Logical Order of Operations in SELECT statements

Module 4: Writing SELECT Queries

Writing Simple SELECT Statements
Eliminating Duplicates with DISTINCT
Using Column and Table Aliases
Writing Simple CASE Expressions

Module 5: Querying Multiple Tables

Understanding Joins
Querying with Inner Joins
Querying with Outer Joins
Querying with Cross Joins and Self Joins

Module 6: Sorting and Filtering Data

Sorting Data
Filtering Data with a WHERE Clause
Filtering with the TOP and OFFSET-FETCH Options
Working with Unknown and Missing Values

Module 7: Working with SQL Server 2012 Data Types

Introducing SQL Server 2012 Data Types
Working with Character Data
Working with Date and Time Data

Module 8: Using Built-In Functions

Writing Queries with Built-In Functions
Using Conversion Functions
Using Logical Functions
Using Functions to Work with NULL

Module 9: Grouping and Aggregating Data

Using Aggregate Functions
Using the GROUP BY Clause
Filtering Groups with HAVING

Module 10: Using Subqueries

Writing Self-Contained Subqueries
Writing Correlated Subqueries
Using the EXISTS Predicate with Subqueries

Module 11: Using Table Expressions

Using Derived Tables
Using Common Table Expressions
Using Views
Using Inline Table-Valued Functions

Module 12: Using Set Operators

Writing Queries with the UNION Operator
Using EXCEPT and INTERSECT
Using APPLY

Module 13: Using Window Ranking, Offset and Aggregate Functions

Course Benefits

This course prepares students to pass the Microsoft exam 70-641 which is a credit towards the MCSE - Data Platform certification. This course is intended for Database Administrators, Database Developers, and Business Intelligence professionals. The course will very likely be well attended by SQL power users who aren’t necessarily database-focused or plan on taking the exam; namely, report writers, business analysts, and client application developers.

Course Duration

This course is taught in 40 hours of hands-on instructor-led training sessions.