back to Course Categories | back | print
SQL Server Database Administration          

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.


 
 
 

Trubix Inc. P.O. Box 2235 Littleton, CO 80161 | 1.866.4-TRUBIX • 303.730.6800
email: info@trubix.com
....................................................................................................................................................................

Training Service | Consulting / Mentoring | Public Schedule | Course Listings | Tru iLearning | About Us | Contact Us
Oracle DBA Classes | Oracle Dev Classes | Oracle App Server Classes | Linux / Unix Classes
SQL Server / .NET / Tools / DB2 Classes / Public Classes

 

 
all content property © 2006, 2007Trubix Inc.| site design by Art Z design