Your privacy matters: This site uses cookies to analyze site usage and provide social media features. Learn More.

Introduction to SQL Server 2008 for Developers and Query Writers

SQL-200 (5 Days)
4.49 out of 5 (81 reviews)  

Request Pricing

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 delivered as private, customized, on-site training at our clients' locations worldwide for groups of 3 or more attendees and are custom tailored to their specific needs. Please visit our client list to see organizations for whom we have delivered private in-house 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 for private training at your site or online, please contact us.

In addition, some courses are available as live, online classes for individuals. See a schedule of online courses.

SQL Server 2008 Training Objectives

  • 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

SQL Server 2008 Training Outline

Expand All | Collapse All | Printer-Friendly

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
Request Pricing

Lecture percentage

40%

Lecture/Demo

Lab percentage

60%

Lab

Course Number:

SQL-200

Duration:

5 Days

Prerequisites:

No prior experience is presumed.

Training Materials:

Software Requirements:

  • Windows XP or later, or Windows Server 2003 or later, with the latest service pack updates and at least 3 GB RAM
  • SQL Server 2008 installed (we will provide detailed installation instructions)
  • Visual Studio 2008
  • Related databases and lab files - please contact us for details

Contact Us:

Accelebrate’s training classes are available for private groups of 3 or more people at your site or online anywhere worldwide.

Don't settle for a "one size fits all" public class! Have Accelebrate deliver exactly the training you want, privately at your site or online, for less than the cost of a public class.

For pricing and to learn more, please contact us.

Contact Us

Toll-free in US/Canada:
877 849 1850
International:
+1 678 648 3113

Toll-free in US/Canada:
866 566 1228
International:
+1 404 420 2491

925B Peachtree Street, NE
PMB 378
Atlanta, GA 30309-3918
USA

Subscribe to our Newsletter:

Never miss the latest news and information from Accelebrate:

Microsoft Partner

Please see our complete list of
Microsoft Official Courses

Recent Training Locations

Alabama

Huntsville

Montgomery

Birmingham

Alaska

Anchorage

Arizona

Phoenix

Tucson

Arkansas

Fayetteville

Little Rock

California

San Francisco

Oakland

San Jose

Orange County

Los Angeles

Sacramento

San Diego

Colorado

Denver

Boulder

Colorado Springs

Connecticut

Hartford

DC

Washington

Florida

Fort Lauderdale

Miami

Jacksonville

Orlando

Saint Petersburg

Tampa

Georgia

Atlanta

Augusta

Savannah

Idaho

Boise

Illinois

Chicago

Indiana

Indianapolis

Iowa

Ceder Rapids

Des Moines

Kansas

Wichita

Kentucky

Lexington

Louisville

Louisiana

Banton Rouge

New Orleans

Maine

Portland

Maryland

Annapolis

Baltimore

Hagerstown

Frederick

Massachusetts

Springfield

Boston

Cambridge

Michigan

Ann Arbor

Detroit

Grand Rapids

Minnesota

Saint Paul

Minneapolis

Mississippi

Jackson

Missouri

Kansas City

St. Louis

Nebraska

Lincoln

Omaha

Nevada

Reno

Las Vegas

New Jersey

Princeton

New Mexico

Albuquerque

New York

Buffalo

Albany

White Plains

New York City

North Carolina

Charlotte

Durham

Raleigh

Ohio

Canton

Akron

Cincinnati

Cleveland

Columbus

Dayton

Oklahoma

Tulsa

Oklahoma City

Oregon

Portland

Pennsylvania

Pittsburgh

Philadelphia

Rhode Island

Providence

South Carolina

Columbia

Charleston

Spartanburg

Greenville

Tennessee

Memphis

Nashville

Knoxville

Texas

Dallas

El Paso

Houston

San Antonio

Austin

Utah

Salt Lake City

Virginia

Richmond

Alexandria

Arlington

Washington

Tacoma

Seattle

West Virginia

Charleston

Wisconsin

Madison

Milwaukee

Alberta

Edmonton

Calgary

British Columbia

Vancouver

Nova Scotia

Halifax

Ontario

Ottawa

Toronto

Quebec

Montreal

Puerto Rico

San Juan

© 2013-2019 Accelebrate, Inc. All Rights Reserved. All trademarks are owned by their respective owners.