Microsoft SQL Server 2008 Installing, Querying, and Security (MCTS 70-433) Taining Course Midlands | Birmingham | Telford | Stafford | Wolverhampton

A three day intensive course which comprehensively introduces SQL server 2008. The course will address installation and upgrade issues, configuration choices, post installation configuration. Participants will become familiar with the Management Studio environment, querying, inserting, updating, and deleting data, the Transact SQL (T-SQL) programming language. The course concludes with a comprehensive exploration of security features. This course also forms the first module in our MCTS 70-433 SQL Server 2008 Database Development exam preparation programme.

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

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