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