SQL SERVER Course Content

sql server 2008
  • 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