Home > SQL Server Training CD ROMs > Exploring SQL Server 2005 Training Series

Exploring SQL Server 2005 Training Series

Product Description

Want to get up to speed on Microsoft's new SQL Server 2005? SQL Server 2005 is a major upgrade from its very successful predecessor, SQL Server 2000. This course introduces you to the new technological advances in SQL Server 2005 that provide businesses decreased downtime, increased scalability and performance, and set a new standard on data security. You will also learn about many new features that greatly reduce application development time allowing developers to be highly productive.

Course includes 9+ hours of total training time...

6 modules of training

Over 9 hours of media run time

Sample code

Course Outline

This course looks at many of the new features within SQL Server 2005 and will give you a first look at Microsoft’s new powerful database server.

Introduction to SQL Server 2005

Database Engine
Security
Analysis Services
Integration Services
Reporting Services
Notification Services

SQL Management Tools

Management Studio
Reports
Template Explorer
SQL Server Profiler
Database Tuning Advisor
Configuration Manager
Surface Area Configuration
SQLCMD

Authorization

Strong Password Policies
Password Policies
Changing a Login
SQL 2005 Principals
Securable Objects
Metadata Visibility

Security in Practice

Execution Contexts
Ownership Chains
When to Use Each Option
Users and Schemas
Synonyms

Encryption

Algorithms
Encryption Hierarchy
Service Master Key
Database Master Key
Use a Certificate
Asymmetric Keys
Symmetric Keys

SQLCLR

Introduction to SQLCLR
Why Use SQLCLR Code?
Creating Raw SQLCLR Code
Create with Visual Studio
Deploy the UDF
Deployment Notes
Data Access in SQLCLR
User-Defined Functions
Stored Procedures

More SQLCLR

Write a SQLCLR Stored Procedure
User-Defined Aggregates
Triggers
User-Defined Types
Troubleshooting Code
Security in SQLCLR
Permission Sets
Secure Coding Practices
T-SQL vs SQLCLR

SQL Management Objects

Management Frameworks
SMO Object Model
SMO Class Types
Code Behind the SMO Demo
Code to Connect to the Server
Create a Database
Delete a Database
Create a Table

SQL Express & Visual Studio Integration

Introducing SQL Express
Client and Management Tools
Design Time Features
Create a Database Application
Deploy the Database Application
Server Explorer Features
SQL Reporting Services

ADO.NET Enhancements

New Data Types
Multiple Active Result Sets
Asynchronous Queries
Asynchronous Methods
Error Handling
Query Notifications
Working with Service Broker
Setup Database for Service Broker

Client Access Enhancements

Batch Updates
Bulk Copy
Changes to the DataTable
Stream Data into DT/DS
DataTable from a DataView
New Rowstate Features

XML

XML Data Type
Typed XML Data
Indexing XML Data
Using the XML Schema
Querying XML
XML Data Type Methods
XQuery Limits in SQL Server

T-SQL XML Enhancements

Retrieving XML
Path for Returning XML Data
Include Multiple Paths
Output Column Data as a TN
Include an Inline XML Schema
Nested FOR XML Queries
OpenXML Enhancements
XML Bulk Load

Web Services

Exposing Web Services
Create a Stored Procedure
Create a Web Service
View the WSDL

Multimedia Training DVD 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.

Certificate of Completion
Planetlearn's Career Academy is recognized worldwide for its technology-based IT training curriculums. Upon successful completion of our program, you will be receiving a Career Academy Distance Education Certificate of Completion.

"Training Desktop Users, IT, and Business Professionals since 1997."

Yahoo has awarded us with the Top Service Star! "Those with a star are the best of the best, with at least 95% positive ratings."