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

SQL Server® 2008 Comprehensive Introduction: Hands-On

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

You Will Learn How To

  • Build and manage SQL Server 2008 databases
  • Retrieve and manipulate data with SQL queries
  • Integrate SQL Server with .NET, Microsoft Office and XML
  • Secure and monitor databases with Management Studio
  • Replicate data over multiple servers with merge replication
  • Transform data into strategic information using Business Intelligence processes

Course Benefits
SQL Server 2008 offers a progressive and powerful way to manage your organisation's information. A robust and scalable enterprise solution, SQL Server 2008 extends the features of SQL Server 2005 and improves application development time and cost management. This hands-on course provides a solid foundation on which to build essential SQL Server development and administrative skills, including creating databases, generating Transact-SQL statements, implementing security and replicating data over multiple servers.

Who Should Attend
Those who are new to Microsoft SQL Server. Familiarity with relational databases is helpful.

Hands-on Training
Throughout the course, you gain extensive experience with SQL Server 2008. Practical exercises include:
  • Installing SQL Server 2008
  • Creating tables and constraints
  • Manipulating data with SQL
  • Integrating SQL Server with Office
  • Securing access to SQL Server from intruders
  • Backing up databases to prevent disasters with the Maintenance Plan Wizard
  • Replicating data between multiple servers
  • Rendering a report to Excel

Course Content
Getting Started with SQL Server 2008
Overview of SQL Server architecture
  • Fundamentals of relational databases
  • Client/server model
SQL Server 2008 editions
  • Express
  • Standard
  • Enterprise
  • Workgroup
  • Mobile
  • Developer
SQL Server components and tools
  • SQL Server Management Studio
  • Management reports
  • Business Intelligence Development Studio
  • SQL Server Agent
  • Database engine
Constructing the Database
Creating a database
  • Choosing files and directories
  • Allocating file size and growth parameters
  • Implementing database schemas
Designing tables
  • Analysing various datatypes
  • Defining column attributes
  • Indexing tables with Management Studio
  • Adding, deleting or changing columns
Protecting data with constraints
  • Enforcing uniqueness with primary key constraints
  • Check constraints to validate conditions
  • Building relationships with foreign keys
Server-Side Programming
Data retrieval with Transact-SQL
  • Leveraging Query Designer to construct SQL statements
  • Writing multiple table join queries
  • Aggregating data for business analysis
Modifying data
  • Adding new rows with the INSERT command
  • Changing targeted data with UPDATE
  • Deleting specific rows
Programming constructs
  • Writing stored procedures for performance and productivity
  • Capturing change events with triggers
  • Simplifying data access with user-defined functions
Integrating with Client Applications
Exploiting .NET capabilities
  • Analysing Web forms and Windows forms
  • Creating a .NET CLR component
Interacting with Microsoft Office
  • Pulling data from SQL Server into Excel
  • Upsizing an Access database to SQL Server
Leveraging XML features
  • Retrieving data in XML form
  • Storing XML documents
Administering SQL Server 2008
Securing the database infrastructure
  • Controlling access to SQL Server
  • Granting or revoking permissions
  • Defining roles and user memberships
Running the Maintenance Plan Wizard
  • Automating backups by scheduling jobs
  • Checking database integrity and defragmenting data
  • Notifying operators via e-mail
Monitoring SQL Server activity
  • Viewing locks and queries
  • Requesting management reports with Management Studio
Sharing Data through Replication
Defining the replication architecture
  • Snapshot
  • Transactional
  • Merge replication
  • Choosing a replication strategy
Configuring merge replication
  • Distributing published data
  • Subscribing to a publication
Business Intelligence Components
Transforming data with Integration Services
  • Importing and exporting files
  • Moving and denormalising data into a data warehouse
Producing information with Analysis Services
  • Building multidimensional cubes
  • Predicting trends with data mining
Information delivery with Reporting Services
  • Designing reports quickly with the Report Wizard
  • Deploying reports to a Report Server for centralised access
  

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%
SQL Server 2008 Comprehensive Introduction
Course Schedule
18 - 21 Nov, 2008
London
3 - 6 Feb, 2009
London

Course participants configuring SQL Server Agent.

£ 1,695 - Standard Tuition
Savings Plans
£ 1,080 - 10-Day Training Pass
£ 995 - Flex-Training Passport
£ 1,215 - 10-Training Vouchers
£ 1,300 - 5-Training Vouchers
£ 1,525 - Alumni Gold Tuition

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