News »Browse Articles » SQL Server 2008 Training and Placement

SQL Server 2008 Overview

Availability and Scalability Features
Security Features
Data Management Features
Administration and Maintenance Features
Development Features

Installing SQL Server 2008
SQL Server 2008 Editions
Installing Microsoft SQL Server
System Requirements
Preparing for a SQL 2008 Installation
Installation Checklist
Setup Features
Using the System Consistency Checker
Component Install
Unattended Installation
Installation Sequence
Installation Maintenance
Upgrading from previous versions of SQL Server
Retaining SQL 2000
To verify the Installation

Administrative Tools
Upgrading to SQL Server Management Studio
Management Studio Windows
Registered Servers
Object Explorer
Review Database Objects
Modify Database Properties
Create Database Scripts
The Maintenance Plans Node
Solution Explorer
Query Editor
Template Explorer
Dynamic Help
Upgrading to SQL Server Computer Manager
SQL Server 2008 Services node
SQL Server 2008 Network Configuration node
SQL Server 2008 Native Client Configuration node
The SQLCMD Management Utility
SQLCMD Syntax
SQLCMD Variables
Dedicated Administrative Connection
SQL Server Management Studio SQLCMD Mode
Using SQL Management Objects
SMO Object Model



Securing SQL Server 2008
Implementing Securables
New Security Features
Principals
Securables
Permissions
Permission Types
Managing Logins
Managing Users
Managing Schemas
Schema Definition
Using Schemas
Managing Execution Context
Managing Permissions
Manage Server Permissions
Manage Server-Scope Securable Permissions
Manage Database Permissions
Manage Database-Scope Securable
Permissions
Managing Certificates
Native Data Encryption
Code and Module Signing

SQL Server Disaster Recovery
Disaster Recovery
SQL 2008 Disaster Recovery Feature
Enhanced Features
Database Snapshots
Creating a Snapshot
Common Snapshot Applications
Recovering a dropped object
Backup and Restore
Backup Changes
Restore Changes
Recovering the MASTER Database
Create a mirrored backup
Restore from the backup mirror
Create a snapshot
Restore the snapshot data
Automate the creation of daily snapshots

Backup and Recovery
Backups (All available Types)
Recoveries (All available Types)






Database Availability (HA Solutions)
SQL 2008 Data Availability
Log Shipping
Mirroring
Replication
Clustering (With Practicals, Full implementation and


Monitoring the Database Server
Managing Event Notifications
Managing Metadata Views
Metadata Storage
System Views
Information Schema
Catalog Views
Sys All
Dynamic Management Views
System Stored Procedures

Database and Index Maintenance
Index Management
New Index Features
Creating Indexes
Online Index Maintenance
Lock Options
Included Columns in Indexes
Partitioned Tables and Indexes
XML Index Support
Altering an Index
Rebuilding an Index
Reorganising an Index
Disabling an Index
Dropping an Index
Index Fragmentation
Using the Database Tuning Advisor

Monitoring and Performance
SQL Server Profiler
Optimal Data Storage
Diagnostic Tools
Query Analyzer
Database Engine Tuning Advisor
Index Optimisation
Partitioned Indexes
Lock optimisation




Add-Ons:-


Windows Administration
Security administration
Domain Controller
Domain account creations
Security/Group policies
Active Directory
OS installations, Service Packs, Hotfixes
Page File
Fragmentation

Professional Behavioral Ethics
Important things to consider as a DBA
The Do’s and Don’ts of a DBA
Working in a Team (Fun exercises only for Physical audience… video/audio for Virtual)

Communication Improvements
Clear cut communication (Fun exercises)
Let’s not try to adopt false accent

No Comments For This News

Post a link to something interesting from another site, or submit your own original writing for the JOSO community to read.