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.
Creating Calculated Fields and using Aggregate Functions
Structured Query Language Review
Creating calculated fields
Using aggregate functions
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
Creating Table Joins
Creating Inner joins
Creating Outer joins
Creating Self joins
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.
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.
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
- 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
Make every day count. Discover your passions. Advance your career. Play and learn.
I started a new job as a graphic and web designer and the digital badge I got was part of the reason they chose to hire me. I couldn't have done it without you!
David is a truly amazing teacher who makes learning the harmonica lots of fun. His enthusiasm is contagious and he has a heart of gold.
The Writing Salon was so much more than a writing class. The experience was energetic, enthusiastic and supportive. I highly recommend this class for anyone who wants to develop their skills as a writer!
As always, your Spanish classes are packed with new information about the language. You make it easy to learn Spanish and keep it very interesting. Thank you!
I have participated in many LLI classes over the past two years. Gary is a terrific discussion facilitator and brings excellent background knowledge to our classes. I'm learning so much about Foreign Policy.
Just want to let you know how much I enjoyed your class. Hope you will have more classes since I am a novice in the wine area and am anxious to learn.