With this certificate, you will learn how to design, query and update Microsoft SQL Server and Oracle databases using Structured Query Language (SQL) and other database tools. You’ll also learn about the security, performance and maintenance of databases. In addition, you’ll explore the operation and management of client/server back-end relational databases. These valuable skills will help further your career in today’s business environment.

COURSE LIST

Course list for reference only. Current students please refer to your individualized program plan or see your advisor.
**Outside effort hours are an estimate based on state standards, and may vary from person to person.

Course Title

Course
Number

Credits

Instructional
Hours

Outside Effort
Hours**

Prior Learning
Credit Eligibility
Options

Oracle Database Administration

10-152-165

3Credit

72

90

72 hours in class and estimate 90 hours outside of class. Provides comprehensive training for developing and supporting relational database applications using Oracle database and application development utilities. It also covers maintenance and management of the Oracle environment.

Prereq: Database Servers (10152162) or Data Admin Techniques (10152170)

Data Access for Programmers

10-152-168

3Credit

72

90

72 hours in class and estimate 90 hours outside of class. Provides background in fundamental database concepts, design, documentation, implementation and distribution involving the relational database model. Students will create, query and update relational databases using Structured Query Language (SQL).

Advanced Database Design

10-152-169

3Credit

72

90

[Test](https://www.fvtc.edu/programs/Credit-For-Prior-Learning/Prior-Learning-Credit-Options)

72 hours in class and estimate 90 hours outside of class.

[Credit for Prior Learning Options Available](https://www.fvtc.edu/programs/Credit-For-Prior-Learning/Prior-Learning-Credit-Options)

Expands on the concepts of the Database Fundamentals course. Reviews design techniques and normalization concepts related to creating a database. Introduces the concepts of security planning, performance tuning, analysis, and deployment and maintenance duties.

Prereq: Data Administration Techniques (10152170) or not pursuing a degree

Data Administration Techniques

10-152-170

3Credit

72

90

[Test](https://www.fvtc.edu/programs/Credit-For-Prior-Learning/Prior-Learning-Credit-Options)

72 hours in class and estimate 90 hours outside of class.

[Credit for Prior Learning Options Available](https://www.fvtc.edu/programs/Credit-For-Prior-Learning/Prior-Learning-Credit-Options)

Covers the operation and management of client/server back-end relational databases. Topics include data definition language, table modification, creating views, indices, triggers, transactions, backup and recovery.

Prereq: Must earn a C or better in Data Access for Programmers 10152168