Fast Track to SAP Adaptive Server Enterprise

Duration: 5 days
  • Use the basic components of ASE to connect to a server database
  • Create tables, populate the tables with data, and efficiently query data from those tables
  • Write code in Transact-SQL
  • Use and manage transactions effectively
  • Write stored procedures and triggers to help in database maintenance and upkeep

This course is geared towards data consultants/managers, system architects and technology consultants with a basic understanding of network connectivity architecture and Knowledge of general Unix commands. Some basic knowledge of database and SQL is recommended but not required.

Please find the course objectives below:

Adaptive Server Enterprise

  • Describing Client/Server Architecture and Relational Database Concepts
  • Explaining SAP Adaptive Server Enterprise (ASE) Management of Relational Databases

Client Tools and Transact-SQL

  • Accessing a Database Server with Client Tools and Transact-SQL
  • Connecting to ASE

Data Analysis

  • Executing Queries with Select Statements
  • Writing Qualified Queries
  • Organizing the Result Set into Groups
  • Querying Data from Multiple Tables Using Joins
  • Running Queries Using Subqueries

Table Management

  • Creating Tables
  • Creating Temporary Tables
  • Querying System Tables

Data Modification

  • Listing Data Manipulation Language (DML) Statements
  • Adding Data to Tables
  • Updating Data in Tables
  • Combining Insert and Update Statements
  • Modifying Data in Tables
  • Describing the Transaction Log

Views and Indexes

  • Creating Views
  • Creating Indexes

Data Integrity

  • Explaining Data Integrity
  • Maintaining Data Integrity with Constraints
  • Managing Constraints
  • Creating Defaults and Rules to Maintain Data Integrity
  • Choosing a Data Integrity Method

Transact-SQL Functions

  • Manipulating Data Using Built-in Transact-SQL Functions
  • Creating User-Defined Functions

Variables

  • Explaining Batches
  • Applying Local and Global Variables
  • Describing the Dynamic Execution of SQL Using Variables

Control-of-Flow Statements and Messages

  • Creating Control-of-Flow Statements
  • Managing Message Statements

Transactions and Data Consistency

  • Executing Transactions
  • Examining Transaction Modes
  • Processing Transaction Errors
  • Describing the Implementation of Data Locking Methods
  • Implementing Locking Schemes and Isolation Levels

Cursors

  • Inserting Data Using a Cursor
  • Modifying Data with Cursors

Stored Procedures

  • Describing Stored Procedures
  • Creating Stored Procedures Using Parameters
  • Applying Best Practices to Stored Procedures

Triggers

  • Describing Triggers
  • Creating Triggers to Complete Cascaded Updates
  • Applying Relevant Rollback to Triggers
  • Applying Best Practices and Data Integrity with Triggers
For an onsite course please contact us