ICT Essentials Suite

Database Essentials
- Communication Technology Domain -

ICT Database Essentilas

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 Table of Contents

Lesson 1: What is a Database?

Lesson Sections

  • Introduction to Databases
  • Database Applications
  • Big Data

Suggested activity

  • Developing Database Queries (Team)

Lesson 1 Quiz

Lesson 2: Designing a Database

Lesson Sections

  • Database Basics

Suggested activity

  • Relational Databases: In Depth (Hands-on)

Lesson 2 Quiz

Lesson 3: Creating and Managing Database Tables

Lesson Sections

  • Creating, Editing and Sorting Database Tables
  • Working with Records

Demonstration video

  • Creating a Database

Suggested activities

  • Creating a Database (Hands-on)
  • Access It! (Hnds-on)
  • Access It! (Online)

Lesson 3 Quiz

Lesson 4: Manipulating and Sharing Data in a Database

Lesson Sections

  • Troubleshooting Common Database Errors
  • Creating Database Queries
  • Creating Table Joins
  • Importing and Exporting Data
  • Creating Database Reports

Demonstration videos

  • Creating a Query Using the Query Wizard
  • Creating an Update Query
  • Joining Tables
  • Exporting Data from Access
  • Importing Records
  • Creating a Report

Suggested activity

  • Creating a Database Query (Hands-on)
  • Creating a Multi-Table Query (Hands-on)
  • Database Vocabulary Crossword (Hands-on)
  • Creating a Database Report (Hands-on)
  • Access Terms (Online)
  • Access Tables & Queries (Online)

Case Study

  • Growing a Business

Lesson 4 Quiz

Close Window
Previous
Next