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

SQL Server® 2005: A Comprehensive Hands-On Introduction

Course: 131   Type: Hands-On   Duration: 4 Days
Quick Enrol  

You Will Learn How To

  • Build databases, queries and reports for SQL Server 2005
  • Create and manage databases with SQL Server Management Studio
  • Generate Transact-SQL statements for data retrieval and modification
  • Implement security and back up databases to protect critical data
  • Configure merge replication and handle data conflicts
  • Explore business intelligence solutions using Integration, Analysis and Reporting Services

Course Benefits
SQL Server 2005 offers a robust architecture for enterprise data management, developer productivity and business intelligence. This course provides the knowledge and practical skills needed to maximise the benefits of SQL Server 2005. You gain a solid foundation on which to build essential SQL Server development and administrative skills, including creating databases, generating Transact-SQL statements and implementing security.

Who Should Attend
Those who are new to SQL Server, as well as those evaluating SQL Server 2005. Familiarity with relational databases is helpful.

Hands-on Training
Exercises throughout the course reinforce the knowledge you gain in class, including:
  • Installing SQL Server 2005
  • Creating databases with SQL Server Management Studio
  • Adding primary and foreign key constraints to tables
  • Retrieving and joining data from tables
  • Simplifying data access using views
  • Defining a database maintenance plan
  • Backing up databases to protect against disasters
  • Automating administrative jobs with SQL Server Agent
  • Importing data from text files using SSIS

Course Content
Introducing SQL Server 2005
Overview of database fundamentals
  • Client/Server
  • RDBMS
SQL Server 2005 editions
  • Express
  • Standard
  • Enterprise
  • Workgroup
  • Mobile
  • Developer
SQL Server components and tools
  • SQL Server Management Studio
  • Business Intelligence Development Studio
  • SQL Server Agent
  • Database engine
Assembling a Database
Building a database
  • Choosing file names and locations
  • Determining file size and growth parameters
  • Utilising schemas to partition tables
Designing tables
  • Defining columns and attributes
  • Selecting appropriate datatypes
  • Setting the primary keys and indexes
  • Modifying or removing columns
Applying declarative constraints
  • Enforcing check constraints
  • Validating the existing data
  • Protecting relationships with foreign keys
Developing Database Applications
Retrieving data with Transact-SQL
  • Writing SQL queries with Management Studio
  • Sorting the final result sets
  • Aggregating data by groups
  • Joining columns from different tables
  • Refining result sets with subqueries
Altering data with SQL commands
  • INSERT
  • UPDATE
  • DELETE
Storing query definitions
  • Generating views with Management Studio
  • Simplifying data access with views
Server-side and client-side programming
  • Constructing a stored procedure
  • Executing a stored procedure
  • Exploring functions and triggers
  • Integrating SQL Server with Office
Providing Application Solutions with SQL Server
  • Upsizing from Microsoft Access
  • Displaying data on the Web with ASP.NET
  • Pulling data into Microsoft Excel
Managing SQL Server Security and Administration
Administering security
  • Allowing logins access to databases
  • Creating SQL Server logins
  • Implementing a security plan
  • Defining database roles
  • Granting permissions on tables to roles
Deploying the Maintenance Plan Wizard
  • Checking database consistency
  • Backing up the database and log
  • Reporting on maintenance plan success
Automating administration
  • Defining operators
  • Generating and scheduling jobs
  • Notifying operators of job outcome
Preparing for disasters
  • Performing routine database backups
  • Restoring databases to fix corruptions
Replicating Data
  • Designing replication strategies
  • Configuring the distribution server
  • Publishing data with merge replication
  • Pulling or pushing subscriptions
  • Resolving conflicts using priorities
Leveraging Business Intelligence
SQL Server Integration Services (SSIS)
  • Importing data into SQL Server
  • Exporting data to text or CSV format
Analysis Services
  • Storing multidimensional data
  • Pivoting cubes in Microsoft Excel
  • Detecting patterns with data mining
SQL Server 2005 Reporting Services
  • Authoring and deploying reports
  • Viewing reports from a Web site

Related Courses
SQL Server is a registered trademark of Microsoft Corporation.
  
  


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 £500 per 10-Day Pass
SQL Server 2005 Comprehensive Introduction
Course Schedule
21 - 24 Jul, 2009
London
25 - 28 Aug, 2009
London
6 - 9 Oct, 2009
London
17 - 20 Nov, 2009
London
5 - 8 Jan, 2010
London
12 - 15 Jan, 2010
Edinburgh
16 - 19 Feb, 2010
London
29 Mar - 1 Apr, 2010
London
18 - 21 May, 2010
London
25 - 28 May, 2010
Edinburgh
Complete Schedule
On-Site Courses

Participants retrieving data using SQL Server Management Studio.
 
The green bar below shows the average course score on a 4.00 scale from the most recent 100 attendee evaluations:

  (3.74/4.00)
 

Course Fees
£ 1,745 Standard Tuition
Saving Plans
£ 920 10-Day Training Pass
£ 1,095 Flex-Training Pass
£ 1,490 Voucher 10-Pack
£ 1,600 Voucher 5-Pack
£ 1,575 Alumni Gold Tuition

All Saving Plans
 
Certification Core Course
 
SQL Server 2005 for the Enterprise
 
Customer Service or Enrol: 0800 282 353 or +44 1372 364610