1-800-THE-TREE (1-800-843-8733)
TRAINING YOU CAN TRUST
 
 

SQL Server 2005: A Comprehensive Hands-On Introduction

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

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

Related Courses

 
SQL Server is a registered trademark of Microsoft Corporation. 		 

Upcoming Dates

Jan 13 - 16, 2009
 Boston (Waltham)
Jan 20 - 23, 2009
 Washington, DC (Reston, VA)
Jan 27 - 30, 2009
 Ottawa
Feb 3 - 6, 2009
 Atlanta
Feb 3 - 6, 2009
 Los Angeles
Feb 17 - 20, 2009
 New York
Feb 17 - 20, 2009
 Washington, DC (Rockville, MD)
Feb 24 - 27, 2009
 Dallas
Feb 24 - 27, 2009
 N. New Jersey
Feb 24 - 27, 2009
 Toronto
Mar 10 - 13, 2009
 Washington, DC (Reston, VA)
Mar 17 - 20, 2009
 Boston (Waltham)
Mar 24 - 27, 2009
 New York
Mar 31 - Apr 3, 2009
 San Francisco Bay Area
Apr 7 - 10, 2009
 Washington, DC (Rockville, MD)

For complete schedule, please visit www.learningtree.com
 
http://www.learntree.com/courses/131pf.htm
 
 
1-800-THE-TREE (1-800-843-8733)
TRAINING YOU CAN TRUST
 
 

SQL Server 2005: A Comprehensive Hands-On Introduction

 
Course: 131   Type: Hands-On Training   Duration: 4 Days
 
 
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
 
http://www.learntree.com/courses/131pf.htm
 
 
1-800-THE-TREE (1-800-843-8733)
TRAINING YOU CAN TRUST
 
 

SQL Server 2005: A Comprehensive Hands-On Introduction Tuition

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

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

 

Your Course Tuition Entitles You 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
  • FREE participation in College Credit programs (including related exams)
  
 

Tuition Savings Plans

Training Passport
  • 3 courses in 12 months
  • As little as $1,670 per course
  • Savings as much as 45%
  • Only $5,000
Premium Pass
  • 4 courses in 24 months
  • As little as $1,625 per course
  • Save as much as 45%
10-Day Pass
  • A NEW way to save on training
  • 10 days of training for one person
  • Save as much as $990 per course
  • Only $4,500
Training Vouchers
  • Save as much as $990 per course
  • Fully transferable
  • As low as $2,200 per course
Alumni Gold Discount Attend your first course and you'll receive a personalized Alumni Gold Discount card, entitling you to save as much as $305 on each course you take within the following 12 months. Take just one course each year and you'll be entitled to ongoing discounts...year after year!

Your Guarantee of Satisfaction

Unless you feel 100% satisfied that Learning Tree delivered even more than you expected, there is no fee for your course attendance. Our Guarantee of Quality lets you experience the value of the course--and then pay only if you feel the course was well worth the tuition.

Enrolling is Easy and Flexible!

Enroll by phone or online. If your plans change, just let us know and, without a fee, you can transfer to another course or cancel your enrollment. Pay after you've taken the course, and then only if you are 100% satisfied.
 
http://www.learntree.com/courses/131pf.htm