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 Outline:
Lesson 1: What is a Database?
- Introduction to Databases
- Database Applications
- Big Data
Lesson 2: Designing a Database
- Database Basics
Lesson 3: Creating and Managing Database Tables
- Creating, Editing and Sorting Database Tables
- Working with Records
Lesson 4: Manipulating and Sharing Data in a Database
- Troubleshooting Common Database Errors
- Creating Database Queries
- Creating Table Joins
- Importing and Exporting Data
- Creating Database Reports
