Database

This certificate provides students with basic skills in database design and programing to prepare them for an entry-level job, or internship, in the database field.

Essential Knowledge and Skills

Outcomes

Utilize SQL and Query to communicate with databases
Design a transaction entity relationship model
Work with stored programs in a database
Configure, administer, and performance tune a database
Demonstrate ability to work with a database warehouse and star schema

Certificate of Database

Program Requirements

Certificates lead to associate and bachelor's degrees. For more information about which programs this certificate stacks into, visit the Programs List page.

This is an introductory certificate.

Certificate

15 CREDITS

Associate

60 CREDITS

Bachelor's

120 CREDITS

Certificate of Database

Course Code

Course Name

# of Credits

CIT111

Introduction to Databases

CIT111 — 3 credits

Introduction to Databases

This course covers the basic elements of database management systems. It introduces students to the concepts of logical and physical relationships in a data model and the concepts of inner and outer joins. Students will use a computer aided software engineering (CASE) tool to design, create, and query a database.

CIT225

Database Design & Development

CIT225 — 3 credits

Database Design & Development

The course deals with concepts and principles of database theory, application and management technologies. It focuses on the logical and physical database design and implementation. The course covers the use of UML semantic to describe Entity Relationship Designs (ERDs) and SQL to implement relationships between entities. SQL will be used to query and transact against a sample database.

CIT325

Database Programming

CIT325 — 3 credits

Database Programming

This course teaches the concepts of database programming. It teaches how to write stored functions and procedures inside the database, how to use collections, how to use embedded objects, how to use transaction control mechanics, how to import large comma separated files, and large text files into a database. It explores the uses of the database as a data repository for web-based applications.

CIT326

Database Administration

CIT326 — 3 credits

Database Administration

This course defines the theory and practice of how to manage a commercial relational database management system. Students will learn how to install, configure, and create databases; transact with data; and create operational plans that maintain, backup, and recover database instances.

CIT327

Data Warehousing

CIT327 — 3 credits

Data Warehousing

This course defines the theory and practice of data analysis. The course will compare and contrast the operational and analytical database models. Students will learn how to define, implement, and query a database warehouse by leveraging sample data warehouses built from Enterprise Resource Planning (ERP) and Customer Resource Management (CRM) solutions.

For questions about this program, contact BYU-Pathway Support

Degree Options

Customize your degree

BYU-Pathway degree programs (offered in partnership with and granted from BYU-Idaho) are made up of a series of certificates, general and religious education courses, and electives.

Use the following tool to view options for building a degree.
View descriptions for individual certificates and degrees .

Step 1

Select 1st certificate

Step 2

Select 2nd Certificate

Associate Degree Associate of Applied Business Management Associate of Applied Technology Associate of Applied Health Associate of Family History Research Associate of Marriage & Family Studies Associate of Professional Studies

Step 3

Select 3rd Certificate

Bachelor's Degree Bachelor's of Applied Business Management Bachelor's of Applied Technology Bachelor's of Marriage & Family Studies Bachelor's of Applied Health Bachelor's of Professional Studies

Certificate

Associate

Bachelor's

First Certificate Associate of Family History Research Associate of Applied Business Management Associate of Applied Technology Associate of Marriage & Family Studies Associate of Professional Studies Associate of Applied Health Bachelor's of Applied Business Management Bachelor's of Applied Technology Bachelor's of Marriage & Family Studies Bachelor's of Professional Studies Bachelor's of Applied Health

Certificate

First Certificate

Certificate

Second Certificate

General Education & Elective Courses

Certificate

Third Certificate

General Education & Elective Courses

Bachelor's of Professional Studies

Students who complete an associate degree in family history research may continue on and earn a bachelor's degree in Professional Studies.