1-800-THE-TREE (1-800-843-8733)
 

SQL Server 2005: A Comprehensive Hands-On Introduction

 
Course: 131     Type: Hands-On Training     Duration: 4 Days

Quick Enroll    

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 maximize 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 131 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
  • Utilizing 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 trademark of Sybase, Inc.
  
 
Request More Info

Salutation

First Name

Last Name

Company

Zip Code

Country
   Codes
Work Phone

Extension

E-mail

A representative will contact you to follow up your request.
Privacy Statement

Save Up to 40% per course on the Training Passport!

SQL Server 2005: A Comprehensive Hands-On Introduction
Upcoming Dates
Oct 14 - 17, 2008
 Los Angeles
Oct 14 - 17, 2008
 Washington, DC (Alexandria, VA)
Oct 21 - 24, 2008
 Ottawa
Oct 28 - 31, 2008
 Washington, DC (Reston, VA)
Nov 11 - 14, 2008
 Philadelphia
Nov 18 - 21, 2008
 Chicago (Schaumburg)
Nov 18 - 21, 2008
 New York
Dec 2 - 5, 2008
 Washington, DC (Rockville, MD)
Dec 9 - 12, 2008
 Washington, DC (Reston, VA)
Dec 16 - 19, 2008
 Toronto

SQL Server 2005: A Comprehensive Hands-On Introduction
Bring Learning Tree On-Site

About the Course Author
James Beidleman
About the Author - James Beidleman

"Whereas most introductory courses focus on either SQL, developers or DBA, this one provides a sampling of all three. That way, the attendee learns about all the capabilities SQL Server..."
more »

Course Tuition
$ 2,790 Standard Tuition
Tuition with a Savings Plan
$ 1,800 10-Day Pass
$ 1,670 Training Passport
$ 1,700 Premium-Pass
$ 2,200 Voucher 10-Pack
$ 2,515 Alumni Gold Discount
$ 2,484 Government Discount
 

 

SQL Server 2005: A Comprehensive Hands-On Introduction
SQL Server 2005: A Comprehensive Hands-On Introduction
Participants retrieving data using SQL Server Management Studio.
The most recent 100 evaluations scored this course at:

  (3.76/4.00)


SQL Server 2005 for the Enterprise


Certification Core Course CPE 23 Credits 2 Hour(s) College Credit
Customer Service or Enroll: 1-800-843-8733