Email Us   Phone : 503-259-0312   
  Home    |    Instructor-led Training    |    Self-Paced Learning    |    Online Training     


Contact Us   -   Why Choose Wintrac   -   Clients    

Order CD-ROMs   Order Videos 
Exploring SQL Server 2005
with Don Kiely


View the Course Outline

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
Format Sessions Retail Price
Exploring SQL Server 2005
CD-ROM

 6 CD-ROMs

$395.00  
DVD-ROM

  1 DVD-ROM

$395.00  
Read about with Don Kiely .
Course Outline (Outlines are subject to change.)
Exploring SQL Server 2005

Sessions Run Time
6 9 hours

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
T-SQL Enhancements - Part 1
  • New Data Types
  • Using TOP
  • Using DML Output
  • Pivot/Unpivot Operators
T-SQL Enhancements - Part 2
  • Ranking Functions
  • Using Other Ranking Functions
  • Common Table Expressions
  • Using DDL Triggers

back to top


Your Instructor

Don Kiely
has been using and programming computers since the mid-1970s, when he first punched IBM punch cards for batch processing to solve engineering problems. Since then, he has been writing business software using assembly, C/C++, dBASE, Nantucket Clipper, RPG II, C#, and Visual Basic, for a variety of industries. He has authored and coauthored several programming books. He is an XML, ASP.NET, Visual Basic .NET, C#, and SQL Server instructor for and has taught software and business administration courses at community colleges. Based in Fairbanks, Alaska but constantly on the road, he is a consultant for a variety of companies that develop distributed applications for public and private organizations. Don is also the author or coauthor of several programming books, and a featured speaker at SQL Server conferences.

back to top


 
About us
Contact us
Careers at Wintrac
Our Clients
Why Wintrac


Register for a free training CD-ROM drawing
Refer a client or instructor and earn $$$


Wintrac Inc.
16523 SW McGwire Ct.
Beaverton OR 97007
 
© Wintrac, Inc. All rights reserved.                                                                               Site Map   |   Terms of Use   |   Privacy Policy