Database Fundamentals

Spreadsheets

• Excel

  • Excel Online

  • Learning resources

    • Quick Start Guide

    • Excel video training

    • Microsoft Digital Literacy

      • Working with Computers and Devices

        • 8. Get Started with Excel

  • Certification

    • Office Certification

      • Certiport

  • Sample Data

  • Format as Table

  • Insert chart

• Google Sheets

Databases

• Entity and Schema

  • ER diagrams

  • Schema tutorialspoint

• Database Management Systems

  • Access

    • Template

  • SQL Server

    • Azure Dev Tools for Teaching (download)

    • Azure account

  • MariaDB / MySQL

• Database Query Language

  • SQL

    • w3schools

    • SQL Exercises

    • Hackerrank

• Tasks of DBMS Packages

  • Database development - define and organize the content, relationships, and structure of the data needed to build a database.

  • Database interrogation - accessing the data in a database for information retrieval and report generation.

  • Database Maintenance - add, delete, update, and correct the data in a database.

  • Application Development - develop prototypes of data entry screens, queries, forms, reports, tables, and labels for a prototyped application.

• BLS OOH Database Administrators

  • Database Administrators Career Video

• ModernStates 5. Technology Applications

12. Database Basics and Data Management

12.1. Entity and Schema

12.2. Database Management Systems (DBMS)

12.3. Database Query Language

12.4. Tasks of DBMS Packages

12.5. Data Management

12.6. Data Mining