Fast Track to SAP Sybase Adaptive Server Enterprise 16 (ASE2)

In this course you will learn the ASE server architecture, core components and recent features, and how to create and manage tables and other objects using ANSI SQL and Transact-SQL. Practical exercises give hands-on experience with ASE databases.

The course covers ASE special features including stored procedures, triggers and cursors, and teaches efficient programming techniques and development strategies to build robust, maintainable, high-performance database applications.

Location, current course term

Contact us

Custom Customized Training (date, location, content, duration)

The course:

Hide detail
  • Adaptive Server Enterprise
    1. Client/server architecture and relational database concepts
    2. How SAP Adaptive Server Enterprise (ASE) manages relational databases
  • Client Tools and Transact-SQL
    1. Creating views
    2. Creating indexes
  • Data Analysis
    1. Executing queries with SELECT statements
    2. Writing qualified queries
    3. Grouping and organizing result sets
    4. Querying multiple tables using joins
    5. Running queries with subqueries
  • Table Management
    1. Creating tables
    2. Creating temporary tables
    3. Querying system tables
  • Data Modification
    1. Data Manipulation Language (DML) overview
    2. Inserting data into tables
    3. Updating table data
    4. Combining INSERT and UPDATE operations
    5. Modifying data and handling changes
    6. Understanding the transaction log
  • Views and Indexes
    1. Creating views
    2. Creating indexes
  • Data Integrity
    1. Data integrity concepts
    2. Enforcing integrity with constraints
    3. Managing constraints
    4. Using defaults and rules for integrity
    5. Choosing suitable integrity methods
  • Transact-SQL Functions
    1. Using built-in Transact-SQL functions
    2. Creating user-defined functions
  • Variables
    1. Understanding batches
    2. Using local and global variables
    3. Describing dynamic execution of SQL
  • Control-of-Flow Statements and Messages
    1. Creating control-of-flow statements
  • Transactions and Data Consistency
    1. Transaction modes and behavior
    2. Executing transactions
    3. Handling transaction errors
    4. Data locking methods and implementation
    5. Locking schemes and isolation levels
  • Cursors
    1. Inserting data using a cursor
    2. Modifying data with cursors
  • Stored Procedures
    1. Overview of stored procedures
    2. Creating stored procedures with parameters
    3. Applying stored procedure best practices
  • Triggers
    1. Understanding triggers
    2. Creating triggers for cascaded updates
    3. Applying appropriate rollback behavior in triggers
    4. Trigger best practices and data integrity considerations
Assumed knowledge:
Basic computer skills.
Schedule:
5 days (9:00 AM - 5:00 PM )
Education Partner:
MIBCON DIMA s.r.o.
Language: