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

The Microsoft Certified IT Professional (MCITP) is appropriate for IT professionals who develop a Microsoft SQL Server 2005 database. This certification tests knowledge related to installation or SQL Server 2005, administration of databases, creation of applications, integration of databases, providing reporting services, and integration of notification services with existing applications.

MCITP: Database Developer Certification is appropriate for:

Database Administrators
Datab...

Full archival course description>>

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

6232: Implementing a Microsoft SQL Server 2008 Database

2778: Writing Queries Using Microsoft SQL Server 2008 Transact-SQL

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

After completing this SQL Server 2008 R2 training course, students will be able to:
Understand the product, its components, and basic configuration.
Work with the data types supported by SQL Server.
Design and implement tables and work with schemas.
Design and implement views and partitioned views.
Describe the concept of an index and determine the appropriate data type for indexes and composite index structures.
Identify the appropriate table structures and implement clus...

Full archival course description>>