SQL Server 2003 Administration
Description: Five days of intensive hands on training, this class will allow the student to understand relational database concepts and the Structured Query Language (Transact-SQL) in the Microsoft SQL Server environment as well as identify and configure all major aspects of a Microsoft SQL Server RDBMS. You will learn about tables and constraints; DTS packages and transformations; transact SQL queries; creating views; creating and tuning indexes; building transactions & triggers and creating stored procedures; relational database concepts; SQL vocabulary; a terminology guide; key features of SQL Server; a comprehensive guide to the SQL Server tools, including Enterprise Manager and Query Analyzer; and database implementation basics. The course also shows how to install and configure SQL Server, create and manage databases and database devices, backup and restore SQL Server databases, import and export data, implement automated tasks and optimize SQL server.
This course is intended for administrators new to database management and development, and includes all of the material in the SQL Programming and Relational Database Design courses. You should not register for either of those courses if you will be attending this course.
Prerequisites: Familiarity with Windows desktop navigation and software installation procedures.
--------------------------------------------------------------------------------
Information provided is for information purposes only and no guarantees are made with regards to accuracy. It is advised that all details are checked prior to making a booking. Terms of use