Flash Sale: Save 15% on IT Training

closeClose

Fast Track to SAP Adaptive Server Enterprise

  • Tuition USD $4,090 GSA  $3,037.78
  • Reviews star_rate star_rate star_rate star_rate star_half 1453 Ratings
  • Course Code EDB116-v015
  • Duration 5 days
  • Available Formats Virtual, Classroom

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

When does class start/end?

Classes begin promptly at 9:00 am, and typically end at 5:00 pm.

Does the course schedule include a Lunchbreak?

Lunch is normally an hour long and begins at noon. Coffee, tea, hot chocolate and juice are available all day in the kitchen. Fruit, muffins and bagels are served each morning. There are numerous restaurants near each of our centers, and some popular ones are indicated on the Area Map in the Student Welcome Handbooks - these can be picked up in the lobby or requested from one of our ExitCertified staff.

How can someone reach me during class?

If someone should need to contact you while you are in class, please have them call the center telephone number and leave a message with the receptionist.

What languages are used to deliver training?

Most courses are conducted in English, unless otherwise specified. Some courses will have the word "FRENCH" marked in red beside the scheduled date(s) indicating the language of instruction.

What does GTR stand for?

GTR stands for Guaranteed to Run; if you see a course with this status, it means this event is confirmed to run. View our GTR page to see our full list of Guaranteed to Run courses.

Does ExitCertified deliver group training?

Yes, we provide training for groups, individuals and private on sites. View our group training page for more information.

Does ExitCertified deliver group training?

Yes, we provide training for groups, individuals, and private on sites. View our group training page for more information.

Learnt new things on AWS DEVOPS side from Tutor Ryan. Happy that he was able to assist on our questions.

Pretty concise course mainly covering AWS Redshift while briefly introducing practical use examples with other services for companies.

Facilities were very clean, coffee was nice to have, snack selection was refreshing

AZ-300 course experience was good . Eylem Uysal was very good, the best instructor and i had really good experience attending course and classes with Eylem.

Loved the training format, content and the exercises. Jemma is a great Instructor.

2 options available

undo
  • Jan 25, 2021 Jan 29, 2021 (5 days)
    Location
    Virtual
    Location Details
    Language
    English
    Time
    9:30 5:30 EST
    Enroll
    Enroll
  • Jul 12, 2021 Jul 16, 2021 (5 days)
    Location
    Virtual
    Location Details
    Language
    English
    Time
    9:30 5:30 EST
    Enroll
    Enroll
Contact Us 1-800-803-3948
Contact Us Live Chat
FAQ Get immediate answers to our most frequently asked qestions. View FAQs arrow_forward