ICT Database Essentials

8 Hours / Access Length: 12 Months / Delivery: Online, Self-Paced

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 Requirements:
  • Cable and DSL internet connections are recommended for the best experience.
Hardware Requirements:
  • CPU: 1 GHz or higher
  • RAM: 2 GB or higher
  • Resolution: 1280 x 720 or higher
  • Speakers / Headphones
  • Microphone (Webinar / Live Online sessions)
Operating System Requirements:
  • Microsoft Windows 7 or 10 (Home, Pro)
  • Mac OSX 10 or higher.
  • Latest Chrome OS
  • Latest Linux Distributions

NOTE: While we understand that our courses can be viewed on Android and iPhone devices, we do not recommend the use of these devices for our courses. The size of these devices do not provide a good learning environment for students taking online or live online based courses.

Web Browser Requirements:
  • Latest Google Chrome is recommended for the best experience.
  • Latest Mozilla FireFox
  • Latest Microsoft Edge
  • Latest Apple Safari
Basic Software Requirements (These are recommendations of software to use):
  • Office suite software (Microsoft Office, OpenOffice, or LibreOffice)
  • PDF reader program (Adobe Reader, FoxIt)
  • Courses may require other software that is denoted in the above course outline.