Goals

• 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

Audience

• Database Administrators, Database Designers, End-Users, SQL Developers

Prerequisites

Essential

• * 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.
• (Interactive_DE)

Popular tags