SQL Server 2008 Overview and INstallation
Overview of SQL Server
Installation Requirements (Hardware and Software)
Installation Walkthrough (Step-by-Step)
Overvoew of SQL Server Management Studio (SSMS)
Creating and Managing Databases
Creating Databases
Database
File Groups
Database Options
Managing database
Creating and Managing Tables and iimplementing Data Integrity
Creating Tables
Defining Table Location
Modifying Tables
Dropping Tables
Data Types
Defining Constraints
Partitioned Table
Data Compression (New Feature in SQL Server 2008
Data Manipulation and Data Correlation
Select/Update/Delete
Sub Queries
Joins
Union/UnionAll/Intersect
SQL Sever Built in Functions
Mathematical Functions
String Functions
Date Functions
Convert Functions
Aggregate Functions
Creating and Maanaging Views
Create View
Alter View
Drop View
Check and Encryption Options
Introduction to T-SQL Programming
Variable Declaration
Temp Table Concepts
Variable Table Concepts
Loops
Creating and Modifying Procedures and Cursors
Creating Procedures
Parameter Types
Modifying Procedures
Using Temp Tables, Variabke Tabkes and cursirs in Procedures
How to use Dynamic SQL Statements in Procedures.
Error Handling
Creating and Modifying user defned Functions
Creating/Modifying Scalar functions
Creating/Modifying table functions
Creating and Modifying Triggers
Table Triggers
DDL Triggers
Working with distributed Data
Creating Linked Servers
How to use DML Statements against to the remote servers
How to use remote Procedure execution in SQL Servers
SQL Server Security
Authentication Methods
Server level Security
Database Level Security
Object Permissions
Creating and Managing Indexes
Clustered Index
Non Clustered Index
Unique index
Composite Indexes
Fill Factor /Pad Index
Backup/Recovery
Recovery Models
Backup Types
Full Database backup
Differential Backup
Transactional Log Backup
Restore Databases
Restore transaction Logs
Point of Recovery
Backup Compression (New Feature in SQL Server 2008)
Database Mail
SQl Server Scheduling and Notification
Managing jobs
Managing Alerts
Monitoring and Troubleshooting SQL Server Performance
Identify and Resolve Blocking lssues
SQL Server trace
QUERY Execution Plan Analysis
DB Tuning Adviser
Performance Monitor
Setting Maintenance plans
SQL Server Clustering(High availabilty Solutions)Concept
Database Mirroring
Replication
Migrate or UPgrade to SQL Server2008
Log shipping
Resource Governor (new Feature in SQL Server 2008
SQL Server Intedration Services(SSIS)
SQL Server Reporting Serveices(SSRS)
Database Design Concepts and Design TOOl (ERWin Tool)
Normalion
De-Normalization




