List Price: |
Special Price: |
|
 |
 |
Schedule our instructor led classroom training at your convenience and never miss another lecture or fall behind. You are in complete control. We invited the best SQL Trainers in the industry to help us develop the ultimate training & certification program.
This course provides students with the knowledge and skills to upgrade their skills to SQL Server 2005 so that they can design, build, query and develop enterprise SQL Server 2005 databases and servers.
Package Includes:
- 8 Sessions featuring live instructor-led classroom sessions with full audio, video and demonstration components
- Printable courseware
- Step-by-step hands-on-labs
- Exclusive LearningZone Live Mentor (Value at $195)
Help Whenever you need it! Exclusive LearningZone - Chat Live with our Certified Instructors anytime around the clock (7x24) - Focused on practical solutions to real-world development problems
- Comprehensive, understandable, and reusable as reference material
- Free 1 Year Upgrade Policy
Mark Russell - SQL 2005 Trainer (MCT, MCDBA, MCSD.NET, MCSE Security, CEH, Security+)
Mark Russell has over twenty years total networking and programming experience with a current focus enterprise database development and training using Microsoft SQL Server tools and technologies. Mark is a Certified Technical Trainer. He has taught over 500 Desktop Applications classes and over 500 Technical classes. Mark has completed Microsoft approved Train-the Trainer Program. He was named Instructor of the Year in 1999 with New Horizons Worldwide. As a Microsoft Certified Trainer, Mark has maintained an overall class (Instructor score) average of 9.62 on a 10 scale.
Course Features:
- Main Menu
Move through hours of in-depth content - quickly and easily due to the efficient and organized structure. - PowerPoint
Utilizing PowerPoint presentations enhances the delivery by displaying a variety of visual information to the user. This type of representation allows the user to better interpret the material through charts, definitions, graphs, and more... - Exclusive Learning Zone
Train around the clock, around the world. Our certified online instructors are located at global support centers in the U.S., U.K., Australia, and Singapore to provide real-time answers to technology- and soft-skill-related questions 24x7. This means access to a live subject matter expert no matter where you are - day or night. This level of student/instructor interaction provides real-time training specific support and extends training beyond content and instructor-led solutions by providing flexibility to accommodate individual needs and schedules. - Controls
Move forward, back, and repeat entire topics or just a section. A progress bar illuminates as you advance through exercises.
- Full Motion Video
All courses feature full-motion videos of instructors teaching the information as if they are speaking directly to you. Our unique delivery simulates a one-on-one classroom environment creating a more personal lesson and learning experience. - Study Guides
Printable study guides for the entire course are available. This allows all material to be viewed, reviewed, and printed for viewing at a later date. - Review Exercises
Each section has a review quiz to aid in the learning process by validating the comprehension of the material covered before moving on to a new section. - Resume
All courses are resumed to where you left off last session allowing you to learn when it is convenient for you without the hassle of remembering where you where. - Live Demonstrations
Demonstrations are a way for the instructor to show and tell the user how to perform a task by actually doing it on screen in front of them. In this format it gives the user the power to see things done by a professional in the intended environment as many times as they would like. - Labs
This course features cutting-edge, interactive labs, which provide a hands-on learning experience. This environment allows you to interact with the software with out the need for purchasing it or having it installed on your computer. - Certificate of Completion
Our training is recognized worldwide for its technology-based IT training curriculums. Upon successful completion of our program, you will be receiving an official Distance Education Certificate of Completion.
Module 1
What's New In SQL Server 2005 for Developers
SQL Server 2005 Developer Tools
SQL Server Management Studio
Demo - SQL Server Management Studio
SQL Server Security
Business Intell Development Studio
Demo - Extra Features
Transact-SQL Enhancements
Reporting Services Enhancements
SQL Server Integration Services
SQL CLR Support
Notification Services
Service Broker
Native HTTP Support
ADO.NET 2.0
SQL Management Objects
Lab - Disconnected Query
Module 1 Wrap-up
SQL Server Management Studio
Demo - SQL Server Management Studio
SQL Server Security
Business Intell Development Studio
Demo - Extra Features
Transact-SQL Enhancements
Reporting Services Enhancements
SQL Server Integration Services
SQL CLR Support
Notification Services
Service Broker
Native HTTP Support
ADO.NET 2.0
SQL Management Objects
Lab - Disconnected Query
Module 1 Wrap-up
Module 2
Enhancements to T-SQL in SQL Server 2005
New Data Definition Language Features
New Data Types
New Large Value Types
XML Data Type
Table Partitioning
Demo - Table Partitioning
Indexing Enhancements
Common Table Expressions
Demo - Common Table Expressions
Recursive Common Table Expressions
The OUTPUT Keyword
PIVOT and UNPIVOT Operators
Demo - Pivoting
The APPLY Operator
Demp - APPLY
Ranking Functions
Demo - Ranking Functions
Structured Exception Handling
Lab - Partitioning a Table
Module 2 Wrap-up
New Data Types
New Large Value Types
XML Data Type
Table Partitioning
Demo - Table Partitioning
Indexing Enhancements
Common Table Expressions
Demo - Common Table Expressions
Recursive Common Table Expressions
The OUTPUT Keyword
PIVOT and UNPIVOT Operators
Demo - Pivoting
The APPLY Operator
Demp - APPLY
Ranking Functions
Demo - Ranking Functions
Structured Exception Handling
Lab - Partitioning a Table
Module 2 Wrap-up
Module 3
New XML Features in SQL Server 2005
FOR XML Enhancements
Demo - FOR XML Enhancements
OPENXML Enhancements
The XML Data Type
Using Untyped XML
Demo - Untyped XML
XML Schema Collections
Strongly Typed XML
Demo - Strongly Typed XML
XML Indexes
Creating XML Indexes
Using XQuery
Demo - XQuery Expressions
XQuery: Modifying Data
XQuery: Shredding
Demo - XQuery Nodes and Modify
Lab - Returning XML from Relational Data
Module 3 Wrap-up
Demo - FOR XML Enhancements
OPENXML Enhancements
The XML Data Type
Using Untyped XML
Demo - Untyped XML
XML Schema Collections
Strongly Typed XML
Demo - Strongly Typed XML
XML Indexes
Creating XML Indexes
Using XQuery
Demo - XQuery Expressions
XQuery: Modifying Data
XQuery: Shredding
Demo - XQuery Nodes and Modify
Lab - Returning XML from Relational Data
Module 3 Wrap-up
Module 4
SQL Server 2005 Service Broker
Service Broker Architecture
Service Broker Security
Enabling Service Broker
Implementing Services
Creating Message Types
Demo - Creating Message Types
Creating Contracts
Demo - Creating a Simple Contract
Creating Queues
Demo - Creating Queues
Creating Services
Demo - Creating Services
Sending & Receiving Messages
Demo - Sending & Receiving Messages
Lab - Creating Service Broker Objects
Module 4 Wrap-up
Service Broker Security
Enabling Service Broker
Implementing Services
Creating Message Types
Demo - Creating Message Types
Creating Contracts
Demo - Creating a Simple Contract
Creating Queues
Demo - Creating Queues
Creating Services
Demo - Creating Services
Sending & Receiving Messages
Demo - Sending & Receiving Messages
Lab - Creating Service Broker Objects
Module 4 Wrap-up
Module 5
SQL Server 2005 Native HTTP Support
Web Services
Native HTTP Support
Native HTTP Usage Scenarios
Native HTTP Architecture
Creating an HTTP Endpoint
Demo - Creating an HTTP Endpoint
Securing an HTTP Endpoint
Calling HTTP Endpoints from Client Apps
Demo - Securing an HTTP Endpoint
Lab - Creating an HTTP Endpoint
Module 5 Wrap-up
Native HTTP Support
Native HTTP Usage Scenarios
Native HTTP Architecture
Creating an HTTP Endpoint
Demo - Creating an HTTP Endpoint
Securing an HTTP Endpoint
Calling HTTP Endpoints from Client Apps
Demo - Securing an HTTP Endpoint
Lab - Creating an HTTP Endpoint
Module 5 Wrap-up
Module 6
SQL Server 2005 Notification Services
Notification Services Architecture
Subscription Management
Event Providers
Notification Generation
Notification Formatting
Building Notifications
Design Considerations
The Configuration File
Demo - The Configuration File
The Application Definition File
Demo - The Application Definition File
Managing Notification Services
Demo - Notification Services
Subscription Management Applications
Demo - Subscription Management
Using Event Providers
Demo - Event Providers
Best Practices
Lab - Creating an Event Provider
Module 6Wrap-up
Subscription Management
Event Providers
Notification Generation
Notification Formatting
Building Notifications
Design Considerations
The Configuration File
Demo - The Configuration File
The Application Definition File
Demo - The Application Definition File
Managing Notification Services
Demo - Notification Services
Subscription Management Applications
Demo - Subscription Management
Using Event Providers
Demo - Event Providers
Best Practices
Lab - Creating an Event Provider
Module 6Wrap-up
Module 7
.NET CLR Integration in SQL Server 2005
The .NET Common Language Runtime
Features of Managed Code
SQL Server 2005 Hosting the CLR
When to Use Managed Code
Intro to Managed Code in SQL Server
Demo - Managed Code
.NET CLR Security
SQL Projects in Visual Studio 2005
Demo - SQL Server Project
Microsoft.SqlServer.Server Namespace
Creating Managed Stored Procedures
Managed User Defined Functions
Creating Managed Triggers
Creating Managed Aggregates
Creating Managed Data Types
Deploying Managed Database Objects
Demo - SQL ClR
Lab - Creating a Managed Stored Procedure
Module 7 Wrap-up
Features of Managed Code
SQL Server 2005 Hosting the CLR
When to Use Managed Code
Intro to Managed Code in SQL Server
Demo - Managed Code
.NET CLR Security
SQL Projects in Visual Studio 2005
Demo - SQL Server Project
Microsoft.SqlServer.Server Namespace
Creating Managed Stored Procedures
Managed User Defined Functions
Creating Managed Triggers
Creating Managed Aggregates
Creating Managed Data Types
Deploying Managed Database Objects
Demo - SQL ClR
Lab - Creating a Managed Stored Procedure
Module 7 Wrap-up
Module 8
Developing Client Applications for SQL Server 2005
ADO.NET Overview
ADO.NET 2.0 Enhancements
Demo - Async
MARS
Demo - MARS
Managed Bulk Copy
Demo - Bulk Copy
Batch Update
Demo - Batch Update
Lab - Creating a MARS Application
Module 8 Wrap-up
Course Closure
ADO.NET 2.0 Enhancements
Demo - Async
MARS
Demo - MARS
Managed Bulk Copy
Demo - Bulk Copy
Batch Update
Demo - Batch Update
Lab - Creating a MARS Application
Module 8 Wrap-up
Course Closure