SQL SERVER

SQL SERVER

Overview:
SQL Server is relational database management system(RDBMS) from Microsoft. It is both GUI and command based software. It is commonly used as the back end system for websites and cooperate CRMs and can support thousands of concurrent users. It runs on T-SQL, a set of programming extensions from Sybase and Microsoft which includes exception and error handling, transaction control and declared variables. Microsoft SQL Server is a database platform for large-scale online transaction processing (OLTP), data warehousing, and e-commerce applications.

Training Objectives of SQL Server
The Main Objective of this course covers all of the SQL Server Database performance tuning topics including global tuning with SQL Server parameters, SQL tuning, file and table space management, user administration and security and table and index management.

Target Students / Prerequisites
Students must be familiar with the Concepts in Database.

Course Contents:
Availability and Scalability Features
Security Features
Data Management Features
Administration and Maintenance Features
Development Features
To enable SQLiMail
Testing mail delivery
Installing SQL Server 2005 & 2008
SQL Server 2005 & 2008 Editions

Installing Microsoft SQL Server
System Requirements
Preparing for a SQL 2005 Installation
Installation Checklist
Setup Features
Using the System Consistency Checker
Component Install
Unattended Installation
Installation Sequence
Installation Maintenance

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 2005 & 2008 Services node
SQL Server 2005 & 2008 Network Configuration node
SQL Server 2005 & 2008 Native Client Configuration node
The SQLCMD Management Utility
SQLCMD Syntax
SQLCMD Variables
Dedicated Administrative Connection
SQL Server Management Studio SQLCMD Mode

Monitoring the Database Server
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
Parallel (multiple CPU) Index Operations
Lock Options
Included Columns in Indexes
Partitioned Tables and Indexes
XML Index Support
Altering an Index
Rebuilding an Index
Reorganizing an Index
Disabling an Index
Dropping an Index
Index Fragmentation
Using the Database Tuning Advisor

Securing SQL Server 2005 & 2008
Implementing Securable
New Security Features
Principals
Securable
Permissions
Permission Types
Managing Logins
Managing Schemas
Managing Users
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
Native Data Encryption
Code and Module Signing

SQL Server Disaster Recovery
Disaster Recovery
SQL 2005 Disaster Recovery Feature
Enhanced Features
Database Snapshots
Creating a Snapshot
Common Snapshot Applications
Undeleting table rows
Undoing a table update
Recovering a dropped object
Backup and Restore
Media Integrity 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

Database Availability
SQL 2005 Data Availability
Database Mirroring
The Witness Server and Automatic Failover
Configuring Database Mirroring
Transaction Safety Level
Operating Modes
High Availability Operating Mode
High Protection Operating Mode
High Performance Operating Mode
Monitoring Mirroring
Database States for Database Mirroring
Prepare the Servers
Configure Mirroring
Verify Principal and Mirror Access
Execute the Mirror Failover
Verify Mirror and Witness Status
Terminating the Mirror Session

Replicating Information
Replication Enhancements
Stand-alone Replication Monitor
Support for Oracle Publishing
HTTP Synchronization for Merge Replication
Subscriber Initialization
Replicating DDL Statements
Modified User Interface
Replication Management Objects
To Configure Publishing and Distribution
Configuring Peer-to-Peer Replication
Create a Publication
Create a Subscription with RMO

SQL Server 2005 & 2008 Integration Services
Creating the Database Objects
Creating a Package Using Business Intelligence Studio
Integration Services Project Template
OLE DB Command object
Column Mappings
Adding a Data Viewer

Monitoring and Performance
SQL Server Profiler
Optimal Data Storage
Diagnostic Tools
Query Analyzer
Database Engine Tuning Advisor
Index Optimization
Federated Database Servers
Partitioned Indexes
Lock Optimization
Best Practices for Native XML Web Services

About the Trainer

10 + Years of IT experience, provided training for over 1000+ professionals online Real-time IT experience which enables to provide dedicated quality training. Teaching is his passion vast experience in providing online training around the globe with good communication skills.