Title: MICSQL70DI) Microsoft SQL Server 7.0 Database Implementation Curriculum
Abstract: From the Publisher:
General Information
Course Duration:
40 hours
Audience:
IT professionals including database administrators, application developers, independent software vendors, IS managers, system integrators, and Internet consultants who want to plan, deploy, configure, administer, and troubleshoot SQL Server 7.0
Prerequisites:
Experience of configuration and administration of Windows NT, familiarity with the Windows 95 or Windows NT user interface, familiarity with managing end-user accounts in an NT environment, knowledge of SQL or Transact-SQL, and an understanding of the role of a database administrator
Topics Covered
Architecture and Features Fundamentals of Database Design Normalization and Physical Database Design Basic Transact SQL Creating Databases Data Integrity and Loading Techniques Indexes and Views Advanced Transact SQL Stored Procedures and Triggers Transactions and Distributed Data Monitoring and Optimizing
Minimum Requirements to run SmartForce products:
486/33 processor or higher 8MB of RAM VGA display (256 colors recommended) 10-20MB of hard disk space DOS version 3.1 or higher Windows version 3.1/Windows 95
Supported Network Operating Systems:
Novell NetWare 3.1x/4.1x Windows NT 3.51/4.0 OS/2 LAN Manager Banyan Vines
Course Aim
To prepare students for Microsoft exam 70-029: Designing and Implementing Databases with Microsoft SQL Server 7.0.
Learning Objectives
After taking this course, the user should be able to:
Design and implement a Microsoft SQL Server client/server database management system version 7.0
Implement a database solution with Microsoft SQL Server 7.0 and upgrade MS SQL Server from versions 6.0 and 6.5 to 7.0
Use the architecture and feature changes from version 6.5 to version 7.0
Migrate data from other data sources to SQL Server
Publication Year: 2000
Publication Date: 2000-02-01
Language: en
Type: book
Access and Citation
AI Researcher Chatbot
Get quick answers to your questions about the article from our AI researcher chatbot