Designing and Implementing Databases with Microsoft SQL Server 2000 (Learning Segments)

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.

	Full motion video Each class is presented in full motion video allowing you to see the steps, hear the explanations, and perform the tasks which includes our interactive hands-on training simulations, students will learn from real-world scenarios taught by our expert instructor. Instructor-Led Training combines both the convenience and affordability of computer-based training with the effectiveness of a traditional classroom setting. The instructors featured in our multi-media CD's are not only certified in their area of expertise, but also have years of real world experience and are subject matter experts in their fields.

	E-BOOKS (PDF) We supply a complete line of e-books to offer a complete training solution. Our courses include e-books for CompTIA, CISCO and Microsoft certifications.Supplied on CD for CD Courses. Downloadable for Online Courses.

	Practice Exam Simulators Sandline Learning offers exam simulators for all technical certifications. Our exam simulators are the closest replication to the real exam! Our exam simulators creates a simulation of an actual certification exam. Under timed conditions, IntelliSage? sets up a test with 60 randomly chosen questions designed to help you get ready for the real exam. As with the Practice Exam, the Certification Simulator allows you to mark questions you cannot answer for review at the end of the test. If you ask, IntelliSage? will show you the correct answer. IntelliSage? will also explain why it is the correct answer when you select the "Learn Now" feature. The Practice Exam is the first IntelliSage? step in getting you ready to pass your certification exams.


	Hands-on Lab Simulation Hands-on Lab Simulation is a crucial component of your IT training. Practice make perfect. Step-by-step hands-on labs with detail instructions are included to reinforce all key concepts. When you complete a topic, choose the Lab Simulation button to select the associated hands-on lab exercises. Labs allow you to reinforce concepts by performing the tasks you've just learned..


	Free Upgrades A unique benefit of the Sandline Learning System? is that it allows you to stay current with the ever-changing certification requirements. When a certification test changes and we produce an upgrade for the certification program, we offer our customers free upgrades on their interactive CD-ROM's for up to 1 year from date of original purchase? absolutely free!

MCP 70-229 Training Course

Online Course:	ex. VAT
CD Study Kit:	ex. VAT
List Price:	£495
Online Library:	95% off



	1yr Unlimited Online Access to 143 Courses
	Save 95%

What's included in each option?