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.

Course Title

Course Number

Credits

Prior Learning Credit
Eligibility Options

Oracle Database Administration

10-152-165

3

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

3

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

3

[Test](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

3

[Test](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