LRN0169 - Intermediate SQL
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 sub-query to obtain data from multiple tables simultaneously.
Course Outline
Agenda
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 Sub-queries
- Creating sub-queries
- Creating sub-queries that contain calculated fields
- Creating sub-queries that contain aggregate functions
Notes
Requirements
Make at least one comment every week in the discussion
The comment should show thought and be more substantive than just "Yes, I agree." There is no length required for comments.
Replies to other comments, responses to other participants, count as comments (in most cases your instructor values replies and responses as comments).
Questions and online discussion comments also count as well as long as there is some thought to them.
Take every Unit self-quiz
Take every Unit self-quiz for the course and get at least 80% score.
You may retake any self-quiz as often as you need to get to the 80% level.