Customer Service or Enrol: 0800 282 353 or +44 1372 364610
 
SQL Server 2005 Comprehensive Introduction: Hands-On
 
Course: 131   Type: Hands-On   Duration: 4 Days

Frequently Asked Questions

What is this course about?

This course provides a comprehensive introduction to Microsoft SQL Server 2005. 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 2005 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 2005 is right for their organisation

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 2005?

SQL Server 2005 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.

I have taken Course 530. Should I take this course?

While in Course 131 there is material not covered in Course 530, SQL Server 2000 Comprehensive Introduction: Hands-On, including deeper coverage of SQL and expanded business intelligence, the majority of the topics are too similar to make Course 131 valuable to you.

It is recommended instead that you take Course 132, SQL Server 2005 Database Administration: Hands-On, to further your administrative skills, or Course 133, SQL Server 2005 Server-Side Programming: Hands-On, to advance your knowledge of Transact-SQL development.

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

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

If you have a strong background in SQL Server administration, then Course 129, SQL Server 2005 Administration: Hands-On Skills Upgrade, may be the best choice for you. Course 129 provides the in-depth knowledge and skills to take advantage of the new administrative features and tools available in SQL Server 2005.

If you have a strong background in SQL Server 7 or 2000 development, then Course 130, SQL Server 2005 Programming: Hands-On Skills Upgrade, may prove valuable. Course 130 offers the essential skills needed to leverage the latest .NET, XML and Transact-SQL based programming features of SQL Server 2005.

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

Yes! There are significant differences between SQL Server 6.x and SQL Server 2005 that make a migration potentially problematic. This course is an essential part in creating a smooth transition, providing you with the knowledge and practical skills necessary to take full advantage of the enhanced feature set of SQL Server 2005.

How much time is spent on each topic?

ContentHours
Fundamental concepts2.0
Creating database objects3.0
Retrieving and maintaining data4.0
Basic database administration3.0
Merge replication2.0
Integration Services1.0
Analysis Services2.0
Client applications and .NET integration2.0
Reporting Services1.0
Upsizing Access/Office1.0
SQL Mobile1.0
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?

Numerous hands-on exercises provide immediate reinforcement of the material covered. Exercises include:

  • Installing SQL Server 2005
  • Creating databases with SQL Server Management Studio
  • Retrieving and joining data form tables
  • Securing database objects
  • Recovering a damaged database
  • Synchronising databases with merge replication
  • And much more!

Why should I take this course instead of one offered by Microsoft?

Learning Tree is dedicated to accelerating the careers of our clients by providing them with world-class technology and management training. Our independence from Microsoft (and every other vendor) allows us to give an unbiased view of what works and what does not. This course is objective in its approach, having been developed independently from Microsoft by industry experts who bring their real-world experience to the classroom.

How does this course relate to other Learning Tree courses?

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

Those courses directly related to Course 131 include:

  • 132, SQL Server 2005 Database Administration: Hands-On provides extensive experience using SQL Server 2005 tools to perform real-world administrative tasks. This course is designed for administrators new to SQL Server or coming from versions prior to SQL Server 7.
  • 133, SQL Server 2005 Server-Side Programming: Hands-On offers practical experience developing and debugging stored procedures, triggers and functions, building XML queries, and handling reliable message-driven software. This course is designed for developers new to SQL Server or coming from versions prior to SQL Server 7.

Other courses of interest include:

SQL Server is a trademark of Sybase, Inc.

 
request more info Salutation*:

First Name*:

Last Name*:

Job Title:

Company*:

Post Code*:

Country*:
   Codes
Office Telephone*:

Extension:

E-mail*:

* Required

A Learning Tree representative will contact you to follow up your request for information.

Save 55%

29 Jul - 1 Aug, 2008
London
26 - 29 Aug, 2008
London
23 - 26 Sep, 2008
London
14 - 17 Oct, 2008
Edinburgh
21 - 24 Oct, 2008
London
25 - 28 Nov, 2008
London
6 - 9 Jan, 2009
London
10 - 13 Feb, 2009
Edinburgh
10 - 13 Feb, 2009
London
17 - 20 Mar, 2009
London

£ 1,695 - Standard Tuition
Savings Plans
£ 980 - 10-Day Training Pass
£ 915 - Flex-Training Passport
£ 1,460 - 10-Training Vouchers
£ 1,560 - 5-Training Vouchers
£ 1,525 - Alumni Gold Tuition

 
Certification Core Course
 
Customer Service or Enrol: 0800 282 353 or +44 1372 364610