Training Course:Fast Track to Adaptive Server Enterprise (Certificate)School/Trainer:Sybase, Inc.
Ottawa, Toronto, Ontario, Canada
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:(978) 287-1626
School Address:
Sybase, Inc.
Toronto Learning Center
175 Bloor Street East, Suite 800
Phase 1 - North Tower
Toronto, Canada M4W 3R8
Jobs & Resumes: Ottawa, Toronto
Houses & Roommates: Ottawa, Toronto
Travel Agencies: Ottawa, Toronto
Search other schools for Fast Track to Adaptive Server Enterprise training resources.
Other training courses offered by Sybase, Inc.:
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
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:
You do not need to register before you can use most of our services. You will get a code for each posting ever made on this website. It is the key for you to remove the posting anytime by yourself. |
|
|
