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

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

Looking for SQL Server 2005 training?

Microsoft SQL Server 2008 Training Overview

Accelebrate's SQL Server 2008 training: Introduction to SQL Server 2008 for Developers and Query Writers training course teaches attendees the skills they need to successfully build, query, and interact with Microsoft SQL Server 2008.

Note: This course can also be taught using SQL Server 2008 R2.

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 2008 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 2008 Training Materials

All students will receive:

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

Software Needed on Each Student PC

Windows Server 2003 or 2008, Windows XP Professional, Windows Vista Ultimate or Business, or 7 with at least 2GB RAM
SQL Server 2008
Visual Studio 2008

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

Microsoft SQL Server 2008 Training Objectives

All attendees will learn to:

Use the programming environment in SQL Server Management Studio 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
Implement the SQL Server 2008 security model; and create logins, users and permissions to protect your data
Utilize the fundamentals of Reporting Services, Analysis Services, Integration Services and the Service Broker
Configure and tune SQL Server 2008 and monitor database activity

Microsoft SQL Server 2008 Training Outline

Important Note:

Introducing SQL Server 2008

What's New in SQL Server?
SQL Server Editions
Installing SQL Server

Basics of Database Design

Normalization
Denormalization
Tools for Normalization in SQL Server
Introducing SQL Server Management Studio
Creating a Database
Adding Tables
Creating Indexes and Constraints
Building Relations

T-SQL Basics

What is T-SQL?
Syntax Conventions
Introducing AdventureWorks2008
Executing SQL Statements
Identifiers
Creating Data Types
Operators
Variables
Functions
Using T-SQL to Build and Alter Objects

SELECT Queries

The SELECT Clause
The FROM Clause
The WHERE Clause
The ORDER BY Clause
Using GROUP BY and HAVING
Using TOP N and TOP N PERCENT
UNION Queries
Full-Text Search

Action Queries

SELECT INTO queries
DELETE queries
TRUNCATE TABLE queries
INSERT queries
UPDATE queries
MERGE queries

Locking and Execution Plans

What is Locking?
Monitoring Locks
Tuning Locking
Deadlocks
Tuning Queries
Management Data Warehouse
Performance Studio

Views, Stored Procedures, and Functions

Using Views
Using Stored Procedures
Using Functions

Advanced Transact-SQL

Transactions
Rowset Functions
Ranking Functions
Cursors
Structured Error Handling

XML and SQL Server

XML Columns and Indexes
Querying and Modifying XML Data
Using OPENXML
Using FOR XML

Triggers

Creating DML Triggers
Altering DML Triggers
Using the Inserted and Deleted Tables
Checking Updated Columns
Recursive and Nested Triggers
Creating DDL Triggers

.NET inside of SQL Server

Creating CLR User-Defined Functions
Creating CLR Stored Procedures
Using the Sql Namespace
Creating CLR Triggers
Creating CLR User-Defined Types
Choosing When To Use CLR Objects

SMO and RMO Programming

Retrieving Server Information
Working With Database Objects
Generating Scripts
Viewing and Modifying Server Configuration
Understanding RMO

Data Protection/Tracking

Understanding Change Data Capture
Data Capture Schema and Tables
Transparent Data Encryption

SQL Server 2008 Analysis Services

Understanding Analysis Services
Introducing Business Intelligence Development Studio
Creating a Data Cube
Exploring a Data Cube

SQL Server 2008 Integration Services

The Import and Export Wizard
Creating a Package
Working with Connection Managers
Building Control Flows
Building Data Flows
Creating Event Handlers
Saving and Running Packages

SQL Server 2008 Reporting Services

The Reporting Services Architecture
Using Report Designer
Publishing a Report
Using Report Builder
Using Report Manager

Service Broker

Service Broker Terminology
Creating a Service Broker Application
Processing Messages with Stored Procedures
Using Service Broker Across Servers

Security and SQL Server

Choosing Service Accounts
Authentication Modes
Roles and Users
Permissions
Object Ownership

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.