SQL Server 2000 Admin MCDBA MCSA MCSE 70-228 - Creating and Managing Databases

Summary:

This course discusses the basic creation of databases and database objects within a SQL Server 2000 instance. The tools provided in SQL Server 2000 installations for creating these are the SQL Server Enterprise Manager, a graphical user interface (GUI) ma

This lesson is part of our SQL Server 2000 Admin MCDBA MCSA MCSE 70-228 online training series which contains over 13 hours of self-paced courseware. Our web-based training provides 6 months of unlimited access.

Objectives:

After completing this course you will be able to:

• Plan proper data and log file placement for a new database
• Understand how to create and use filegroups
• Create and delete a database using GUI and command-line methods
• Restrict database access to Single-User Mode and restore normal access
• Perform Attach and Detach operations on a database
• Use the Enterprise Manager to modify existing database objects, including tables, views and stored procedures

Outline:

• Basic Requirements
• Creating and Deleting Databases
• The CREATE and DROP DATABASE Commands
• Creating Objects
• Managing Databases
• The ALTER DATABASE Command
• Managing Objects

Applicability:
This course is for anyone who wants to get the most out of using SQL Server 2000 Admin MCDBA MCSA MCSE 70-228.

Prerequisites: None:

Technical Requirements:

• Internet connection
• Browser: Internet Explorer, FireFox, Chrome, Safari, Opera or any standards compliant browser.
• Authorware and Macromedia Flash player recommended but not required.
• JavaScript must be enabled.

Retake any or all of our computer training as often as you want. Our online tutorials allow you to learn anywhere, anytime from any computer with internet access. All courses allow for 6 months of unlimited access (1 user), includes a variety of features and all courses qualify for Continuing Education Unit credit.

StaffKit is an e-learning leader in providing computer training tutorials and online education. We have satisfied customers in over 75 countries using our online training courses. We have been a leading provider of self-paced web based training for the past 10 years.