Sybase

This series is designed to introduce database administrators to using and managing Sybase System 11. It covers an overview of Sybase SQL Server, the client/server system model, and the tools and components of Sybase System 11. It discusses using SQL Server to create, manage, and access database information, and the tasks and commands of a system administrator. Additional topics covered in this series include management of user accounts and groups, granting and revoking permissions, basic T-SQL programming commands and functions, and using T-SQL commands to create database queries, manipulate data, join queries, create subqueries, and insert and modify data.

Syllabus

INTRODUCTION TO SYBASE

Provides an overview to Sybase SQL Server, the client/server system model, and the tools and components of Sybase System 11.

• Host versus Client/Server Systems
• Sybase Introduction
• SQL Server, Data Replication, and Open Architecture
• System Management Tools and Servers

USING SQL SERVER

Introduces users to SQL Server and how to use it to create, manage, and access database information.

• SQL Server Overview
• SQL Server Functions
• SQL Server Features
• T-SQL and Database Integrity
• Triggers, Partitions, and Security
• Using isql and Performing Queries
• Viewing, Managing, and Creating Tables
• Maintaining Databases

SYSTEM ADMINISTRATION

Provides an overview of the tasks and commands of a system administrator.

• The Role of a System Administrator
• Using System Procedures
• Creating and Dropping Database Devices
• Creating and Altering Databases
• Managing Segments

USER ADMINISTRATION

Shows users how to manage user accounts and groups in Sybase.

• Managing Server Logins
• Managing User Access and Aliases
• Managing Groups
• Assigning and Managing Roles
• Granting Permissions
• Revoking and Modifying Permissions

PROGRAMMING WITH T-SQL

Introduces users to basic T-SQL commands and functions through the isql interface.

• Using T-SQL and isql
• Managing Tables
• Defining Integrity Constraints
• Creating Integrity Defaults and Rules
• Using Views
• Managing Indexes

QUERYING DATABASES WITH T-SQL

Shows users how to create database queries and to manipulate the data received through queries.

• Introduction to Queries
• Using Functions in Queries
• Manipulating Query Data
• Ordering and Grouping Query Results
• Combining Queries and View Queries

T-SQL COMMANDS

Explains how to join queries, create subqueries, and how to insert and modify data in Sybase.

• Join Queries
• Subqueries
• Other Subquery Types
• Inserting Data
• Deleting and Modifying Data

Qualifications

Qualification: Printable Transcript

On completion of this course you may print a transcript off as evidence of your progression throughout the course.

Requirements for Entry

There is no experience or previous qualifications required for enrolment on this course. It is available to all students, of all academic backgrounds.

Study Options

If you do not have Internet access, or would prefer to study this course via the traditional paper/postal based study method, you can find more information on the course by clicking on the link below.

Study Hours

This is only an approximate figure and is dependant upon how much time you can dedicate to your studies and how well you grasp the learning concepts in the course material. Furthermore, at the end of each lesson there is a question paper that needs to be completed and returned to your tutor. You should allow at least 1 - 2 hours of study to complete each question paper.

The approximate amount of time required to complete the course is: 40 hrs.