MCITP Training Package ( EC110206 )

Price: £500

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.

MCITP Qualifications: MCITP Certification Course Packages :

Certification	Required Exams
MCITP: Windows Client
MCITP: Enterprise Support Technician (Windows 7)	70-680 70-685 (in development) 70-686 (in development)
MCITP: Enterprise Support Technician (Vista)	70-620 70-622
MCITP: Windows Server
MCITP: Enterprise Administrator Server 2008	70-640 70-642 70-643 70-647 plus either 70-620 or 70-680
MCITP: Server Administrator 2008	70-640 70-642 70-646
Microsoft Office Project Server
MCITP: Enterprise Project Management with Microsoft Office Project Server 2007	70-632 70-633/4 (in development)
Microsoft Exchange Server
MCITP: Enterprise Messaging Administrator on Exchange 2010	70-662 70-663/4 (in development)
Microsoft SQL Server
MCITP: Database Administrator 2008	70-432 70-451 (in development)
MCITP: Database Developer 2008	70-433 70-451 (in development)

Windows Server 2008 Enterprise Admin MCITP 70-647 - Duration: 29 Hours

Name Resolution and IP Addressing Duration 3 Hour(s)
Network Access Strategy Duration 3 Hour(s)
Active Directory Forests and Domains Duration 3 Hour(s)
Enterprise-Level Group Policies Duration 2 Hour(s)
Identity and Access Management Duration 2 Hour(s)
Branch Office Deployment Duration 3 Hour(s)
Certificate Services and PKI Duration 3 Hour(s)
Server Virtualization Duration 2 Hour(s)
Business Continuity and High Availability Duration 2 Hour(s)
Software Updates and Compliance Management Duration 2 Hour(s)
Practice Exams Duration 4 Hour(s)

SQL Server 2008 Maintenance MCSA/MCTS 70-432 - Duration: 26 Hours

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.
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.
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.
Managing Security Duration 1 Hour(s)
- This course covers all aspects of managing security for Microsoft SQL Server 2008.
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.
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.
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.
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.
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.
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.
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.
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.
Performance Tuning Duration 2 Hour(s)
- This course covers troubleshooting and performance tuning tools and processes you can use with SQL Server 2008 implementations.
Practice Exams Duration 4 Hour(s)

Microsoft SQL Server 2005 Data Access MCITP 70-442 - Duration: 13 Hours

Designing Data Access Duration 1 Hour(s)
- 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
Optimising Indexing Strategies Duration 1 Hour(s)
- This course covers optimising data storage for best performance by using proper design and selecting optimal data types.
Scaling Out Applications Duration 1 Hour(s)
- This course covers the requirements of designing applications so they can be scaled out to the enterprise level.
Resolving Performance Problems Duration 1 Hour(s)
- This course covers tuning database application performance at the server level.
Practice Exams Duration 3 Hour(s)

Microsoft Windows Vista Enterprise Support MCTS/MCITP 70-622 - Duration: 8 Hours

Deploying Windows Vista 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)
- Troubleshoot policy settings Configure the Task Scheduler Apply updates Troubleshoot performance issues
Configuring and Troubleshooting Networking Duration 1 Hour(s)
- Configure Windows networking Troubleshoot networking issues e
Supporting and Maintaining Desktop Applications Duration 1 Hour(s)
Practice Exams Duration 3 Hour(s)

Microsoft Windows Vista Configuration MCTS 70-620 - Duration: 14 Hours

Installing and Upgrading 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
Practice Exams Duration 3 Hour(s)

Server 2008 Networking MCTS/MCITP 70-642 - Duration: 8 Hours

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

Server 2008 Applications MCTS/MCITP 70-643 - Duration: 8 Hours

Deploying Servers Duration 1 Hour(s)
- 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
Configuring Terminal Services Duration 1 Hour(s)
- 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
Configuring Network Application ServicesConfiguring Network Application Services Duration 1 Hour(s)
- 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.

		Job Prospects Become fully trained and substantially improve your chances of employment or earn more money!
		Interactive simulations Feel like you are actually using the software you are being trained about in the added security of our learning environment.
		Skills Assessments Test yourself and receive a certificate online. Multiple choice or fill in the blanks style questioning helps you remember and learn.
		Printable reference guides and exercises Every chapter has its own hands on exercises for you to carry out to help you gain essential experience. You also have automatic glossary and search features to help you use the course as a 'quick reference' guide.
		Full telephone and email support with no premium rate charges Our friendly support team is here on hand 24hrs a day from Monday to Friday to help you out if you get stuck.
		Free upgrades for 12 months For the duration of your 12 months license you will receive any updates we make to your course free of charge. Sign up for our complete package and you will be able to receive all the new courses we add free of charge.
		Call us for best prices We are so confident that you will not find another online training service of the same quality and price that we will try to not only to match any legitimate quote but beat it by 10%. Please ring one of our sales agents to take advantage of this offer 01279 814 876.

e-Careers

Find A Course!

MCITP Training Package ( EC110206 )

Course Catalogue

Exams & Testing

Testimonials

Quick Enquiry

Our Courses

About us

support

Connect with us

Learning Awards

	Microsoft Certified IT Professional
	Course Completion Certificate