SQL Server Beginner Course - Schoolhouse Teachers

SQL Server Beginner Course

Length: Eighteen weekly lessons
Includes: Printable lessons with activities
Age/Grade: Middle-High School

Print a Certificate of Completion

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.

Course Introduction

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.

Course Outline

Week 1:

  • 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

Week 2:

  • 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

Week 3:

  • Data Types
  • More practice on creating tables, inserting, deleting, and updating data

Week 4:

  • 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

Week 5:

  • What is data normalization?
  • In the database world, what are relationships?
  • Create a Database with Multiple Tables with Relationships (keys)

Week 6:

  • How do we retrieve data if it is in multiple tables?
  • Selecting Data from Multiple Tables with JOIN

Week 7:

  • Inserting, Deleting, and Updating Data from/into Multiple Tables

Week 8:

  • The Database Diagram—Viewing Relationships
  • More complex SELECT queries with JOINS

Week 9:

  • Mid-term practice project: create multiple tables with relationships, insert, update and delete data, retrieve data with select statements – Creating the Homeschool Tracker program

Week 10:

  • Review

Week 11

  • Using Date and Time in Tables – Inserting, Updating, Deleting, and Querying

Week 12:

  • Using Math, Calculations, and Logic in Tables (aggregating), Part I

Week 13:

  • Using Math, Calculations, and Logic in Tables, Part II

Week 14:

  • Basic Administrative Tasks

Week 15:

  • Backing Up Our Database
  • Restoring from a Backup

Week 16:

  • Final project – Finish our Homeschool Tracker database

Week 17 and 18:

  • Overview of Intermediate to Advanced SQL concepts–Stored Procedures, Triggers, Indexes

Transcript Information

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.

Are you enjoying this course? Why not tell your friends about it? Become an affiliate, share your personal link and graphics with your friends, and earn money. Click Here to find out more about our affiliate program.
We love hearing from our members as to what classes they or their students enjoyed. Please share some feedback with us so we can make this the best homeschooling curriculum site ever!
Do you enjoy teaching? How about writing? Click here to find out how you can use your talents and abilities to serve your fellow members of SchoolhouseTeachers.com.