Training Course:Fast Track to Adaptive Server Enterprise (Certificate)School/Trainer:Sybase USA
Atlanta, Bethesda, Boulder, Chicago, Concord, Dallas, Irvine, New York, Richmond, United States
Course Format: Classroom | E-learning | Virtual Class | Online | On-site | Blended | Self-paced
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. ...''
Elements of this syllabus are subject to change.
Please go to the school's official website for training price and schedule:
http://www.sybase.com/
Phone:1-800-8-SYBASE
School Address:
Manhattan Learning Center
The Grace Building
1114 Avenue of the Americas, 32nd Floor
New York, NY 10036
Irvine Learning Center
19800 MacArthur Blvd. Suite 855
Irvine, CA 92612
Jobs & Resumes: Atlanta, Bethesda, Boulder, Chicago, Concord, Dallas, Irvine, New York, Richmond
Houses & Roommates: Atlanta, Bethesda, Boulder, Chicago, Concord, Dallas, Irvine, New York, Richmond
Travel Agencies: Atlanta, Chicago, Dallas,
Search other schools for Fast Track to Adaptive Server Enterprise training resources.
Other training courses offered by Sybase USA:
Business Process Modeling Using PowerDesigner 11
Data Modeling with PowerDesigner 11
Essential Techniques for Object-Oriented Modeling using PowerDesigner 12
Object-Oriented Modeling with PowerDesigner 11.0
Object-Oriented Modeling with PowerDesigner 12
Data Modeling with PowerDesigner 15
Business Process Modeling with PowerDesigner 15
Advanced Modeling Techniques using PowerDesigner 12
Moving to PowerDesigner 15
Implementing Mirror Activator for Sybase
System and Database Administration: Adaptive Server Enterprise
Fast Track to Replication Server Administration
Replication Server 15.0 Masters
Powering Up to Replication Server 12.6
Powering Up to Replication Server 15.0
Fast Track to Mirror Activator for Sybase
Fast Track to Sybase OpenSwitch 15.0
Fast Track to Data Federation Administration
Data Federation for Developers
Notice: The course description on this page was captured from the Internet as historical reference or submitted by visitors. It was archived statically and not updated from day to day.
Tips:
In most cases you will get a unique submit code along with your each posting on this website. Please provide it as well as the message title if you want any assistance for editing/removal. |
|
|
