Email Us   Phone : 503-259-0312   
  Home    |    Instructor-led Training    |    Online Training     


Contact Us   -   Why Choose Wintrac   -   Clients    

Courses
ADA
Adobe
Agile
AJAX
Android
Apache
AutoCAD
Big Data
BlockChain
Business Analysis
Business Intelligence
Business Objects
Business Skills
C/C++/Go programming
Cisco
Citrix
Cloud Computing
COBOL
Cognos
ColdFusion
COM/COM+
CompTIA
CORBA
CRM
Crystal Reports
Data Science
Datawarehousing
DB2
Desktop Application Software
DevOps
DNS
Embedded Systems
Google Web Toolkit (GWT)
IPhone
ITIL
Java
JBoss
LDAP
Leadership Development
Lotus
Machine learning/AI
Macintosh
Mainframe programming
Microsoft technologies
Mobile
MultiMedia and design
.NET
NetApp
Networking
New Manager Development
Object oriented analysis and design
OpenVMS
Oracle
Oracle VM
Perl
PHP
PostgreSQL
PowerBuilder
Professional Soft Skills Workshops
Project Management
Rational
Ruby
Sales Performance
SAP
SAS
Security
SharePoint
SOA
Software quality and tools
SQL Server
Sybase
Symantec
Telecommunications
Teradata
Tivoli
Tomcat
Unix/Linux/Solaris/AIX/
HP-UX
Unisys Mainframe
Visual Basic
Visual Foxpro
VMware
Web Development
WebLogic
WebSphere
Websphere MQ (MQSeries)
Windows programming
XML
XML Web Services
Other
Introduction to Sybase and the Transact_SQL Programming Facilities
Sybase Training Overview:

The INTRODUCTION TO SYBASE AND THE TRANSACT-SQL PROGRAMMING FACILITIES course provides the students with a comprehensive explanation of all the capabilities of the Sybase relational database management system. The course begins by teaching basic structured query language facilities, and then presents greater detail of SQL coding techniques, and the numerous extensions to standard SQL that have been incorporated within the TRANSACT-SQL product. The class will cover, through detailed lecture and corresponding lab assignments, the programming aspects of Transact-SQL including; stored procedures, defaults, triggers, indexes, system functions, data control statements, Transact-SQL programming statements, and efficient transaction processing.

Upon completion of the course, the student will have a detailed knowledge of Sybase, Transact-SQL programming, and transaction management as well as being highly trained with the advanced SQL facilities that are available through the SYBASE product.

Sybase Training Objectives:

Upon successful completion of this course, participants will be able to create and process SYBASE tables and all related entities. The students will be able to efficiently access Transact-SQL data, and be capable of creating transactions, stored procedures, rules, defaults, functions and triggers. Students of this class will be able to use all the programming aspects available within Transact-SQL to successfully accomplish their required database accessing.

Sybase Training Prerequisites:

Having worked with another relational database management system will be of some advantage for a prospective student, but is not required. A background in programming will also be a useful prerequisite for this class.

Sybase Training Audience:

This course is recommended for applications programmers, systems programmers, database administrators, database designers and all other related personnel who require an in depth understanding of the SYBASE Transact-SQL facility.

Course duration:

5 days

The first day of the class will be devoted to strengthening the participants understanding of Structured Query Language facilities. The next four days build upon this basic knowledge to provide in depth lectures and labs in order to explain all of the functions of the Sybase relational database management system.


Sybase Training Course outline

Day One

Relational database concepts

Introductory SQL programming

Creating tables

System datatypes

Insert coding

Update coding

Delete coding

Coding a Select statement
  • Syntax
  • Distinct
  • Order by
Where clause coding
  • In / Like / Between
  • Precedence
Primary and Foreign Keys

Join Operations

Demonstration Data Layout

Lab Exercise

Day Two

Database creation facilities

Database security features

Defining Tables

Examining table structures

Lab on table creations

Null processing

Table constraints

User defined datatypes

Index processing

Creating clustered and nonclustered indexes

Lab on creating indexes

Day Three

Outer joins

Ansi join processing

Aggregate Functions

Subqueries

Transact-SQL enhancements to standard SQL processing

Sybase functions
  • String operations
  • Data conversions
  • Datetime processing
  • Mathematical functions
Lab on functions

Order by statement

Group by statement

Having clause

Compute by processing

Compute processing

Lab on Order, Group and Compute

The select into command

Creating Temporary tables

SQL INSERT / UPDATE / DELETE statements

Lab exercise

Creating and using Views

Lab on Views

Day Four

Batch processing

Transact-SQL control of flow statements
  • IF....ELSE
  • BEGIN...END
  • CASE
  • IF EXISTS
  • WHILE....
  • GOTO
  • RETURN
  • WAITFOR
  • PRINT
  • RAISERROR
Lab on control of flow logic statements

Local variables

Global variables

Error processing

Dynamic statement execution

Lab on variables

Stored procedures
  • Creating
  • Executing
  • Parameters
  • Returning values
  • Recompiling stored procedures
Lab on stored procedures

Day Five

Coding cursors for select processing

Coding update cursors

Transaction Processing

Begin Transaction

Save Transaction

Rollback Transaction

Commit Transaction

Lab on transactions

Referential Integrity

Creating Triggers

Sample Triggers

Trigger processing

Coding triggers

Examples of stored procedures and triggers

Lab on Triggers




 
About us
Contact us
Careers at Wintrac
Our Clients
Why Wintrac


Register for a free training CD-ROM drawing
Refer a client or instructor and earn $$$


Wintrac Inc.
16523 SW McGwire Ct.
Beaverton OR 97007
 
? Wintrac, Inc. All rights reserved.                                                                               Site Map   |   Terms of Use   |   Privacy Policy