Course announcements

  • Gain hands-on experience with the newest features of Adaptive Server Enterprise (ASE) through 16.0 and learn to create database objects expertly using ANSI-standard SQL and Transact-SQL extensions.

Goals

  • 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

Audience

  • Data Consultant / Manager
  • System Architect
  • Technology Consultant

Prerequisites

Essential

  • Basic understanding of network connectivity architecture
  • Knowledge of general Unix commands

Recommended

  • Fundamental understanding of databases and SQL language

Course based on software release

  • ASE16 with client apps installed

Content

  • 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