Profile

e-Catalog

Contact

Search

Cart

Microsoft SQL Server 7.0: Creating Databases

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

Course Aim

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

Learning Objectives

Analyze the hardware and software requirements for a new SQL Server database. Create a SQL Server database. Compare the different database options. Distinguish between the different system-supplied datatypes. Create user-defined datatypes. Create and manage database tables.

Topics Covered

Database planning - Files and filegroups - Data placement - Planning for database growth Working with databases - Database creation - Modifying a database - Hands-on: Creating and altering a database Datatypes - System-supplied datatypes - User-defined datatypes - Hands-on: Creating a user-defined datatype Database tables - Creating a table - Modifying a table - Hands-on: Building a table