Sybase ASE 2019 - The Complete Guide to Sybase
3.3 (23 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
86 students enrolled

Sybase ASE 2019 - The Complete Guide to Sybase

Step by step tutorial to help you learn Sybase ASE Administration
3.3 (23 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
86 students enrolled
Last updated 7/2019
English
English [Auto-generated]
Current price: $139.99 Original price: $199.99 Discount: 30% off
5 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 8.5 hours on-demand video
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
What you'll learn
  • Learn to install Sybase and Learn to validate the installation
  • Learn to troubleshoot some common problems with installation or configuration
  • Understand the variables are used by ASE
  • Learn to install Interactive SQL on Windows
Requirements
  • Basic understanding of Linux and Windows
  • A computer with internet
  • Basic RDBMS Concepts
Description

Sybase ASE is a relational database management system or RDBMS used for performance and stability. After completing the course you will be able to install and configure sybase and troubleshoot the installation and configuration issues by yourself. You will learn to install Sybase and Learn to validate the installation. In this course, Learn to start/stop ASE, Learn to configure it to automatic start/stop. Understand the variables are used by ASE.

Learn to configure sybase on external network interfaces

Learn to troubleshoot some common problems with installation or configuration

Learn to install Interactive SQL on Windows

Learn to work with configuration files


Who this course is for:
  • Linux and Windows administrators specializing in applications
  • Developers
  • Database professionals
Course content
Expand all 64 lectures 08:24:42
+ Transact SQL
9 lectures 01:09:58
Data Modification
07:12
Creating Tables with Primary Key
08:31
Creating Tables with Primary Key Continue
07:01
Assigning Foreign keys
08:24
Inserting Records Part 1
05:10
Inserting Records Part 2
12:23
Inserting Records Part 3
07:30
Inserting Records Part 4
05:39
+ Databases and Tables
6 lectures 42:39
Creating Database
07:28
Creating Database Continue
05:22
Altering Tables Part 1
08:00
Altering Tables Part 2
08:38
Altering Tables Part 3
07:05
Altering Tables Part 4
06:06
+ SQL Driven Tables
3 lectures 28:48
Creating Views
12:30
Creating and Altering DBSpace
08:16
Creating and Altering DBSpace Continue
08:02
+ Select Queries
10 lectures 01:13:35
Select Data from Tables
07:44
Select Data from Tables Continue
06:58
Selecting Data using Operators
05:56
Selecting Data using Operators Continue
10:07
Select with where Clause
07:11
Select with where Clause Continue
07:30
Like Clause in where
06:31
Like Clause in where Continue
04:36
More on Like Clause in where
05:47
Null Values in Select Queries
11:15
+ Sub Queries
9 lectures 01:17:19
Subqueries Restrictions
06:47
Corellation Names
09:24
Asterisks in Select
07:58
Delete and Insert
07:55
Types of Subqueries
05:58
Types of Subqueries Example
09:21
Subqueries with Any
10:38
Subqueries with Any Continue
07:04
Subqueries used with not Exists
12:14
+ Aggregates, Grouping and Sorting
10 lectures 01:13:59
Aggregates
07:28
Count Aggregate Functions
06:52
Aggregate Functions
07:13
Group By
07:02
Having with Group By
09:49
Having with Group By Continue
05:13
Compute with Aggregate
08:05
Compute with Aggregate Continue
05:32
Compute
08:59
Union
07:46
+ Joins
10 lectures 01:16:09
Joins Equi Join
06:23
Joins Equi Join Continue
08:13
Self Join
08:10
Self Join Continue
06:38
Outer Joins
10:31
Outer Joins Continue
06:07
ANSI Inner Join
06:30
ANSI Inner Join Continue
07:35
ANSI Outer Join
08:32
ANSI Outer Join Continue
07:30
+ Managing Data
6 lectures 01:00:08
Inserting Data
12:08
Insert Data with Null
11:47
IDENTITY Column
09:05
Not Materialized Column
06:42
Update Command
09:54
Delete Command
10:32