Introduction to SQL

Introduction to Structured Query Language (SQL) Course Description

Learn the key concepts of Structured Query Language (SQL), and gain a solid working knowledge of this powerful and universal database programming language.

By the end of this course, you’ll have a solid working knowledge of structured query language. You’ll feel confident in your ability to write SQL queries to create tables; retrieve data from single or multiple tables; delete, insert, and update data in a database; and gather significant statistics from data stored in a database.

Upcoming Sessions

New sessions start every month, so you can sign up anytime. View upcoming session start dates below.

October 16th, 2019
November 13th, 2019
December 11th, 2019
January 15th, 2020

Course Mechanics

Total Course Hours: 24

Duration of Access: 6 weeks

Course Type: Online

You will spend about two to four hours each week completing two engaging lessons in an enjoyable, interactive online learning environment.

Expert instructors develop and lead every course, and you’ll be able to interact with them and with fellow students in lively online Discussion Areas.

Lessons are released every Wednesday and Friday at noon during your session. Upon completing a course with a passing score, you’ll get confirmation of completion from the Savannah Tech Continuing Education department.

Course Outline

Week One

Lesson 01 – Database Basics and Structured Query Language

Wednesday

In the first lesson, you’ll explore the basic structure and history of relational databases. You’ll learn the history of SQL and then review some key terms. Then, you’ll discover what SQL is and how it’s used with a relational database.

Lesson 02 – Filtering and Retrieving Data

Friday

In this lesson, you’ll learn how to use SQL to filter and retrieve data from tables. The lesson will talk about important query terms that allow you to communicate with your database, as well as syntax rules that will help you to create clear and understandable queries while avoiding system generated errors.

Week Two

Lesson 03 – Sorting and Filtering Data

Wednesday

In this lesson, you’ll learn how to use SQL to filter retrieved data. You’ll practice sorting retrieved data using the ORDER BY clause. You’ll be able to sort single and multiple columns, and you’ll know how to specify sort directions such as ascending and descending order. You’ll also learn additional query terms that will help you customize your SQL queries.

Lesson 04 – Calculated Fields and Functions

Friday

Today, you’ll learn how to reformat retrieved data with calculated fields and functions. You’ll also learn how to create alternate names for columns, and you’ll discover the secret behind merging columns with the concatenation symbol.

Week Three

Lesson 05 – Summarizing and Grouping Data

Wednesday

This lesson will show you how to gather significant statistics from data using aggregate functions. You’ll also learn how to use the GROUP BY clause in conjunction with an aggregate function to gather important statistics from a table. Then you’ll find out how to use the HAVING clause in conjunction with an aggregate function to filter groups of data from a table.

Lesson 06 – Working with Subqueries

Friday

This lesson is all about subqueries. You’ll learn how to extract data from multiple tables simultaneously, how to use calculated fields in subqueries, how to use the DATEPART () function in subqueries, and how to use aggregate functions in subqueries. The lesson will then talk about qualification—a technique used to combine a table name with a column name so that there’s no question about which table the column name refers to.

Week Four

Lesson 07 – Creating and Using Table Joins

Wednesday

In this lesson, you’ll learn how to use joins to gather information from two or more tables simultaneously. You’ll learn how to use the inner join, self-join, natural join, and the outer join. Then you’ll become familiar with the term Cartesian product.

Lesson 08 – Inserting, Updating, and Deleting Data

Friday

In today’s lesson, you’ll discover how to manipulate data using the INSERT, UPDATE, and DELETE statements. You’ll learn how to insert partial and complete rows into a table, and how to update information already stored in a table. You find out how to transfer data to a new table, how to transfer data to an existing table, and how to delete rows from a table.

Week Five

Lesson 09 – Table Creation and Maintenance

Wednesday

In this lesson you’ll find out how you can use SQL to create and maintain tables. You’ll learn how to use the CREATE TABLE keywords to create a table and how to use the ALTER TABLE, DROP TABLE, ADD COLUMN, and DROP COLUMN keywords to manipulate the tables themselves. You’ll also find out how to define a primary key, data type, and field size.

Lesson 10 – Creating and Understanding Views

Friday

In this lesson, you’ll learn how and why views are used in SQL. You’ll learn how to create and use views to simplify complex queries, summarize data, and manipulate data stored in tables. The lesson will also teach you how to update and delete a view.

Week Six

Lesson 11 – Understanding Transaction Processing, Constraints, and Indexes

Wednesday

Today, you’ll learn how transaction processing, constraints, and indexes are implemented in SQL. You’ll work through an example that demonstrates how a transaction is created, how constraints are used in the creation of a table, and how indexes are used to improve the performance of a database by optimizing the speed at which queries are processed.

Lesson 12 – Understanding Stored Procedures, Triggers, and Cursors

Friday

In the final lesson, you’ll find out how stored procedures, triggers, and cursors are implemented in SQL. You’ll see how stored procedures are created and executed, as well as how triggers work. You’ll also see how cursors are declared in SQL.

Cost & Payment Options

Cost: $125

Payment Options: Credit & Debit Card payments are accepted online.

Course Requirements

Course Prerequisites:
- You do not have to take any other courses before taking this class.
- Anyone can enroll.
Instructional Material Requirements:
- The instructional materials required for this course are included in enrollment and will be available online.

Hardware Requirements:
- This course must be taken on a PC. A Mac is not compatible.
- You must have working headphones or speakers.

Software Requirements:
- PC: Windows 8 or later.
- Browser: The latest version of Google Chrome or Mozilla Firefox are preferred. Microsoft Edge and Safari are also compatible.
- Adobe Acrobat Reader.
- Software must be installed and fully operational before the course begins. Student will install the required software in the course.

Other Requirements:
- Email capabilities and access to a personal email account.

How To Register

Registration for this course can be completed online in just 5 easy steps.

1. Click the “Register Now” Button below.

2.Click “Add to Cart”.

3. Select a session start date from the drop down menu under Session Date. Click the “Continue to Checkout” button to move on to the Sign In page.

4. Use either Returning Students or New Student to access or create your account. If you are a new student, you will be asked to create an account by creating a username and password and providing your contact information. Select Continue or Continue to Payment Options to move on to the Purchase page.

5. Provide your preferred payment method, confirm your payment, and you’re set!

Registration-Button-for-Continuing-Education

Recommended Courses

Students who enrolled in Introduction to SQL also enjoyed the following courses:

Intermediate SQL

Introduction to Microsoft Access 2016

Introduction to Microsoft Access 2013

Introduction to Database Development

Microsoft Excel – Pivot Tables

Introduction to Crystal Reports

Introduction to Oracle

Introduction to PHP and MySQL

Introduction to Programming

Offered in Partnership with Ed2Go

In partnership with Ed2Go, Savannah Technical College is proud to offer a collection of over 400 online courses for your to chose from. Whether you’re looking for personal enrichment or professional development, these six-week online courses are the perfect way to learn a new skill or enhance your existing ones.