Microsoft Certified IT Professional - Database Administrator

Microsoft Certified IT Professional - Database Administrator
Course Code: UCCVITITC02
Enrolment Fee: £311.25  £249.00
Format: Online
Award: Ex 70-432, 70-450
Accreditation: UKLC
Study Time: 100 Hrs
Experience: No Entry Requirements

  • 20% discount if you pay in full this month
  • Free Postage & Packing
  • Free Learning for Life Package
  • Pay in Full or Instalments

Please Choose:

Payment Options



COURSE OVERVIEW


A distance learning course is the ideal way to gain a qualification in Microsoft Certified IT Professional (MCITP) - Database Administrator. Whether you're looking to go on to further education, improve your job prospects or expand your knowledge, distance learning Microsoft Certified IT Professional (MCITP) - Database Administrator is a flexible and convenient course, which allows you to comprehensively prepare for an exam or career through home study. What's more, because the distance learning Microsoft Certified IT Professional (MCITP) - Database Administrator course is a fully comprehensive course, no prior knowledge is required.

Microsoft Certified IT Professional - Database Administrator (MCITP: 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. They 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. 


Key TopicsWhat are the key topics?

Course Key Topics 

 

SQL Server 2008 - Implementation and Maintenance (70-432) Training Course Curriculum:

Module 1 - Installing SQL Server

Module 2 - Configuring SQL Instances

Module 3 - Managing Databases

Module 4 - Disaster Recovery

Module 5 - Security

Module 6 - Indexes

Module 7 - Optimizing Performance

Module 8 - High Availability


SQL Server 2008 - Designing, Optimizing and Maintaining a Database Administrative Solution (70-450) Training Course Curriculum:

Module 1 - Configuring SQL Server

Module 2 - Designing Secure SQL Server Solutions

Module 3 - Designing Highly Available SQL Server Solutions

Module 4 - Designing Disaster Recovery Solutions

Module 5 - Designing Data Distribution

Module 6 - Monitoring SQL Server

 



(see full course syllabus below for more information) 

AssessmentsHow will I be assessed?

Course Assessments


 

Our MCITP Database Administrator 2008 Training Package includes the following exams:

70-432

70-450

The Microsoft Certified IT Professional: Database Administrator 2008 (MCITP: Database Administrator 2008) certification training course from QuickCert enables students with the knowledge and skills needed to manage or maintain databases or multidimensional databases, user accounts, database availability, recovery, and reporting.

Database Administrators design or implement security or server automation and monitor and troubleshoot SQL Server activity. They are typically employed by mid-sized to large organizations.

You can be certain that our comprehensive MCITP: Database Administrator 2008 training courses will provide you with all the tools necessary to successfully prepare for your MCITP: Database Administrator 2008 certification.   

 

 

 

 

 


Testing Centres

Prometric Test Centres

Prometric offers the most extensive, professional and secure testing network in the world where tests are delivered in over 160 countries in over 7,500 locations.

Prometric Authorized Professional Testing Centres: A network of over 4,000 testing centres that mostly deliver exams that lead to certifications for many of the IT industry’s leading companies such as Microsoft, CompTia, Apple, HP, Oracle and many others.

Find a Prometric Test Centre  (Testing for 3Com, Adobe, APC, Apple, Cisco, CIW, CompTIA, CTI, CTP, HP, IBM, intel, Linux, Lotus, Macromedia, Microsoft, Novell, Oracle, Sun, Symantec, XML & more... )

http://securereg3.prometric.com/

Pearson VUE® Authorized Test Centers

The largest global test center network available with over 4,400 test centers in more than 160 countries. Prior to testing, Pearson VUE Authorized Test Centers must sign a pre-arranged agreement, meet hardware requirements and provide a certified test administrator. In addition to this, Pearson VUE performs on-going quality control measures to ensure program integrity.

Find a Pearson VUE Test Centre  (Testing for Adobe, Cisco, CIW, CompTIA, CTP, Linux, MySQL, Novell, SAP, Sun & more... )

http://www.vue.com/servlet/vue.web2.core.Dispatcher?webContext=CandidateSite&webApp=TestCenterLocator
&requestedAction=register

Find a Certiport Microsoft Office Test Centre

http://www.certiport.com/Portal/Pages/LocatorView.aspx


 


 

Course DurationHow long will it take me to complete?

Course Duration


We recommend you spend approximately 100 hours of your time studying for the Microsoft Certified IT Professional (MCITP) - Database Administrator course. The pace of study is completely up to you. To give an example, if you dedicate 2 hours a week to the course it would take you a year to complete but  if you could spare 4 hours a week you could complete it in six months.

Get started today, and you can earn your Microsoft Certified IT Professional (MCITP) - Database Administrator certification in as little as six months, or take up to a year, if you prefer – the choice is yours.



Enrolment FeesHow much are the course fees?

Course Enrolment Fees


Our aim is to provide you with the best deal available, therefore the registration fee, certification fee and full tutor support is included in the course price for you. The enrolment fee for the Microsoft Certified IT Professional (MCITP) - Database Administrator home study course is £311.25, though for a limited time we are offering you the opportunity to pay only £249 which is a 20% discount if you enrol online and pay in full.

 

Please note that examination fees are additional to course fees. 
 

 


 

Full Course SyllabusWhat will I learn?

How is the course structured?


 MCITP Database Administrator SQL Server 2008 Certification Training:

SQL Server 2008 - Implementation and Maintenance (70-432) Training Course Curriculum:

Module 1 - Installing SQL Server

  • Services and Installation Process
  • Installing SQL Server
  • Module Review

Module 2 - Configuring SQL Instances

  • Common Server Options
  • Database Mail
  • Module Review

Module 3 - Managing Databases

  • Recovery Models
  • Partitions
  • Encryption and Compression
  • Module Review

Module 4 - Disaster Recovery

  • Backups and Restores
  • Database Snapshots
  • Module Review

Module 5 - Security

  • Authorization
  • Policies
  • Database and Server Level Triggers
  • SQL Server Auditing
  • Module Review

Module 6 - Indexes

  • Specialized Indexes
  • Module Review
  • Concurrency
  • Monitoring Locks
  • Module Review

Module 7 - Optimizing Performance

  • SQL Server Profiler
  • Data Collector
  • Resource Governor
  • Module Review
  • Maintaining a SQL Server Database
  • Automating SQL Tasks
  • Maintenance Plans
  • Importing/Exporting Data
  • Module Review

Module 8 - High Availability

  • Database Mirroring
  • Log Shipping
  • Replication
  • Module Review

Course Review and Exam Tips

70-432 Demo Scripts

SQL Server 2008 - Designing, Optimizing and Maintaining a Database Administrative Solution (70-450) Training Course Curriculum:

Module 1 - Configuring SQL Server

  • Module Overview
  • Hardware Configuration
  • Windows Configuration
  • Instance Configuration
  • Database Configuration
  • Maintaining SQL Server
  • Upgrading
  • Module Review

Module 2 - Designing Secure SQL Server Solutions

  • Module Overview
  • Authentication
  • Authorization
  • Encryption
  • Policies
  • SQL Server Auditing
  • Module Review

Module 3 - Designing Highly Available SQL Server Solutions

  • Module Overview
  • Failover Clustering
  • Database Mirroring
  • Log Shipping
  • Combining Solutions
  • Module Review

Module 4 - Designing Disaster Recovery Solutions

  • Module Overview
  • Backup Strategies
  • Recovery Strategies
  • Piecemeal Backup and Restore
  • Recovering Pages
  • Media Failure
  • Database Snapshots
  • Module Review

Module 5 - Designing Data Distribution

  • Module Overview
  • SQL Server Integration Services
  • Replication
  • Module Review

Module 6 - Monitoring SQL Server

  • Module Overview
  • Windows Resources
  • SQL Resources
  • Resource Governor
  • Module Review
  • Course Review
  • Exam Tips

 


QualificationsWhat qualifications will I receive?

Course Qualifications


 Qualification: MCITP Database Administrator

 


 

 


 

Career ProspectsWhat can I do after I qualify?

Database Administrator


Database administrators (commonly referred to as DBAs) plan and build computer systems. They also make sure they are secure and working properly.To be able to do this job you should have an excellent understanding of computer systems. You will need a high level of accuracy and attention to detail. You will also need strong problem-solving and organisational skills.For most administrator jobs, you would need to know how to use database management systems. Employers often look for previous experience in computing such as IT support, programming or web development.
 


  SEE A FULL CAREER PROFILE 


What's IncludedWhat do I get when I enrol?

Your course fee covers everything you will need to successfully complete the Microsoft Certified IT Professional (MCITP) Database Administrator home study course and earn your Qualification:


Self Paced CBT

Our Computer Based Training is divided into courses, which are divided into units. Each unit consists of a well-defined set of learning objectives, a series of interactions that teach the stated objectives, and a means for evaluating whether the learning objectives have been met.

Instructional Design Principles

Our courses are based on sound principles from research in instructional design, adult learning, and information processing. We believe that for training to be effective, the learner must view the training as meaningful and relevant. The learner must be engaged as an active participant.

Instructor-Led Training

This combines both the convenience and affordability of computer-based training with the effectiveness of a traditional classroom setting. The instructors featured in our multi-media CD's are not only certified in their area of expertise, but also have years of real world experience and are subject matter experts in their fields.   Our courses feature video modules of our instructors teaching the information directly to you.   This creates a personal learning experience and simulates the benefits of classroom learning- without leaving the comfort of your home.

Full motion video

Each class is presented in full motion video allowing you to see the steps, hear the explanations, and perform the tasks which includes our interactive hands-on training simulations, students will learn from real-world scenarios taught by our expert instructor.

Navigation and Controls

Our self-paced elearning courseware is designed to give you the freedom to proceed through each training class at your own pace.  Courses are arranged in sections, with navigation and controls that allow you to fast forward, skip, go back, stop, restart, and control the pace of your training.  You can stop at any time and easily find where you left off in your training.

Practice Tests and Exam Simulators

We incorporate practice tests and certification exam simulators into all of our courseware.  The flexibility of our practice tests and exam simulators allow you to apply your knowledge and test what you have learned, ensuring you have the skills and confidence needed to pass your exams - the first time.

Hands-on Lab Simulation

Our courseware includes instructor-led demonstrations and hands-on lab exercises that allow you to practice what you learn in a fully functional, simulated environment.  You will learn how to implement what you have learned to build skills for your chosen area of study and to pass your exams.

Our training system employs the next generation learning curriculum. Our courses include hands-on lab exercises that allow you to practice what you learn in a fully functional, simulated environment. You'll learn how to implement and utilize your knowledge to build the skills you need for your chosen area of study and to pass your exams.  Hands-on Lab Simulation is a crucial component of your IT training. Practice make perfect. Step-by-step hands-on labs with detail instructions are included to reinforce all key concepts. When you complete a topic, choose the Lab Simulation button to select the associated hands-on lab exercises. Labs allow you to reinforce concepts by performing the tasks you've just learned.

Digital Video/Audio Presentations

Our courses are developed using the latest in digital video/audio technology. Setting the standard for IT training, our courses provide you something no one else can - next generation, interactive, and effective training solutions. Do not accept any training unless it meets the high standards we offer - you deserve the best training there is!

Multimedia Presentations

Incorporating PowerPoint, Flash animations, charts, graphs, graphics and other relevant course material enhances the user experience of our computer based training modules.  The use of multimedia reinforces key learning material and creates a more stimulating user experience.

Realistic Simulations

So you can see how the application really works. All Courses also include pre and post-test which identifies individual strengths and weaknesses, allowing you to take only the units you haven't mastered and test how well you've mastered the completed Module.

Vendor Approved Curriculum

ReTrain for IT’s  Computer-Based-Training modules have been designed in partnership with Microsoft, CompTIA and the EC Council and incorporate the official approved curriculum, guaranteeing you receive the appropriate information and training needed to get you certified.


 


 

Home Study ExplainedHow does home study work and is it right for me?

Distance Learning Explained


Distance Learning is a term used to describe a method of learning where you; the learner, are not physically required to be ‘onsite’ to be guided through learning materials. Learners and tutors will use methods such as email and telephone to communicate, with you deciding how, when and where you learn.
 
UK Learning College gives you the flexibility to complete our programmes as quickly or as slowly as is convenient for you. To make this possible, our learning programmes have been written and prepared in such a way that it enables you to take control over these decisions.  We also have a varied range of e-learning courses available to complement our full portfolio of distance learning courses.
 
Distance Learning allows you to develop the personal confidence and independence needed for success. Once you have become familiar with your distance learning course materials and you feel you know your way around the programme, then it is time to put together your own personal study plan to help you decide how best to study. We would advise that you write down your plan to assist you in following your timetable.
 
Although our distance learning course guides are primarily aimed at the first time user, you may already have some experience of distance learning. Whatever your experience, it is important to understand that to be a successful distance learner you need to become familiar and comfortable with the learning materials.
 
Online Learning Explained

Online learning descends from computer-based training, interactive multimedia and integrated learning centers and is the delivery of a learning, training or education program by electronic means.  With the internet boom in the mid '90s, the concept of online learning has spread broadly. 
 
Online learning or e-learning (electronic learning) is a term used to describe learning materials that are not physically provided to you, but are accessible online where you; the learner, are not physically required to be ‘onsite’ to be guided through any of these online learning materials. Learners and tutors will use methods such as email and telephone to communicate, with you deciding how, when and where you learn.
 
UK Learning College gives you the flexibility to complete our online courses as quickly or as slowly as is convenient for you. To make this possible, our online learning courses have been written and prepared in such a way that they enable you to take control over these decisions.
 
Online learning allows you to develop the personal confidence and independence needed for success. Once you have become familiar with your online course and you feel you know your way around the program, then it is time to put together your own personal study plan to help you decide how best to study. We would advise that you write down your plan to assist you in following your online course study timetable.
 
Home Study Explained

Home Study Courses are a type of learning material in the form of manuals, CD Roms, Online courses etc. where you; the learner, are not physically required to be ‘onsite’ to be guided through any of these learning materials. Learners and tutors will use methods such as email and telephone to communicate, with you deciding how, when and where you learn.
 
UK Learning College gives you the flexibility to complete our home study courses as quickly or as slowly as is convenient for you. To make this possible, our home learning courses have been written and prepared in such a way that they enable you to take control over these decisions.
 
Home study courses allow you to develop the personal confidence and independence needed for success. Once you have become familiar with your home learning course materials and you feel you know your way around the course, then it is time to put together your own personal study plan to help you decide how best to study. We would advise that you write down your plan to assist you in following your home study timetable.
 
Although our home learning course guides are primarily aimed at the first time user, you may already have some experience of home learning. Whatever your experience, it is important to understand that to be a successful home study course learner, you need to become familiar and comfortable with the learning materials.
 

 


 

Student PortalHow can I interact with other students?

Student Community


We understand that studying from home may be a new experience for you. You could even be excused for feeling a little daunted since you will not be studying in a traditional "classroom environment". To help our students overcome these concerns we have developed a friendly online student community. The Student Community encourages a high level of interaction with your tutor and other like-minded students.

All of our students receive access to the Student Community. You will be able to use the student community for the following:

  1. Access the student forum which allows you to share ideas and chat with other students.
  2. View your tutor's feedback on your marked assignments.
  3. View optional reading lists for your course (where available).
  4. Access free online games, for when you need a break from studying.
  5. View the study guide with plenty of useful hints and tips on how to get the most out of your course.

Access free courses such as: Improving Learning Skills, Job Interview Skills, The Effective Learner, Goal Setting and Time Management, Ten Tips to Complete a Good Test Paper


VISIT THE STUDENT COMMUNITY


 

Related CoursesI am not sure this is for me. Are there similar courses?

Related Courses
Below you will find a list of courses that previous students have taken to complement their course. We hope that this list will give you some idea of the types of progression courses we offer, or alternative course options that may be of interest to you.

 

Microsoft Certified IT Professional (MCITP) - Database Developer - Database developers design and implement relational database models (logical and physical) and database storage objects. They also program servers by using user-defined functions, triggers, stored procedures, Transact-SQL, or the CLR. They retrieve or modify data using SQL queries or tune and optimize queries. Database developers are typically employed by mid-sized to large-sized organizations......Read More »

Microsoft Certified IT Professional (MCITP) - Enterprise Support - This certification prepares you for various job roles, which include: system administrators, network administrators, or technical support specialists. The test is appropriate for you if you have experience in resolving issues concerning network connectivity, desktop operating systems, security, and other issues related with desktop applications........Read More »

Cisco Certified Network Assosiate (CCNA) - Cisco Certified Network Associate CCNA training course provides students with the knowledge and skills that are needed to install, configure, operate, and troubleshoot medium-size routed and switched networks, including implementation and verification of connections to remote sites in a WAN. The CCNA training course curriculum includes basic mitigation of security threats, introduction to wireless networking concepts and terminology, and performance-based skills......Read More »


 


 

Further InformationWhat else do I need to know?

If your course is being delivered online, please ensure you meet the minimum requirements below.


For Windows:
Windows 98, 2000, XP, Vista, Windows 7 - Acrobat Reader 4.0 and above

For Macintosh:
Mac OS X, Mac OS 9.2 - Acrobat Reader 4.0 and above

From time to time we may enrol our students with our partner sites; this is dependent on the number of students enrolling on a particular course and course material availability. If this happens, nothing changes for you other than the name of the college administering your course.  We will continue to be your point of contact; you will get the exact same course you have enrolled on with the same high level of quality content and support.

The course can be enrolled upon by students Internationally. There are no deadlines for enrolments.



 

How to EnrolHow do I enrol?


       

Step One 
It's simple - Choose from our list of 100s Accredited Courses. Click on the enrol now button to select your enrolment option

Step Two
After you enrol, Course Material will be delivered to you within 7 working days (Normally 48 Hours).

Step Three
A personal tutor and a Dedicated Support advisor will be allocated to you throughout the course.

Step Four
On successful completion of the course, You will be given a Recognised Qualification towards a successful career.


 


 

FAQsWhat are the most frequent questions?

Course Frequently Asked Questions 


Q. When can I start the course?
The answer is simple, when YOU want; you can start the course at any time we do not have any set enrolment dates. Most of our courses don’t require any previous experience or qualifications. All you need is a desire and motivation to succeed. You can even start right now - call and speak to one of our Professional Course Advisors.
 
Q. How long do the courses take?
This is dependent upon your choice of course and how fast you want to learn. A full breakdown of the course is available in your course literature. We do provide estimated number of study hours; ask our course advisors for details.
 
Q. Do the courses have tutorial support?
Yes, You will be allocated an experienced tutor who will guide you through the course, mark your assignments and generally help you with any problems you may have. Your tutors can be contacted via email.
 
Q. If I fail an assignment can I retake it?
Yes, your tutor will ask you to resubmit your assignment and give you support as to where you could improve.
 
Q. How do I get help with my course work?
You can get help 7 days a week by email, or post from your dedicated tutor, you just email your assignments for marking. You have to send your assignments one at a time so the tutor can mark one and give you the feedback.
 
Q. Is the course work done online or sent via the internet?
No, the course work can be done offline using your PC or for paper based courses working through your course folder. 
 
Q. Will I have to sit an examination?
Most of our paper based courses do not require you to sit examinations, only continual assessments. Where there are examinations required, you will receive all the information you need to make your own exam arrangements. Please note exam fees are not included in your course fee, unless otherwise stated.
 
Q. How quickly will I receive my course material?
Once your payment has been received and cleared your enrolment should be processed within two days and your course materials delivered within 5 days, for customers who choose to pay in instalments this can take longer as we need a signed agreement back from you before we send the course materials.
 
Q. Do I have to buy any other materials?
Our comprehensive course materials are designed to be self-contained with all the relevant information you require to complete the course and gain the relevant certification. However some of our students undertake additional reading via relevant textbooks/study guides and/or the Internet to add value to their studies.
 
Q. I’m not sure of what course I should take? Can you help?
Yes we can, it is important that you pursue a course which you will enjoy. Although we cannot make this decision for you, we employ a team of dedicated Professional Course Advisors, who will guide you towards making the right choice. Whether you want specific information, or just a chat about what’s available, contact us now.
 
Q. Why choose UK Learning College?
The breadth and depth of our portfolio of courses means that we will have a course to interest you. We are committed to your success, and offer advice and support through every step of the process. We have a dedicated team of Professional Course Advisors that can give you access to career and recruitment advice, whilst offering excellent value and quality courses.
 
Please contact us if you have not found the answer you are looking for.

 


 

Contact UsIím still not sure can you help me?

Get in touch...


If you would like to talk to someone about your choice of home learning course, or if you would like to discuss anything else with us please don't hesitate to call us on 0800 009 62490800 009 6249. You can also call us on Skype at dialgia.group

Postal Address:

UK Learning College
22 Turnbull Street
Suite 108
Glasgow
G1 5PR
United Kingdom


Contact Us


 



Exam 70-642 - Configuring W...

Copyright © 2017 UKLC. All rights reserved.
UK Learning College, 2 Byres Road
Glasgow, G11 5JY
Telephone UK: +44 (0) 844 884 9291 International: +44 (0) 705 006 221
Wildcard SSL Certificates