Upon completion you will:Create databases & database files; Create data types & tables; Use XML-related features in Microsoft SQL Server 2008; Plan, create, & optimize indexes; Implement views; Implement stored procedures; Implement functions & much more
- Course Outline
Who should attend
This course is intended for IT Professionals who administer and maintain SQL Server databases.
Performance objectives After completing this course, students will be able to:
- Create databases and database files.
- Create data types and tables.
- Use XML-related features in Microsoft SQL Server 2008.
- Plan, create, and optimize indexes.
- Implement data integrity in Microsoft SQL Server 2008 databases by using constraints.
- Implement data integrity in Microsoft SQL Server 2008 by using triggers.
- Implement views.
- Implement stored procedures.
- Implement functions.
- Implement managed code in the database.
- Manage transactions and locks.
- Use Service Broker to build a messaging-based solution.
- Lesson 1: Creating Databases
- Lesson 2: Creating Filegroups
- Lesson 3: Creating Schemas
- Lesson 4: Creating Database Snapshots
- Exercise 1: (Level 200) Creating a Database
- Exercise 2: (Level 200) Creating Schemas
- Exercise 3: (Level 300) Creating a Database Snapshot
- Create databases
- Create filegroups
- Create schemas
- Create database snapshots
- Lesson 1: Creating Data Types
- Lesson 2: Creating Tables
- Lesson 3: Creating Partitioned Tables
- Exercise 1 (Level 200): Creating Data Types
- Exercise 2 (Level 200): Using New Date and Time Data Types
- Exercise 3 (Level 200): Creating Tables
- Exercise 4: (Level 300) Creating Partitioned Tables
- Create new data types.
- Create new tables.
- Create partitioned tables.
- Lesson 1: Planning Indexes
- Lesson 2: Creating Indexes
- Lesson 3: Optimizing Indexes
- Exercise 1: (Level 200) Creating Indexes
- Exercise 2: (Level 300) Tuning Indexes
- Plan indexes.
- Create indexes.
- Optimize indexes.
- Lesson 1: Data Integrity Overview
- Lesson 2: Implementing Constraints
- Lesson 3: Implementing Triggers
- Exercise 1: (Level 200) Creating Constraints
- Exercise 2: (Level 200) Disabling Constraints
- Exercise 3: (Level 300) Creating Triggers
- Describe the options for enforcing data integrity in SQL Server 2008.
- Implement data integrity in SQL Server 2008 databases by using constraints.
- Implement data integrity in SQL Server 2008 databases by using triggers.
- Lesson 1: Using the XML Data Type
- Lesson 2: Retrieving XML by Using FOR XML
- Lesson 3: Shredding XML by Using OPENXML
- Lesson 4: Introducing XQuery
- Lesson 5: Creating XML Indexes
- Lesson 6: Implementing XML Schemas
- Exercise 1: (Level 200) Mapping Relational Data and XML
- Exercise 2: (Level 200) Storing XML Natively in the Database
- Exercise 3: (Level 300) Using XQuery with XML Methods
- Exercise 4: (Level 200) Create XML Indexes
- Exercise 5: (Level 300) Implementing XML Schemas
- Use the xml data type.
- Retrieve XML by using the FOR XML clause.
- Shred XML by using the OPENXML function.
- Use XQuery expressions.
- Create XML indexes.
- Implement data integrity in SQL Server 2008 databases by using XML schemas.
- Lesson 1: Introduction to Views
- Lesson 2: Creating and Managing Views
- Lesson 3: Optimizing Performance by Using Views
- Exercise 1: (Level 200) Creating Views
- Exercise 2: (Level 200) Creating Indexed Views
- Exercise 3: (Level 200) Creating Partitioned Views
- Describe the purpose of views.
- Create and manage views.
- Explain how to optimize query performance by using views.
- Lesson 1: Implementing Stored Procedures
- Lesson 2: Creating Parameterized Stored Procedures
- Lesson 3: Working With Execution Plans
- Lesson 4: Handling Errors
- Exercise 1: (Level 300) Creating Stored Procedures
- Exercise 2: (Level 300) Working with Execution Plans
- Implement stored procedures.
- Create parameterized stored procedures.
- Work with execution plans.
- Handle errors in stored procedures.
- Lesson 1: Creating and Using Functions
- Lesson 2: Working with Functions
- Lesson 3: Controlling Execution Context
- Exercise 1: (Level 300) Creating Functions
- Exercise 2: (Level 300) Controlling Execution Context
- Create and use functions.
- Work with functions.
- Control execution context.
- Lesson 1: Introduction to the SQL Server Common Language Runtime
- Lesson 2: Importing and Configuring Assemblies
- Lesson 3: Creating Managed Database Objects
- Exercise 1: (Level 300) Importing an Assembly
- Exercise 2: (Level 300) Creating Managed Database Objects
- Identify appropriate scenarios for managed code in the database.
- Import and configure assemblies.
- Create managed database objects.
- Lesson 1: Overview of Transactions and Locks
- Lesson 2: Managing Transactions
- Lesson 3: Understanding SQL Server Locking Architecture
- Lesson 4: Managing Locks
- Exercise 1: (Level 300) Using Transactions
- Exercise 2: (Level 300) Managing Locks
- Exercise 3: (Level 300) Using Partition Locking
- Describe how SQL Server 2008 transactions use locks.
- Execute and cancel a transaction.
- Describe concurrency issues and SQL Server 2008 locking mechanisms.
- Manage locks.
- Lesson 1: Service Broker Overview
- Lesson 2: Creating Service Broker Objects
- Lesson 3: Sending and Receiving Messages
- Exercise 1: (Level 300) Creating Service Broker Objects
- Exercise 2: (Level 300) Implementing the Initiating Service
- Exercise 3: (Level 300) Implementing the Target Service
- Describe Service Broker functionality and architecture.
- Create Service Broker objects.
- Send and receive Service Broker messages.
- Prerequisites & Certificates
Before attending this course, students must have: * 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.
Certificate of completion
- Cancellation Policy
We require 16 calendar days notice to reschedule or cancel any registration. Failure to provide the required notification will result in 100% charge of the course. If a student does not attend a scheduled course without prior notification it will result in full forfeiture of the funds and no reschedule will be allowed. Within the required notification period, only student substitutions will be permitted.
Reschedules are permitted at anytime with 16 or more calendar days notice. Enrollments must be rescheduled within six months of the cancel date or funds on account will be forfeited.
- Map & Reviews
[ View Provider's Profile ]
ReviewsHere are some reviews of the training vendor.
This course has not yet been rated by one of our members.
If you have taken a course through this vendor please log into your account and leave feedback for this vendor. You will be helping ensure our members get directed to the best training facilities.
This course currently does not have any dates scheduled. Please call 1-877-313-8881 to enquire about future dates or scheduling a private, in house course for your team.
This page has been viewed 247 times.