Database Fundamentals
Course
Course
IT Fundamentals
Grade Levels
Grade Levels
8
9
Duration (hours)
Duration (Approx hours)
10
Already have a Canvas account? Log In
Overview
In this unit, students will examine the importance of databases. They will explore database structures, concepts, and purposes while exploring different methods of interacting with them
Standards
CompTIA IT Fundamentals (FC0-U61) Objectives 5.1 – 5.3
Cyber Connections
Coding/Programming
Networks and Internet
Section Title
Lessons
Accordion Items
Title
5.1 – Explain database concepts and the purpose of a database
Content
- Usage of database
- Create
- Import/input
- Query
- Reports
- Flat file vs. database
- Multiple concurrent users
- Scalability
- Speed
- Variety of data
- Records
- Storage
- Data persistence
Title
5.2 – Compare and contrast various database structures
Content
- Structured vs. semi-structured vs. non-structured
- Relational databases
- Schema
- Tables
- Rows/records
- Fields/columns
- Primary key
- Foreign key
- Constraints
- Non-relational databases
- Key/value databases
- Document databases
Title
5.3 – Summarize methods used to interface with databases
Content
- Relational methods
- Data manipulation
- Select
- Insert
- Delete
- Update
- Data definition
- Create
- Alter
- Drop
- Permissions
- Database access methods
- Direct/manual access
- Programmatic access
- User interface/utility access
- Query/report builders
- Export/import
- Database dump
- Backup