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. |
|
|