Microsoft SQL Server 7.0: Creating Databases

Overview/Description
To provide a SQL Server database administrator or developer with the knowledge required to create and maintain SQL Server databases and tables

Target Audience
IT professionals including database administrators, application developers, independent software vendors, 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

Expected Duration
4:00 Hours

Objectives:

Microsoft SQL Server 7.0: Creating Databases

  • To give an overview of how data is stored and placed on different disks, and how to plan for database growth
  • To describe how to work with databases and show how to create and alter a database
  • To describe how to use datatypes in SQL Server
  • To demonstrate how to create and modify tables


    • Course Number: SQ7042E