MCTS SQL Server 2008 Database Development Course in London @ Westminster College , IT Training, Computer Training Courses in Central London

WCC

Westminster College of Computing

020 8261 4684

C o r p o r a t e T r a i n i n g

1000 Great West Road, Brentford TW8 9HH

Home About us Courses Schedules

19/05/2012

Pay Securely

Course Start Dates

Start Date	Time	Days	Duration
09/04/2011	3.30-6.30pm	Sat	12 classes
06/08/2011	3.30-6.30pm	Sat	12 classes
17/03/2012	3.30-6.30pm	Sat	12 classes
16/06/2012	3.30-6.30pm	Sat	12 classes
06/10/2012	3.30-6.30pm	Sat	12 classes

Create and alter tables.
Create and alter views.
Create and alter indexes.
Create and modify constraints.
Implement data types.
Implement partitioning solutions.
Implementing Programming Objects
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.
Working with Query Fundamentals
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.
Applying Additional Query Techniques
Implement subqueries.
Implement CTE (common table expression) queries.
Apply ranking functions.
Control execution plans.
Manage international considerations.
Working with Additional SQL Server Components
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.
Working with XML Data
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 output from the Database Engine Tuning Advisor.
Collect information from system metadata.