Relational Database Design and Administration

This course covers the design methodologies and techniques utilized when building an application based on a Relational Database Management System (RDBMS), using Structured Query Language (SQL). The course is based on RDBMS technology and will identify and explain the details and implementation.

Relational Database Design and Administration training covers such topics as:

SQL Server Administration
Installation and Configuration
Managing with SQL Server
Replication
Performance
Accessing SQL Server

The course is designed for database administrators.

Relational Database Design and Administration
Everything Programming

Description
This course covers the design methodologies and techniques utilized when building an application
based on a Relational Database Management System (RDBMS), using Structured Query Language
(SQL). The course is based on RDBMS technology and will identify and explain the details and
implementation.
Audience
The course is designed for database administrators.
Prerequisites
Some knowledge of SQL and RDBMS.
Course Duration
» 5 hours
Topics Include
Unit 1:
SQL Server Administration
» Server Features
» Administrative Tasks
» Server Tools
» Server Basic Concepts
Unit 2:
Installation and Configuration
» Pre-Installation
» Installation
» Post-Installation
Unit 3:
Managing with SQL Server
» Devices and Databases
» SQL Security
» Backup and Restore
» Scheduling and Alerts
Everything Courseware
Relational Database Design and Administration
Unit 4:
: Replication
» Concepts
» Implementing
Unit 5: Performance
» SQL Performance Monitor
» Troubleshooting
Unit 6: Accessing SQL Server
» Client Utilities
» SQL Compatible Applications

System Requirements

» Pentium class computer
» 200 MHz processor (266 MHz recommended)
» 32 MB RAM (64 MB recommended)
» CD-ROM drive
» Any one of Windows 95, Windows 98, Windows Me, Windows NT 4.0, or Windows
2000 (both Windows NT 4.0 and Windows 2000 require at least 64 MB RAM)
» SVGA monitor capable of 16-bit color and 800 x 600 screen resolution
» Sound card with speakers or headphones (optional)

Features
• Industry-leading Technology - CCI's Learning Object Framework enables the design and development of flexible, self-contained learning modules for a personalized training experience

• Award-winning Products - eSchool Solutions create anywhere, anytime learning environments that boost productivity with their off-the-shelf courseware or fully customized content.

• Powerful Training Solutions - Highly adaptable and customized e-learning models and instructional design tailored to the diverse needs of the training industry, delivered in a packaged CD or on the Web.

• Satisfied Clients - With a solid reputation for quality products and bottom-line results, CCI's e-learning solutions have been adopted by diverse organizations including Royal Bank, Thomson Publishing, IBM, Paradyne Corporation, InfoCast Corporation, GE, Delta Environmental, HighTech Campus, California Federal Bank, CIBC and many others.