|
|
Introduction to Sybase Adaptive Server
| Duration: 4 days |
| Participants: Application programmers and developers, and database administrators who want to learn the basics of Sybase's Adaptive Server, a full-featured relational database. |
|
Objectives:
Upon successful completion of this course you will be able to:
- Use the fundamentas of SQL Server. - Use the features of Transact-SQL. - Write stored procedures and triggers. - Contribute to a project. |
|
Overview:
- This course teaches the funamentals of SQL Server. Participants practice coding Transact-SQL, and learn stored procedurs, cursors, and triggers in the workshops. Instructors are hands-on Database Administrators who share their experience. |
| Prerequisites: Prior attendance at the 'Introduction to SQL for Sybase Adaptive Server' course or equivalent knowledge of SQL and understanding of relational database theory. |
| Format: Lecture and discussion with hands-on exercises. |
|
Topic Outline:
- Introduction to Client-Server Architecture Types Definition of Client-Server Functions in Client/Server Architecture Adaptive Server Architecture - Back End Development Tools isql wisql Definition Client Server SQL Advantage Sybase Advantage - Relational Database Entities Attributes Relationships Primary and Foreign Keys Referential Integrity Data Integrity - Review SQL Update Delete Select Select Into Insert - Basic Database Structures Databases Tables Views - Basic Data Integrity Structures Rules Defaults User-Defined Datatypes Indexes Constraints - Security Special Logins Users Groups and Roles Learn How to Allow Users Access to: Adaptive Server, Databases, Objects, Commands - Transact-SQL Functions Wildcards Escape Clause Date Conversions Group By Compute Compute By - Programming Constructs Review Batches Understand Message Handling Understand Error Handling Learn How to Use Variables Learn to Control Flow Commands - Transactions and Locking Using Adaptive Server Transactions Understand the Transaction Log and the Automatic Recovery Process Understand Adaptive Server Locks - Cursor Programming Declaring Opening Fetching Rows Modifying Data Closing Deallocating Scope Cursors Locking - Stored Procedures Definition Executing Creating Displaying Maintaining Calling With Cursors Referencing Optimizing Groups Remote Guidelines Parameters Result Sets Procedure and Server Status - Declarative Referential Integrity Defined Deleting and Inserting Rows Updating Keys Constraints Create Schema - Triggers Creating During Transactions Firing Save Points Nesting Guidelines Deleted and Inserted Tables - Back Up and Restore How to Back Up a Database How to Restore a Database BCP Utility - Open Client Revisit Client/Server db_library ct_library ODBC Other Sybase Components |