About | Classes

As society grows to depend increasingly on having accurate and current information available, organizations must be able to organize, retrieve, and interpret this information. This certificate program provides you with an understanding of database technology and database design, development, and implementation. You'll work with both file-based and server-based applications to learn to set up databases for end-users using GUI applications, while mastering SQL commands to interact with these databases.

You'll learn to:

  • Use proven design techniques to develop effective relational databases.
  • Design queries to retrieve meaningful information.
  • Understand client-server systems and SQL commands.
  • Create a database using a WYSIWYG program.
  • Optimize the functions of a database for everyday operations.

Prerequisites

You should be proficient with the Windows or Macintosh operating system.

Certificate Class Requirements

A minimum of 72 hours is required –12 hours from Server-Based classes, 36 hours from File-Based classes (including at least one advanced level course), and 24 additional hours from the classes list.

Certificate Requirements

Complete the application form and return it with your $25 nonrefundable fee. To earn this certificate, you must complete a minimum of 72 hours in the classes and categories specified. (Please note that you are required to take at least one advanced level class in the File-Based category.) If you have successfully completed some of these certificate classes through the UMSL Computer Education & Training Center in the 24 months prior to completing your application, they may be applied to this certificate. You can list these classes on your application form. Granting approval for these classes depends on verification of satisfactory completion of each class. Previously taken classes can be applied to only one specialized certificate.

  • Registration is on a first-come, first-served basis; submitting the application and paying the fee doesn’t guarantee a seat in any class.
  • You do not have to be enrolled in the certificate program to take these classes.
  • You also receive CEUs for successful completion of each class. Students completing the Database Technology Chancellor's Certificate receive at least 7.2 CEUs. The hours completed in these classes will also be applied toward the 96-hour Chancellor's Certificate on the Computer. Other certificates are also available.

Classes

Server Based

(minimum 12 hours required)

  • Introduction to SQL
  • Intermediate Applications of SQL
  • Advanced Applications of SQL
  • SQL Programming: Level 1
  • SQL Programming: Level 2
  • Fundamentals of SQL Using Oracle: Level 1
  • Fundamentals of SQL Using Oracle: Level 2
  • Fundamentals of SQL Using Oracle: Level 3
  • Oracle Programming Using PL/SQL: Level 1
  • Oracle Programming Using PL/SQL: Level 2
  • Introduction to SQL Reporting Services
  • Introduction to SQL Server Analysis Services
  • Introduction to SQL Server System Administration
  • Intermediate SQL Server System Administrationn
  • Advanced SQL Server System Administration
  • Intermediate Applications of ASP .NET Using VB .NET
  • Introduction to ColdFusion
  • Intermediate Applications of ColdFusion

File Based

(minimum 36 hours required, including at least one advanced level course)
  • Introduction to Access
  • Intermediate Applications of Access
  • Advanced Applications of Access
  • Advanced Topics in Access: Database Design
  • Advanced Topics in Access: Macros
  • Programming Applications of Access: Level 1
  • Programming Applications of Access: Level 2
  • Programming Applications of Access: Level 3
  • Introduction to FileMaker Pro
  • Intermediate Applications of Filemaker Pro
  • Advanced Applications of FileMaker Pro
  • Introduction to Crystal Reports
  • Intermediate Applications of Crystal Reports
  • Advanced Applications of Crystal Reports
  • Advanced Topics in Crystal Reports: Designing Reports
  • Advanced Topics in Visual Basic .NET: Data Access
  • Advanced Topics in Visual C#: Data Access

Electives

(minimum 24 hours required)

Complete 24 additional hours from the classes listed within this certificate. 

For specific course schedules, please visit the CETC Catalog.  For more information, visit our Web site at http://www.cetc.umsl.edu.