Database Admin school training courses in Birmingham, AL (public, in-house or online)

MCITP candidates must first complete the requirements for the MCTS: SQL Server 2005 certification (one exam). After earning this certification, candidates earn their MCITP: Database Administrator by passing two required exams.

If you are a Microsoft Certified Database Administrator (MCDBA), you may upgrade to the MCITP: Database Administrator certification by taking one upgrade exam instead of the two required exams. MCDBAs must still obtain the MCTS: SQL Server 2005 certification as a pr...

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

Select the Informix data types appropriate for storing your data
Create and maintain databases, tables, and indexes
Estimate size and extent requirements for tables and indexes
Create index strategies to improve performance
Create and maintain table and index partitioning (fragmentation)
Implement referential and entity integrity
Manage database and table modes
Manage violations logging
Describe how the optimizer builds an optimal query plan
Use the SET EXPLAI...

Full archival course description>>

In this Transact-SQL Server 2008 Training course, students will learn about the features that are available in SQL Server like how to design and create a database, and how to build basic queries using Transact-SQL, the language of SQL Server. Then students will learn how to build effective views, stored procedures, triggers, and user-defined functions using Transact-SQL. Students will also learn how to use the Transact-SQL programming language for error handling and hierarchical queries, dealing...

Full archival course description>>