|
Provided by: Binary Research International, Inc. Implementing and Maintaining Microsoft SQL Server 2005Training, Instruction and Documentation |
 |
Training
Provided by Binary Research International, Inc.
The training course consists of online, live instructor-led sessions and additional self-paced e-learning content, scenario-based labs, and assessments to provide Participants with the knowledge and skills to manage and maintain Microsoft SQL Server 2005.
Topics include:
SQL Server 2005 Architecture
Preparing to Install SQL Server 2005
Installing SQL Server 2005
Installing and Configuring Administrative Tools
SQL Server 2005 Conformation Tools
Related Software Programs or Products: Microsoft SQL Server 2005
Related Jobs or Careers: It Administrator, Network Administrator
|
|
||||||||||
Implementing and Maintaining Microsoft SQL Server 2005
This course is intended for IT Professionals wanting to become skilled on SQL Server 2005 product features and technologies for maintaining a database.
Participants will learn to:
- Install and configure SQL Server 2005.
- Create databases and database files.
- Create data types and tables.
- Generate basic SQL Server 2005 queries and XML reports.
- Manage SQL security.
- Backup and restore user databases.
- Recover system database in the event of a disaster.
- Implement data integrity for a database by using the constraints, triggers, and XML schema.
- Implement basic stored procedures and functions.
- Mirror SQL databases.
Before attending this course, Participants should have up to 1 year of experience implementing server plans although have probably not yet had full responsibility for planning.
This course requires that Participants meet the following prerequisites:
- Basic knowledge of the Microsoft Windows operating system and its core functionality.
- Working knowledge of Transact-SQL.
- Working knowledge of relational databases.
- Some experience with database design.
- Working knowledge of XML
Participants will learn to:
- Install and configure SQL Server 2005.
- Create databases and database files.
- Create data types and tables.
- Generate basic SQL Server 2005 queries and XML reports.
- Manage SQL security.
- Backup and restore user databases.
- Recover system database in the event of a disaster.
- Implement data integrity for a database by using the constraints, triggers, and XML schema.
- Implement basic stored procedures and functions.
- Mirror SQL databases.
Before attending this course, Participants should have up to 1 year of experience implementing server plans although have probably not yet had full responsibility for planning.
This course requires that Participants meet the following prerequisites:
- Basic knowledge of the Microsoft Windows operating system and its core functionality.
- Working knowledge of Transact-SQL.
- Working knowledge of relational databases.
- Some experience with database design.
- Working knowledge of XML
About The Training Provider: Binary Research International, Inc.
Binary Research International, Inc. - Binary Research was the original developer of Ghost. BRI has been selling and supporting Ghost since 1997, when we first opened as the worldwide technical support office. Symantec acquired Ghost in 1998 and our technical support staff have been developing Ghost training courses ever since. During this time, BRI has developed courseware for five different Ghost Workshops, including two that...
