Sybase Database Administration

Sybase Database Administration

The training are conducted using state-of-the-art facilities. In a significant departure from the traditional teaching methodology that separates the theory and the practical sessions, the courses at Micro Academy are highly interactive with concurrent theory and practical sessions. The practical sessions ensure an immersive hands-on experience. These sessions also impart critical trouble-shooting skills, which are much sought after by the industry.

The course at Micro Academy is so constructed using state-of-the-art infrastructure as to provide the participants with simulation of real-life production environment. In this context, as proprietary RISC-based machines are needed to run the different flavors of UNIX, we impart trainings on such machines.

One of the main advantages for our clients is our ability to tailor courses to meet their specific and bespoke requirements. Our trainings are also so structured as to provide us and the clients with regular feedback on the progress and the effectiveness of the courses. Our ISO-driven methodology helps us in adhering to the defined requirements.

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
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

sybase database administration

system and database administration: adaptive server enterprise

course topics:

* module 1: introducing adaptive server adaptive server enterprise 15.0
* adaptive server databases
* system administrator responsibilities

* module 2: installing servers loading the ase software
* installing adaptive server
* ase directory structure
* starting and stopping servers

* module 3: establishing connectivity the interfaces file
* the unix interfaces file
* the windows sql.ini file
* maintaining the interfaces file
* introduction to ldap directory services

* module 4: configuring server behavior the configuration file
* viewing configuration values
* modifying configuration values
* multiple configuration files

* module 5: configuring memory components of memory
* allocation of memory
* major uses of memory
* estimating initial configuration values

* module 6: initializing and using devices creating and dropping devices
* default devices
* mirroring devices

* module 7: creating and using databases sizing and creating databases
* setting ownership and options
* expanding databases

* module 8: suggested disk resource strategies resource allocation for system databases
* resource allocation for user databases
* monitoring space usage

* module 9: auto expansion overview of auto database expansion
* installing auto expansion
* managing auto expansion using a?dbextend

* module 10: managing tempdb review of system tempdb
* installing multiple tempdbs
* binding to a tempdb
* managing tempdbs - precedence
* troubleshooting and recommendations

* module 11: administering system roles and logins overview of access
* system roles
* logins
* proxy authorization

* module 12: managing database access and users database owners
* database users
* object creation permissions

* module 13: implementing object permissions groups, and roles
* object permissions
* groups
* overview of user-defined roles
* implementing user-defined roles

* module 14: using bulk copy utility copying definitions
* bulk copy overview
* bulk copy syntax

* module 15: overview of automatic recovery overview of automatic recovery
* recording modifications
* recovering modifications after a shutdown
* checkpoints
* recovery order

* module 16: checking and fixing database consistency
* overview of the dbcc commands
* checking page linkage
* checking page allocation
* setting up the dbccdb database
* using dbcc checkstorage

* module 17: planning for backups backup basics
* backup server
* truncating the transaction log
* developing a backup plan

* module 18: performing a backup making backup servers known to adaptive server
* dumping databases
* loading databases
* dumping transaction logs
* loading transaction logs

* module 19: practicing advanced backup techniques thresholds
* transaction log recovery
* database recovery
* rebuilding the master database

* module 20: sybase central sybase central defined
* using sybase central
* administration tasks
* job scheduler
* interactive sql

* module 21: monitoring the system monitoring errors
* monitoring processes
* monitoring licenses
* monitoring system performance

Pages:- 1
[ Online / Live ] [ Corporate Training ] [ Locations ] [ Schools ] [ Job Seekers ]

Dear Visitor: You are strongly recommended to bookmark this page and come back later, since new course may be available anytime. Click to Proceed>>