BL TS: Microsoft SQL Server 2008, Database Development

Part Time

Course Details

Click here

Course Code

QBSNT167/BCP0

Course Level

N/A

Where will this course lead?

The primary audience for this course is individuals who administer and maintain SQL Server databases. This course can also be helpful for individuals who develop applications that deliver content from SQL Server databases.

This course will help the student prepare (in part) for the Microsoft Certified Technology Specialist (MCTS): Microsoft SQL Server 2008, Database Development exam. Further courses will be required prior to taking exam

Students who satisfy the minimum pass level, for the above vendor exam(s), as defined by Microsoft at the time of taking the online exam, will be awarded the following:-

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

And counts as credit toward the following certification(s):

MCITP: Database Developer 2008

What will I study?

After completing this course, you will be able to:

Implementing Tables and Views
Create and alter tables.
Create and alter views.
Create and alter indexes.
Create and modify constraints.
Implement data types.
Implement partitioning solutions.
Create and alter stored procedures.
Create and alter user-defined functions (UDFs).
Create and alter DML triggers.
Create and alter DDL triggers.
Create and deploy CLR-based objects.
Implement error handling.
Manage transactions.
Query data by using SELECT statements.
Modify data by using INSERT, UPDATE, and DELETE statements.
Return data by using the OUTPUT clause.
Modify data by using MERGE statements.
Implement aggregate queries.
Combine datasets.
Apply built-in scalar functions.
Implement subqueries.
Implement CTE (common table expression) queries.
Apply ranking functions.
Control execution plans.
Manage international considerations.
Integrate Database Mail.
Implement full-text search.
Implement scripts by using Windows PowerShell and SQL Server Management Objects (SMOs).
Implement Service Broker solutions.
Track data changes.
Retrieve relational data as XML.
Transform XML data into relational data.

Query XML data.
Manage XML data.
Gathering Performance Information
Capture execution plans.
Gather trace information by using the SQL Server Profiler.
Collect information from system metadata.

How will this course be delivered?

This course is one of the 'blended learning' series from the Microsoft IT Academy at Solihull College. Providing IT professional access to the latest Microsoft certification courses with high quality, flexible learning systems.

The 'blended learning' courses comprise of components to facilitate effective self directed learning, with flexible start and attendance date to meet your individual needs.

This course offers bookable hands-on practice labs in our Academy open access lab facility that assist students in becoming proficient in the skills needed to support the Microsoft technology.

The student kit includes relevant comprehensive Microsoft Official Curriculum workbook(s) and other necessary materials for this class.

Students will also receive 150 days access to Microsoft's internet e-learning system, with relevant e-learning course materials.

Access to MSDN AA to enable students to download Microsoft operating systems and applications to create and develop their own practice lab environments, for your academic use only. Conditions and systems requirements apply.

Tailored individual learning plans, with one-one support and guidance from our qualified Microsoft Certified Trainer / mentors.

On-line exam preparation and assessment with MeasureUP test practice system.

This course is available to study in daytime or evening sessions.

What qualifications will I get?

Vocational study not leading to a recognised qualification, Information and Communication Technology (SSA 6)

How will I be assessed?

There is no formal examination required; however students may take the external Microsoft examination, typically three weeks from end of course.

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

Examinations must be taken at our in-house Authorised Prometric testing centre (APTC) at Specialist IT Training. APTC Site code GB3K.

The course includes continual assessments.

How do I get a place on the course?

Places are offered by interview.

What are the entry requirements?

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. Candidates for this exam are IT professionals who work in jobs in which database development is their main area of responsibility, or they work in environments in which databases are central to their primary job roles. These job roles include the following:
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
Developers who build applications that use SQL Server 2008
IT professionals who work with third-party applications that are built on SQL Server 2008
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.

Completed Course 2778: Writing Queries Using Microsoft SQL Server 2008 Transact-SQL

What else do I need to know?

The Microsoft certification program is one of the IT industry's most comprehensive programs for assessing and maintaining software-related skills. Microsoft has designed this program to ensure that a high level of expertise is sustained within an international IT professional community. We offer a range of courses to help delegates prepare for the following Microsoft Certifications MCP, MCSA, MCSE, MCTS, MCITP, MCPD, MCAD, MCSD.

The Microsoft Certified Technology Specialist (MCTS) certifications provide the foundation for Microsoft Certification. These certifications are designed to validate your skills on the features and functionality of key technologies. You can show your depth of knowledge in one specific technology, earn multiple MCTS certifications to show breadth across different products, or build on the MCTS to earn a Microsoft Certified IT Professional (MCITP) credential.

Course schedules, content, supporting materials and availability may be subject to change.

Solihull College offers full time and part time courses for businesses and residents in Birmingham, Walsall, Wolverhampton, Coventry Warwickshire and the whole of the West Midlands.

What can I do after this course?

The primary audience for this course is individuals who administer and maintain SQL Server databases. This course can also be helpful for individuals who develop applications that deliver content from SQL Server databases.

The following courses are recommended for further study:-


Further Microsoft certification courses are available, please enquire for details.

Is there anything else I will have to pay for in order to do this course?

Study material fees are payable.
If required, vendor exam will be charged at current rates.
This course is not eligible for fee concession.

Contact

Blossomfield Campus

Solihull College
Blossomfield Road
Solihull
B91 1SB

Tel: 0121 678 7000
Minicom: 0121 628 7005
Email: enquiries@solihull.ac.uk
Internet: www.solihull.ac.uk

Have you got a question about this course?

Please contact Admissions on 0121 678 7000 with any queries.

Course Details