How to Use This Course
This one-semester course is designed to teach 6th-12th graders about relational databases and SQL (Structured Query Language). We will start with the basics of what relational databases are and how they are used in the real world then move through what SQL is, how to create a database and tables, how to insert and manipulate data, and how to query for data. We’ll even create a couple of useful database projects along the way.
This is a one semester course designed to teach 6th-12th graders about relational databases and SQL (Structured Query Language). We will start with the basics of what relational databases are then move through how to create a database and tables, insert and manipulate data, query for data, and create a couple of useful database projects.
By the end of the course, you will have a useful Homeschool Tracker Database and will have viewed about half of a training series from Microsoft® that is part of Microsoft’s Database Fundamentals Certification.
We will be using Microsoft’s SQL Server Express for this lesson. It is a free version. You will need a computer running Windows. Click this link to read more about PC and software requirements to run SQL Server: https://msdn.microsoft.com/en-us/library/ms143506(v=sql.120).aspx.
Students will need to have basic computer proficiency, experience installing software, experience with office applications like Word documents and spreadsheets, and ability to safely use the Internet.
- What is a database? How is a database used (practical/real world)?
- What is a relational database?
- What is SQL? What is it used for?
- Install SQL Server Express
- How to Create a Database and Tables
- How to Insert Data into a Table
- How to Delete Data from a Table (includes real world example of using a test database before running commands on a live, production database)
- How to Update Data from a Table
- Data Types
- More practice on creating tables, inserting, deleting, and updating data
- Retrieving Data – How do you get and display data from a database?
- The SELECT Statement – a basic select from one table
- SELECT Statements with WHERE and BETWEEN
- What is data normalization?
- In the database world, what are relationships?
- Create a Database with Multiple Tables with Relationships (keys)
- How do we retrieve data if it is in multiple tables?
- Selecting Data from Multiple Tables with JOIN
- Inserting, Deleting, and Updating Data from/into Multiple Tables
- The Database Diagram—Viewing Relationships
- More complex SELECT queries with JOINS
- Mid-term practice project: create multiple tables with relationships, insert, update and delete data, retrieve data with select statements – Creating the Homeschool Tracker program
- Using Date and Time in Tables – Inserting, Updating, Deleting, and Querying
- Using Math, Calculations, and Logic in Tables (aggregating), Part I
- Using Math, Calculations, and Logic in Tables, Part II
- Basic Administrative Tasks
- Backing Up Our Database
- Restoring from a Backup
- Final project – Finish our Homeschool Tracker database
Week 17 and 18:
- Overview of Intermediate to Advanced SQL concepts–Stored Procedures, Triggers, Indexes
If this course is taken in full, completing all reading assignments and projects, and the student spends approximately one hour a day for eighteen weeks, it can count for one-half high school credit.