Scheduled Dates (sort by: location | date) |
Request availability or book by selecting a date: Greater London
Prices exclude VAT.
Have questions or need a better city/date? Ask now.
On-site/international quote? Ask now.
|
Course Overview Gain exposure to the newest features of Adaptive Server Enterprise 12.5, and learn to expertly create database objects using ANSI-standard SQL and Sybases Transact-SQL extensions. Get hands-on experience with special features and functions of the Adaptive Server such as automatic recovery of transactions, stored procedures, triggers, and cursors. Newly included within this 5 day course is a basis of concepts and key features from the Introduction to SQL course. Prerequisites Basic Computer Literacy Course Outline - Overview of relational database concepts
- Adaptive Server clients: isql and jisql
- Creating tables
- Modifying data in tables
- 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
- Managing transactions and locking
- Writing stored procedures and triggers
- Creating and using cursors
How to make a booking for the EDB115 course
|
