SharePoint 2007/2010 training

Streamline is now delivering the following SQL courses.

These courses cover everything you need to make best use of SQL 2008 in your business.

Phone 0800 0439971 or use the the contact form for details and availability.

Transact SQL Server 2008 - 4 days

In this course, you will learn about the features that are available in SQL Server like how to design and create a database, and how to build basic queries using Transact-SQL, the language of SQL Server. Then you will learn how to build effective views, stored procedures, triggers, and user-defined functions using Transact-SQL. You will learn how to use the Transact-SQL programming language for error handling and hierarchical queries, dealing with complex data structures and processes, and how to make your databases more scalable through partitioning.

SQL Server 2008 includes a rich set of tools that go beyond the basics of querying and manipulating data. You will learn how to take advantage of the user-friendly management console that integrates both authoring and administrative tasks. You will learn how to take advantage of SQL Server's tools for analyzing and tuning your databases.

Prerequisites: To get the most out of the Microsoft T-SQL Server 2008 course, you should have a solid understanding of relational databases. No particular programming experience is required, but the course is taught from a developer's perspective.

Course Outline

A Tour of SQL Server 2008

  • SQL Server 2008 Editions, Components, and Tools
  • Using SQL Server Management Studio (SSMS)
  • Working with Tables, Queries, and Views
  • Business Intelligence Services

Designing and Creating a Database

  • Relational Database Design Principles
  • Implementing the Design

Working with SQL Server Management Studio

  • Getting Started with Management Studio
  • Exploring the Object Explorer
  • Working with the Query Editor
  • Using SQL Server Books Online

Transact-SQL Programming

  • Overview of Transact-SQL
  • Using Built-In Functions
  • Controlling Flow
  • Ranking Results

Transactions and Error Handling

  • Transaction Concepts
  • Applications and Transactions
  • Creating Explicit Transactions
  • Using TRY/CATCH Error Handling

Data Selection Queries

  • Understanding Transact-SQL
  • The SELECT Statement
  • The WHERE Clause
  • Using ORDER BY to Sort Data
  • The GROUP BY Clause
  • Joining Tables

Advanced Data Types

  • Introduction
  • The HierarchyID Data Type
  • Sparse Columns and Column Sets
  • FILESTREAM Storage
  • Spatial Data

Complex Querying

  • Working with NULL Values
  • Ranking Grouped Data
  • Writing Correlated Subqueries
  • Using Common Table Expressions

Modifying Data

  • Modifying Data with Transact-SQL
  • Inserting Data
  • Updating Data
  • Deleting Data
  • Understanding Transaction Isolation

Working with XML

  • The XML Data Type
  • XML Schema Collections
  • Querying XML
  • Best Practices

Creating Views

  • What Is a View?
  • Creating Views
  • Updating Data Using a View
  • Using Computed Columns
  • Indexed Views
  • Partitioned Views

Implementing SQL Server Partitions

  • Overview of Table-Based Partitions
  • Creating Partitioned Tables
  • Querying Partitions
  • Managing Partitions

Creating User-Defined Functions

  • User-Defined Function Overview
  • Scalar Functions
  • Inline Table-Valued Functions
  • Multi-Statement Table-Valued Functions
  • Using Functions, Views, and Stored Procedures

Creating Stored Procedures and Triggers

  • Creating Stored Procedures
  • Creating Triggers

Advanced Query Techniques

  • Full-Text Search
  • Advanced T-SQL Techniques
  • Executing Dynamic SQL

Advanced Techniques

  • Complex Data and Structures
  • Writing More Efficient Queries
  • Working with Complex Queries
  • Maintaining Query Files