
Short introduction to this course. It briefly explains what you can expect.
Short introduction to the fundamentals of SQL. It gives the basic idea what SQL is about without going deep into theory or writing any code (query).
This part covers how to setup an account in the Oracle Cloud, setup a database and connect to it with SQL Developer. After connecting to it, you will import the data I have prepared for you. This is the pre-requisite for all hands-on exercises.
You will learn…
…basic queries consisting of SELECT, FROM and WHERE.
…how you can rename column names and format dates
…how to set conditions in the WHERE clause in combination with AND and OR
…how to use “case” to add additional information based on conditions you define
You will learn…
…how to read and understand relational diagrams.
…how to do aggregations by using the keyword GROUP BY.
…how to join different tables and understand the difference between INNER, LEFT and RIGHT JOIN
…how to divide and conquer by using common table expressions CTEs, also called WITH clause
In this part you will have to combine the fundamentals and advanced techniques you’ve learned so far. You will get up to 3 hints before the solution is revealed.
Final words and advice I have for you on your SQL journey.
Less is More - Learn SQL in This Pragmatic Online Course By Using the 80/20 Approach
Looking to learn SQL without the fluff? This course is designed for business users without any technical skills. Learn real-world SQL fundamentals and techniques quickly and efficiently.
Why This Course?
No-Nonsense Approach: It focuses on what you need to know—no confusing jargon, no extra theory. You’ll get straight to the point, learning SQL in a clear and effective way.
Hands-On Learning: With real-life examples and practical exercises, you’ll be writing and executing SQL queries within minutes.
Immediate Results: This course is designed to get you up and running in hours, not weeks, with skills you can apply immediately in your job or projects.
Flexible & Self-Paced: Learn on your own time, with bite-sized lessons that fit into your schedule.
Key Course Features:
Excel as memory hook, easier to understand SQL concepts
Short, focused lessons that get straight to the point.
Real-World scenarios to apply what you learn.
Simple language, no prior experience needed!
Perfect for Beginners or Busy Professionals
Whether you're a beginner or looking to level up your skills fast, this course is designed for you. Get the SQL essentials you need, without the extra hassle.