Training Schedule Training Schedule

(EDB116) Fast Track to Adaptive Server Enterprise
Code: EDB116 v15
Type: null
Tuition (USD): $3750
Length: 5 Days
Have a question?

Contact Us

character(s) remaining

Location Date Guaranteed to Run
Newtown Square, PA 10/28/2019

Not finding any suitable dates? Contact us for additional availability: training@dunnsolutions.com

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 Should Attend?
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
What You Will Learn:
  • 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
Course Info:
Course based on software release: ASE16 with client apps installed


Course notes and announcements:

1) 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.

2) This course is an entry point for ASE Administration and ASE Development curricula

This is a SAP CERTIFIED Course. Your course will include Full Class Delivery of the comprehensive standard SAP curriculum agendas, SAP Certified Instructor, Demonstration and Presentation, Student Hands on exercises, Access to SAP Hosted servers/training environment, SAP Certified e-book participant guides and SAP Certified Hard copy participant guides.

This 5 day instructor led course qualifies for 40 CPE Credits. CPE Credits are currently available only for publicly scheduled courses delivered live at SAP locations and our Authorized Education Partner locations. CPE Credits are not available for virtual live classroom sessions.

With virtual live classroom training you get comprehensive training from SAP experts using seamless over-the Web connectivity. The same content delivered in SAP's traditional "brick and mortar" classrooms is presented during virtual live classroom deliveries. As in SAP's traditional classrooms, SAP virtual live classroom stresses hands-on learning providing each registered student with exclusive access to live SAP systems throughout each course. Each Virtual Live class is taught by a SAP Certified Instructor and will include an e-book student guide for you to download and keep. CPE Credits are currently available only for publicly scheduled courses delivered live at SAP locations and our Authorized Education Partner locations. CPE Credits are not available for virtual live classroom sessions.