Training Courses
Cisco
CCNA
CCNP
CCVP
CompTIA
CompTIA A+
CompTIA Network+
Microsoft
MCSE 2003
MCTS Web Applications
MCPD Web Development
MCTS SQL Server 2005
Oracle
Oracle 10g OCP
Oracle 11i Financials
Oracle 11i HRMS
Sun
SCJP
SCNA
SCSA
Sybase
Sybase DBA
|
Sybase DBA
Upon completion of this course, you will be able to:
- Describe the basic concepts surrounding a relational database
- Access an Adaptive Server database using ASE client software
- Write a simple query that returns data from a database
- Write a qualified query that returns a specific subset of information
- Use aggregates to perform mathematical analyses of data
- Query data from more than one table using joins
- Query data from more than one table using subqueries
- Gain familiarity with the ASE by navigating through key features of the ASE environment
- Manage physical data placement and storage
- Create, backup and restore databases
- Configure auto-expansion
- Create and Manage multiple temporary databases
- Create user accounts and manage permissions
- Use Sybase Central to maintain an Enterprise environment
- Run diagnostic and repair functions
- Reconfigure Adaptive Server dynamically
- Create a new ASE server and perform post-installation security tasks
- Describe ASE connectivity and implement balanced network and port utilization with fail-over safety
- Describe Sybase Asset Management and Licensing Architecture
- Describe the mechanics of database and table allocation/deallocation
- Use DBCC commands to detect and resolve table fragmentation, allocation, and linkage problems
- Perform effective backups, and troubleshoot dump, load, and recovery problems
- Rebuild a damaged database with up-to-the-minute data
- Rebuild the master device and database
- Describe the working details of Component Integration Services
- Describe advanced database monitoring tools and options
- Configure ASE for optimum Data Security
Training Cost
- £5995
Training Dates
- 1st September 2008
- 15th September 2008
- 28th September 2008
- 6th October 2008
- 20th October 2008
- 3rd November 2008
Training Duration
- Two Weeks
- Monday-Friday
- 10.00-5.00pm
Training Venue
12 Helmet Row
London EC1V 3QJ
|