Courses

Information Technology

Relational Database Fundamentals

Course Code: 01-05-T928

Databases store and organize data to provide valuable decision making and analysis tools in business.  When building a database there are multiple layers of employees that are using the database for a variety of reasons.  It is essential to incorporate the needs of the users to make the database successful.  An understanding of database structure and function can help facilitate conversations to plan and provide a product that is fully functional for all levels of a business team.

Finding agile solutions in a technical world and delivering technology projects can be difficult, particularly understanding how different technological elements work together towards a solution. This is the recommended second class of the Technical Solutions Delivery Certificate that provides an overview of technological understanding to help in the communication of projects and working relationships.

Class format includes lecture, hands-on exercises, and real-world examples.

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.

Recommended Prerequisite: To be successful in this course, 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.

Competencies Covered: Overall review of technical structure

Intended Audience: This course is ideal for anyone, but especially communications professionals who are involved in the conception of projects. This class is aimed at non-IT professionals to gain an understanding of the IT world.