Database Admin school training courses in Concord, NH (public, in-house or online)

Learn how to identify the major tasks of Sybase system and database administration and practice these tasks using your own Adaptive Server Enterprise (ASE) in a safe and controlled environment. Emphasis is given to resource management (memory, disk, and tempdb space with a goal of creating a reliable Adaptive Server environment. Examine fundamental monitoring and troubleshooting methods, backup and recovery strategies, job scheduling and user access issues.
Course Objectives :
Upon comple...

Full archival course description>>

Sybase DBAs have specialized needs when it comes to ASE 15 migration. Sybase Education has developed a five-day comprehensive ASE 15 migration program to support not only the migration to ASE 15.x but also post migration issue resolution training for the DBA.

The Microsoft Certified IT Professional (MCITP) certification is appropriate for IT professionals who administer a Microsoft SQL Server 2005 database. This certification tests knowledge related to installation and management of SQL Server 2005, backup and maintenance of databases, generation of reports, security management and implementation of automated tasks.

Classroom-based training combined with intensive hands-on labs build the knowledge and experience you needed to succeed!

Full archival course description>>

After completing this SQL Server 2008 R2 training course, students will be able to:
Explain SQL Server 2008 R2 architecture, resources requirements and perform pre-checks of I/O subsystems
Plan, install and configure SQL Server 2008 R2
Backup and restore databases
Import and export wizards and explain how they relate to SSIS
Use BCP and BULK INSERT to import data
Manage security
Assign, configure fixed database roles and create and assign user defined database roles
Full archival course description>>

Install and Upgrade MySQL 5.0 for the most common operating systems

Utilize the MySQL Administrator Graphical User Interface (GUI) to manage a MySQL server

Use the INFORMATION_SCHEMA database to access metadata

Perform the MySQL start and shutdown operations

Configure MySQL server options at runtime

Evaluate data types and character sets for performance issues

Understand data locking concepts and the different levels of locking in MySQL

...

Full archival course description>>