Database Essentials
- Communication Technology Domain -
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
