|
Provided by: Serebra Learning Corporation SQL Server 7.0 Management Part IMS SQL Server |
 |
This course is designed to teach the skills necessary to take full advantage of SQL Server 7.0 features and enhancements used to manage data. SQL Server 7.0 contains two powerful tools for managing data: Transact-SQL at the command-line level and SQL Server Wizard features. This course presents a comprehensive view of the database development process by outlining the processes of creating the database managing elements and data and building retrieval features. Students begin with an overview of elemental database objectives. The student learns to use Transact-SQL commands SQL Server 7.0 Wizards and SQL Server 7.0 Managers to manage database contents schema and performance. This course is written to SQL Server 7.0. Related Exams: Prepares users for both Microsoft Exams #070-028 Administering Microsoft SQL Server 7.0 and #070-029 Designing and Implementing Databases with Microsoft SQL Server 7.0
|
|
||||||||||
Audience
Database administrators Database analysts and Database developers who are working toward the Microsoft Certified Database Administrator (MCDBA) credential. The series is designed to help the student pass the Microsoft Exam 70-028: Administering Microsoft SQL Server 7.0 and Exam 70-029: Designing and Implementing Databases with Microsoft SQL Server 7.0. This series is also appropriate for individuals who derive physical database designs develop logical data models create physical databases create data services by using Transact-SQL manage and maintain databases configure and manage security monitor and optimize databases and install and configure Microsoft SQL Server.
Prerequisites
Students understand computer system fundamentals and have user knowledge of Windows 95 Microsoft Office Internet browsing and HTML and e-mail systems. Students are expected to have successfully completed SQL Server 7.0: Introduction and SQL Server 7.0: Installing and Upgrading courses.
Objective
Upon completion of this course the student will be able to:
Topics Include
Unit 1: SQL Server and Relational Databases
- SQL Server Integration with Windows NT4.0
- Enhancements to SQL Server 7.0
- Files and Filegroups
Unit 2: Building a SQL Server Database
- Using the Create Database Wizard
- Dropping a Database
- Creating Filegroups
- Using Database Objects
Unit 3: Importing and Exporting Data
- Data Transformation Services (DTS)
- Bulk Copy Program (bcp)
- BULK INSERT
- Choosing a Transfer Method
Duration
5 Hours
Minimum Requirements
IBM-compatible PC with 166 MHz or higher processor 32 MB RAM (64 MB RAM recommended); 800x600 SVGA color monitor with 16-bit high color display; Internet Explorer 4 or Netscape Navigator 4 or later with Shockwave 7.0.1; Windows 95 Windows 98 Windows NT; 3.5 diskette (for tracking); 28.8 kbps connection or higher for on-line use.
Media
CDROM
Web Based Training
Serebra Learning Corporation 119 - 7565 132nd Street Surrey BC V3W 1K5 Canada
