| Length:
4 Days |
| Prerequisites:
Prior Knowledge of SQL, Basic Knowledge, Relational
Database Theory |
Key Benefits:
- Learn The
Fundamentals of SQL Server
Know the Features
of Transact-SQL
Leave Ready to
Contribute to a Project
Write Stored
Procedures, Triggers
|
Other Course Features:
- How-To Pages!
Step-By-Step Instructions on a Variety Of ‘Cookbook’
Procedures
A Comprehensive
Course Workbook
Reference Guide
Lab Workbook with
Real-world Examples
|
| Course Description:
Learns the basics of
Sybase’s Adaptive Server, a full-featured relational
database. Students are taught the Server’s powerful SQL
programming language; and stored procedures, cursors,
triggers. This course provides a thorough discussion and
should allow the student to prepare for programming this
powerful product. Our instructors are hands-on
Database Administrators. They will share their
experiences while teaching the course material.
|
Topics Covered:
- 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, Commnands
Transact-SQL
Functions, Wildcards, Escape Clause, Date
Conversions, Group By, Compute, and 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
|
|
|
|
