LRN0183 - 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 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
- SQL Digital Badge : SQL Digital Badge