Loading...

Course Description

Discover how to write powerful SQL queries that enable you to retrieve data from one table or from multiple tables stored in the database simultaneously. In this course, you will learn how to retrieve more meaningful data from one or more tables stored in a database. You will learn how to merge data from multiple columns, how to create calculated fields, and how to order and group the results from a query. You will also learn how to create a single join query or subquery to obtain data from multiple tables simultaneously.

Note: This course is part of a Digital Badge for those who wish to earn a credential. You may register for this individual class, but if If you would like to earn the Digital Badge, register for LRN0164- Online Self-Paced SQL Digital Badge.

Course Outline

Unit 5

Creating Calculated Fields and using Aggregate Functions

Structured Query Language Review

Creating calculated fields

Concatenating columns

Using aggregate functions

Unit 6

Using Clauses in Structured Query Language

Using the ORDER BY clause

Using the GROUP BY clause

Using the GROUP BY clause and WHERE clause

Using the HAVING clause

Unit 7

Creating Table Joins

Creating Inner joins

Creating Outer joins

Creating Self joins

Unit 8

Creating Subqueries

Creating subqueries

Creating subqueries that contain calculated fields

Creating subqueries that contain aggregate functions

About Your Instructor:

Dr. Cecelia Allison is an experienced software tester and technical specialist with more than 15 years of hands-on experience using and teaching SQL. She is also a technical writer, a published author, and a university professor. She holds a Bachelor of Science in finance, a Master of Science in information systems and a Doctor of Business Administration in management information systems.

Learner Outcomes

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.

Notes

Course Objectives

Create calculated fields and implement aggregate functions.

Use clauses in structured query language.

How to create table joins.

How to create subqueries.

Related Course Recommendations

Requirements:

- Windows 8 or later. Macs are not compatible.

- Necessary rights (local administrative rights) to install programs on the computer.

Applies Towards the Following Digital Badges

Loading...
Enroll Now - Select a section to enroll in
Section Title
Intermediate SQL
Type
Online-Self Paced
Dates
Mar 04, 2024 to Mar 29, 2024
Contact Hours
16.0
Course Fee(s)
Tuition non-credit $245.00 Click here to get more information
Section Notes

Requirements:

- Windows 8 or later. Macs are not compatible.

- Necessary rights (local administrative rights) to install programs on the computer.

For further information on this course, please contact dlanpher@harpercollege.edu.

 

Section Title
Intermediate SQL
Type
Online-Self Paced
Dates
Apr 01, 2024 to Apr 26, 2024
Contact Hours
16.0
Course Fee(s)
Tuition non-credit $245.00 Click here to get more information
Section Notes

Requirements:

- Windows 8 or later. Macs are not compatible.

- Necessary rights (local administrative rights) to install programs on the computer.

For further information on this course, please contact dlanpher@harpercollege.edu.

 

Section Title
Intermediate SQL
Type
Online-Self Paced
Dates
Jul 01, 2024 to Jul 26, 2024
Contact Hours
16.0
Course Fee(s)
Tuition non-credit $245.00 Click here to get more information
Section Notes

Requirements:

- Windows 8 or later. Macs are not compatible.

- Necessary rights (local administrative rights) to install programs on the computer.

For further information on this course, please contact dlanpher@harpercollege.edu.

 

Required fields are indicated by .