Database Admin school training courses in Bellevue, NE (public, in-house or online)

DBA 130 Database Theory . 5 CR
Develops in-depth understanding of database concepts and terminology, emphasizing the relational databases model. Understanding the role of Structured Query Language (SQL), data modeling and normalization of database tables. Prerequisite: BTS 168 with a C- or better. Placement by assessment into ENGL 089 and ENGL 092 or 093 with a C- or better.
DBA 232 Database Administration . 5 CR
Develops the concepts and skills required to perform the duties of Data...

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