Welcome to the e-Learning MCITP Training Package course powered by XYZ.co.uk. Classroom versions of this course are also available. If you would like us to host a e-Learning MCITP Training Package course at your premises, at a location, date and time of your choosing – then please complete this form.
e-Learning MCITP Training Package
At eLearning.co.uk all of our courses are delivered online. This gives you the opportunity to study at your own pace and within your own time. Online learning allows you to study in the evenings, weekends, or even the odd hour during the day! With each course you will have full tutor and technical support available via the telephone and by e-mail – so you are not on your own by any means. This e-Learning MCITP Training Package course will award you with the same certification as the classroom version of this course – usually for a cheaper cost and with the additional benefit of flexible study times!
Once you’ve decided to go ahead and enrol on this e-Learning MCITP Training Package course, you will receive an e-mail shortly after containing your user name and password, receipt of payment and full course joining instructions. Use this with the link/url provided in the e-mail and you can log into the online training system and begin learning right away. This e-Learning MCITP Training Package online learning course will use various interactive features and different types of media to enable you to stay engaged whilst learning. The course has been designed to be simple to follow and solely with the user in mind – so don’t worry about the technical side of things.
If you want to learn a little more about e-Learning in general, watch the video below. If you want to know more about your chosen course, please scroll down.
About the course
The MCITP: Microsoft Certified IT Professional: Database Developer (MCITP: Database Developer) certification training.
This SQL focused MCITP demonstrates that you can design a secure, stable, enterprise database solution by using Microsoft SQL Server.
Microsoft SQL Server 2008 Maintenance MCTS 70-432: New Features in SQL Server 2008 – Duration 1 Hour(s)
This course covers the new features in SQL Server 2008. There are quite a few enhancements to SQL Server, many of which will make the job of the DBA much easier. One of these, the new performance data management system, allows for database statistics and performance information to be automatically captured across an enterprise.
Microsoft SQL Server 2008 Maintenance MCTS 70-432: Installing SQL Server 2008 – Duration 2 Hour(s)
This course covers the installation of SQL Server 2008. More specifically, it reviews the features, capabilities, and limitations of each edition and type of installation. Planning an installation and best practices for hardware utilization are also discussed.
Microsoft SQL Server 2008 Maintenance MCTS 70-432: Configuring SQL Server 2008 - Duration 2 Hour(s)
This course explores using multiple SQL Server instances and managing connection protocols and service accounts with Configuration Manager. It also covers some key configuration options and how to set them using sp_configure and Management Studio as well as how to set up and use Database Mail and manage Full-Text Indexes.
Microsoft SQL Server 2008 Maintenance MCTS 70-432: Managing Security – Duration 1 Hour(s)
This course covers all aspects of managing security for Microsoft SQL Server 2008.
Microsoft SQL Server 2008 Maintenance MCTS 70-432: Managing Data Encryption – Duration 1 Hour(s)
This course covers using encryption in SQL Server 2008. This includes using Transparent Data Encryption, Encrypting File System, and Extensible Key Management.
Microsoft SQL Server 2008 Maintenance MCTS 70-432: Managing High Availability – Duration 2 Hour(s)
This course describes how high availability ensures that your application is always available. High availability incorporates such technologies as clustering, mirroring, log shipping, and replication.
Microsoft SQL Server 2008 Maintenance MCTS 70-432: Maintaining Your Database – Duration 3 Hour(s)
This course covers the SQL Server features you use to perform ongoing maintenance tasks to keep your databases functioning well.
Microsoft SQL Server 2008 Maintenance MCTS 70-432: ETL Techniques – Duration 3 Hour(s)
This course covers ways to extract, transform, and load data using SQL Server 2008. SQL Server provides many tools for your ETL needs.
Microsoft SQL Server 2008 Maintenance MCTS 70-432: Managing Replication – Duration 2 Hour(s)
This course covers various replication technologies. This course discusses copying and distributing data between databases and then synchronizing them to maintain consistency and integrity.
Microsoft SQL Server 2008 Maintenance MCTS 70-432: Monitoring and Troubleshooting – Duration 1 Hour(s)
This course covers the tools and techniques you can use to monitor SQL Server and troubleshoot any problems that arise.
Microsoft SQL Server 2008 Maintenance MCTS 70-432: SQL Server XML Support – Duration 1 Hour(s)
This course covers ways that SQL Server 2008 supports XML. It also discusses the use of HTTP endpoints and Web services.
Microsoft SQL Server 2008 Maintenance MCTS 70-432: Service Broker – Duration 2 Hour(s)
This course covers what SERVICE BROKER is, how to set it up, and how to test to be sure it’s functioning. This course also discusses message queuing with SQL Server.
Microsoft SQL Server 2008 Maintenance MCTS 70-432: Performance Tuning – Duration 2 Hour(s)
This course covers troubleshooting and performance tuning tools and processes you can use with SQL Server 2008 implementations.
Microsoft SQL Server 2008 Maintenance MCTS 70-432: Practice Exams – Duration 4 Hour(s)
Practice Exam 1
This course presents questions that will help you prepare for the Microsoft SQL Server 2008 Maintenance MCTS 70-432 exam. The feedback for each question provides in-depth background on the topic, including why each incorrect option was wrong and what to look for in correct answers.
Practice Exam 2
This course presents questions that will help you prepare for the Microsoft SQL Server 2008 Maintenance MCTS 70-432 exam. The feedback for each question provides in-depth background on the topic, including why each incorrect option was wrong and what to look for in correct answers.
Practice Exam 3
This course presents questions that will help you prepare for the Microsoft SQL Server 2008 Maintenance MCTS 70-432 exam. The feedback for each question provides in-depth background on the topic, including why each incorrect option was wrong and what to look for in correct answers.
Practice Exam 4
This course presents questions that will help you prepare for the Microsoft SQL Server 2008 Maintenance MCTS 70-432 exam. The feedback for each question provides in-depth background on the topic, including why each incorrect option was wrong and what to look for in correct answers.
Design appropriate data access technologies Design an appropriate data access object model Design a cursor strategy for a data access component Design caching strategies
Designing Application Access – Duration 1 Hour(s)
Design client libraries to write applications that administer a SQL Server service Design queries that use multiple active result sets
Designing Queries – Duration 1 Hour(s)
Write queries Modify queries to improve query performance Design queries for retrieving data from XML sources
Using Cursors – Duration 1 Hour(s)
This course covers the appropriate use of cursors in SQL Server 2005.
Planning Error Handling – Duration 1 Hour(s)
Design code that validates input data and permissions Design code that detects and reacts to errors Design user-defined messages to communicate application events
Planning a Transaction Strategy – Duration 1 Hour(s)
Manage concurrency by selecting the appropriate transaction isolation levels Design the locking granularity level Design transaction scopes Design code that uses transactions
Optimising and Tuning Queries for Performance – Duration 1 Hour(s)
Optimise and tune queries for performance Evaluate query performance Detect locking problems Modify queries to Optimise client and server performance Rewrite subqueries to joins Design queries that have search arguments Convert single-row statements into set-based queries
Select an appropriate deployment method Prepare a system for installation or upgrade Deploy Windows Vista Perform post-installation tasks and troubleshooting
Managing Windows Vista Security – Duration 1 Hour(s)
Troubleshoot security configuration issues Troubleshoot Windows firewall issues Apply security patches and updates Troubleshoot user access issues
Managing and Maintaining Windows Vista Systems – Duration 1 Hour(s)
Select an appropriate deployment method Prepare a system for installation or upgrade Deploy Windows Vista Perform post-installation tasks and troubleshooting
Managing Windows Vista Security – Duration 1 Hour(s)
Troubleshoot security configuration issues Troubleshoot Windows firewall issues Apply security patches and updates Troubleshoot user access issues
Managing and Maintaining Windows Vista Systems – Duration 1 Hour(s)
Identify Windows Vista installation methods Check for and install Windows Vista fixes, patches, and service packs Upgrade Windows Vista to another version of Windows Vista Use the Windows Upgrade Advisor Activate and Repair a Windows Vista installation
Interface and Device Options – Duration 1 Hour(s)
Identify parts of the desktop used in Windows Vista Use the Control Panel to configure certain aspects of Windows Vista Load and manage device drivers List the requirements for Windows Aero Use the Ease of Access Center to enable accessibility technology
Advanced Networking – Duration 1 Hour(s)
Define and use TCP/IP addressing Diagnose network problems Use a wireless connection and identify the technology and security associated with it Set up remote access through dial-up and broadband
NTFS Security Features and File Sharing – Duration 1 Hour(s)
List and describe the advantages and permissions of NTFS Configure NTFS permissions Encrypt files using the Encryption File System (EFS) Compress and share a folder using Windows Explorer
User Account Security – Duration 1 Hour(s)
Describe the difference between standard, administrator, and guest accounts Using the User Accounts console, create and manage users Describe the purpose of UAC and how it affects users using the computer Enable, disable, and configure UAC Configure legacy software to work with Windows Vista
Network Security – Duration 1 Hour(s)
List the symptoms of a system infected by spyware Configure a computer to resist spyware Given a computer with spyware, use Windows Defender to remove the spyware Use Software Explorer to configure items not loaded during startup Configure and use Windows Firewall to protect your computer from unauthorized access
Internet Explorer 7.0 – Duration 1 Hour(s)
Demonstrate how to zoom in and out within Internet Explorer Configure common Internet Explorer options Configure Internet Explorer security Enable Protected mode in Internet Explorer Configure RSS feeds for Internet Explorer
Maintenance and Optimization – Duration 1 Hour(s)
Use the Windows Reliability and Performance Monitor and Task Manager to identify bottlenecks Run Chkdsk and Disk Defragmenter to Optimise and verify the integrity of the drive Describe, enable, and configure ReadyBoost and ReadyDrive Run multiple troubleshooting tools and configure the paging file for optimum performance Use Event Viewer to view errors and warnings when troubleshooting a problem
Media Applications – Duration 1 Hour(s)
Configure your system, Windows Media Player, and Windows Media Center to be as secure as possible Describe what a codec is and how it relates to Windows Media Player Describe what a region is and how it relates to Windows Media Player
Productivity Applications – Duration 1 Hour(s)
Use WordPad and Notepad to create and modify files Secure and access e-mail using Windows Mail Use Windows Calendar to organize appointments, set reminders, and set tasks Use Windows Fax and Scan to fax and scan documents Use Windows Meeting Space to conduct meetings and share documents during the meeting Configure the Windows Sidebar and its gadgets
Mobile Computers – Duration 1 Hour(s)
Configure Power Management to balance performance and battery life Use the battery meter to monitor power levels Use the Sync Center to synchronize offline files and connect mobile devices Describe the use and features of Presentation mode and Windows SideShow Configure Windows Vista to support Tablet PCs, including configuring flicks
Configuring IP Addressing and Services – Duration 1 Hour(s)
Explain IPv4 addressing and subnetting Examine IPv6 addressing Explain DHCP functionality Install a DHCP server and configure scopes Examine DHCP options, reservations and exclusions Differentiate static and dynamic routing Describe routing tables Discuss RIP, OSPF and border routing Describe IPSec security features Explain security policies Create an IPSec policy in a GPO
Configuring Name Resolution – Duration 1 Hour(s)
Define DNS Describe the Domain Namespace Compare different types of DNS server deployment Differentiate DNS zone types Illustrate DNS zone creation Discuss DNS resource records Configure DNS resource records Discuss configurable record options Summarize how clients are configured with DNS server list Discuss DNS suffix Discuss alternate name resolution
Configuring Network Access – Duration 1 Hour(s)
Discuss dial-up networking Explain and configure RRAS Describe VPN Discuss NAT List the individual components of this new Windows platform Describe LAN, Wireless, and Remote Access authentication methods Explain wireless connection modes Discuss wireless encryption methods Differentiate Windows Firewall and Windows Firewall with Advanced Security Discuss firewall profile options Describe incoming and outbound traffic filters
Configuring File and Print Services – Duration 1 Hour(s)
Discuss and configure file sharing Examine and set file permissions Explain file encryption Describe and configure DFS Explain DFS namespace Discuss DFS replication Configure Shadow Copy Services List backup types Plan and configure backup schedules Illustrate data restore process Examine and configure disk quotas Discuss options for setting user quotas Identify options for printer sharing Discuss and configure printer permissions and priorities Describe print queue monitoring
Monitoring and Managing a Network Infrastructure – Duration 1 Hour(s)
Explain how Windows Update works Discuss the benefits of Windows Server Update Services (WSUS) Examine the options for configuring WSUS Describe the features of Performance Monitor Explain the System Stability Index Discuss the benefits of using Data Collector Sets Describe the features and functions of the Event Viewer Describe how Custom Views are created Discuss DNS debug logging Explain and configure SNMP Describe the features and operation of Microsoft Baseline Security Analyzer (MBSA) Discuss the operation of Network Monitor
Mock testing and practice exams 1, 2 & 3 – Duration 3 Hour(s)
Encrypt data on a hard disk by using Encrypting File System (EFS) Implement, configure, manage, and troubleshoot local security policy Implement, configure, manage, and troubleshoot a security configuration
Create an IFM file Assign boot and installation images Create capture and discover images Create a MAK Describe a KMS server Identify the features of SLMGR Describe components Explain relocating Achieve optimization Summarize clustering Describe Network Load Balancing Describe RAID types Define Virtual Disk Specification (VDS) Discuss APIs Select SAN protocols
Discuss Remote Desktop Web Connection Deploy applications for Web Access Explain server configuration Define network policies Describe monitoring Describe Group Policy Describe methods of Load Balancing Use the Terminal Services Broker Explain Windows Server Resource Manager Describe application logging Define License Servers Explain Client Access Licenses (CAL) List Local Resources Explain Consistent Experience Describe Client Software Explain Terminal Services Manager Utilize Terminal Services Configuration
Configuring a Web Services Infrastructure – Duration 2 Hour(s)
Describe IIS architecture Describe Web application integration Publish applications Improve integration Expand security Detail Logging Create Web sites Migrate Web sites Configure the local SMTP server Configure site and application SMTP preferences Back up data Tune performance of IIS Delegate administrative rights Install certificates Maintain certificates Configure permissions Enable Client Certificate Mappings
Configure an Origin Server Configure a Cache/Proxy Server Create DRM media Play DRM media Configure an initial installation Create sites Back up sites Configure global e-mail parameters Configure specific e-mail parameters
Mock testing and practice exams 1, 2 & 3 – Duration 3 Hour(s)
This course presents questions that will help you prepare for the MCTS 70-643 exam. The feedback for each question provides in-depth background on the topic, including why each incorrect option was wrong and what to look for in correct answers.
Qualification
Microsoft Certified IT Professional
Course study options
Course Study Format
This course is delivered through online method. The course is available for you to complete at your convenience over a 12 month period.
IT Training Course Tutor Support
Home study courses include step by step online training and keyword search facilities.
Our Interactive online IT Training courses will take you step by step though your chosen eLearning courseware using show and ask training methods.
Study Hours
This is only an approximate figure and is dependent upon how much time you can dedicate to your studies and how well you grasp the learning concepts in the course material.
Technical Requirements
Windows: Windows 98, 2000, XP, Vista, Windows 7 – Acrobat Reader 4.0 and above
OR
Macintosh: Mac OS X, Mac OS 9.2 – Acrobat Reader 4.0 and above
An up to date internet browser such as Internet Explorer, Mozilla Firefox, or Safari.
Internet connection (broadband recommended.)
Cost - Per Person
£ 500 + VAT
Make An Enquiry Or Book This Training Here
Please use the form below to book or make an enquiry for this eLearning eLearning MCITP Training Package training course
