Our SQL Server 2008 Programming training course gives delegates a solid introduction to developing secure, robust commercial database applications incorporating Transact-SQL, Stored Procedures & XML.

Microsoft SQL Server 2008 R2 combines power with scalability, and is at the heart of a huge number of the world’s CRM, ERP, CMS and e-commerce systems, and has solid support for deployment in the Cloud through Microsoft’s Azure platform.

• Create robust & well-optimised databases in SQL Server 2008 R2
• Write SQL queries and Stored Procedures to manipulate data
• Learn SQL Server Management Studio Best PractisesCreating tables and constraints
• Replicating data between multiple databases
• Disaster Recovery strategies
• Overview of Microsoft Business Intelligence with Reporting Services

This course is aimed at anyone who needs to gain hands-on experience with SQL Server, creating commercial database solutions with T-SQL, XML and Stored Procedures

Delegates will ideally have some experience of writing basic SQL queries in a Relational Database such as Access or MySQL.

Introduction to Relational Databases & SQL Server 2008 R2 Architecture

Client / Server model
SQL Server Management Studio
Business Intelligence Development Studio
Database schemas
Integrating with .NET CLR
Windows / ASP.NET Authentication
Creating a database
Files and Directories
Parameters & options
Filegroups
SQL Server Database Schemas

Tables & Data Types

Pre-configured Data Types
Creating custom Data Types
Handling columns
Table Partitions
Indexing tables

Constraints & Triggers

Primary keys
Validation
Foreign keys
Triggers

Server-Side Programming with Transact-SQL

SQL statements in Query Designer
Joining multiple tables
INSERT, UPDATE, DELETE

Stored Procedures

Efficiency Benefits of using Stored Procedures
Creating and deploying new Stored Procedures
Maintaining existing Stored Procedures
AFTER Triggers

SQL Server & XML

Storing & Retrieving XML
Intro to XQuery
XML Native Data Types
XML Schemas & Indexes

Administration Essentials for Developers

Monitoring SQL Server
Roles and user memberships
Security policy
Maintenance Plan Wizard
Scheduling backups Checking database integrity
Defragmenting data
Notification Services / Management Reports
Replication - Snapshot / Transactional / Merge

Intro to SQL Server & Microsoft Business Intelligence

Overview of Reporting Services
Overview of Integration Services
Overview of Analysis Services

Coming Soon: Overview of SQL Server 2012 New Features

New features in T-SQL

• WithResultsSet
• Throw / Catch (Error Handling)
• Offset and Fetch
• Sequence

Enhanced Full Text Search
New High Availability features

Nb. Please contact us if you wish to enquire about SQL Server 2012 training.

Related courses

BI1 Intro to Microsoft Business Intelligence Training Course (SQL Server 2008 & SQL Server 2012)