Sybase Advanced Programming Training

Sybase Advanced Programming Online Training

Stored procedure basics

  • Pros and Cons
  • Creating Stored Procedures
  • Three ways to execute
  • System Stored Procedures

Parameters and returned values

  • Passing parameters
  • Default Values/ WHERE clauses
  • Output parameters
  • Using RETURN

Testing Conditions and looping

  • IF/ELSE statements
  • Using CASE where possible
  • Syntax of WHILE
  • Breaking out of a loop

Basic Transactions, Deleting and Updating

  • Beginning a transaction
  • Committing/ rolling back
  • Using DELETE and UPDATE
  • Sys Objects
  • Dropping Objects

Temporary tables and table variables

  • Using temporary tables
  • Creating table variables
  • Pros and Cons of each approach

Fundamentals of Query Processing

  • Query Processing Steps
  • Possible Bottlenecks
  • Define the Basic Steps in Query Processing

Union Queries

  • Features and Restrictions
  • Show plan output for UNION
  • Union optimization

Multi-Table Queries

  • Join processing
  • Optimization
  • Nested Iteration
  • Reformatting and Device performance
  • Breaking up large queries
  • Self and Outer Joins
  • Multi table joins

Single Table Optimization

  • Search methods
  • Table scan optimization
  • Index selection
  • Optimizer selection criteria
  • Using Indexes
  • Clustered and Non Clustered Indexes

Stored Procedure

  • Coding standards & Conventions
  • Optimization and Error Handling
  • Recompiling
  • Temp Table Performance
  • Return Status and Parameter Techniques

Views and Cursors

  • Uses of Views
  • Group by views
  • Views with check option
  • Nested cursors
  • Multi level cursors
  • Performance issues

Query Troubleshooting Tools and Approaches

  • Show plan
  • Statistics I/O and Time

SQL Statement Processing

  • General Optimization Steps
  • Using select distinct
  • Sum, Where, Order by and Having
  • Understanding Worktables and Groups

Datatype Conventions and Conflicts

  • Adaptive Server Data types and Conversions
  • Datatype Error handling
  • Deadlocks
  • Analyze data
  • Deadlock Avoidance
  • Deadlock Phases and Output

Join Processing

  • Breaking up large queries
  • Join optimization
  • Join order
  • Overriding the optimizer
  • Sybase Advanced Programming Online Training

Send Enquiry

Your Name (required)

Your Email (required)

Your Phone No. (required)

Subject

Your Message