Implementing a SQL Server 2008 Database

Global Knowledge Canada
Calgary, Edmonton, Halifax, Montreal, Ottawa, Quebec City, Toronto, Vancouver, Winnipeg, Canada

Course Format: Classroom | E-learning | Virtual Class | Online | On-site | Blended | Self-paced

Course Description:

'' Gain the knowledge and skills to implement a Microsoft SQL Server 2008 database. In this course, you’ll focus on learning to use SQL Server 2008 database implementation features and tools.

What You’ll Learn


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 databases 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
Course Outline


1. Creating Databases and Database Files
Creating Databases
Creating Filegroups
Creating Schemas
Creating Database Snapshots
2. Creating Data Types and Tables
Creating Data Types
Creating Tables
Creating Partitioned Tables
3. Creating and Tuning Indexes
Planning Indexes
Creating Indexes
Optimizing Indexes
4. Implementing Data Integrity by Using Constraints and Triggers
Data Integrity Overview
Implementing Constraints
Implementing Triggers
5. Using XML
Using the XML Data Type
Retrieving XML by Using FOR XML
Shredding XML by Using OPENXML
Introducing XQuery
Creating XML Indexes
Implementing XML Schemas
6. Implementing Views
Introduction to Views
Creating and Managing Views
Optimizing Performance by Using Views
7. Implementing Stored Procedures
Using Stored Procedures
Creating Parameterized Stored Procedures
Working With Execution Plans
Handling Exceptions
8. Implementing Functions
Introducing Functions
Working with Functions
Controlling Execution Context
9. Implementing Managed Code in the Database
Introduction to the SQL Server Common Language Runtime
Importing and Configuring Assemblies
Creating Managed Database Objects
10. Managing Transactions and Locks
Overview of Transactions and Locks
Managing Transactions
Understanding SQL Server Locking Architecture
Managing Locks
11. Using Service Broker
Service Broker Overview
Creating Service Broker Objects
Sending and Receiving Messages
Labs


Lab 1: Creating Databases and Database Files
Creating a Database
Creating Schemas
Creating a Database Snapshot
Lab 2: Creating Data Types and Tables
Creating Data Types
Using New Date and Time Data Types
Creating Tables
Creating Partitioned Tables
Lab 3: Creating and Tuning Indexes
Creating Indexes
Optimizing Indexes
Lab 4: Implementing Data Integrity by Using Constraints and Triggers
Creating Constraints
Disabling Constraints
Creating Triggers
Lab 5: Using XML
Mapping Relational Data and XML
Storing XML Natively in the Database
Using XQuery with XML Methods
Creating XML Indexes
Lab 6: Implementing Views
Creating Views
Creating Indexed Views
Creating Partitioned Views
Lab 7: Implementing Stored Procedures
Creating Stored Procedures
Working with Execution Plans
Lab 8: Implementing Functions
Creating Functions
Controlling Execution Context
Lab 9: Implementing Managed Code in the Database
Importing an Assembly
Creating Managed Database Objects
Lab 10: Managing Transactions and Locks
Using Transactions
Managing Locks
Lab 11: Using Service Broker
Creating Service Broker Objects
Implementing the Initiating Service
Implementing the Target Service
...''

Elements of this syllabus are subject to change.

Phone:1-800-COURSES

School Address:

Global Knowledge - Canada
535 Legget Drive
Suite 200
Kanata, ON K2K 3B8 Canada



Jobs & Resumes: Calgary, Edmonton, Halifax, Montreal, Ottawa, Quebec City, Toronto, Vancouver, Winnipeg
Houses & Roommates: Calgary, Edmonton, Halifax, Montreal, Ottawa, Quebec City, Toronto, Vancouver, Winnipeg
Travel Agencies: Calgary, Montreal, Ottawa, Toronto, Vancouver, Winnipeg

Search other schools for Implementing a SQL Server 2008 Database training resources.

Effective Technical Communication
Communication and Negotiation Skills
Six Sigma Master Black Belt Certification
six sigma black belt certification
Six Sigma Jumpstart
Six Sigma Green Belt Certification
writing effective requirements
requirements development and management
CBAP Exam Prep
microsoft sql server 2008 analysis services
Microsoft SQL Server 2008 Integration Services
microsoft sql server 2008 reporting services
SQL Server 2008
Writing Queries Using Microsoft SQL Server 2008 Transact-SQL
Designing a Reporting Solution Architecture Using Microsoft SQL Server 2005 Reporting Services
microsoft sql server 2005 reporting services
Database Administrator
SQL Server 2005 Administration

Notice: The course description on this page was captured from the Internet as historical reference or submitted by visitors. It was archived statically and not updated from day to day.
 

Facts: We serve the schools and students around the world. Major visitors come from India, United States, United Kingdom, Canada, Australia, Philippines, Malaysia, Singapore and South Africa.