Training » Sybase

Find the course you need

Print | Email | Bookmark | Facebook | LinkedIn

EDB115: Fast Track to Adaptive Server Enterprise

Course length: 5 Days | Tuition: $3375.00

Course Description : 
Gain hands-on experience with the newest features of Adaptive Server Enterprise (ASE), and learn to create database objects expertly using ANSI-standard SQL and Transact-SQL extensions. Study key features and functions of ASE including automatic recovery of transactions, writing Stored Procedures and triggers, and creating and using cursors. Course material also covers important concepts from Introduction to SQL (EDB100), new functions, increased number of arguments in IN statements, increased limits on object identifiers, and new datatypes.

Course Objectives :
Upon completion of this course, you will be able to:

  • Use the basic components of Adaptive Server Enterprise to connect to a server database
  • Create tables, populate the tables with data, and efficiently query data from those tables
  • Employ data integrity methods to ensure the validity of the data
  • Write code in Transact-SQL
  • Use and manage transactions effectively
  • Write stored procedures and triggers to help in database maintenance and upkeep

Course Topics: 
Overview of relational database concepts, using the basic components of ASE to connect to a server database, Adaptive Server clients, isql and SQL advantage, creating tables, modifying/querying data in tables, improving query functionality and performance, 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, and managing transactions and locking.

Who Should Attend: Database Administrators, Database Designers, End-Users, SQL Developers

Prerequisites: None

Skill: Introductory

Format:
70% Lecture
30% Labs

Courses with a guaranteed icon () are guaranteed to run. View our full guaranteed to run schedule.

Onsite / Private Class

We can provide this class onsite to your team as a standard class or customized to meet your specific needs. Request a quote today.

Start Date End Date Start Time End Time Location    
Your Dates Your Time Your Location Request a quote today

Virtual Course Dates

  Start Date End Date Start Time End Time Location    
2010-09-13 2010-09-17 Contact KU Contact KU Virtual Generate Online Quote Enroll Now

Notify Me of Upcoming Dates

Where are all the dates? Contact us using the form below and we will provide you with training options for this course, as we have many nationwide dates that may not be listed.

Name: Phone:
Email: Company:
Comments: