0800 282 353 or +44 1372 364610
TRAINING YOU CAN TRUST
 
 

SQL Server 2005 Comprehensive Introduction: Hands-On

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

Related Courses

  • 132 SQL Server 2005 Database Administration
  • 133 SQL Server 2005 Server-Side Programming
  • 382 Relational Database Design
  • 595 Windows Server 2003 Comprehensive Introduction
  • 598 Troubleshooting Windows Server 2003 Environments
  • 523 SQL Server Reporting Services
  • 502 Programming with .NET Introduction
  • 290 Management Skills
  • 134 SQL Server 2005 Integration Services

 
SQL Server is a trademark of Sybase, Inc.
   SQL Server 2005 Comprehensive Introduction

Upcoming Dates

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
28 Apr - 1 May, 2009
London

For complete schedule, please visit www.learningtree.co.uk
 
http://www.learningtree.co.uk/courses/uk131.htm
 
 
0800 282 353 or +44 1372 364610
TRAINING YOU CAN TRUST
 
 

SQL Server 2005 Comprehensive Introduction: Hands-On

 
Course: 131   Type: Hands-On Training   Duration: 4 Days
 
 
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
 
http://www.learningtree.co.uk/courses/uk131.htm
 
 
0800 282 353 or +44 1372 364610
TRAINING YOU CAN TRUST
 
 

SQL Server 2005 Comprehensive Introduction: Hands-On Tuition

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

Course 131 Tuition

£ 1,695Standard Tuition
Tuition with a Savings Plan
£ 98010-Day Training Pass
£ 915Flex-Training Pass
£ 1,46010-Training Vouchers
£ 1,5605-Training Vouchers
£ 1,525Alumni Gold Tuition

Your Course Fee Entitles You To...

  • Class participation
  • Team workshops
  • Use of in-class hands-on equipment
  • Comprehensive course materials
  • Morning and afternoon refreshments
  • Lunch
  • Course Completion Certificate
  • FREE participation in the Learning Tree Professional Certification Programmes (including related exams)
  
 

Tuition Savings Plans

Flex-Training Pass
  • 3 Courses for £2 750
  • As little as £915
  • Savings as much as 50%
  • 3 courses in 24 months
10-Day Training Pass
  • Save as much as £770 per course
  • Any combination of courses
  • Only £2,450
Training Vouchers
  • Save as much as £535 per course
  • Fully transferable
  • As low as £1,460 per course
Alumni Gold Discount Attend your first course and you will receive a personalised Alumni Gold Discount card, entitling you to save as much as £200 on each course you take in the following 24 months. Take just one course every two years, and you will be entitled to ongoing discounts...year after year. You save 10%.
* Exact savings may vary depending on courses selected.

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 fee.

Enrolling is Easy and Flexible!

Enrol 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.learningtree.co.uk/courses/uk131.htm