Live Panel Discussion - Leveraging Red Hat OpenShift for a Multi-Cloud Strategy

closeClose

Fast Track to SAP Adaptive Server Enterprise

Course Details
Code: EDB116-v015
Tuition (USD): $3,750.00 • Virtual (5 days)
$3,750.00 • Classroom (5 days)
Course Details
GSA (USD): $3,037.78 • Virtual (5 days)
$3,037.78 • Classroom (5 days)

Skills Gained

  • 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

Who Can Benefit

  • 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 Details

Course 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

Notes

  • The course material is available in English only
  • This course is an entry point for ASE Administration and ASE Development curricula

Course based on software release

  • ASE16 with client apps installed