ICT 128 - Relational Databases Fundamentals

Course Description

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.

Course Details

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.

Course Level Learning Outcomes

• Design a relational database, normalize it and create tables that implement the design
• Apply Structured Query Language (SQL) to query and manipulate data in a relational database as required

Topics of Instruction

• Introductory Concepts of Relational Databases
  • Introduction to SQL
• Data Retrieval with SELECT
• Filtering and Sorting Data Sets
• More Complex Data Retrieval Queries
  • Joining Tables
  • Using Functions
• Data Manipulation with INSERT, UPDATE and DELETE
• Managing Transitions
• Creating Tables
• Managing Data Integrity
• Designing Databases
  • Logical Modelling
  • Normalization
• Introduction to Database Administration
  • Managing Secure Access and Performance

Notes

For the best experience, your computer and internet connection should meet certain requirements. See the recommended requirements...

Proficiencies

This course content is at the beginner level of the subject matter, however computer proficiency is required:

• Students must be familiar with the personal computer, keyboard and mouse.
• Students must have Microsoft Windows Operating systems skills and knowledge, and be able to perform the following tasks:
  • start and run Windows computers
  • use the taskbar, Start button and Help feature
  • use Minimize, Maximize, Restore Down/Up and Close
  • use the left and right mouse buttons appropriately
  • understand file management techniques
  • navigate between files, folders, or drives
  • cutting, copying, and pasting content, files and folders
  • using print screen or snipping tool

Applies Towards the Following Program(s)

• Certificate in .NET Application Development : Optional Courses
• Certificate in Business Intelligence and Analytics : Optional Courses
• Certificate in IT Fundamentals : Core Courses