|
|
Sybase: 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
|
|
|
Sybase: 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
|
|
|
Sybase: 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
|
|
|
Sybase: 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
|
|
|
Sybase: 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
|
|
|
Sybase: 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
|
|
|
Sybase: 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
|
|
|
