1-877-WEBUCATE
(1-877-932-8228)
info@webucator.com
 
Microsoft Training
Java Training
XML Training
Database & SQL Training
PHP, Perl, ASP, Groovy, Grails, Ruby on Rails Training
HTML, JavaScript, Ajax & CSS Training
Adobe Training
◊ PRIVATE SQL SERVER TRAINING


Need a private class for your team delivered at your site or a location near you?
For private groups of three or more, Webucator offers completely customizable and cost-effective SQL Server classes delivered at your offices or a location near you.

To have someone contact you about these classes, please fill out the form below.

* (Required)
* (Required)
* (Required)
* (Required)
* (Required)
(The number of people requiring training)
(For Federal Government Pricing)
* (Required)

Microsoft SQL Server 2005 Training (5 days)

This SQL Server class is delivered for private groups onsite at your offices or a location of your choice. It can also be delivered via the Internet for geographically distributed staff.

Click here for our public SQL Server classes

Microsoft SQL Server 2005 Training Course Overview

This SQL Server 2005 training course teaches students how to build, administer, and query Microsoft SQL Server 2005 databases.

Microsoft SQL Server 2005 Training Course Goals

  • Learn to use the programming environment in the Query Analyzer.
  • Learn the Transact-SQL language .
  • Learn to work with views, stored procedures, triggers, and user-defined functions.
  • Learn the SQL Server 2005 security model.
  • Learn to create logins, users and permissions to protect your data.

Microsoft SQL Server 2005 Training Course Outline

  1. Introducing SQL Server
    1. Major features
    2. Limits
    3. Editions
    4. Installing SQL Server
  2. Basics of Database Design
    1. Normalization
    2. Denormalization
    3. Tools for Normalization in SQL Server
  3. Building a Database
    1. Introducing SQL Server Management Studio
    2. Databases
    3. Tables
    4. Indexes
    5. Relations
    6. Using T-SQL to build and alter objects
  4. T-SQL Basics
    1. What is SQL?
    2. Reading syntax diagrams
    3. Identifiers
    4. Datatypes
    5. Operators
    6. Wild cards
    7. Variables
    8. Functions
    9. Using sqlcmd
  5. SELECT Queries
    1. The SELECT clause
    2. The FROM clause
    3. The WHERE clause
    4. Using Joins
    5. ORDER BY
    6. GROUP BY and HAVING
    7. TOP N and TOP N%
    8. OVER
    9. Full-text search
  6. Action Queries
    1. DELETE
    2. TRUNCATE TABLE
    3. UPDATE
    4. INSERT
    5. SELECT INTO
  7. Locking and ShowPlan
    1. What is Locking?
    2. Monitoring and tuning Locking
    3. Deadlocks
    4. Application Locks
    5. Tuning Queries with ShowPlan
  8. Views, Stored Procedures, and Functions
    1. Partitioning and Joining Tables with Views
    2. Updateable views
    3. Indexed Views
    4. Information Schema Views
    5. Catalog Views
    6. Stored Procedures
    7. Functions
  9. Advanced Transact-SQL
    1. Transactions
    2. Distributed Transactions
    3. Rowset Functions
    4. Ranking Functions
    5. Cursors
    6. Structured Error Handling
  10. XML and SQL Server
    1. Using FOR XML
    2. Using XQuery
    3. HTTP SOAP access to data
  11. Triggers
    1. INSERT triggers
    2. DELETE triggers
    3. UPDATE triggers
    4. INSTEAD OF triggers
    5. Recursive triggers
    6. DDL triggers
  12. Security and SQL Server
    1. Security modes and authentication
    2. Fixed server roles
    3. Database user accounts
    4. Permissions
    5. Database roles
    6. Ownership chains

Microsoft SQL Server 2005 Training Course Materials

In addition to a comprehensive set of materials, including course notes and all the programming examples, each student will also receive a one-year subscription to Webucator's online reference library, which contains hundreds of the most current electronic technology books - a $149.95 per student value.

Microsoft SQL Server 2005 Training Course Technical Requirements and Setup Instructions

Click here for technical requirements and setup instructions

home - onsite classes - instructor-led online courses - self-paced online courses - why webucator - partners - contact - sitemap
© 2009 Webucator. All rights reserved. info@webucator.com | Toll Free: 877-WEBUCATE (877-932-8228) | From Outside the USA: 315-849-2724 | Fax: 315-410-5320
Phoenix, AZ | Santa Clara, CA | Santa Clara, CA | Los Angeles, CA | Sacramento, CA | Washington, DC | Atlanta, GA | Chicago, IL | Indianapolis, IN | Muncie, IN
New Orleans, LA Boston, MA | Cambridge, MA | Charlestown, MA | Framingham, MA | Ipswich, MA | Lincoln, MA | Wellesley, MA | Worcester, MA | Bangor, ME | Detroit, MI
Raleigh, NC Winston-Salem, NC | Lincoln, NE | East Hanover, NJ | Eatontown, NJ | Madison, NJ | Parsippany, NJ | Trenton, NJ | Albany, NY | Buffalo, NY | Rochester, NY
New York City, NY | Syracuse, NY | West Babylon, NY | Dayton, OH | Bethlehem, PA | Philadelphia, PA | Pittsburgh, PA | Pittsburgh, PA | State College, PA
Middletown, RI | Rapid City, SD | Austin, TX | Dallas, TX | Houston, TX | Arlington, VA | McLean, VA | Seattle, WA | Toronto, Canada | Ottawa, Canada | Calgary, CA