Database Fundamentals – baceu2010 (0 credits)

Organizations keep their business records within databases. To successfully extract information for use in business decisions, it is important to understand how data is structured and stored. In this course, students will learn the general principles involved in designing a database as it applies to a relational database model. Further, students will learn the terminology, data types, and integrity elements of database design and how queries allow data to be extracted from the database. To complete this course, students are required to have access to Microsoft Access software. This course provides 0.8 continuing education units over two 4-hour workshops.

This non-credit course is 2 weeks. To enroll, speak with an Enrollment Representative.

Database Fundamentals

  • Determine the purpose of the database
  • Define the fields for the database
  • Identify what data exists
  • Identify a primary key for each table
  • Examine table relationships
  • Identify how to normalize tables to the first, second, third, and higher normal forms

Data Integrity

  • Examine how to ensure consistent data
  • Identify how to prevent field data errors
  • Understand select queries, calculations queries, and action queries
  • Explore how to test queries to ensure they provide the correct results

Start your journey now

Continue
or call us at866.766.0766

Contact us