SQL Server Training: Introduction to SQL Server 2005 for Developers and Query Writers

Course Number: SQL-110
Duration: 5 days
view class outline

Looking for the SQL Server 2008 version of this class?

Microsoft SQL Server 2005 Training Overview

Accelebrate's Introduction to SQL Server 2005 for Developers and Query Writers training teaches attendees the skills they need to successfully build, administer, and query Microsoft SQL Server 2005 databases.

Location and Pricing

Most Accelebrate courses are taught on-site at our clients' locations worldwide for groups of 3 or more attendees and are customized to their specific needs. Please visit our client list to see organizations for whom we have recently delivered training. These courses can also be delivered as live, private online classes for groups that are geographically dispersed or wish to save on the instructor's or students' travel expenses. To receive a customized proposal and price quote private training at your site or online, please contact us.

In addition, some courses are available as live, online classes for individuals. To see a schedule of online courses, please visit http://www.accelebrate.com/online_training/?action=category&page=mssql.

Microsoft SQL Server 2005 Training Prerequisites

No prior experience is presumed.

Hands-on/Lecture Ratio

This class is 70% hands-on, 30% lecture, with the longest lecture segments lasting for 10 minutes.

Microsoft SQL Server 2005 Training Materials

All students will receive:

More than 500 pages of fully-illustrated courseware
A copy of Apress' Pro SQL Server 2005

Software Needed on Each Student PC

Windows 2000 Pro, XP Pro, Windows Server 2003, Windows Server 2008, Vista Business/Ultimate, or 7 with latest service packs applied
Microsoft IIS turned on prior to SQL Server installation
SQL Server 2005 full install, including Integration, Analysis, and Reporting Services, with latest service packs applied
At least 2GB RAM (3GB recommended)
Sample databases and related tools - please contact us for a detailed setup sheet

Important Note: If you have purchased this class, please contact us for detailed setup instructions.

Microsoft SQL Server 2005 Training Objectives

All attendees will learn to:

Use the programming environment in the Query Analyzer and learn the Transact-SQL language
Understand the differences between view, stored procedures, triggers, and user-defined functions, and know the advantages and drawbacks of each
Understand the SQL Server 2005 security model; and create logins, users and permissions to protect your data
Utilize the fundamentals of Reporting Services, Notification Services, and the Service Broker.
Configure and tune SQL Server 2005, and monitor database activity

Microsoft SQL Server 2005 Training Outline

Important Note:

Advanced SQL Server 2005 training

Introducing SQL Server

Major features
Limits
Editions
Installing SQL Server

Basics of Database Design

Normalization
Denormalization
Tools for Normalization in SQL Server

Building a Database

Introducing SQL Server Management Studio
Databases
Tables
Indexes
Relations
Using T-SQL to build and alter objects

T-SQL Basics

What is SQL?
Reading syntax diagrams
Identifiers
Datatypes
Operators
Wild cards
Variables
Functions
Using sqlcmd

SELECT Queries

The SELECT clause
The FROM clause
The WHERE clause
Using Joins
ORDER BY
GROUP BY and HAVING
TOP N and TOP N%
OVER
Full-text search

Action Queries

DELETE
TRUNCATE TABLE
UPDATE
INSERT
SELECT INTO

Locking and Execution Plans

What is Locking?
Monitoring Locks
Tuning Locking
Deadlocks
Tuning Queries

Views, Stored Procedures, and Functions

Partitioning and Joining Tables with Views
Updateable views
Indexed Views
Information Schema Views
Catalog Views
Stored Procedures
Functions

Advanced Transact-SQL

Transactions
Distributed Transactions
Rowset Functions
Ranking Functions
Cursors
Structured Error Handling

XML and SQL Server

Using FOR XML
Using XQuery
HTTP SOAP access to data

Triggers

INSERT triggers
DELETE triggers
UPDATE triggers
INSTEAD OF triggers
Recursive triggers
DDL triggers

.NET inside of SQL Server

Understanding .NET and the CLR
Using CLR objects in SQL Server
Using the Sql namespace

SMO and RMO Programming

What is SMO?
The SMO Object Model
Sample SMO tasks
Sample RMO tasks

Analysis Services

Understanding Analysis Services
Introducing BIDS
Creating a Data Cube
Exploring a Data Cube

SQL Server Integration Services

SSIS Architecture
SSIS Tasks
SSIS in action

Notification Services

The Notification Services Architecture
Using Notification Services

Reporting Services

The Reporting Services Architecture
Building Reports
Managing Reporting Services

Service Broker

The Service Broker Architecture
Using Service Broker

Security and SQL Server

Security modes and authentication
Fixed server roles
Database user accounts
Permissions
Database roles
Ownership chains

Conclusion

VB.NET, C#, ASP, & ASP.NET Training

Java Training

SQL Server Training
SharePoint Training

Adobe Training

“Accelebrate,” “Accelerated Learning Celebrated Results,” and the Accelebrate logo are registered trademarks of Accelebrate, Inc. All other product names and trademarks are property of their respective owners. Course outline content may mirror or be derived from the book that each student receives with the course. Otherwise, all content is copyright © 2003- by Accelebrate, Inc. of Atlanta, Georgia, USA. To contact us, please use the contact form, email info@accelebrate.com us, or call 1 877 849 1850 in the US and Canada, 0808 234 2132 in the UK, 1 800 550 311 in Ireland, or +1 678 648 3113 from all other locations.