MS SQL Server

Learn SQL Server - one step at a time. Get the practical guidance you need to build database solutions that solve real-world business problems. Learn to integrate SQL Server data in your applications, write queries, develop reports, and employ powerful business intelligence systems.

Basic Outline:
SQL Server Level 1

Part 1: Getting Started with Microsoft SQL Server 2008

Overview of Microsoft SQL Server
Installing and Configuring SQL Server 2008
Using the Tools in SQL Server 2008

Part 2: Designing Databases

Creating Databases
Designing Tables
Indexes
Partitioning

Part 3: Retrieving and Manipulating Data

Data Retrieval
Advanced Data Retrieval
Data Manipulation

Part 4: Designing Advanced Database Objects

Views
Stored Procedures
Functions
Triggers
Database Snapshots
Service Broker
Full-Text Indexing

Part 5: Database Management

Security
Policy-Based Management
Data Recovery
SQL Server Agent
Dynamic Management Views

Part 6: High Availability Overview

High Availability

Part 7: Business Intelligence

SQL Server Integration Services
SQL Server Reporting Services
SQL Server Analysis Services

Venues

Date: 02 April 2013 to 04 April 2013
Time: 08:30 AM - 04:00 PM
Location: Boksburg
Cost: R5500

Date: 03 April 2013 to 05 April 2013
Time: 08:30 AM - 04:00 PM
Location: Cape Town
Cost: R5500

Date: 08 April 2013 to 10 April 2013
Time: 09:00 AM - 04:00 PM
Location: Sandton
Cost: R5500

Date: 17 April 2013 to 19 April 2013
Time: 08:30 AM - 04:00 PM
Location: Pretoria
Cost: R5500

Date: 23 April 2013 to 25 April 2013
Time: 08:30 AM - 04:00 PM
Location: Durban
Cost: R5500

Date: 06 May 2013 to 08 May 2013
Time: 09:00 AM - 04:00 PM
Location: Sandton
Cost: R5500

Contact: Jeanne Combrinck
Company name: MultiMediaCentre
Telephone number: +27 21 790 3684
Email address