The University is no longer accepting applications to this program.

Certificate Program in Database Management Technologies

Please Note: UMass Lowell is phasing out the Database Management Technologies Certificate program. Students who are matriculated into the certificate program will have an opportunity to complete the program under certain conditions. Please contact the coordinator T. Michael Cummings by email at Thomas_Cummings@uml.edu for further information.

The Database Management Technologies Certificate program, as part of Oracle Corporation's Academic Initiative (OAI), prepares students for the requirements and rigors of becoming an in-demand Database Administrator or Developer. Centered on the industry-leading Oracle 11g/12i™ product suite, students engage in a progressive learning experience. Hands-on skill building throughout the program will prepare students for challenging and highly rewarding positions in today's data-driven industry. In addition to preparing for Oracle Professional Certification, students may apply all courses towards a degree in Information Technology. Whether pursuing an academic degree, a certificate or both, our Oracle-certified faculty will help students gain valuable technical skills as a marketable enhancement to their overall academic program of study. Students choose three electives from either the Developer or Administrator Tracks, depending upon their specific area of interest.

Curriculum Outline

- Required Courses: 4
- Electives: 3

Speak with an Advisor

Our Student Support Staff are available to help you with your questions! Email Continuing_Education@uml.edu for assistance, or call for advising at (800) 480-3190 and press 1 to speak with an advisor. See links at the bottom of this page for technical assistance with your online course.

View Our Current Courses

For More Information

- For additional information on any of our programs, call Online and Continuing Education at (978) 934-2474 or email Continuing_Education@uml.edu .
- For information on Financial Aid, call the Financial Aid Office at (978) 934-4220.

Gainful Employment Disclosure Information

Completion rates, median loan debts and program costs are outlined in the Graduate Certificate Gainful Employment Disclosure Information.

Course Descriptions

INFO.3040 Introduction to Java Web Development

This course will introduce Java/Java Script, Java Server Face (JSF), Java Serverlet Page (JSP) Web development. Students will utilize a Windows-based development platform configured with Java JDK, JBoss Application Server and Eclipse IDE. Fundamentals of Java and object- oriented programming using the Model View Controller (MVC) web application and application server architectures, Enterprise Java Beans (EJB) and Asynchronous JavaScript and XML (AJAX) programming technologies will be examined. Students will also learn core skills in personalizing websites using sessions, leveraging reusable components, use of JSP tags and development of embedded Java/Java script code into HTML to build interactive web pages. 3 credits. Prerequisite: INFO.2970 Intro to Java Programming

INFO.4430 Introduction to Client/Server Computing

An overview of what Client/Server is all about. The course will introduce the six leading technologies for developing Client/Server applications: database servers, TP (Transaction Processing) Monitors, middleware, groupware, distributed objects, and the Internet. 3 credits. Special Notes:
This course qualifies for free MSDNA software!

INFO.4500 Database Administration I: Introduction to Oracle 11g

This course is designed to give the student an in-depth review of the Oracle DBMS architecture and physical components. The student is also introduced to common DBA skills to set up, maintain, and troubleshoot an Oracle 11g database. Students learn to leverage the 11g architecture to build and configure databases, manage database objects and logical/phsical storage, configuration of Oracle processes and memory, manage user accounts, privileges and roles, and backup recovery strategy. Students also learn database organization including a comprehensive examination of Oracle's data dictionary, space management, table and index segments, undo and rollback segments, logical and physical block sizing, and key dynamic and static parameter files. Progessive hands-on labs utilizing the latest release of Oracle 11g Enterprise Server reinforces key concepts learned. Successful comletion of this course prepares students for the Oracle Database Administration I certification exam and also qualifies as an oracle 10g DBA OCP Hands-On Approved Course. Prerequisite: None. Credits: 3.0 3 credits.

INFO.4530 Database Administration II: Advanced Oracle 11g

Building upon the skills students learned in Database Administration I, this course focuses on advanced concepts of managing enterprise-scale Oracle 11g databases. Students are introduced to advanced concepts used to analyze, troubleshoot, and resolve performance, backup and recovery, and configuration-related problems. Students closely examine Oracle 11g diagnostic, resource and data protection methodologies including interrogating dynamic and static system views, alert log, thresholds and traces, 11g flashback of critical/non-critical data, 11g automatic storage management, 11g automatic shared memory tuning, and 11g data pump import and export utilities. Students will also utilize the 11g Enterprise Manager Database and Grid Control web-based interface to perform advanced database maintenance and configuration Successful completion of this course prepares students for the Oracle Database Administration II certification exam and also qualifies as an oracle 11g DBA OCP Hands-On Approved Course. Prerequisite: 90.450 or related experience. Credits: 3.0 3 credits.

INFO.4540 Oracle 11g SQL Development

This course provides students a practical, hands-on approach to working with the SQL language. Students will learn how to create and maintain database objects such as tables and indexes as well as to store, retrieve, and manipulate data on a host server. Students are introduced to simple and complex queries using standard SQL. Instructor-led hands-on labs utilizing Oracle's 11g Enterprise Database server will reinforce concepts learned throughout the course. This course will aid students in preparation for the Oracle Database Administration I certification exam and also qualifies as an Oracle's 11g DBA OCP Hands-On Approved Course. Prerequisite: None Credits: 3.0 3 credits.

INFO.4550 Database Administration III: Oracle 11g Projects

Designed as a capstone course, students will build upon concepts learned in both Oracle Database Administration I and II. This course focuses on extensive hands- on skills building to enable students to gain practical Oracle Database Administration experience. Utilizing the latest release of Oracle 11g Enterprise Server, students hone their Oracle skills through problem analysis, troubleshooting, and performance and configuration resolutions in a variety of common 'real world' scenarios. Delivered completely via lab-based projects, primary focus is on identification and resolution of common problems involving server and database configuration, database performance, backup/recovery, and networking. This course documents student skills in preparation for employment as an Oracle Database Administrator as well as prepares students to sit for Oracle's Certified Master (OCM) hands-on lab. Prerequisite: 90.450 and 90.453, or instructor permission. Credits: 3.0 3 credits.

INFO.4590 PL/SQL I: Introduction to Oracle 11g PL/SQL

This course will introduce students to the basics of PL/SQL subprograms. Students will learn how to write and invoke PL/SQL procedures, functions and packages. Using Oracle's 11g Enterprise Database Server, students will engage in hands-on lab work in both Oracle's Procedure Builder and SQL*Plus environments. Students will learn how to create and manage PL/SQL program units, database triggers, and common Oracle-supplied packages. This course will aid students in preparation for certification as an Oracle PL/SQL Developer Certified Associate and also qualifies as an Oracle's 11g DBA OCP Hands-On Approved Course. Prerequisite: None Credits: 3.0 3 credits.

INFO.4660 Oracle 11g Data Warehousing

This course introduces students to the fundamentals of Data Warehousing. Upon completion, students should be able to guide a Data Warehousing project and avoid common pitfalls of implementation. The course provides an overview of the topic, comparing and contrasting it to other data management techniques to define how it is implemented and used. The course then drills into the topics that make up a data warehouse: Dimensions, Hierarchies, Facts/Cues, Data Marks and Summary (OLAP) techniques, and ETL. Throughout the course, attention will be given to life-cycle concerns. Case studies of several functional areas will be covered to illustrate particular patterns or techniques. Students will build models utilizing the Oracle 10g database platform. Prerequisite: None Credits: 3.0 3 credits.

INFO.4670 PL/SQL II: Advanced Oracle 11g PL/SQL

This course introduces students to advanced features of PL/SQL used to design and interface with the Oracle 11g database. Students learn the benefits of Oracle 11g powerful extended PL/SQL functionality by exploring and utilizing advanced Oracle-supplied packages, procedures, REF cursors, extended interface methods, PL/SQL block debugging, case statement flows, bulk binds, code tuning considerations, and advanced object types. Students will engage in hands-on lab work using advanced techniques learned throughout the course to design PL/SQL applications that solve today's most complex business problems. This course will aid students in preparation for certification as an Oracle PL/SQL Developer Certified Associate. Prerequisite: 90.459 Credits: 3.0 3 credits. Prerequisite: INFO.4590

INFO.4690 Oracle 11gR2 High Performance and Internals

In this course, students will learn how to use Oracle Database 11g automatic tuning features such as SQL Tuning Advisor, SQL Access Advisor, SQL Monitor, Automatic Workload Repository, Automatic Database, Diagnostic Monitor, Health Monitor, and practice these tuning methods utilizing and Oracle 11gR2 Enterprise database. The course focuses on the tuning tasks expected of a DBA: reactive tuning of SQL statements, maintaining SQL statement performance, and tuning the Oracle Database Instance components. Various Oracle memory internals will be examined including the discovery and usage of key high performance DBMS packages and views, use of the Automatic Diagnostics Repository (ADR) interface, Cost-based optimizer statistics, and memory management, Throughout the course, students practice the art of tuning and internals using an Oracle 11gR2 Enterprise RDBMS through a series of weekly lectures, group discussions and hands-on lab workshops. 3 credits. Prerequisite: INFO 4500,453 Pre-reqs

INFO.4740 Relational Database Concepts

Introduces database directives, design elements of databases, architectures, and commercial databases. Students will participate in design of a large-scale database application and administration of this database. Prerequisite; 90.267 3 credits. Special Notes:
This course qualifies for free MSDNA software!

INFO.4790 Oracle 12i Applications DBA

Building on the fundamentals of database technology learned in 90.450 and 90.453, this course focuses on Oracle DBA roles and responsibilities in an Oracle 12i applications environment. The course closely examines the oracle I2i database architecture focusing on Oracle I2i database software installation, capacity planning, database configuration, database tuning, and upgrade and patching maintenance. Students are exposed to I2i-specific tools such as the Concurrent Manager and Enterprise Manager Console. The course also reviews Oracle I2i application modules used in typical implementations to meet today's business requirements. Prerequisites: 90.450, 90.453 3 credits. Prerequisite: INFO.4500, 90.453.

Certificate Requirements

Students enrolled in UMass Lowell certificate programs must complete all courses, generally consisting of both required courses and electives. Students may complete the certificate program at their own pace, enrolling in one or two courses each semester. Courses on-campus typically meet one night per week, three hours each night, during the Fall and Spring semesters. Online students generally log on to their course site one or more times per week to retrieve lectures and assignments or to participate in a chat session. For more information on online courses, visit our online program home page.

In addition to the Fall and Spring semesters, students may also have the opportunity to accelerate their programs of study during two concentrated six-week Summer sessions. Online courses are also offered during the Summer semester, but typically run from May through August unless otherwise noted. All students should anticipate at least two hours of preparation for every hour of classroom instruction. Students are required to maintain a grade point average of 2.0 or better to receive the certificate.

Certificate Completion

Upon successful completion of the certificate program, students must submit a completed Certificate Petition Form to Online and Continuing Education. Upon verification, students will be mailed their certificates. Receipt of the certificate will be noted formally on the student's transcript with an award date of October, February, or June.

Registration

The Division of Online and Continuing Education offers courses during the Fall, Spring and Summer semesters. Approximately 2 months prior to the start of each semester, we post the upcoming semester course schedule on our website. Once you know which course(s) you would like to take, current students can register using SIS self-service, while new students, who have not already applied and been accepted into the program, must use the Non Degree Registration Form.

You may take courses without being officially enrolled in a certificate or degree program, but you must meet the particular course prerequisites. Registrations are accepted on a first come, first served basis. Class size is limited. We recommend that you register early to reserve your place in class.

If you would like to be notified by email when we post our next semester's course schedule, click here.

For more information, please visit our Registration Information Page.

Tuition

Please refer to our tuition and fees page for up-to-date pricing information or refer to the Online and Continuing Education Course Bulletin each semester.

Transfer Policy

With the program coordinator's approval, one course may be transferred from another accredited institution to satisfy undergraduate certificate program requirements. The course should be equivalent to UMass Lowell instruction, applicable to the intended program, and the student must have received a grade equivalent to a C- (1.70 on a 4.00 scale) or better.

Academic Advising

Program Coordinators and Faculty and Student Support Specialists are available by appointment to help students determine appropriate course loads, discuss admission requirements, and review the transferability of courses. For online advising, email us at Continuing_Education@uml.edu. To schedule an appointment with a Program Coordinator or Faculty and Student Support Specialist, please call Online and Continuing Education at (978) 934-2474. General academic advising is also available at the Faculty and Student Support Center on a drop-in basis, located in Southwick Hall, Room 203 on UMass Lowell North. Call (978) 934-2474 or stop by the office Monday through Thursday between 8:30am-8:00pm and on Friday between 8:30am-5:00pm.

New Students

If you have not already applied and been accepted to the program.
Register with Non Degree Reg. Form

Current Students

If you have applied, been accepted and currently in a program.
Register with SIS self-service

Questions:

Online & Continuing Ed Support:
Email our Student Support Center for assistance, or call for advising at (800) 480-3190 and press 1 to speak with an advisor.

Restrictions

RESIDENTS OF Arkansas, Kansas and Minnesota: State and federal laws require colleges and universities to be authorized to offer online degree programs in states other than their own. Due to these regulations, the University of Massachusetts Lowell is unable to accept applications or registrations for online courses, degrees or certificate programs from residents of Arkansas, Kansas or Minnesota. Current UML students that move their residence to one of these states should contact Catherine_Hamilton@uml.edu in Online and Continuing Education to determine their eligibility to continue their program of study.

Please Note: While every effort has been made to ensure the accuracy of the information presented within this website, the Division of Online and Continuing Education reserves the right to implement new rules and regulations and to make changes of any nature in its program, calendar, locations, tuition, and fees. Whenever possible, appropriate notice of such changes will be given before they become effective. In registering for courses, each student assumes full responsibility for knowledge of and compliance with the definitions, regulations, and procedures for the University as set forth in our Academic Policies & Procedures and on the main UMass Lowell website.

Applying into an Undergraduate Certificate Program

Apply to an undergraduate certificate program using the Online Application Form or by printing and completing the Undergraduate Certificate Application Form in .pdf file format. Applicants will be required to have either their official high school transcript, HiSET®, GED® or their most recent college transcript if applicable, sent to Continuing Education at the address below. Applications, transcripts, and other correspondence should be sent to:

University of Massachusetts Lowell
Division of Online & Continuing Education
OCE Admissions - Southwick Hall, Rm 203
1 University Avenue
Lowell, MA, 01854

Undergraduate certificate applications are accepted on an ongoing basis and there is no fee to apply. Upon acceptance, notification will be sent to students.

Apply Online

Questions Regarding Your Undergraduate Application?

Email OCE_Admissions@uml.edu or call (978) 934-2474.

For General Assistance:

Call the Online and Continuing Education Student Support Center at (978) 934-2474 or (800) 480-3190. Our team of Student Support Specialists are here to help!

Already Applied?

Check the Status of Your Application

Fees

Applications are accepted on an ongoing basis and there is no fee to apply. Upon acceptance, notification will be sent to students.

Restrictions

RESIDENTS OF Arkansas, Kansas and Minnesota: State and federal laws require colleges and universities to be authorized to offer online degree programs in states other than their own. Due to these regulations, the University of Massachusetts Lowell is unable to accept applications or registrations for online courses, degrees or certificate programs from residents of Arkansas, Kansas or Minnesota. Current UML students that move their residence to one of these states should contact Catherine_Hamilton@uml.edu in Online and Continuing Education to determine their eligibility to continue their program of study.