Implementing a Microsoft SQL Server 2005 Database

KnowledgeAir
Buffalo, New York, United States

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

Course Description:

'' This course provides students with product knowledge and skills needed to implement a Microsoft SQL Server 2005 database. The course focuses on teaching individuals how to use SQL Server 2005 product features and tools related to implementing a database.

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 2005
- Plan, create, and optimize indexes.
- Implement data integrity in Microsoft SQL Server 2005 databases by using constraints.
- Implement data integrity in Microsoft SQL Server 2005 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.
- Use Notification Services to generate and send notifications.

--------------------------------------------------------------------------------

Course Outline

--------------------------------------------------------------------------------

Lesson 1: Creating Databases and Database FilesCreating Databases.
Creating Filegroups.
Creating Schemas.
Creating Database Snapshots.

Lesson 2: Creating Data Types and TablesCreating Data Types.
Creating Tables.
Creating Partitioned Tables.

Lesson 3: Using XMLRetrieving XML by Using FOR XML
Shredding XML by Using OPENXML
Introducing XQuery
Using the xml Data Type

Lesson 4: Creating and Tuning IndexesPlanning Indexes.
Creating Indexes.
Optimizing Indexes.
Creating XML Indexes.

Lesson 5: Implementing Data Integrity by Using ConstraintsData Integrity Overview
Implementing Constraints

Lesson 6: Implementing Data Integrity by Using Triggers and XML Schemas
Implementing Triggers
Implementing XML Schemas
Lesson 7: Implementing ViewsIntroduction to Views
Creating and Managing Views
Optimizing Performance by Using Views

Lesson 8: Implementing Stored ProceduresImplementing Stored Procedures
Creating Parameterized Stored Procedures
Working With Execution Plans
Handling Errors

Lesson 9: Implementing FunctionsCreating and Using Functions
Working with Functions
Controlling Execution Context

Lesson 10: Implementing Managed Code in the DatabaseIntroduction to the SQL Server Common Language Runtime
Importing and Configuring Assemblies
Creating Managed Database Objects

Lesson 11: Managing Transactions and LocksOverview of Transactions and Locks
Managing Transactions
Understanding SQL Server Locking Architecture
Managing Locks

Lesson 12: Using Service BrokerService Broker Overview
Creating Service Broker Objects
Sending and Receiving Messages

Lesson 13: Using Notification Services (Optional)Introduction to Notification Services
Developing Notification Services Solutions

...''

Phone:866-322-3685

School Address:

KnowledgeAir Buffalo
726 Exchange St, Suite 628
Buffalo, NY 14210

KnowledgeAir Rochester
100 Allens Creek Road
Rochester, NY 14618


Jobs & Resumes: Buffalo
Houses & Roommates: Buffalo

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

Access 2003
Excel 2003
Excel 2007
OneNote 2007
PowerPoint 2003
Word 2007
Illustrator CS3
InDesign CS3
Photoshop CS3
SQL Server 2005
Maintaining a Microsoft SQL Server 2005 Database
SQL Advanced Querying
SQL
Windows 2003 Active directory
Exchange Server 2007
ACT!
CISSP
Advanced Administration of Blackberry Enterprise Server
BlackBerry Enterprise Server

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 provide free training course catalog service since 2003, in English and Chinese. Tens of thousands of visitors search our database from our portal and partners' websites each day.