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.

• 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.

Who Should Attend: Database Administrators, Database Designers, End-Users, SQL Developers

Prerequisites: None

Skill: Introductory

Format:
70% Lecture
30% Labs

Type:
Classroom, On Site, SyberLearning LIVE

Delivery Times:
Learning Center Classroom: Classes typically begin at 8:30AM Local Time in most Learning Centers. Please check your Confirmation Letter for exact time.
SyberLearning LIVE (Instructor-facilitated online training): Five, 6.0 Hour Sessions (Lecture & Lab: 11:00am - 5:00pm ET)