Design & Implementation of SQL Server 2008 (Basic features)

Ø Overview of Client/Server computing

Ø Comparison of SQL Server 2008 with

- Microsoft Access

- Oracle

- SQL Server 2000

Ø Installation of SQL Server 2008 and Service Pack 1

- Overview of different Services

- Service Logon

- Authentication Modes

- Collation settings

Ø SQL Server Management Studio

Ø An overview of SQL Server 2008 Security

Ø System Databases

Ø Creating and Altering user Databases

- File groups

- Concept of Database Transaction Log

- Recovery Models

- Other database options

Ø An overview of Database Design

- Entities

- Relations

- Cardinality of the relation

- Referential Integrity

- Anatomy of Master-Details relations

- Normalization / De-Normalization

Ø Creating and Altering Tables

- Data Types

- Nullablity

- Primary Key

- Default

- Identity fields

- GUID

- Computed fields

- Table Properties

- Table Owner / File group

- Relations

- Check Constraints

- CREATE TABLE (T-SQL)

- ALTER TABLE

- DROP TABLE

- Table Partitioning

Ø Database Scripting

Ø SQL Server Integration Services (SSIS)

- Import / Export

Ø Structured Query Language (SQL)

- SELECT

Simple SELECT:

- PREDICATES

- Expression List

- FROM

- WHERE

- GROUP BY

- HAVING

- ORDER BY

JOINS: INNER / OUTER

SUBQUERY (Nested Select)

UNION

COMPUTE

CUBE / ROLLUP

Ø SQL Server 2005/2008 Enhancements to the SELECT statement

- Top variable

- Common Table Expression (CTE)

- Pivot / Unpivot

- Random data sampling

- Ranking Functions

- Except & Intersect

- Synonyms

- Row Constructors

- Grouping Sets

Ø INSERT / UPDATE / DELETE /Merge

- SQL Server 2008 extension: OUTPUT

-. WRITE Extension to the UPDATE Statement

Ø VIEW

Ø INDEX & Query Optimization