Database Fundamentals

Database Fundamentals

Rating
Average: 4 (1 vote)
Database
Course
Course
IT Fundamentals
Grade Levels
Grade Levels
8
9
Duration (hours)
Duration (Approx hours)
10
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