Training Schedule Training Schedule

(ED116e) Fast Track to SAP Adaptive Server Enterprise (eLearning)
Code: ED116e v15
Type: null
Tuition (USD): $936
Length: 182 Days
Have a question?

Contact Us

character(s) remaining

Location Date Guaranteed to Run
eLearning, US 03/25/2019
eLearning, US 03/26/2019
eLearning, US 03/27/2019
eLearning, US 03/28/2019
eLearning, US 04/01/2019
eLearning, US 04/02/2019
eLearning, US 04/03/2019
eLearning, US 04/04/2019
eLearning, US 04/05/2019
eLearning, US 04/06/2019
eLearning, US 04/07/2019
eLearning, US 04/08/2019
eLearning, US 04/09/2019
eLearning, US 04/10/2019
eLearning, US 04/11/2019
eLearning, US 04/12/2019
eLearning, US 04/13/2019
eLearning, US 04/14/2019

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

Skills Gained:
1) Use the basic components of ASE to connect to a server database 2) Create tables, populate the tables with data, and efficiently query data from those tables 3) Write code in Transact-SQL 4) Use and manage transactions effectively 5) 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:
  • 1) Adaptive Server Enterprise
  • a) Describing Client/Server Architecture and Relational Database Concepts
  • b) Explaining SAP Adaptive Server Enterprise (ASE) Management of Relational Databases
  • 2) Client Tools and Transact-SQL
  • a) Accessing a Database Server with Client Tools and Transact-SQL
  • b) Connecting to ASE
  • 3) Data Analysis
  • a) Executing Queries with Select Statements
  • b) Writing Qualified Queries
  • c) Organizing the Result Set into Groups
  • d) Querying Data from Multiple Tables Using Joins
  • e) Running Queries Using Subqueries
  • 4) Table Management
  • a) Creating Tables
  • b) Creating Temporary Tables
  • c) Querying System Tables
  • 5) Data Modification
  • a) Listing Data Manipulation Language (DML) Statements
  • b) Adding Data to Tables
  • c) Updating Data in Tables
  • d) Combining Insert and Update Statements
  • e) Modifying Data in Tables
  • f) Describing the Transaction Log
  • 6) Views and Indexes
  • a) Creating Views
  • b) Creating Indexes
  • 7) Data Integrity
  • a) Explaining Data Integrity
  • b) Maintaining Data Integrity with Constraints
  • c) Managing Constraints
  • d) Creating Defaults and Rules to Maintain Data Integrity
  • e) Choosing a Data Integrity Method
  • 8) Transact-SQL Functions
  • a) Manipulating Data Using Built-in Transact-SQL Functions
  • b) Creating User-Defined Functions
  • 9) Variables
  • a) Explaining Batches
  • b) Applying Local and Global Variables
  • c) Describing the Dynamic Execution of SQL Using Variables
  • 10) Control-of-Flow Statements and Messages
  • a) Creating Control-of-Flow Statements
  • b) Managing Message Statements
  • 11) Transactions and Data Consistency
  • a) Executing Transactions
  • b) Examining Transaction Modes
  • c) Processing Transaction Errors
  • d) Describing the Implementation of Data Locking Methods
  • e) Implementing Locking Schemes and Isolation Levels
  • 12) Cursors
  • a) Inserting Data Using a Cursor
  • b) Modifying Data with Cursors
  • 13) Stored Procedures
  • a) Describing Stored Procedures
  • b) Creating Stored Procedures Using Parameters
  • c) Applying Best Practices to Stored Procedures
  • 14) Triggers
  • a) Describing Triggers
  • b) Creating Triggers to Complete Cascaded Updates
  • c) Applying Relevant Rollback to Triggers
  • d) 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 Info:
Courses based on software release: ASE16 with client apps installed
Course Length: 1200 minutes

Course notes and announcements:

1) The course material is available in English only

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

3) This course is free with the purchase of the SAP Learning HUB Professional Edition Subscription

E-Learning (single course access)

In order for your company to get the most from its SAP investment, your executives need to understand the full potential of your solution - and your users need the right skills to accomplish their daily tasks. That's why SAP Education offers a growing catalog of e-learning offerings - highly interactive, Web-based courses that enable you to deliver the timely, focused training your organization demands.

SAP Education's e-learning courses complement our tried-and-tested classroom-based training, allowing users to improve or maintain their skills by building online learning into their schedules. Your people have the flexibility to determine what, where, and when to learn. They can repeat learning units as often as required and control the duration of learning sessions. Each E-Learning course is available for six months. And your organization can realize significant benefits in reduced travel - and the resulting time and cost savings.

E-learning courses include highly effective instructional elements and simulations based on authentic situations. By completing these courses, users gain a solid understanding of how to navigate SAP solutions and how SAP solutions can support their role-specific business processes and individual objectives - as well as your overall corporate strategy.

Our eLearning curriculum meets your needs. SAP's e-learning curriculum caters to a wide range of learning styles and subject-matter requirements. Experienced consultants, project team members, support professionals, end users, power users, and executives will find courseware to meet their needs. In addition, individuals can get the training they need without the cost of travel or time out of the office. All courses are based on real-world business scenarios and the latest learning methodologies and technological standards to provide an e-learning environment that will enable users to work more productively with the SAP solutions related to their business functions.

All SAP Online Knowledge Products and SAP eLearning and Learning Hub sessions are non-refundable.