MICSQL70DI) Microsoft SQL Server 7.0 Database Implementation Curriculum

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