Choose your language:

France
Germany
Hong Kong
India
Ireland
Japan
Malaysia
Netherlands
New Zealand
Singapore
Sweden
United Kingdom
United States

Fast Track to Sybase

Course Code

RT741

Duration

3 Days

MySQL experience.
This course helps students make the transition from MySQL database to Sybase (SAP) Adaptive Server Enterprise (ASE). In a fast paced class, we cover the major aspects of programming, administration and performance in Sybase with comparisons with MySQL.
This course is designed for individuals who want to become Sybase programmers, DBAs or System Administrators.

Upon completion of this course, participants will be able to:

  • Understand differences between MySQL and Sybase ASE
  • Use Sybase and course tools
  • Determine how the optimizer chooses access methods
  • Write queries and Stored Procedures
  • Create Databases and Tables
  • Understand Sybase Security
  • Interpret optimizer statistics
  • Tune insert, update, and delete operations
  • Understand Transaction management and logging
  • Backup up databases and transaction logs
  • Use Database recovery and restoration
  • Generate faster, more efficient code
Overview of Sybase and MySQL
History - Timeline
MySQL Architecture
Multiple Engines
InnoDB
Sybase Architecture
Thread Mode
System Databases
System Tables
System Stored Procedures
Install Sybase Server
Sybase Query Tools
Lab

TSQL
Transact SQL (TSQL)
Select
Execution Sequence
Statistical Mode
Operators
Where
Insert/Update/Delete
Merge
Conditional Execution
Truncate Table
Select Into
Identifiers
Nulls
System Procedures
Lab

Databases and Tables
Devices
Create Database
Designing Tables
Datatypes
Identity Property
User Tables
Computed Columns
Alter Table
System Tables
Temporary Tables
Derived Tables
sp_help
Lab

Storage
Devices
Allocation Units
Extents
Page Layout
Row Layouts
Heap Table
Partitioned Tables
Object Allocation Maps
sp_helpdevice
Catalog tables
Lab

Indexes
Clustered
Non-clustered Index
Indexing for Multiple Queries
Dynamic Index
Index Statistics
Index Design Guidelines
Parallel create index
create index ... online
Bloom Filters
Function-based Indexes
Lab

Joins and Subqueries
Joins
ANSI Inner Joins
Outer Joins
Self Joins
Not Equi-Joins
Cumulative Totals
Missing Data - Gaps
Medians
Subqueries
Correlated Subquery
Unions
Lab

Advanced TSQL
Case Expression
Syntax
Examples
Grouping
Pivoting Data
Cross Tabulations
Characteristic Functions
Reverse Cross Tabulations
Lab

Sybase Security
Logins
Roles
System Roles
Database Owner (DBO)
Database Users
Guest User
Command Permissions
Object Permissions
System Procedures
System Tables
Lab

Stored Procedures
Types
Create procedure
Parameters
Parameter Defaults
Information
Return Parameters
Return Status
Query Trees
Query Plans
Deferred Name Resolution
System Tables
Recompile Rrocedures
sp_recompile
Re-resolve Procedures
System Procedures
Remote Procedure Call
Deferred Compilation
Lab

Bulk Loading (bcp)
Bulk Copy Program
Modes
Copy from Table
Copy to Table
Format File
Copy Speed
Lab

Transactions and Locking
Transaction Control
Transaction Log
Nested Transactions
Locks and Transactions
Types of Locks
Lock Schemes
All Page Locking
Data Page Locking
Data Row Locking
DOL Table Maintenance
Incremental Reorganization
Lab

Access Processing
Query Processor
Access Methods
Statement Cache
Table Scans, APL and DOL
Index Seeks and Scans
showplan
Page i/o
Partition elimination
Worktable optimization
Hash-based distinct
Procedure Cache
Set fmtonly on
Statement Cache
Literal Parameterization
Lab

Data/Index Modifications
SQL DML
Inserts
APL
DOL
Page Splits
Asynchronous Writes
Deletes
Updates
Direct
Deferred
Post-commit Optimization
Recommendations for DML
Lab

Query Processing
Query Processor Steps
Pre Processing
Find Predicates
Search Arguments
or Strategy
Eager and Lazy Aggregation
order by and group by
Estimate Index Selectivity
set option Examples
Optimizer Diagnostic Utility
sybperf
Lab

Optimizer Statistics
Statistics tables
Fragmentation
Describe optimizer statistics
View statistics with sp_optdiag
Manage optimizer statistics
Up-to-date statistics
datachange
Hash-Based Update Statistics
Expression Histogramming Selectivity Estimates
Automatic Running of update statistics
Lab

Performance Strategies
Index Covering
Seek or Scan
Composite Keys
Key Order
Statistics
Range Query
How joins are processed
Join order
Nested-Loop Joins
N-ary
Merge Joins
Hash Joins
Subqueries Optimization
set option show
Bloom Filters
Lab

Backup and Recovery
Backup Basics
Dumps and Loads
Types of Backups
Backup Server
Dump Database Command
Loading Databases
load database Command
Bringing a Database Back Online
Dumping Transaction Logs
dump transaction Command
Loading Transaction Logs
Lab

Troubleshooting
Monitoring Errors
Error Log
Error Messages
Severity Levels
Monitoring Processes
Process Status
sysprocesses System (materialized) Table
Killing a spid
Developing a Monitoring Strategy
Lab
Send Us a Message
Choose one