Duration: 5 days

Description 
This class will teach students how to manage a SQL Server database and environment. Attendees will learn how to manage and configure the database, configure and manage tables, create indexes, create stored procedures, views and triggers. Topics will include working with Enterprise Manager, Query Analyzer, backup and recovery, importing and exporting data and automating tasks. An emphasis is placed on best practices.

Topics

• SQL Server architecture
• Query analyzer
• Enterprise Manager
• Transact-SQL identifiers
• Transact-SQL data types
• SQL functions
• Data definition language statements
• Stored procedures
• User defined functions
• Triggers
• Managing transactions
• SQL Server utilities
• Managing users
• Security
• Performance tuning
• SQL Server agent
• Alerts
• Troubleshooting
• XML support
• Backup and recovery
• Data transformation services
• Best practices

Prerequisites

• A fundamental understanding of SQL and relational database concepts. Fundamental knowledge in programming is strongly recommended.