Database Design Management

classroom technology

The people responsible for developing and managing databases are called database administrators. Database management is among the fundamental processes in the software field of computing. Students who choose this field of study will learn how to develop logical and comprehensive approaches to defining what the anticipated outcomes/needs are and will plan and design functional and efficient databases.

DPR-732 Introduction to Database Management     7.5 CEUs
This course will cover data management techniques using Microsoft Access.  Topics include Fundamentals of database design and programming with emphasis on relational file processing. Meets concurrently with credit course INT-2150. For the online version of this class visit www.pgcconline.com for details. Students must have an Owl Link account and a college e-mail address. Text required.  This course prepares your for the Microsoft Office Certification (MOS) Exam in Access 2016.  Students must purchase an exam voucher through www.certiport.com to take the exam.
29 sessions, $500* (includes a $200 lab fee)

30881   1/22 - 5/14 Online Online
26038 W 1/24 - 5/9 6:00 pm - 9:40 pm CAT 215

DPR-706 SQL Fundamentals     1.8 CEUs
This course introduces students to the fundamentals of SQL using Oracle Database Technology. Students learn concepts of relational databases, write queries against single and multiple tables, manipulate data in tables, and create database objects. This class will prepare you for the Oracle Database 11g: SQL Fundamentals Exam 1Z0-051. Prerequisites: Before taking this course, you should have a basic understanding of your computer's operating system. For example, you should know how to launch an application, create and save files, copy files from CD and other media. You should have some familiarity with data tables and basic knowledge of how to create queries in Microsoft Access. Textbook: Database Systems Using Oracle, (2nd edition) by Nilesh Shah.
6 sessions, $270* (includes a $95 lab fee)

27266 M 1/29 - 3/11 6:30 - 9:30 pm Laurel College Center

DPR-864 SQL Fundamentals II     1.8 CEUs
This course will prepare you for the Oracle Database 11g:  Administration I 1Z0-052 exam.  This class will give you the knowledge on how to set up database environments and secure Oracles instances in any network environment, understanding database backup and recovery, Oracle Database Architecture, as well as configuration of security instances.  This is the final class needed to become and Oracle Certificate Associate (OCA).
6 sessions, $270* (includes a $95 lab fee)

29177 M 4/02 - 5/7 6:30 - 9:30 pm Laurel College Center