PrintE-mail

Updating Your Database Development Skills to Microsoft SQL Server

 
Updating Your Database Development Skills to Microsoft SQL Server
View Full-Size Image



Updating Database Development Skills to MS SQL Server 2005 Online $695.00  $495.00

:

Updating Database Development Skills to MS SQL Server 2005 DVD $695.00  $495.00

:



Updating Your Database Development Skills to Microsoft SQL Server


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. Before taking this course, students must have: MCDBA certification or equivalent knowledge, development experience with Microsoft SQL Server 2000 or Microsoft SQL Server 7.0, knowledge of SQL Server 2000/7.0: Database and Server Architecture. In addition, students must have experience with: Database security, Transact SQL, Query Engine, DDL, DML, Optimization, Schema and Objects, Programming Objects, UDF, Triggers, Stored Procedures, Optimization, SQL XML, .NET Development (Visual Basic .NET or C# .NET) and ADO.NET.

This course is intended for experienced database developers and database administrators, who are responsible for the design, build, query, and develop enterprise SQL Server 2005 databases and servers.

Package Includes

  • The Online course features live instructor-led classroom sessions with full audio, video and demonstration components
  • Printable courseware
  • Step-by-step hands-on-labs Try out one of our labs...*
  • Exclusive LearningZone Live Mentor Click for Details (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
  • *These product options are only available in the DVD/CD CBT format and not available in the On-Line Delivery

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 were.
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.

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

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

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

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

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

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 6 Wrap-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

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




You may also be interested in this/these product(s)

Updating Your Database Administration Skills to Microsoft SQL Server
Updating Your Database Administration Skills to Microsoft SQL Server
$495.00
Microsoft SQL Server 2005 Training Suite
Microsoft SQL Server 2005 Training Suite
$3,995.00
$1,795.00
You Save: $2,200.00


Last Updated: Friday, 30 July 2010 17:58
RocketTheme Joomla Templates