Request Info

Salutation

First Name

Last Name

Job Title

Department

Mailstop

Company

Address

P.O. Box

City

Province

Postal Code

Country
List

Work Telephone

Ext.

E-mail Address

Information provided will be used to communicate with you about our products.
Privacy Statement

A representative will contact you to follow up your request.

 
Special offer: Training Vouchers - Free Courses with purchase.

 

SQL Server® 2008:
A Comprehensive Hands-On Introduction

Course 137 • 4 Days

 E-mail E-mail a Colleague Course Details Course Details Course Details PDF Course Details PDF

Frequently Asked Questions

What is this course about?

SQL Server 2008 offers a progressive and powerful way to manage your organization's information. A robust and scalable enterprise solution, SQL Server 2008 extends the features of SQL Server 2005 and improves application development time and cost management. This hands-on course provides a solid foundation on which to build essential SQL Server development and administrative skills, including creating databases, generating Transact-SQL statements, implementing security and replicating data over multiple servers.

What will I learn in this course?

This course provides a comprehensive introduction to Microsoft SQL Server 2008. You learn how to use the various administrative and development tools included with SQL Server.

The extensive hands-on exercises provide you with valuable experience leveraging the capabilities of SQL Server and its accompanying components. This course provides the stepping stone to begin your SQL Server 2008 career.

Who will benefit from this course?

Typical participants include:

  • Programmers, application designers, developers and system architects who design and write Microsoft SQL Server applications and who require an introduction to the big picture of what SQL Server can do
  • Database administrators looking to explore the capabilities of SQL Server
  • Project managers who will be leading a team of developers in constructing a database
  • Data processing professionals who may have many years of experience working with traditional database systems (hierarchical or network) and who are now moving to the client/server world
  • Evaluators of database servers who will be making a decision about whether SQL Server 2008 is right for their organization

What background do I need?

Tools used in the hands-on exercises assume a familiarity with the Windows user interface. Familiarity with relational database constructs such as tables, rows, columns and referential integrity is helpful. Prior experience with SQL Server is not required.

What is SQL Server 2008?

SQL Server 2008 is the latest version of Microsoft's full-featured relational database management system (RDBMS) with support for robust server-side development and data replication. It is part of the Windows Server System.

Does this course cover SQL Server 2012?

No, this course solely focuses on SQL Server 2008. For coverage on SQL Server 2012 database administration, please see Course 2108: SQL Server® 2012 Database Administration: Hands-On.

Does this course cover the components in Microsoft's Business Intelligence platform?

The focus of this course is on SQL Server 2008 database administration. For more information on BI components, please refer to Course 146: Introduction to Microsoft® Tools for Business Intelligence: Hands-On. For more information on Analysis Services, see Course 139: SQL Server® Analysis Services: Hands-On. For Integration Services, see Course 134: SQL Server® Integration Services: Hands-On, and for additional information on Reporting Services, see Course 140: SQL Server® 2008 Reporting Services: Hands-On.

I am currently a database developer/administrator working in SQL Server 2000. Is this course right for me?

No. This course is designed primarily for those with little or no experience working with SQL Server 2000.

What platform is used for the hands-on exercises?

This course uses Microsoft SQL Server 2008 R2 running on Windows Server 2008.

How much time is spent on each topic?

ContentHours
Getting started with SQL Server 20083.5
Constructing the database4.0
Server-side programming4.0
Integrating with client applications2.5
Administering SQL Server 20084.0
Sharing data through replication2.5
Business Intelligence components2.5
Times, including the workshops, are estimates; exact times may vary according to the needs of each class.

What kind of hands-on exercises will I perform?

Approximately 45 percent of class time is spent in hands- on exercises. Hands-on exercises provide immediate reinforcement of the material covered. Exercises include:

  • Installing SQL Server 2008
  • Creating tables and constraints
  • Manipulating data with SQL
  • Integrating SQL Server with Office
  • Securing access to SQL Server from intruders
  • Backing up databases to prepare for disasters
  • Running the Maintenance Plan Wizard to handle routine administrative tasks
  • Replicating data between multiple sdatabases
  • Rendering a report to Excel

How does this course relate to other Learning Tree courses?

Learning Tree offers a complete SQL Server 2005 and 2008 curriculum. The courses you may take depend on the role you play in your organization. Please refer to The Learning Tree SQL Server 2005 and 2008 Curriculum Q&As for more details

Those courses directly related to SQL Server 2008 include:

SQL Server 2008 is a registered trademark of Microsoft Corporation.

Learning Tree AnyWareTM is a trademark of Learning Tree International, Inc. in the United States and other countries, and is covered by a patent application pending in the United States.
  
SQL Server 2008: A Comprehensive Hands-On Introduction

Training Dates

Live online classroom training.Most events below can be taken in-class or live, online from your home or office with AnyWare.
Aug 14 - 17Toronto enrol
Oct 30 - Nov 2Ottawa enrol
Nov 20 - 23Toronto enrol

US Dates

May 22 - 25New York enrol
May 29 - Jun 1Reston, VA enrol
Jun 19 - 22Rockville, MD enrol
Jul 17 - 20New York enrol
Jul 31 - Aug 3Alexandria, VA enrol
Aug 21 - 24Los Angeles enrol
Aug 21 - 24Reston, VA enrol
Sep 4 - 7Atlanta enrol
Sep 11 - 14Rockville, MD enrol
Sep 18 - 21New York enrol
Sep 25 - 28Chicago (Schaumburg) enrol
Oct 16 - 19Annapolis, MD enrol
Oct 23 - 26Alexandria, VA enrol
Nov 13 - 16Reston, VA enrol
Nov 27 - 30New York enrol
Dec 4 - 7Rockville, MD enrol
Dec 11 - 14Chicago (Schaumburg) enrol
Dec 18 - 21Los Angeles enrol
Jan 8 - 11Alexandria, VA enrol

For AnyWare enrolments, please register at least 7 days prior to the start of the course.

More Dates and locations.

Bring this or any Learning Tree Course on-site to your location!

Your Course Tuition
EntitlesYou to...

  • Class participation
  • Team workshops
  • Use of in-class hands-on equipment
  • Comprehensive course materials
  • Morning and afternoon refreshments
  • Course Completion Certificate awarding Continuing Education Units
  • FREE participation in Professional Certification