SAP ASE 16 / Sybase ASE - Installation and Configuration
4.7 (5 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
1,038 students enrolled
Wishlisted Wishlist

Please confirm that you want to add SAP ASE 16 / Sybase ASE - Installation and Configuration to your Wishlist.

Add to Wishlist

SAP ASE 16 / Sybase ASE - Installation and Configuration

How to install and perform initial configuration of SAP ASE / Sybase on Linux. Step by step tutorial with quizes and lab
4.7 (5 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
1,038 students enrolled
Created by Rafał Kraik
Last updated 6/2017
English
Current price: $10 Original price: $60 Discount: 83% off
5 hours left at this price!
30-Day Money-Back Guarantee
Includes:
  • 2.5 hours on-demand video
  • 26 Articles
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • How to prepare virtual machine for the course
  • How to install Linux on it
  • How to configure Linux for SAP ASE installation
  • How to install SAP ASE
  • How to validate the installation
  • How the start-up procedure works
  • How to start/stop ASE, how to configure it to automatic start/stop
  • What environmental variables are used by ASE
  • Which files are the most important, what kind of information they contain and how and when it is used
  • How to configure ASE to listen on external network interfaces
  • How to troubleshoot some common problems with installation or configuration
  • How to install Interactive SQL on Windows
  • How to work with sp_configure and how to work with configuration files
View Curriculum
Requirements
  • Advanced Windows user
  • Some basic experience in Linux (course explains the Linux stuff in detail, but some prior knowledge is a bonus)
  • Basic understanding of how services work
  • Basic understanding of database terminology
Description

SAP Adaptive Server Enterprise (formerly known as Sybase ASE) is a relational database management system used by companies where high performance and stability counts. 

There is not many good educational materials available teaching how to administer this database type, specially on Linux environment. That is why this course has been created. Specially difficult is the installation part, as a lot of manual pre-installtion and post-installation steps need to be done to have the environment ready to use. All those steps are covered in this course.

If you want to be a SAP ASE professional database administrator join the course and learn step by step:

  • How to prepare virtual machine for the course
  • How to install Linux on it
  • How to configure Linux for SAP ASE installation
  • How to install SAP ASE
  • How to validate the installation
  • How the start-up procedure works
  • How to start/stop ASE, how to configure it to automatic start/stop
  • What environmental variables are used by ASE
  • Which files are the most important, what kind of information they contain and how and when it is used
  • How to configure ASE to listen on external network interfaces
  • How to troubleshoot some common problems with installation or configuration
  • How to install Interactive SQL on Windows
  • How to work with sp_configure and how to work with configuration files

After completing the course you will be able to install and configure SAP Adaptive Server Enterprise and troubleshoot the installation and configuration issues by yourself.

For active participation in the course you will need:

  • Windows computer with virtual machine, where Linux will be installed, or just Linux machine - Fedora 23 is used in the course. Fedora can be downloaded from Internet repositories.
  • SAP Adaptive Server installation package for Linux and Windows - it can be downloaded from vendor site after registration.

Course helps  in preparation towards certification exam C_SASEAA157 SAP Certified Technology Associate - Database Administrator for SAP Sybase ASE 15.7

Join our course and become the professional SAP Adaptive Server Enterprise administrator!

Who is the target audience?
  • Administrators of other database types like Oracle, MSSQL, MySQL and others
  • Beginners in the area of SAP Adaptive Server Enterprise / Sybase ASE
  • Linux and Windows administrators specializing in applications
  • Developers, who want to understand, how the databases internally work
Students Who Viewed This Course Also Viewed
Curriculum For This Course
52 Lectures
02:43:45
+
Introduction
3 Lectures 05:49

Word from the author:

  • Why to learn SAP ASE / Sybase?
  • How to learn?
  • Why should you choose this course?
Preview 02:08

Welcome on the course! Here you can find some tips how to work with the course. I know it is not an easy task. Try to plan your study, watch the video, solve the quiz, try to do some exercises. And remember - not the tempo is important, but the quality!

Preview 03:16

Here you can find all the packages that will help you to actively participate in the course!

Preview 00:25
+
Preparation to study
4 Lectures 16:41

This lesson shows how to configure Hyper-V on Windows machine, to have it ready for Linux Fedora installation. Hyper-V is available only on the higher editions of Windows, so if you have Windows Home edition see the another video about VMPlayer installation and configuration

Configuring Virtual Machine on Hyper-V - VIDEO
08:36

Test your knowledge!

Configuring Virtual Machine on Hyper-V - QUIZ
3 questions

Do some exercises!

Configuring Virtual Machine on Hyper-V - LAB
00:04

In this lesson you will see how to install VMPlayer and use it as a virtual environment in the scope of that course. This lesson is not mandatory. It should help you to get familiar with VMPlayer if you don't have Hyper-V

Configuring a Virtual Machine on VMPlayer - VIDEO
07:56

Test your knowledge!

Configuring a Virtual Machine on VMPlayer - QUIZ
3 questions

Do some excercises!

Configuring a Virtual Machine on VMPlayer - LAB
00:05
+
Linux Fedora Installation
4 Lectures 15:59

In this lesson you will see how to install Linux Fedora. The most important points here are the disk configuration and the network configuration. If you are using Hyper-V, this video covers all you need. If you have installed VMPlayer, than the network configuration differs slightly. No worries - this part of network configuration is included in Video telling about VMPlayer installation and configuration.

Linux Fedora Installation - VIDEO
08:29

Test your knowledge!

Linux Fedora Installation - QUIZ
3 questions

Do some exercises!

Linux Fedora Installation - LAB
00:05

Sometimes we need to copy some files from Windows host to Linux machin and vice versa. This lesson shows how integrate Windows and Linux. Of course such integration can be condigured in many different ways, so choose the best from your point of view.

Integrating Linux with Windows host - VIDEO
07:20

Test your knowledge!

Integrating Linux with Windows host - QUIZ
3 questions

Do some exercises!

Integrating Linux with Windows host - LAB
00:05
+
Sybase prerequisits - pre configuration
8 Lectures 23:21

Software like Sybase 16 may have some problems of compatibility nature. In such a case you need first to perform some initial configuration and disable components causing problems. Here you will see, how to disable the IPv6 protocol on Linux

Disabling IPv6 - VIDEO
04:51

Test your knowledge!

Disabling IPv6 - QUIZ
3 questions

Do some excercises!

Disabling IPv6 - LAB
00:08

In this lesson you will learn which additional packages are required for successful installation of SAP Sybase on Linux. You will get familiar with package manager dnf.

Prerequisites - installing required packages - VIDEO
05:50

Test your knowledge!

Prerequisites - installing required packages - QUIZ
3 questions

Do some exercises!

Prerequisites - installing required packages - LAB
00:05

In this lesson you can learn how to create a user account for the Sybase database engine installation. You will add a user account, define a password and add the user to sudoers file.

Creating user accout for SAP Sybase ASE installation - VIDEO
03:03

Test your knowledge!

Creating user accout for SAP Sybase ASE installation - QUIZ
3 questions

Do some exercises!

Creating user accout for SAP Sybase ASE installation - LAB
00:22

In this lesson some security related topics will be shown allowing to better understand how some works and how security on Linux works. You will see how to work with sudo, visudo, mount, umount, whoami, id. You will also see the content of passwd, groups, shadow and sudoers files.

Basic Linux Security Info - VIDEO
08:44

Test your knowledge!

Basic Linux Security Info - QUIZ
3 questions

Do some excercises!

Basic Linux Security Info - LAB
00:17
+
SAP Sybase ASE Installation
4 Lectures 15:23

In this llesson you will see how to install Sybase ASE step by step, screen by screeen

Installing SAP Adaptive Server Enterprise - VIDEO
10:30

Test your knowledge!

Installing SAP Adaptive Server Enterprise - QUIZ
3 questions

Do some excercises!

Installing SAP Adaptive Server Enterprise - LAB
00:07

In this lesson you will see, how to configure the session of a unix user, who want to work with isql command. You will learn also how to test if the server is running or not.

Testing Sybase Installation - VIDEO
04:23

Test your knowledge!

Testing Sybase Installation - QUIZ
3 questions

Do some excercises!

Testing Sybase Installation - LAB
00:23
+
Adaptive Server start and stop procedures
6 Lectures 17:42

This lesson presents how to start and stop Sybase server process.It will be also discussed, how the Sybase start script (RUN FILE) is built.

Preview 07:23

Test your knowledge!

Starting Sybase Servers - QUIZ
3 questions


This lesson presents information about how to stop the dataserver and the backupserver. After finishing the module you will understand the difference between shutdown and shutdown with nowait option.

Stopping Sybase Servers -VIDEO
04:25

Test your knowledge!

Stopping Sybase Servers - QUIZ
3 questions

Do some excercises!

Stopping Sybase Servers - LAB
00:11

In this lesson you will learn about interfaces file, its syntax and how it is used by client applications and by the server during the booting procedure.

Interfaces file -VIDEO
05:14

Test your knowledge!

Interfaces file -QUIZ
3 questions

Do some exercises!

Interfaces file - LAB
00:12
+
Becoming Familiar with the SAP Sybase ASE Installation
10 Lectures 27:57

For a dba it is important to know the location of some critical files and folders. You need to know where the logs can be found, where the programs are located, where the configuration files are hold and  so on. This type of information is covered by this lesson.

Important Files and Directories in Sybase Installation - VIDEO
05:53

Test your knowledge!

Important Files and Directories in Sybase Installation - QUIZ
3 questions

Do some excercises!

Important Files and Directories in Sybase Installation - LAB
00:16

In this lesson you can learn how to define environmental variables and what are the most important Sybase variables. You will also see how to modify sap user's profile to automatically load all the required by Sybase client tools variables.

Sybase Environmental Variables - VIDEO
06:20

Test your knowledge!

Sybase Environmental Variables - QUIZ
3 questions

Do some excercises!

Sybase Environmental Variables - LAB
00:12

In this lesson you will find some basic and introductory information about the sybase configuration files: where to find them, what is the content of them, when copies of the config file are created.

Configuration files - VIDEO
03:05

Test your knowledge!

Configuration files - QUIZ
3 questions

Do some excercises!

Configuration files - LAB
00:10

This lesson concentrates on the error log of Sybase server. .You will see where the error log is saved, how to work with error log and you will take look into the error log, So that you will be aware of what kind of information is saved in the errorlog.

Sybase Error Log - VIDEO
07:29

Test your knowledge!

Sybase Error Log - QUIZ
3 questions

Do some exercises

Sybase Error Log - LAB
00:13

In this lesson you will learn how to install the Open Client and Interactive SQL on Windows. You will also see the fundamental info about how to use Interactive SQL

Open Client and Interactive SQL Installation - VIDEO
04:09

Test your knowledge!

Open Client and Interactive SQL Installation - QUIZ
3 questions

Do some exercises!

Open Client and Interactive SQL Installation - LAB
00:09
+
Configuring Sybase ASE on Operating System Level
6 Lectures 27:30

In this lesson you will analyze the script used to start and stop Sybase. You will also learn how to use the script.

Script to start and stop Sybase - VIDEO
09:56

Check your knowledge!

Script to start and stop Sybase - QUIZ
3 questions

Do some excercises!

Script to start and stop Sybase - LAB
01:42

Here you will learn how to configure Sybase service to start automatically when operating system boots. Exact steps of how to define a new service will be shown, as well as the entire configuration with tests.

Configuring Sybase ASE for Autostart - VIDEO
08:16

Test your knowledge!

Configuring Sybase ASE for Autostart - QUIZ
3 questions

Do some exercises!

Configuring Sybase ASE for Autostart - LAB
00:03

This lesson is dedicated to configuration of Sybase to listen incoming requests on external network requests. You will get familiar with configuration of firewall on Linux and with pure-Sybase configuration. You will work with sp_listener procedure

Preview 07:23

Test your knowledge!

Configuring Sybase to listen on external network interface - QUIZ
3 questions

+
SAP Sybase ASE configuration
6 Lectures 13:19

This lesson presents configuration parameters of SAP Sybase server. You will learn how the dataserver process knows which parameters should be loaded and where the parameters file can be found. Next you will learn about how to display the current parameters values and how to get help about them.

Configuration Parameters of SAP - VIDEO
05:21

Test your knowledge!

Configuration Parameters of SAP - QUIZ
3 questions

Do some excercises!

Configuration Parameters of SAP - LAB
00:11

In this lesson you will learn how to change the configuration parameter.

Changing configuration parameters - VIDEO
03:03

Test your knowledge!

Changing configuration parameters - QUIZ
3 questions

Do some excercises!

Changing configuration parameters - LAB
00:12

This lesson shows how to replace the entire set of configuration options at once and not one by one. 

Operation on Configuration Files -VIDEO
04:25

Do some excercises!

Operation on Configuration Files -LAB
00:06

Test your knowledge!

Operation on Configuration Files -QUIZ
3 questions
+
What next?
1 Lecture 00:25

Congratulations on completing the course. Now print your certificate!

What next?
00:25
About the Instructor
Rafał Kraik
4.5 Average rating
113 Reviews
1,685 Students
6 Courses
Microsoft Certified Trainer

EN

Rafał Kraik - Microsoft Certified Trainer. Programmer, database administrator, trainer and consultant. The  main areas of interest are database administration and design, automation with PowerShell and Bash, analysis and presentation of data.

Experienced e-learning and distance learning tutor.

Worked with, or teached for such companies as ING, Intel, Cadbury, Bank PeKaO, Volvo, UPC, ZUS, Polish Post and many more...

PL

Rafał Kraik - Microsoft Certified Trainer. Programista, administrator baz danych, trener i konsultant. Główne specjalności to administracja i programowanie baz danych, automatyzacja z wykorzystaniem PowerShell, Bash oraz analiza i prezentacja danych.

Doświadczony trener szkoleń e-learning.

Pracował/pracuje/prowadził szkolenia dla takich firm i instytucji jak ING, Intel, Cadbury, Bank PeKaO, Volvo, UPC, ZUS, Poczta Polska i wiele innych...