The database 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.

This certificate is offered by BYU-Idaho, with support and resources from BYU-Pathway Worldwide.

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

This certificate builds into the Applied Technology degree.

This is an advanced certificate. Prior to working on this certificate, you must complete Web and Computer Programming and Technical Support Engineer.

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

Looking Ahead

Potential Employment

General or database programmer

Database designer or developer
Data warehouse

Why choose this certificate?

Studying in this field will prepare you to develop and maintain database programs, which are central to business information systems. You will work with systems that provide file creation as well as data entry and query functions.

BYU-Pathway has found that certain combinations of certificates lead to better job opportunities. Most degrees have a recommended plan of certificates that will help students increase their income and improve their employment possibilities.