Back
Certificate
Database
certificate-icon-white.svg

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.

wes-hicks-480398-unsplash-1-840x560.jpg adult-business-computer-1181354-1-600x400.jpg

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-icon-white.svg
Certificate
15 CREDITS
associate-degree-icon-navy3.svg
Associate
60 CREDITS
bachelors-icon-navy4.svg
Bachelor's
120 CREDITS
Certificate of Database
Course Code
Course Name
# of Credits
CIT111
Introduction to Databases
3
CIT111 — 3 credits
x
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
3
CIT225 — 3 credits
x
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
3
CIT325 — 3 credits
x
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
3
CIT326 — 3 credits
x
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
3
CIT327 — 3 credits
x
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
nesa-by-makers-1130758-unsplash-1-600x400.jpg
Looking Ahead
Potential Employment
  • General or database programmer
  • Database designer or developer
  • Data warehouse

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 .

Select a Degree Applied Business Management Applied Health Applied Technology Family History Research Marriage & Family Studies Professional Studies

  • Applied Business Management
  • Applied Health
  • Applied Technology
  • Family History Research
  • Marriage & Family Studies
  • Professional Studies

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

        +
        +

        General Education & Elective Courses

        +
        +

        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.