After completing Sybase: System Administration the user should be able to:

	Explain the role of a system administrator
	Use system procedures for database administration
	Manage databases
	Manage segments

The Role of a System Administrator

	Understanding roles
	The SA role
	The SSO role
	The OPER role

Using System Procedures

	System databases tables and procedures
	Common system tables
	Creating system procedures
	Preconfigured system procedures

Creating and Dropping Database Devices

	Initializing database devices
	Default database devices
	Dropping database devices

Creating and Altering Databases

	Creating a database
	Database information
	Altering databases
	Dropping databases

Managing Segments

	Using segments
	Creating segments
	Getting information on segments
	Placing objects in a segment
	Altering segments
	Dropping segments

This course has the following features:

	Exercises that allow users to practice in SQL Server
	A file containing the text of the exercises
	Simulations that allow users to practice course skills even if they don't have access to Sybase SQL Server
	A glossary
	A Skill Assessment