Implementing a Microsoft SQL Server 2008 Database
Course: SS8IMP
Duration: 5 Days
Level: I
Course Summary
This 5-day course covers in detail how to use Microsoft's
SQL Server 2008 features and capabilities in order to
implement databases.
« Hide The Details
Topics Covered In This Course
Introduction
Creating Databases and Database Files
- Creating Databases
- Creating Filegroups
- Creating Schemas
- Creating Database Snapshots
- Lab: Creating a Database
- Lab: Creating Schemas
- Lab: Creating a Database Snapshot
Creating Data Types and Database Tables
- Understanding Data Types
- Creating Data Types
- Creating Tables
- Creating Partitioned Tables
- Lab: Creating Data Types
- Lab: Creating Tables
- Lab: Creating Partitioned Tables
Implementing Database Constraints
- Understanding Data Integrity
- Creating Database Constraints
- Lab: Defining Constraints
- Lab: Disabling Constraints
Creating and Using Database Views
- Understanding Views
- Creating Views
- Optimizing Database Performance with Views
- Lab: Creating Views
- Lab: Creating Indexed Views
- Lab: Creating Partitioned Views
Creating and Using Stored Procedures
- Defining Stored Procedures
- Creating Parameterized Stored Procedures
- Defining Execution Plans
- Error Handling
- Lab: Creating Stored Procedures
- Lab: Defining Execution Plans
- Lab: Stored Procedures and Error Handling
Creating and Using Functions
- Defining Functions
- Using Functions
- Controlling Function Execution
- Lab: Defining Functions
- Lab: Controlling Function Execution
Understanding Database Processes, Transactions, and Locks
- SQL Server 2008 Processes, Transactions, and Locks
- Managing Transactions
- SQL Server 2008 Locking
- Finding and Managing Locks
- Lab: Using Transactions
- Lab: Understanding and Eliminating Locks
Microsoft SQL Server 2008 and XML
- Overview of XML and SQL Server 2008
- Using FOR XML
- Using OPENXML
- XQuery
- The XML Data Type
- Lab: Mapping Data to XML
- Lab: Storing XML in a Database
- Lab: Using XQuery
Creating Database Indices
- Planning Database Indices
- Creating Indices
- Improving Indices
- Creating XML Indices
- Lab: Creating Database Indices
- Lab: Optimizing Database Indices
- Lab: Creating XML Indices
Database Triggers
- Understanding Database Triggers
- Implementing Database Triggers
- Lab: Creating Triggers
- Lab: Application of Triggers
XML Schemas
- Understanding XML Schemas
- Implementing XML Schemas
- Lab: Implementing XML Schemas
Managed Code
- Common Language Runtime
- Application of Common Language Runtime
- Creating, Importing, and Configuring Assemblies
- Understanding Managed Database Objects
- Lab: Importing an Assembly
- Lab: Configuring an Assembly
- Lab: Creating Managed Database Objects
Service Broker
- Understanding Service Broker
- Creating Service Broker Objects
- Using Service Broker for a Message-based Application
- Lab: Creating Service Broker Objects
- Lab: Implementing the Initiating Service
- Lab: Implementing the Target Service
What You Can Expect
- Learn the features of Microsoft's SQL Server 2008
- Understand and create databases
- Understand and demonstrate the use of data types and database
tables
- Demonstrate and use XML-related features of Microsoft SQL
Server 2008
- Plan databases for indices
- Implement and use database indices
- Learn about and implement database constraints
- Demonstrate and apply database triggers
- Use database views in Microsoft SQL Server 2008
- Understand and use stored procedures
- Deploy managed code in Microsoft SQL Server 2008
- Manage database processes, transactions, and locks
- Implement messaging solutions
- Build and send automated notifications
Who Should Take This Course
Technology professionals interested in learning the features
and capabilities of Microsoft's SQL Server 2008 product
in order to implement databases.
Training Style
Instructor-led lecture coupled with relevant individual
activities.
« Hide The Details
Related Courses
| Code |
Course Title |
Duration |
Level |
|
DSSRPT |
Maintaining, Troubleshooting, and Developing Solutions with Microsoft SQL Server 2008 Reporting Services |
5 Days |
I |
Details |
Every student attending a Verhoef Training class will receive
a certificate good for $100 toward their next public class taken
within a year.
You can also buy "Verhoef Vouchers" to get a discounted rate for a
single student in any of our public or web-based classes.
Contact your account manager or our sales office for details.
|
