Information Technology

Relational Database Fundamentals

Course Code: 01-05-T928

Databases store and organize data providing businesses valuable tools for decision making and analysis.  Often there are multiple layers of employees using the database for a variety of reasons. When building a database, it is vital to consider users’ needs to ensure the database is functional.  This course gives you a foundational understanding of database structure and function. The class format includes lecture, hands-on exercises, and real-world examples.

Finding agile solutions and delivering technology projects can be difficult. It can be especially difficult for a non-IT professional to understand how different technological elements work together. This is the recommended sixth class of the Technical Solutions Delivery Certificate. This certificate provides you with an overview of the programs and systems commonly used in projects so that you can communicate and collaborate effectively with your project team.

Performance Objectives: Upon completion of this course, you should be able to:

  • Define and identify relational databases.
  • Understand the steps in a database design process.
  • Review table design standards, including naming conventions and data types.
  • Describe database relationships and constraints and why they are so important.
  • Normalize database tables to follow best design practices.

Prerequisite: You should be familiar with using personal computers, the mouse, and keyboard. You should be able to use Windows to launch and close programs, navigate to information stored on the computer, and manage files and folders.

Intended Audience: This course is appropriate for anyone, but it is especially ideal for communications professionals engaged in project planning. It equips non-IT professionals with a basic understanding of the IT world.