|
|
SQL Server 6.5
Join over 1 million people who learn
online, with these complete interactive computer training
courses.
Receive your login ID to take the training courses online,
as many times as you wish, for 1 year.
Click
here for group orders.
| Buy this entire
online training course with one easy payment of $67 |
|
OR
| Buy the Microsoft
Pack, and receive this course
plus many more, for only $197
|
 |
|
Benefits |
- Unlimited access for
1 year
- Learn anytime,
anywhere
- You control the pace
- Start & stop
wherever you want
- No books to read
- No software needed
- Value Packs include
Free online tech support
- Double
guarantee
|
- 100% Money back
guarantee
- One time payment No
monthly fee
- Use the course index
for review anytime
- Answer course
questions with at least 70% accuracy and print
your own certificates of
completion to prove that you have mastered each training course.
- Free status reports
for company managers
|
|
|
Requirements |
All you need is a PC with Windows,
the Microsoft Internet Explorer (browser)
and an Internet connection.
Note: The online computer training is designed to
work only with Internet Explorer. Prices shown are per
user. |
|
What
You will Learn |
| This online training course provides an overview of Microsoft SQL Server 6.5. The SQL Enterprise Manager and its use for creation and management of database objects is explained in detail. Instructions for installing SQL Server 6.5 and setting up physical and mirror devices is provided, along with instructions on implementing security, user administration, and configuring replication. Database administration is covered in detail, including creating and maintaining databases and database logs, and using OBCC for maintenance. Advanced topics covered include system management, remote and distributed management options, and performance tuning. |
|
Introduction |
- Access the features of SQL Enterprise Manager
- Understand the terminology and options available in SQL Enterprise Manager
|
- Create database objects with SQL Enterprise Manager
- Modify and manage database objects
- Manipulate and control database objects
|
|
|
Installation and Setup |
- Identify system administrator functionality
- Configure Microsoft Windows NT for SQL Server installation
- Load multiple Net Libraries
- Create a device
|
- Configure SQL Executive to log on as a service
- Upgrade SQL Server 4.2x to SQL Server 6.5
|
|
|
Users and Replication |
- Set up a security mode
- Identify how SQL Server is integrated with Windows NT
- Manage user accounts
|
- Manage permissions
- Identify and implement the appropriate replication scenario
|
|
|
Database Administration |
- Create and alter a database
- Estimate space requirements for database storage
|
- Set database options
- Check object integrity
- Investigate a database that is marked suspect
|
|
|
System Management |
- Identify how automatic recovery works
- Perform a database dump and load a database dump
- Perform a striped backup
|
- Configure and manage server in the enterprise
- Set up alerts and schedule tasks
|
|
|
Tuning for Performance |
- Select the appropriate settings for locks
- Configure the number of worker threads
- Select the appropriate settings for read ahead
|
- Identify the benefits of installing the tempdb database in RAM
- Tune and monitor memory use
|
|
|