- 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),
unions in views, increased number of arguments to Stored Procedures (extensible new
limits), and new data-types with Unichar16.
Objectives:
Upon completion of the course, participants should 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
Prerequisites:
None
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.
Audience:
Database Administrators, Database Designers, End-Users, and SQL Developers
Course duration:
5 days
Skill:
Introductory
Format:
70% Lecture
30% Labs
