Relational Databases Fundamentals

This course introduces students to the principles behind designing a well formed relational database management system (RDMS) that optimizes the storage and retrieval of data. In addition, students will learn how to utilize the SQL language for creating, manipulating and securing the various database objects that are used in a RDMS.

A database is a structured collection of information. The data structure is a particular way of storing and organizing the data in a computer so that it can be used efficiently. A Database Management System (DBMS) is a set of computer programs that enables you to store, modify, and extract information from a database, and provides users with tools to add, delete, access, modify, and analyze data stored in one location. Online retailers, grocery stores, and hospitals all rely on the timely input and retrieval of data to maintain daily operations. How the database systems are designed to organize data plays a key role in determining the ease with which relevant and reliable information can be made available to the organization.

This course is designed for those who have little to no prior knowledge or experience with relational databases and want to gain some fundamental skills in an expanding industry. Databases are steadily becoming a vital part of IT as they comprise the backend of websites such as Amazon, Facebook, and university or government sites.