Sybase

About Sybase

Sybase offers highly featured enterprise software solutions with the use of relational database, mobile application development platforms and much more. Sybase is the industry leading business process/ data modelling software, information architecture, data enterprise architecture management solution and so on. Sybase is known as a database servers and it deal with Microsoft to share the source code for the Microsoft to re-market on the operating system platform as SQL Server.
Upon completion of this course, you will be able to Discuss trade offs involved in performance tuning
• Use sp_sysmon and other utilities to tune the server for performance gains
• Properly configure memory for optimal performance
• Manage multiple engines
• Configure, tune, and size data, procedure, and partitioned caches
• Identify and correct problems in database physical design, including table partitions
• Use statistics to manage space on DOL tables and indexes
• Choose the appropriate table locking scheme for a given application
• Configure Adaptive Server dynamically
• Improve performance of tempdb by sizing, placement, and solving locking

 

Who should take this Sybase Course ?

Students and job seekers who are willing to build their career in Databases
Basic knowledge of Database management system
Professional DBA can attend Sybase Database training.

 

What are the prerequisites for taking this Sybase Course?

Basic knowledge of SAP Business Suite and basis technologies
Basic knowledge of SAP Netweaver
Experienced Application Developers using .Net C#, Objective C, or Java
PowerBuilder Developers who want to begin developing robust Mobile Application on proven technology

 

Certifications:

Sybase ASE 15 Administrator Associate Certification (exam code C_SASEAA_15 (previously 510-025))
Sybase ASE 15 SQL Developer Professional (exam code C_SASEDP_15 (previously 510-026))
Sybase IQ Administrator 15.2 Professional (exam code C_SIQAP_152 (previously 510-702))
Sybase Replication Server 15.0.1 Administrator Professional (exam code C_SRSAP_15 (previously 510-410))

 

Sybase Course Outline

Sybase Developer

Introduction

  • DB Concepts
  • Transact – Structured Query Language (T-SQL)
  • Data Definition Language
  • Data Manipulation Language
  • Data Control Language
  • Identifiers
  • T-SQL Extensions

Data Definition Language (DDL)

  • CREATE
  • ALTER
  • DROP
  • SQL Constraints
  • Primary key
  • Foreign key
  • Unique
  • Not null
  • Check
  • Default
  • identity
  • Data types
  • Implicit conversions
  • Explicit conversions

Data Manipulation Language

  • Selecting data from table
  • Eliminating duplicates
  • Operators used
  • Comparison operators
  • Ranges
  • Lists
  • Where clause
  • Matching patterns
  • Aggregate functions
  • Organizing query results into groups
  • group by clause
  • having clause
  • null values and group by
  • aggregates with and without group by
  • Sorting query results
  • order by clause
  • Summarizing group of data (compute clause)
  • Combining queries
  • Union operator

Joins and Sub-queries

  • Joins
  • How joins works
  • How joins are processed
  • Types of Joins
  • Equi-joins and natural joins
  • Self joins
  • Inner and Outer joins
  • Inner joins
  • Left outer joins
  • Right outer joins
  • How null values affect joins
  • Which columns to join
  • Sub-queries
  • How sub-queries works
  • Restrictions
  • Sub-queries in update/insert/delete statement
  • Types of sub-queries
  • Correlated sub-queries

SQL Derived tables and views

  • What is a derived table
  • How SQL derived table works
  • Partitions
  • Views
  • How view works
  • Creating views
  • Retrieve and modify data through views
  • Dropping views

Indexes

  • How indexes works
  • Types of indexes
  • Clustered index
  • Non-clustered index
  • Differences
  • Creating indexes
  • Using clustered and non-clustered indexes
  • Index options
  • Defaults
  • Rules

Stored Procedures, Cursors and Triggers

  • Control flow Language
  • Local and Global variables
  • How SP works
  • Create and execute procedures
  • Return values from SP
  • System Stored procedures
  • Cursors
  • Triggers
  • Using triggers to maintain referential integrity

Transactions

  • How transaction works
  • Consistency
  • Recovery
  • Transactions and its usage
  • Transactions mode
  • Using transaction with SP, cursors

 

Sybase Training Reviews

Online Training Reviews given by our students already completed the training with us. Please give your feedback as well if you are a student.