 |
Sandline
Training
CD-ROM Video Based Courses |
 |
 |
|
|
| |
|
|
|
|
|
 |
|
 |
|
|
 |
 |
 |
 |
 |
 |
![]() |
 |
|
Installing, Configuring, and Administering Microsoft SQL Server 2000 Enterprise Edition
The course training 70-228
(Installing, Configuring,
and Administering Microsoft
SQL Server) from Sandline
Learning will prepare the
IT professional with the
skills and knowledge required
to install, configure, and
administer Microsoft's SQL
Server. The Sandline Learning
course will strengthen and
exceed your knowledge implementing
relational databases in
several environments including
heterogeneous databases,
SQL Server security, Client/Server
configurations of numerous
users, web configurations,
and more.
|
|
 Audience:
Candidates for this course operate in medium to very large computing environments that use Microsoft SQL Server 2000 Enterprise Edition.
Did you know that being certified would increase your salary tremendously? Microsoft certification is a leading credential that validates your experience and skills to keep you competitive in today's changing business environment. Technical and Professional certification is becoming more popular today. Because of the rise of the Internet, and the overall growth of the Information Technology, companies are finding it hard to find the right person to fill IT positions, being certified is even more important today!
This course will give the student the skills required to administer and troubleshoot information systems that incorporate Microsoft SQL Server 2000 Enterprise Edition. Upon successful completion of this course, the student will be able to pass the Microsoft 70-228 exam, Installing, Configuring, and Administering Microsoft SQL Server 2000 Enterprise Edition, which is one of the core electives in the Microsoft's MCSE 2003 and one of the core exams in the Microsoft MCDBA certification program.
|
|
|
 Our
easy-to-use delivery format
allows you to concentrate
on the lesson at hand and
not how to run the delivery
software - saving you time
and frustration. Our comprehensive
course materials are delivered
in an easy-to- understand
format - allowing you to get
the most out of your time.
Our CD-rom courses incorporate
audio, video, and text training
and then the total experience
is reinforced with exercises
and practice tests to ensure
that you have really grasped
the material.
|
|
|
|
|
 |
 |
 |
|
|
 |
 |
 |
 |
|
 |
|
|
 |
 |
 |
|
|
|
 |
|
|
|
|
|
|
| |
|
|
|
|
|
|
|
|
|
|
|
|
|
![]() |
|
|
| |
Installing, Configuring, and Administering Microsoft SQL Server 2000 Enterprise Edition (Course Modules) |
|
|
| |
| Installing and Configuring SQL Server 2000 |
|
| Install SQL Server 2000. Considerations include clustering, default collation, file locations, number of instances, and service accounts. |
|
Upgrade to SQL Server 2000.
- Perform a custom upgrade.
- Upgrade to SQL Server 2000 from SQL Server 6.5.
- Upgrade to SQL Server 2000 from SQL Server 7.0.
|
|
| Create a linked server. |
|
| Configure SQL Mail and SQLAgentMail. |
|
| Configure network libraries. |
|
| Troubleshoot failed installations. |
|
| Creating SQL Server 2000 Databases |
|
| Configure database options for performance. Considerations include capacity, network connectivity, physical drive configurations, and storage locations. |
|
| Attach and detach databases. |
|
Create and alter databases.
- Add filegroups.
- Configure filegroup usage.
- Expand and shrink a database.
- Set database options by using the ALTER DATABASE or CREATE DATABASE statements.
- Size and place the transaction log.
|
|
| Create and manage objects. Objects include constraints, indexes, stored procedures, triggers, and views. |
|
| Managing, Monitoring, and Troubleshooting SQL Server 2000 Databases |
|
| Optimize database performance. Considerations include indexing, locking, and recompiling. |
|
Optimize data storage.
- Optimize files and filegroups.
- Manage database fragmentation.
|
|
| Modify the database schema. |
|
Perform disaster recovery operations.
- Perform backups.
- Recover the system state and restore data.
- Configure, maintain, and troubleshoot log shipping.
|
|
| Perform integrity checks. Methods include configuring the Database Maintenance Plan Wizard and using the Database Consistency Checker (DBCC). |
|
| Troubleshoot transactions and locking by using SQL Profiler, SQL Server Enterprise Manager, or Transact-SQL. |
|
|
|
| Extracting
and Transforming Data
with SQL Server 2000 |
| Set up IIS virtual directories to support XML. |
| Import
and export data. Methods
include the Bulk Insert
task, the bulk copy program,
Data Transformation Services
(DTS), and heterogeneous
queries. |
| Develop and manage DTS packages. |
Manage linked servers.
- Manage OLE DB Providers.
- Configure security mapping.
|
| Convert data types. |
| Configure, maintain, and troubleshoot replication services. |
| Managing and Monitoring SQL Server 2000 Security |
| Configure mixed security modes or Windows Authentication. Considerations include client connectivity, client operating system, and security infrastructure. |
| Create and manage log ons. |
| Create and manage database users. |
Create and manage security roles. Roles include application, database, and server.
- Add and remove users from roles.
- Create roles to manage database security.
|
| Enforce and manage security by using stored procedures, triggers, views, and user-defined functions. |
| Set permissions in a database. Considerations include object permissions, object ownership, and statement permissions. |
| Manage security auditing. Methods include SQL Profiler and C2 auditing. |
| Managing, Monitoring, and Troubleshooting SQL Server 2000 |
| Create, manage, and troubleshoot SQL Server Agent jobs. |
| Configure alerts and operators by using SQL Server Agent. |
Optimize hardware resource usage. Resources include CPU, disk I/O, and memory.
- Monitor hardware resource usage by using System Monitor.
- Resolve system bottlenecks by using System Monitor.
|
Optimize and troubleshoot SQL Server system activity. Activities include cache hits, connections, locks, memory allocation, recompilation, and transactional throughput.
- Monitor SQL Server system activity by using traces.
- Monitor SQL Server system activity by using System Monitor.
|
| |
|
| |
|
|
|
|
|
|
 |
|
|
|
|
|
|
|
|
|
|
|
|
|
| | | | |
are included. 
then
its included.
