SYBASE Fundamentals & Programming

 LENGTH OF COURSE:
5 Days

DESCRIPTION: This intense 5 day course is designed to introduce students to the SYBASE relational database product. It will begin with an introduction to relational database terminology and conclude with basic system administration. In addition, students will evaluate the use of SYBASE in an Enterprise Environment.

PREREQUISITES: Understand database concepts and terminology.

INSTRUCTION TECHNIQUES: A combination of Lecture, Demonstrations, and Labs (when/where available).

AUDIENCE

This course is designed for Programmers, Users, Technicians, and Managers that need to become proficient with the SYBASE product and facilities. The course will address the issues of technical and non-technical personnel that need to use the SYBASE product to access and manipulate relational data.
KEY HIGHLIGHTS:
  • Introduction to Client/Server Computing
    • Client/Server Terminology, Facilities, and Benefits
    • How to implement Client/Server in a Heterogeneous Computing Environment
    • Components of a Client/Server Environment
    • SYBASE Client/Server Architecture
  • SYBASE Relational Database Terminology and Concepts
    • Entities and Relationships
    • Use of tables, indexes, types, and creation
    • Relationships and use of keys
    • Referential Integrity
    • Datatypes, usage, and nulls
    • Views and usage
    • Data integrity with declarative integrity
    • Rules: Definition, Characteristics and Usage
    • The Structured Query Language
  • SYBASE in the Open Environment


  • SQL Server Functions and Features
    • SYBASE SQL Server
    • Network considerations
    • The Optimizer
    • Rule Enforcement
    • Recovery Considerations
  • Data Manipulation in the SYBASE Environment
    • Displaying Database Information
    • Transact-SQL
    • Select, Insert, Update, Delete
    • T-SQL Extensions and Functions
    • Summarizing and Grouping Data
    • Cursor Processing
  • Programming using Transact-SQL
  • Transaction Management in the SYBASE Environment
    • What is a Transaction?
    • Memory Management
    • Checkpoints, Recovery, and Roll Back
    • Locking and Lock Types
    • Transaction Control and Modes


  • Stored Procedures
    • Creation and Usage
  • Introduction to SYBASE Administration
    • Responsibilities of Administrator
    • SYBASE Utilities and Usage
    • Overview of SYBASE Security
    • Granting and Revoking Permissions
  • Advanced Administration Topics


FROM OUR STUDENT EVALUATIONS...
"Jeff Markiewicz's courses are always the first place I look for instruction/courses."

Marjorie Morrow
Alex. Brown & Sons, Incorporated

Return to Home Page.
Return to Alphabetic Listing of Courses.
Return to Courses by Subject.
Request More Information or Contact Us.