How It Works
Course outcomes
-
Be able to create queries that contain calculated fields.
-
Learn how to use the SQL ORDER BY, GROUP BY and HAVING clause.
-
Understand how to use create SQL table joins and subqueries to query multiple tables simultaneously.
Course objectives
-
Create calculated fields and implement aggregate functions.
-
Use clauses in structured query language.
-
How to create table joins.
-
How to create subqueries.
About Online Learning
How the Course Works
It is easy to participate in your online course. After you register, you will be given a web address to go to get into your online classroom. You will have a password and use your email address and password to gain access. Once inside the online classroom, here's what you can expect.
What You Will Do
For each Unit, you will:
- Access the online readings
- Listen to the audio presentation for the Unit and view the slides
- Take a self-quiz to see how much you have learned
- Engage in written online discussion with your instructor and other participants
For best learning, you should make one or more comments at 2-3 different times each day.
The content (readings, audio lectures, slides) and self-quizzes are accessible for the entire course, so you can work ahead, or go back and review again, at your convenience.
Participate When You Want
You can participate any time of day or evening. The online classroom is open 24 hours a day, 7 days a week. There are no live real-time requirements or meetings. You decide when you participate.
For the best learning, participants should log into the course on 2-3 different days of the week.
Discussion
The Discussion for each Unit lasts one week. All comments are made in writing and can be made at any time of the day or night.
Your instructor will log into the Discussion area at least once a day and answer questions, make comments, and respond to comments by you and the other participants.
We encourage you to make 2-3 comments each day to maximize your learning and enjoyment of the course.