* Fundamental understanding of databases and SQL language * Basic understanding of network connectivity architecture * Knowledge of general Unix commands
Course based on software release
ASE 15.7
Content
Overview of relational database concepts and client/server architecture
Using the basic components of ASE to connect to a server database
Adaptive Server clients
isql and Interactive SQL
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
Programming with variables and control-of-flow statements
Managing transactions and locking
Notes
Gain hands-on experience with the newest features of Adaptive Server Enterprise (ASE) through 15.7, 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 the SQL language, new functions, increased number of arguments in IN statements, increased limits on object identifiers, and new data types.