Sybase Programming Workshop

Course:  SYBPROG
Duration:  5 Days
Level:  I
Course Summary

This workshop uses the 'HANDS ON' approach to teach the participant the essential concepts of SYBASE SQL Server Database using SQL and SYBASE's Transact-SQL extensions (current or any release).

« Hide The Details
Topics Covered In This Course

Relational database concepts

Client/server architecture

Creating tables

Simple queries

Qualified queries

Aggregates

Joins

Unions

Subqueries

Modifying data in tables

Using temporary tables and system tables

Using constraints, defaults, and rules to enforce data integrity

Writing Transact-SQL code with functions, variables, and control-of-flow statements

Creating and using cursors

Managing transactions

Writing stored procedures functions, and triggers

What You Can Expect

At the end of this course, participants will be able to:

  • Understand Relation Database Concepts
  • Create Tables and Manipulate Data
  • Understand both ANSI-SQL and Transact-SQL
  • Run both Simple and Complex queries
  • Run Batches
  • Use Transactions
  • Use Stored Procedures, Functions, Triggers, and Cursors
Who Should Take This Course

Application and Systems programmers, designers interested in gaining an understanding of SYBASE, users who wish to do their own ad-hoc Queries, users with a desire to code their own ad-hoc reports.

Training Style

Instructor led with hands on workshops.

« Hide The Details
Related Courses
Code Course Title Duration Level
SYBSQL
Sybase SQL Workshop
3 Days
I
Details

Every student attending a Verhoef Training class will receive a certificate good for $100 toward their next public class taken within a year.

You can also buy "Verhoef Vouchers" to get a discounted rate for a single student in any of our public or web-based classes. Contact your account manager or our sales office for details.

Schedule For This Course
There are currently no public sessions scheduled for this course. We can schedule a private class for your organization just a couple of weeks from now. Or we can let you know the next time we do schedule a public session.
Notify me the next time this course is confirmed!
Can't find the course you want?
Call us at 800.533.3893, or
email us at info@verhoef.com