MCTS SQL Server 2008 Database Development

MCTS SQL Server 2008 Database Development

This course is designed for IT professionals who have jobs in which database administration is their main area of responsibility, or who work in environments in which databases are central to their job roles

This course is designed for IT professionals who have jobs in which database administration is their main area of responsibility, or who work in environments in which databases are central to their job roles. These job roles include IT generalists who work in environments in which SQL Server 2008 is part of an overall solution, IT professionals who manage systems that run SQL Server 2008, IT professionals who work with third-party applications that are built on SQL Server 2008 and Developers who build applications that use SQL Server 2008.

Entry Requirements

The prerequisites for the exam are that candidates should have one to two years of experience using Microsoft SQL Server 2008 or two to three years of experience using a previous version of SQL Server.

Hardware Requirements

  • Minimum Pentium® 1 GHz
  • Minimum G3 machine for Macintosh®
  • Minimum 128 MB RAM
  • Minimum 256 MB RAM for Macintosh®
  • 1024 x 768 screen resolution is recommended
  • 56K or high-speed Internet

Operating Systems

  • Microsoft® Windows® operating system (32-bit and 64-bit) (not Windows NT)
  • Windows 7 using Internet Explorer 8
  • openSUSE® (SUSE® Linux) - 9.2-9.3, 10.0-10.3, 11.0-11.1
  • Macintosh OS® X™ - 10.4, 10.5
  • Macintosh OS® X™ 10.6

Supported Browsers

  • Internet Explorer® - 6.x-8.0 (not on Macintosh)
  • Firefox® - 2.0 -3.6.10 (not on Macintosh)
  • Safari™ - 3.0-5.0.2 (only on Apple - Macintosh)

Minimum Requirements for Plug-Ins

  • Flash® 6.0 - 10"

Where will I go from here?

This course is designed for IT professionals who have jobs in which database administration is their main area of responsibility, or who work in environments in which databases are central to their job roles.

What will I gain?

Microsoft Certified Technology Specialist (MCTS): SQL Server 2008, Database Development

Assessment

Candidates are required to take and pass exam

  70-433 TS: Microsoft SQL Server 2008, Database Development

Please note exam fees are additional to course fees

What will I get?

  • Full online content via a learning portal
  • Access to a virtual bookshelf containing all the textbooks you might need during your studies
  • Access to all components of the courses from any PC with internet connection
  • Test-Preps. These consist of test questions at a level of difficulty similar to that of your qualifying exams.
  • They come with an test-mode option, which limits the time available to complete it, or in a study mode, which makes detailed feedback available to explain the right and wrong answers for every question
  • SkillSoft's mentors are available online 24 hours a day, seven days a week, 365 days a year for the most popular certification exams to provide support, guidance and encouragement.
  • Other courses have mentors available online Monday to Friday, 2pm-10pm GMT
  • The support period is 12 months from the date of enrolment.

Study Period

12 months

Hours of study

100 hours

Support period

12 months

Course code

194

Course cost

£595.00

Additional fees

Please note exam fees are additional to course fees

See your course content

Key Topics

  • Creating and implementing database objects in SQL server 2008
  • Creating and modifying table and index partitions in SQL server 2008
  • Running queries and manipulating data in SQL server 2008
  • Performing advanced query techniques in SQL server 2008
  • Creating and implementing programming objects in SQL server 2008
  • Querying and managing xml data in SQL server 2008
  • Using SQL server 2008 messaging, full-text search, scripts, and track changes
  • Gathering performance data in SQL server 2008

You can either pay for your course in full or opt for a monthly payment plan.

Course fee: £595.00 (excluding discounts)

Or speak to one of our course advisors now for payment plans.

Please remember that you will not be able to cancel your course once you have unsealed any supplied software or accessed any online courseware.

 

Please note that examination fees are additional to course fees.