pad



Exploring SQL Server 2005 Training Series

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


    ZSQ05-CD-50padRegular price: $795.95padSale price: $695.95pad
    Select:: 
    • Enter Keyword(s):

    **Register Today and Save $$ with Planetlearn.com**
    Enter your email address and receive...

    • FREE coupon good for 10% off all online purchases..
    • FREE newsletter with exclusive offers on cbt training.
    • FREE Email Job Alerts provided by 10millionjobs.com.

    Join today and save! Enter your email address.
    Email:

    Prices are for single user. If you are looking for internet/intranet or LAN solutions and have specific training needs not listed, please call 207-671-1666 or E-Mail sales@planetlearn.com

    Partner Sites
    www.10millionjobs.com
    SAP Top Sites.com - Vote for Us!


    Planetlearn
    107 Elm Street Suite 205G
    Portland, ME 04101
    207-671-1666

    Press Ctrl+ D to bookmark this page.

    Order securely online or call 207-671-1666
    Office hours: Monday - Friday, 9am to 5pm Eastern Standard Time