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.

Microsoft SQL Server 2008 Integration Services - 3 days

This course will enable technology professionals with little or no ETL experience to be comfortable and productive with the SSIS tools and technologies. In this course you will learn about the Business Intelligence Development Studio (BIDS) and working with Control and Data Flows to build workflows to extract, transform, and load data using a variety of data sources, transformations, and destinations. You will also become familiar with SSIS package management and package deployment along with learning to write solid code using debugging, error handling, and logging techniques.

Prerequisites: This course assumes no prior knowledge of SQL Server Integration Services. This course does assume prior knowledge of SQL Server 2008 and the use of SQL Server Management Studio for development and administrative tasks. You should be able to create CRUD (create, retrieve, update, and delete) queries using T-SQL, understand basic relational databases design, run script files and diagnose problems that occur, and have experience building applications that access data stored in SQL Server. You must also know how to connect to an instance of SQL Server 2008 using the various connection dialog boxes in Management Studio and development tools.

Other tools used in this course include Notepad, Microsoft Excel, and basic features of Windows.

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

Installing SQL Server 2008

  • Preparing for Installation
  • Upgrading an Earlier Version
  • Installation Steps
  • Configuring the Server

Designing and Creating a Database

  • Relational Database Design Principles
  • Implementing the Design
  • Create a SQL Server Database
  • Create SQL Server Tables
  • Creating Relationships Using a Database Diagram

Data Selection

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

Modifying Data

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

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
  • Using Control of Flow Constructs

Understanding and Implementing Security

  • Security Overview
  • Authentication
  • Authorization
  • Data Encryption
  • Security Epilog

Creating Views

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

Creating Stored Procedures and Triggers

  • Creating Stored Procedures
  • Creating Triggers

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

Transactions and Error Handling

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

Using .NET Code in SQL Server

  • Introduction
  • Writing SQLCLR Code
  • SQLCLR Code Modules
  • SQLCLR Security
  • T-SQL vs. .NET Code

Advanced SQLCLR Code Techniques

  • Advanced SQLCLR Code Modules
  • Managing Code Modules

Advanced Query Techniques

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

Advanced Data Types

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

Implementing Partitions

  • SQL Server Partitions
  • Creating Partitioned Tables
  • Querying Partitions
  • Managing Partitions

Complex Querying

  • Complex Queries
  • Ranking
  • Correlated SubQueries
  • Common Table Expressions

Advanced Techniques

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

Design and Deployment with Visual Studio

  • Team System for Database Professionals
  • Creating Databases and Managing Projects
  • Database and Project Management

Working with XML

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

Business Intelligence Services

  • Introduction to Business Intelligence Services
  • Using Integration Services
  • Using Analysis Services
  • Using Reporting Services