sybase -fast track to adaptive server enterprise

ahana systems and solutions (p) ltd.
bangalore, karnataka, india

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

Course Description:

'' 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
table 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:08026675891

School Address/Venue(s):



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

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

sql server 2005 - performance tuning and optimisation
SQL Server 2005 Integration Services (SSIS)
SQL Server 2005: Analysis Services (SSAS)
sql server 2005: reporting services (ssrs)
sybase performance and tuning
sybase mastering advanced t-sql
sybase replication
Power Builder (Rapid Application Development System)
VMWARE ESX Administration
Linux 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: You do not need to register before you can use most of our services. You will get a code for each posting ever made on this website. It is the key for you to remove the posting anytime by yourself.