fast track to adaptive server enterprise

ahana systems and solutions pvt ltd
bangalore, india

Course Format: Classroom | E-learning | Virtual Class | Online/Live | On-site/In-house | Blended | Self-paced
Teacher/Instructor: umashankar

Course Description:

'' sybase database administration

fast track to adaptive server enterprise

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 h?s. course material also covers important concepts from introduction to sql, new functions, increased number of arguments in in statements, increased limits on object identifiers, and new datatypes.

course objectives :
upon completion of this course, you will be able to: i

* use the basic components of adaptive server enterprise to connect to a server database
* create5?s, populate the5?s with data, and efficiently query data from those5?s
* 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:

module 00: course introduction
* module 01: introducing relational database concepts and transact-sql relational databases
* ansi sql and transact-sql

* module 02: introducing client/server architecture adaptive server
* isql
* interactive sql
* database system procedures

* module 03: querying data in5?s writing queries 3-5
* reformatting the result set
* modifying the result set
* writing qualified queries

* module 04: analyzing data using aggregate functions aggregates
* grouping clauses
* compute clauses

* module 05: querying multiple5?s (joins and subqueries) joins
* subqueries

* module 06: creating5?s datatypes
* column properties and create5? syntax
* default clauses
*5? management

* module 07: creating temporary5?s and querying system5?s temporary5?s
* creating copy5?s
* system5?s

* module 08: modifying data in5?s insert and update statements
* delete and truncate statements
* the case statement
* transaction log and dml

* module 09: using views and indexes to affect query performance views
* indexes

* module 10: using constraints to enforce data integrity overview of data integrity
* check constraints
* primary key and unique constraints
* references constraints
* constraint management

* module 11: employing reusable database objects (defaults and rules) defaults
* rules
* user-defined datatypes
* data integrity methods

* module 12: manipulating data using transact-sql functions function basics
* datatype conversion
* function categories

* module 13: programming with variables batches and comments
* local variables
* global variables
* dynamic sql

* module 14: programming with control-of-flow statements if statements
* while loops
* message statements

* module 15: using transactions to maintain database consistency defining transactions
* transaction statements
* transaction modes
* error processing

* module 16: transaction management: isolating data with locks locking basics
* locking schemes
* isolation levels

* module 17: using h?s to process data h? statements
* h?s and data modification
* h?s and transactions

* module 18: writing basic stored procedures benefits of stored procedures
* stored procedure syntax
* input parameters
* return parameters

* module 19: refining stored procedures making code readable
* verifying input values
* tagging transaction modes
* capturing an error status
* avoiding unintentional rollbacks
* preventing nesting-level errors
* recompiling procedures

* module 20: using triggers to enforce referential integrity defining triggers
* special trigger5?s
* triggers and transactions
* trigger production practices
* comparing referential integrity methods
...''

Elements of this syllabus are subject to change.

Phone:080-26675891

School Address/Venue(s):

ahana systems & solutions (p) ltd.

105/22, ist floor, 50 feet road
hanumanth nagar, near nirmala store bus stop
banashankari, bangalore ï¿?560050

Jobs & Resumes: bangalore
Houses & Roommates: bangalore
Travel Agencies: bangalore

Search other schools for fast track to adaptive server enterprise training resources.

oracle database administration
oracle 10g database administration
oracle 10g rac
sybase database administration
sybase t-sql
sybase configuring adaptive server
mysql database administration
Perl Script
Shell Script
ClearCase Administration
Linux System Administration (Based on RedHat)
VMWARE ESX Administration

Notice: The course description on this page was captured from the Internet as historical reference or submitted by visitors. It was archived statically and not updated from day to day.
 

Tips: Try the search form on top of each page to find the latest course information, using course topic and location as keywords. Keep the course topic keyword short to get more results.