ICT Database Essentials

Hours: 8 / Access Length: 12 Months / Delivery: Online, Self-Paced
Online Hours: 8
Retail Price: $104.00

Course Overview:

The ICT Database Essentials course focuses on fundamentals of using relational databases.

In this course, students will:

  • Learn about common database components including tables, record and field structures, and data types
  • Learn about queries and how to create them
  • Study data import/export mechanisms
  • Learn the basics of Structured Query Language (SQL) statements for managing and manipulating data
  • Use the skills they have learned to create basic database tables, data queries and data reports

Course Outline:

Lesson 1: What is a Database?
  • Introduction to Databases
  • Database Applications
  • Big Data
Lesson 2: Designing a Database
  • Database Basics
Lesson 3: Creating and Managing Database Tables
  • Creating, Editing and Sorting Database Tables
  • Working with Records
Lesson 4: Manipulating and Sharing Data in a Database
  • Troubleshooting Common Database Errors
  • Creating Database Queries
  • Creating Table Joins
  • Importing and Exporting Data
  • Creating Database Reports

All necessary course materials are included.


System Requirements:

Internet Connectivity

  • Connection Type: Broadband (Cable, Fiber, DSL) or LEO Satellite (e.g., Starlink)
  • Minimum Speed: 10 Mbps download / 5 Mbps upload

Note: While cellular hotspots may allow basic access, high latency and fluctuating speeds can cause disconnects during videos, quizzes, or live sessions. Cellular hotspots are not recommended as a primary connection.

Hardware

  • Processor: Dual-core 2.0 GHz or higher
  • Memory (RAM): 8 GB or higher (4 GB minimum)
  • Display Resolution: 1280 x 720 minimum (1920 x 1080 recommended)
  • Audio/Video: Speakers or headphones; microphone and webcam (recommended for Live Online sessions)

Operating Systems

  • Windows: Windows 10 or Windows 11
  • Mac: macOS 13 (Ventura) or newer
  • ChromeOS / Linux: Latest supported release

Note: While courses may load on iOS and Android devices, phones and small tablets are not recommended. Their smaller screen sizes and mobile browsers do not provide an optimal environment for coursework or live online sessions.

Web Browsers

  • Google Chrome (Latest version — Recommended)
  • Mozilla Firefox (Latest version)
  • Microsoft Edge (Latest version)
  • Apple Safari (Latest version)

Tip: Ensure JavaScript and cookies are enabled, and pop-up blockers are disabled for the learning portal.

Recommended Software

The following software is recommended for viewing and completing general course materials (individual courses may require additional software as noted in the course outline above):

  • Productivity Suite: Microsoft 365/Office, Google Workspace, or LibreOffice
  • PDF Reader: Adobe Acrobat Reader, Foxit PDF Reader, or a built-in browser PDF viewer


** The course outlines displayed on this website are subject to change at any time without prior notice. **