Computer Training Computer Tutorials
Computer Lessons
CD Training CD Learning Elearning CD-ROM Computer Training Online Training
Education Information Learn Information
Career Training Career Skills
Keyword Search
All Training Products
New Releases
Top Sellers
Adobe
Animation & 3D
Applications
Business
Certification
Databases
Documentary History
Educational
General Interest
Graphics & Page Layout
Internet
Macromedia
Microsoft Office
Multimedia & Video
Online Technical
Online General
Operating System
Programming
Software & Design
Technical
Web Design

Webmaster Resources
Free Downloads
Website Promotions
Dictionary Terms
Forum Links
Articles
Free Training Quizzes
About / Demos
SiteMap
Order Info
Online Course Login
Amazon eMall
Add to Favorites

Newsletter Signup
SQL Server 7 Admin: Loading Databases
Product Code: LA7C12 Time: 3 Hour(s) CEUs: .30

Summary:

This training course shows users how to load data from other sources into SQL Server databases.

Objectives:

After completing this training course , students will be able to:
  • Load data using the INSERT statement
  • Load data using the SELECT INTO statement
  • Load data using the BCP Utility
  • Load data using the Data Transformation Services (DTS)
  • Load data using the BULK INSERT command

Outline:

  • The INSERT and SELECT INTO Statements
  • Bulk Copying Data
  • Importing and Exporting Data with DTS
  • Managing DTS Packages

Features:

  • Exercises that allow users to practice the application
  • A file containing the text of the exercises
  • Simulations that allow users to practice training course skills, even if they don't have access to the application
  • A glossary
  • A Skill Assessment

Applicability:

This training course is for database administrators who want to learn how to administer SQL Server 7.0, or who are preparing for the MCSE exam 70-028: Administering Microsoft SQL Server 7.0.

Prerequisites:

Experience working with relational database systemsPrevious training course s in, or experience with, NT Server administrationtraining course s on Database Concepts or equivalent experiencetraining course s on SQL or equivalent experienceSQL Server 7 Admin: Security StrategySQL Server 7 Admin: System RequirementsSQL Server 7 Admin: Migration PlanningSQL Server 7 Admin: Replication PlansSQL Server 7 Admin: Installing the ServerSQL Server 7 Admin: Other InstallationsSQL Server 7 Admin: ConfiguringSQL Server 7 Admin: Security ManagementSQL Server 7 Admin: Managing AccountsSQL Server 7 Admin: Managing PermissionsSQL Server 7 Admin: Database Management

Technical Requirements:

200MHz Pentium with 32MB Ram. 640 x 480 256-color video (800 x 600 is recommended). Windows 95, 98, NT, 2000, or XP. Minimum Connection Speed: 28.8k. Internet Explorer 5.0 or higher required. Authorware and Macromedia Flash player recommended but not required. JavaScript must be enabled. Netscape and AOL browsers not supported.

Copyright Information:

  • Microsoft® is a registered trademark of Microsoft Corporation.

Terms of Use:

None

Copyright © 2004 Discoveryvip.com Online Training All rights reserved.

Featured Computer Training Products

Application Training: Flash MX Software Training, Dreamweaver MX Software Training, Fireworks MX Software Training
Computer Skills Development: Computer Basics Training, Everything Desktop (Microsoft Training), Everything Handheld
Business Skills Development Training: Everything Quick Business, Everything OSHA, Everything HR/Legal, Everything Management Skills, Everything Sales Skills, Everything Basic Finance
Certification Training Everything MCSE, Everything MCSD, Everything O/S 390, Everything Programming, Everything Cisco, Everything UNIX, Everything Oracle, Computer Technician Training, Network Technician Training