Course Code

sapase
 

     Duration

28 Hours
 
 

     Requirements

  • An understanding of database concepts
  • Experience with the Linux command line

Audience

  • Database Administrators (DBA)
 

     Overview

SAP ASE (SAP Adaptive Server Enterprise), previously known as Sybase SQL Server, Sybase DB and Sybase ASE is a relational database for businesses.

In this instructor-led, live training, participants will learn the fundamentals of SAP ASE (SAP Adaptive Server Enterprise) Database Administration as they step through the creation and deployment of a sample SAP ASE Database System.

By the end of this training, participants will be able to:

  • Install and configure SAP ASE for data storage as well as transactional operations.
  • Understand and use SAP ASE components, tools, and utilities.
  • Integrate SAP ASE with non-SAP ASE applications.

Format of the Course

  • Interactive lecture and discussion.
  • Lots of exercises and practice.
  • Hands-on implementation in a live-lab environment.

Course Customization Options

  • To request a customized training for this course, please contact us to arrange.
 

     Course Outline

Introduction

  • Understanding the differences among SAP ASE, SAP Sybase ASE and Sybase SQL Server
  • Host vs Client/Server Systems

Overview of SAP ASE Architecture

SAP ASE SQL Fundamentals

Useful Linux/Unix Commands, Techniques and Tools

Installing and Configuring SAP ASE

Connecting SAP ASE with other Servers and Services

Creating an SAP ASE Database

Working with SAP ASE OS Files

Querying Data in SAP ASE

Transaction Management in SAP ASE

Integrating SAP ASE with non-SAP ASE applications

Configuring SAP ASE Memory for Optimal Performance

Administering System Roles and Logins

SAP ASE Security Management

SAP ASE Backup and Recovery

SAP ASE Space Management

Data Replication with SAP ASE

Managing Database Consistency

Object Resource Management

SAP ASE System Management Tools and Servers

Troubleshooting SAP ASE

Summary and Conclusion

 

     Feedback (48)

I liked the examples and the way he explained.

Sandeep Parashar


The explanation way and including tips on the best practices in VBA/Access, encouraging via exercise to think more by ourselves on how to solve the problem rather than giving ready solutions.

Daria Rudin


Tamil was exceptionally patient and very helpful in figuring out solutions to real needs. He was also very honest about if he didn't know something from the top of his head, which enabled us to quickly jump on in the training and we didn't lose time.

Christine Weiler


I really liked the monitoring.

Ling Xiao


Very high competence of the trainer!!.

Heino Eilers


I mostly liked the good content and exercises.

Richard Smallwood


I generally was benefit from the open mind and communication.

Oleksiy Deliyev


I genuinely enjoyed the trainer Subject Knowledge.

Julian Pirau


Trainer provided some topic and support it with plenty of exercises. We had a chance to apply knowledge by doing them on our own.

UBS Business Solutions Poland Sp. z o.o.


I enjoyed the access to trainers individual support in resolving exercises.

Tomasz Czornak


I enjoyed learning how to maintain the database, and how is the orgenazition of the data.

Jiang Chang


Trainer had good practical knowledge about using Cassandra day-to-day at least for development purposes. Catering (snacks, coffee hour) were great 3 days length was good.

Mika Linnanoja


Good atmosphere during the training.

clovis Nebouet


I liked the super atmosphere, working with Congo shell.

Jan Sturm


Training material was very informative. Learned a lot.

Yaw Asamoah


I really enjoyed the lessons and examples.

Kelly Taylor


He adapted to the experience of the group, gave us great value for a beginners course.

Rich Mickey


The structure and pace of the class was great.

David Lacy


The depth of the Congo db training was explored from basic to advanced, I felt it was a little too much to squeeze into 2 days but I did get exposure to all aspects of Congo db.

Bay Sayarath


I liked that the course was relevant to our need.

Damon Grube


Most of the hands-on stuff was good.

Andrew Bauer


I genuinely liked that there was no pressure.

Eyal Wirsansky


I liked everything he taught.

Emily Zhou


I appreciated Folio's wide breadth of knowledge. Not only was he familiar with the course content, but he also knew of constructs in languages we were familiar with to make examples more meaningful to us. During intervals he shared his knowledge of technologies and solutions outside the training scope to provide insights into other solutions we could use in future (and future training).

Raphael Keymer - Markit Valuations Limited


Enjoyed the pace, delivery and technical know how of the trainer.

Junaid Kalang


Very in depth knowledge on the subject matter. No “I'll have to look into that and get back to you, just new it all”.

David Marshall


The trainer, he was knowledgeable, engaging, and easy to learn from. He encouraged a lot of hands-on learning.

Shawn McAndrew


I like fact, that after each section we had exercises. It helps to remember discussed topic.

Adam Bińczycki


I learned a LOOOOOT.

Kamil Szmid


Topics approached. Very complete.

Carlos Eloi Barros


The last exercise was very good.

José Monteiro


I already using and have an application in production with Cassandra so mostly of the topics i already know but the data modeling and advanced topics are a lot interesting.

Tiago Costa


There was a lot of knowledge and material shared that will help me to do my current tasks.

Miguel Fernandes


I liked the amount of exercises. We could immediately apply the knowledge shared and ensure the information was on point.

Joana Pereira


I liked all technical explanation and theoretical introduction.

André Santos


I enjoyed the very good explanations with in depth examples.

Rui Magalhaes


The practical exercises and examples of implementing examples of real models and contexts.

Leandro Gomes


I liked that the course was tailored to cover our organizations questions.

Robin Bell


The clear depth of knowledge the trainer had, which really shone when combined with his evident enthusiasm for the subject.

Joseph Brailsford


Even though I have been using MongoDB for a while, there were still some new “basic” things that Tamil taught us - as well as teaching us the advanced topics we need to move our projects forwards.

Adam McKay


I enjoyed the attention to detail, knowledge and enthusiasm for the subject.

Bristol City Council


The 1:1 style meant the training was tailored to my individual needs.

Andy McGuigan


The ability to ask questions at any time and the more informal / less structured style. This allowed us to pursue the areas of knowledge we were most interested in.

Jim Lane


I genuinely liked the explanations.

Lowe's


I genuinely was benefit from the training knowledge and mechanic.

Sutiipong Bumlungvech


Adrian was knowledgeable in Linux and MongoDB. He was able to troubleshoot the labs on our computers very quickly when we had mistakes.

MInistry of Defence


I enjoyed the backup and restore and multiple instances.

Lakshmi Ponnada - Albany Medical Center


Gives a good overview of Cassandra. Especially the virtual box training environment is nice also for later use.

Swisscom AG


The course could be tailored to suit your needs and objectives. It can also be delivered on your premises if preferred.


  
  
  


  

Online Price per participant 6000 AED

  

Classroom Price per participant 6000 AED

Starts

 

Ends

 

  Workday courses take place between 9:30 and 16:30

Location


  Show venue details


Number of Participants






Related Courses

Total Courses 12


Angular with Firebase and Firestore

  14 hours

Firebase Fundamentals

  14 hours

Serverless Cloud Based Mobile and Web Development with Firebase

  28 hours

 

ClickHouse Fundamentals

  14 hours

 
Change Data Capture (CDC)

Change Data Capture (CDC)

What is Change Data Capture (CDC)?

Change Data Capture (CDC) with Debezium

  14 hours

Hasura GraphQL Engine

  14 hours

Distributed Data Processing and Storage with Hazelcast

  14 hours

Mastering LINQ with C#

  14 hours

 

Migrating Oracle to Azure SQL or PostgreSQL

  7 hours

 

MongoDB Atlas Fundamentals

  14 hours

Presto for Data Science

  14 hours

 

Monitoring Kubernetes with Prometheus

  7 hours

Prometheus Fundamentals

  14 hours

Building Interactive Applications with React, Redux and GraphQL

  28 hours

SQLite Fundamentals

  14 hours



Discounted Public Courses



This site in other countries/regions