Courses » Database Courses » SQL Server Online Training

 

SQL Server Online Training

 

SQL Server 2010 Online Training

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