| Course Code: |
RT 130 |
| Course Abstract: |
In this course, participants learn to create tables and manipulate data, tables and other database objects using ANSI-standard SQL and Sybase’s Transact-SQL extensions, and gain hands-on experience using Adaptive Server databases. Participants will also learn the special features and functions of the Adaptive Server, such as automatic recovery of transactions, stored procedures, triggers, and cursors. In addition, participants will learn to use good programming techniques and develop strategies for writing efficient applications. |
| Audience: |
This course is designed for end-users and SQL developers who own, access or develop database and database applications managed by an Adaptive Server Database administrators and SQL developers who need to familiarize themselves with Adaptive Server architecture and functionality. |
| Duration: |
5 days |
| Learning Outcomes: |
Upon completion of this course, the participant will be able to:
> Use the basic components of Adaptive Server Enterprise
> Create tables, populate 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 transaction effectively
> Write stored procedures and triggers to help in database maintenance and upkeep |
| Course Topics: |
Introduction
History and Architecture of Client/Server
Query Tools
Structured Query Language
Transact SQL
Joins and Subqueries
Advanced Query Techniques
XML Support
SQL Server Components
Databases
Design
Datatypes
Rules and Defaults
Tables
Constraints
Temporary Tables
Views
Derived Tables
Indexes
Query Optimizer
Stored Procedure Programming
Functions
Variables
Syntax
Cursors
Stored Procedures
Advanced Procedure Techniques
Triggers
Transaction Control
Locking
Managing Data
Security
Bulk Copy |
| Prerequisites: |
None. |