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 Gold 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.