Take your SQL query skills to a new level by learning how to write more advanced SQL queries for enhanced decision making. In this course, you will learn how to write advanced subqueries, advanced join queries, and UNION queries that query more than one table. You will learn how to use transaction processing to ensure SQL statements execute completely or not at all and how to create stored procedures that enable you to store SQL statements for execution.
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 Advanced Subqueries
Structured Query Language Review
Using the IN keyword to link queries
Using the EXISTS keyword to link queries
Using the ANY keyword to link queries
Using the ALL keyword to link queries
Creating Advanced Joins
Creating inner joins review
Creating outer joins review
Creating joins with aggregate functions
Creating nested joins
Creating Union Queries
Creating UNION queries
Creating UNION ALL queries
Creating a WHERE clause and multiple UNION queries
Transaction Processing, Stored Procedures, Triggers
Implementing transaction processing
Implementing stored procedures
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 advanced SQL subqueries.
Be able to create advanced SQL join queries.
Learn how to create union queries in SQL.
Discover how transaction processing, stored procedures, and triggers are implemented in SQL.
- Create advanced subqueries
- Create advanced join
- How to create union queries
- How to implement transaction processing, stored procedures, and triggers
- 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.