After completing this course, the student should be able to:

• recognize how to define data types and column types
• recognize how to create and alter tables
• recognize the function of views, and how to create and modify them
• recognize how to secure objects and document the structure of a database
• recognize index types and how to design a database indexing strategy
• recognize how to create and manage indexes
• create and modify a table
• create a view
• grant permissions to a user
• create an index

 

Duration: 2.5 hrs

After completing this course, the student should be able to:

• recognize how to create table and index partitions
• recognize how to modify table and index partitions
• recognize how to create and use distributed partitioned views
• create a partitioned table
• create a partitioned index
• modify a partitioned table
• create a partitioned view

Duration: 1 hrs

After completing this course, the student should be able to:

• recognize how to use SELECT to retrieve data
• recognize how to use joins to retrieve data
• recognize how to use INSERT to input data
• recognize how to use UPDATE to change existing data
• recognize how to use DELETE to remove data
• recognize how to use MERGE to perform multiple operations
• recognize how to use OUTPUT to generate output
• recognize how to use subqueries
• retrieve data
• manipulate data

 

Duration: 1.5 hrs

After completing this course, the student should be able to:

• recognize how to use built-in functions to perform operations on data
• recognize how to manipulate the result sets of queries
• recognize how to control execution plans
• recognize how to store data in multiple languages within a database
• use advanced queries

 

Duration: 1 hr

After completing this course, the student should be able to:

• recognize key characteristics of user-defined functions
• recognize how to create and manage user-defined functions
• recognize key characteristics of triggers
• recognize how to create and manage triggers
• recognize key characteristics of stored procedures
• recognize how to create stored procedures
• recognize how transaction control works in SQL Server 2008
• recognize how concurrency control works
• recognize how to implement error handling
• recognize key characteristics of CLR
• recognize how to create CLR objects
• create and manage programming objects in SQL Server 2008

Duration: 2 hrs

After completing this course, the student should be able to: 

• recognize how to implement XML data types and schemas
• recognize how XPath is used
• recognize how to query XML data using XQuery
• recognize how to use FOR XML to construct XML
• recognize how to use OPENXML
• recognize how to create an XML index
• use XML data in SQL Server 2008

 

Duration: 2 hrs

After completing this course, the student should be able to:

• recognize how Service Broker is used
• recognize how to create Service Broker objects
• recognize how to create an application
• recognize how to use change data capture in SQL Server 2008
• recognize how to perform change tracking in SQL Server 2008
• recognize how to perform a full-text search
• recognize how to use the full-text predicates and functions
• recognize how to use PowerShell in SQL Server 2008
• recognize how to use Database Mail in SQL Server 2008
• use Service Broker
• use change tracking
• use PowerShell
• set up and use Database Mail

 

Duration: 2.5 hrs

After completing this course, the student should be able to:

• recognize how to view execution plans in SQL Server 2008
• recognize how to use SQL Server Profiler
• recognize how to use the Database Engine Tuning Advisor
• recognize how to use DMVs
• recognize how to use catalog views
• collect performance data in SQL server 2008

 

Duration: 2 hrs