Scholarship Opportunity
PGCC has partnered with the PepsiCo Foundation to support Black and Hispanic students through the Uplift Scholarship program. See if you qualify!
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 will learn how to develop logical and comprehensive approaches to defining the anticipated outcomes/needs and will plan and design functional and efficient databases.
The Oracle Database SQL Certified Associate and the Oracle Database Administration Certified Specialist will give you the complete set of skills that DBAs need today in the competitive marketplace. As an SQL Certified Associate, you can work as an application developer, and as an Administration Certified Specialist, you can work as a junior DBA. Those two professional certifications allow you to manage large databases and develop large-scale database applications.
Course Descriptions
The course below will be taught in an Online* or Remote** learning environment.
TEC-526: Oracle Database SQL
In this course, you will learn the fundamentals of SQL using Oracle Database Technology. The course provides knowledge and skills in manipulating, restricting, and sorting data; using single, group, and conversions functions; using set operators; using subqueries; controlling user access; managing schema objects; and many more. This course prepares you for the Oracle Database SQL 1Z0–071 (or current exam) to earn Oracle Database SQL Certified Associate certification, which is a first step to other Oracle certifications.
$336* (includes $100 lab fee).
Fall 2024 Session
13820 | 9/9 - 10/15 | 6:30-9:30 p.m. | Mon | Remote
Spring 2025 Session
15681 | 1/27 - 3/24 | 6:30-9:30 p.m. | Mon | TBA
TEC-531: Problem-Solving with Databases: MOS Access
This course teaches students to create, manage, and modify databases using tables, queries, forms, and reports. Advanced features include the use of sub-forms, PivotTables, and macros. Using Microsoft Access, students construct various tables, relationships, queries, forms, and reports to solve financial, statistical, and logical problems. Course meets concurrently with credit course INT-2150. This course prepares you for the Microsoft Office Certification Exam (MOS) exam in Access. Students must purchase an exam voucher through Certiport to take the exam.
$420* (includes a $150 lab fee).
Fall 2024 Sessions
11916 | 10/15 - 12/6 | Online
11917 | 8/26 - 12/11 | 10:00 a.m. - 12:45 p.m. | Mon/Wed | Remote
Spring 2025 Sessions
15442 | 1/27- 5/12 | 10:00 - 11:40 a.m. | Mon/Wed | CAT TBA
15443 | 1/27- 3/17 | 6:00-9:40 p.m. | Wed | Remote
15444 | 2/3 - 4/21 | Online
TEC-533: Fundamentals of Database Management-Oracle Certified Professional
In this course, students will gain a solid foundation in the fundamental concepts of relational database management. Students are introduced to database architecture, data migration and recovery, high availability techniques, database performance tuning, and basic database security tasks. They will learn to install and configure relational database server and run queries to retrieve data. Upon completing this course, students will be prepared to take Oracle's MySQL Database Professional exam, IZO-888 (or current exam), to become an Oracle Certified Professional. This course is cross-listed with INT 2080.
$420* (includes a $150 lab fee).
Fall 2024 Session
11920 | 8/26 - 10/6 | 6:00 - 9:40. p.m. | Mon | CAT 305
Spring 2025 Session
11920 | 1/27 - 3/17 | 6:00 - 9:40. p.m. | Mon/Wed | Remote
TEC-534: Oracle Database Administration 19C
This course is designed for entry-level database administrators, data warehouse administrators, support engineers, technical administrators, and database engineers. It provides instruction on Oracle Database administration and prepares students for Certification Exam 1Z0–912 (or current exam) Oracle Database Administration Specialist. Topics include how to install and maintain Oracle Database 19c instances and how to create an operational database and properly manage the various structures effectively and efficiently using performance monitoring, database security, user management, and backup/recovery techniques.
$336* (includes $100 lab fee).
Fall 2024 Session
12194 | 11/4 - 12/9 | 6:30 p.m.-9:30 p.m. | Mon | Remote
Spring 2025 Session
12194 | 11/4 - 12/9 | 6:30 p.m.-9:30 p.m. | Mon | Remote
Online
Learning on your own time
Students taking an online class can access course content 24 hours a day, seven days a week, and have discussions with their instructors and fellow learners using Canvas. Deadlines and due dates will be set for assignments, tests, projects, and the like.
**Remote
Learning in real time
Students who take a remote class will meet online via Zoom in your Canvas course at scheduled times with set deadlines and due dates. Students will also access learning materials, assignments, and participate in discussions via Canvas.
*Visit Owl Link to see our course options online.
Contact Information
Phone: 301-546-0873
Email: itcerts@pgcc.edu