Querying MS SQL Server with Transact-SQL Taining Course Midlands | Birmingham | Telford | Stafford | Wolverhampton

This two day course will enable participants to use Transact-SQL to query Microsoft SQL Server. Retrieve data by using the SELECT statement, modify data by using the INSERT, UPDATE, and DELETE statements, summarise data using the TOP, GROUP BY, COMPUTE, and COMPUTE BY clauses. Participants will also learn how to query multiple tables through the use of joins, design subqueries and work with full-text indexes.

Topics include

A Tour of SQL Server 2008
SQL Server 2008 Editions Components and Tools
Using SQL Server Management Studio (SSMS)
Working with Tables, Queries, 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
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 Hierarchal 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 Partitioning
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 Complex Query Techniques
Complex Data and Structures
Writing More Efficient Queries
Working with Complex Queries
Maintaining Query Files