Database Admin school training courses in Corpus Christi, TX (public, in-house or online)

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.

MCITP: Database Administrator Certification is appropriate for:

Database Administrators
Database Developers
Busine...

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