Introduction to Sybase

Length: 4 Days
Prerequisites:  Prior Knowledge of SQL, Basic Knowledge of Relational Database Theory


Overview

Sybase is one of the Relational Database Servers used in many business sectors today. This course will give you a basic understanding
of how to administer Sybase Adaptive Server. You will learn how to properly maintain the server, back up the database and how to create
good security procedures to protect your system. You will learn the basic structure of ASE, how to work with triggers and cursor and how
to prevent locking.

Key Benefits: Learn The Language of SQL, learn how to write SQL queries. You will leave ready to contribute
to a project and you will be ready to write stored procedures and Triggers

Outline


Chapter 1. Introduction to Client-Server

• Architecture Types
• Definition of Client-Server
• Functions in Client/Server Architecture
• Adaptive Server Architecture

Chapter 2. Back End Development Tools

• isql, wisql
• Definition Client Server
• SQL Advantage
• Sybase Advantage

Chapter 3.  Relational Database

• Entities
• Attributes
• Relationships
• Primary and Foreign Keys
• Referential Integrity
• Data Integrity

Chapter 4. Review SQL

• Update
• Delete
• Select, Select Into
• Insert

Chapter 5. Basic Database Structure

• Databases
• Tables
• Views

Chapter 6. Basic Data Integrity Structures

• Rules
• Defaults
• User-Defined Datatypes
• Indexes
• Constraints

 Chapter 7.  Security

• Special Logins
• Users
• Groups and Roles
• Learn How to Allow Users Access to: Adaptive Server, Databases, Objects, Commands

Chapter 8. Transact-SQL

• Functions
• Wildcards
• Escape Clause
• Data Conversions
• Group By
• Compute and Compute By

Chapter 9. Programming Constructs

• Review Batches
• Understand Message Handling
• Understand Error Handling
• Learn How to Use Variables
• Learn to Control Flow Commands

Chapter 10. Transactions and Locking

• Using Adaptive Server Transactions
• Understand the Transaction Log &  the Automatic Recovery Process
• Understand Adaptive Server Locks

Chapter 11. Cursor Programming

• Declaring
• Opening
• Fetching Rows
• Modifying Data
• Closing
•  Deallocating
• Scope
• Cursors & Locking

Chapter 12. Stored Procedures

• Definition
• Executing
• Creating
• Displaying
• Maintaining
• Calling with Cursors
• Referencing
• Optimzing
• Groups
• Remote
• Guidelines
• Parameters
• Result Sets
• Procedure & Server Status

Chapter 13. Declarative Referential Integrity

• Defined
• Deleting & Inserting Rows
• Updating Keys
• Constraints
• Create Schema

Chapter 14.  Triggers

• Creating
• During Transactions
• Firing
• Save Points
• Nesting
• Guidelines
• Deleted & Inserted Tables

Chapter 15. Backup & Restore

• How to Back up a Database
• How to Restore a Database
• BCP Utility

Chapter 16. Open Client

• Revisit Client/Server
• db_library
• ct_library
• ODBC
• Other Sybase Components

 

Back to Course Listing