Learn: in:
» back to Search Results

Course rating of 0 Vendor rating of 4


This 5-day instructor-led course provides the knowledge and skills 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.


 
Course Outline
This five-day instructor-led course provides students with the knowledge and skills 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.

Audience This course is intended for IT Professionals who want to become skilled on SQL Server 2005 product features and technologies for implementing a database.

At Course Completion 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.

Microsoft Certified Professional Exams
This course helps you prepare for the following Microsoft Certified Professional exam:
    * Exam 70-297: Designing a Microsoft Windows Server 2003 Active Directory and Network Infrastructure

Course Outline Module 1: Creating Databases and Database Files This module explains how to create databases, filegroups, schemas, and database snapshots.
Lessons
    * Creating Databases
    * Creating Filegroups
    * Creating Schemas
    * Creating Database Snapshots
Lab 1: Creating Databases and Database Files
    * Creating a Database
    * Creating Schemas
    * Creating a Database Snapshot
After completing this module, students will be able to:
    * Create databases.
    * Create filegroups.
    * Create schemas.
    * Create database snapshots.

Module 2: Creating Data Types and Tables This module explains how to create data types and tables. It also describes how to create partitioned tables.
Lessons
    * Creating Data Types
    * Creating Tables
    * Creating Partitioned Tables
Lab 2: Creating Data Types and Tables
    * Creating Data Types
    * Creating Tables
    * Creating Partitioned Tables
After completing this module, students will be able to:
    * Create new data types.
    * Create new tables.
    * Create partitioned tables.

Module 3: Using XML This module explains how to use the FOR XML clause and the OPENXML function. It also describes how to use the xml data type and its methods.
Lessons
    * Retrieving XML by Using FOR XML
    * Shredding XML by Using OPENXML
    * Introducing XQuery
    * Using the xml Data Type
Lab 3: Using XML
    * Mapping Relational Data and XML
    * Storing XML Natively in the Database
    * Using XQuery with xml Methods
After completing this module, students will be able to:
    * Retrieve XML by using the FOR XML clause.
    * Shred XML by using the OPENXML function.
    * Use XQuery expressions.
    * Use the xml data type.

Module 4: Creating and Tuning Indexes This module explains how to plan, create, and optimize indexes. It also describes how to create XML indexes.
Lessons
    * Planning Indexes
    * Creating Indexes
    * Optimizing Indexes
    * Creating XML Indexes
Lab 4: Creating and Tuning Indexes
    * Creating Indexes
    * Tuning Indexes
    * Creating XML Indexes
After completing this module, students will be able to:
    * Plan indexes.
    * Create indexes.
    * Optimize indexes.
    * Create XML indexes.

Module 5: Implementing Data Integrity by Using Constraints This module explains how to implement constraints and provides an overview of data integrity.
Lessons
    * Data Integrity Overview
    * Implementing Constraints
Lab 5: Implementing Data Integrity by Using Constraints
    * Creating Constraints
    * Disabling Constraints
After completing this module, students will be able to:
    * Describe the options for enforcing data integrity in SQL Server 2005.
    * Implement data integrity in SQL Server 2005 databases by using constraints.

Module 6: Implementing Data Integrity by Using Triggers and XML Schemas This module explains how to implement triggers and XML schemas.
Lessons
    * Implementing Triggers
    * Implementing XML Schemas
Lab 6: Implementing Data Integrity by Using Triggers and XML Schemas
    * Creating Triggers
    * Implementing XML Schemas
After completing this module, students will be able to:
    * Implement data integrity in SQL Server 2005 databases by using triggers.
    * Implement data integrity in SQL Server 2005 databases by using XML schemas.

Module 7: Implementing Views This module explains how to create views.
Lessons
    * Introduction to Views
    * Creating and Managing Views
    * Optimizing Performance by Using Views
Lab 7: Implementing Views
    * Creating Views
    * Creating Indexed Views
    * Creating Partitioned Views
After completing this module, students will be able to:
    * Describe the purpose of views.
    * Create and manage views.
    * Explain how to optimize query performance by using views.

Module 8: Implementing Stored Procedures This module explains how to create stored procedures and functions. It also describes execution plans, plan caching, and query compilation.
Lessons
    * Implementing Stored Procedures
    * Creating Parameterized Stored Procedures
    * Working With Execution Plans
    * Handling Errors
Lab 8: Implementing Stored Procedures
    * Creating Stored Procedures
    * Working With Execution Plans
After completing this module, students will be able to:
    * Implement stored procedures.
    * Create parameterized stored procedures.
    * Work with execution plans.
    * Handle errors in stored procedures.

Module 9: Implementing Functions This module explains how to create functions. It also describes how to control the execution context.
Lessons
    * Creating and Using Functions
    * Working with Functions
    * Controlling Execution Context
Lab 9: Implementing Functions
    * Creating Functions
    * Controlling Execution Context
After completing this module, students will be able to:
    * Create and use functions.
    * Work with functions.
    * Control execution context.

Module 10: Implementing Managed Code in the Database This module explains how to implement managed database objects.
Lessons
    * Introduction to the SQL Server Common Language Runtime
    * Importing and Configuring Assemblies
    * Creating Managed Database Objects
Lab 10: Implementing Managed Code in the Database
    * Importing an Assembly
    * Creating Managed Database Objects
After completing this module, students will be able to:
    * Identify appropriate scenarios for managed code in the database.
    * Import and configure assemblies.
    * Create managed database objects.

Module 11: Managing Transactions and Locks This module explains how to use transactions and the SQL Server locking mechanisms to meet the performance and data integrity requirements of your applications.
Lessons
    * Overview of Transactions and Locks
    * Managing Transactions
    * Understanding SQL Server Locking Architecture
    * Managing Locks
Lab 11: Managing Transactions and Locks
    * Using Transactions
    * Managing Locks
After completing this module, students will be able to:
    * Describe how SQL Server 2005 transactions use locks.
    * Execute and cancel a transaction.
    * Describe concurrency issues and SQL Server 2005 locking mechanisms.
    * Manage locks.

Module 12: Using Service Broker This module explains how to build a messaging-based solution with Service Broker.
Lessons
    * Service Broker Overview
    * Creating Service Broker Objects
    * Sending and Receiving Messages
Lab 12: Using Service Broker (Optional)
    * Creating Service Broker Objects
    * Implementing the Initiating Service
    * Implementing the Target Service
After completing this module, students will be able to:
    * Describe Service Broker functionality and architecture.
    * Create Service Broker objects.
    * Send and receive Service Broker messages.

Module 13: Using Notification Services (Optional) This module explains how to develop applications that generate and send timely messages to subscribers.
Lessons
    * Introduction to Notification Services
    * Developing Notification Services Solutions
After completing this module, students will be able to:
    * Describe how Notification Services operates.
    * Develop a Notification Services application.
Prerequisites & Certificates
Pre-Requisites

This course requires that students 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. In addition, it is recommended, but not required, that students have completed: * Course 2778: Writing Queries Using Microsoft SQL Server 2008 Transact-SQL. * Course 2780: Maintaining a Microsoft SQL Server 2005 Database.

Certificates offered

The student kit includes a comprehensive workbook and other necessary materials for this class. Participants will receive a Certificate of completion


Cancellation Policy
10 business day cancellation policy. if the course is confirmed and the student cancels within 10 days of the course, then they get charged and apply a credit for future courses. If they cancel outside of 10 business days, then there are no charges at all.
Map & Reviews
CTE Solutions
[ View Provider's Profile ]

Reviews
 

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.

Here are some reviews of the training vendor.
I realize that we are constantly dealing with technology, but I still think for a registration fee of almost $3,000, that a hardcover book should be included. I know that the option to print the book on a one-time basis exists.
Reviewed by 2016
no
Reviewed by 2016
The instructor was very knowledgeable and answered all questions. Jarod did an excellent job presenting.
Reviewed by 2015
The room was cold. I had to sit next to the space heater. It would be good to tell future patrons to dress warmly AHEAD of time. No suprises.
Reviewed by 2015
He was great and offered his contact info for further questions.
Reviewed by 2015
Howard was a fantastic instructor and the course was exactly what I required.
Reviewed by 2014
The trainer was excellent - the course exceeded my expectations.
Reviewed by 2014
This course provides an excellent overview and a bit of practice on the various functions of SharePoint 2013. I was disappointed at the number of exceedingly long breaks given after each module. I would have preferred less break time and more content to the course. Having never taken a SharePoint course with another provider, I don't know if this is the norm with all providers of just this one in particular.
Reviewed by 2014
I ranked the "Use of Technology" low because for Users who were remote the VM's that were setup were a little wonky. Could be very slow at times and then sometimes they needed to be refreshed to work properly with the lab. In some instances we couldn't follow along as replication would not occur fast enough and we would have our lab cut short (for us remote Users).
Reviewed by 2014
The instructor was good at remembering to acknowledge the online students even though he was facing a classroom of students also.
Reviewed by 2014
Insructor was not so good with the live examples. Also the handouts was not so useful
Reviewed by 2013
The trainer was excellent, very knowledgeable and had a lot of valuable experience to share. The problem was that there were way too many workshops that took too long and interfered with getting the maximum benefit from the instructor and the course.
Reviewed by 2013
This was quite informative. It was a great opportunity to have ‘real life’ discussions with certified PMs. The instructor had excellent examples and was able to share his PM experiences with us with concrete examples. In addition, this was a great opportunity to network with private sector/public sector PMs and develop a better appreciation of PM on both sides of the fence. Cheers, CL
Reviewed by 2013
no
Reviewed by 2013
I did not like the video format
Reviewed by 2013
As a remote attendee, it appeared the instructor paid attention to the "Attendee" and "Chat" windows only a few times throughout the day, so I was not confident that he would see if I sent a message or raised my hand during the course.
Reviewed by 2013
The chairs were not very comfortable and the material contained spelling and grammatical error (a few but still)as well as repetition of words.
Reviewed by 2013
Was a bit slow the last 1/2 day. Of course, for some, this was the last of a 4 day course (not just 2 days).
Reviewed by 2013
I really enjoyed the course and I learned a lot. The pace was excellent.
Reviewed by 2013
good!
Reviewed by 2013
The room was excellent on its own - less distraction and no noise around you. There was no direction to the room when I walked in and therefore was not sure if I was heading in the right direction. We were not provided with the direction that there was coffee and fridge on the 3rd floor, and the bathroom floor was dirty.
Reviewed by 2012
This course was great, very informative, had Lionel as instructor and he was also very good.
Reviewed by 2012
Instructor was eager to assist but lacked subject matter expertise. Course time management was very poor. Content provided could have been delivered effectively in a one day course.
Reviewed by 2012
Good Course, good trainer. All questions addressed equally and in a timely professional manner.
Reviewed by 2011
The course content was interesting; however, the instructor didn't have enough knowledge about Microsoft Sharepoint 2010 Development and wasn't able to answer questions without google search. In the future CTE needs to make sure the instructors have real on-hands experience and are highly trained in the technologies they are supposed be teaching.
Reviewed by 2011
need-to-train-a-group-banner

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 279 times.