Courses Tech Library
About Contact

Oracle Mastery

Have you ever written an Oracle query that worked, but felt like there must be a better way?

Most of us learn the basics of SQL and stop there. But Oracle has a lot of features that can replace several queries, or a chunk of application code, with one clear statement.

Oracle Mastery builds on what you already know and shows you those features step by step, with exercises along the way, so you can become the go-to Oracle person in your team.

You'll be able to:

  • Group your data in exactly the combinations you want, using GROUPING SETS, CUBE and ROLLUP
  • Use window functions with frames and window clauses to rank results and refer to other rows
  • Pivot and unpivot data, and write nested and recursive CTEs, using both the Oracle-specific and standard SQL methods
  • Store, query and filter JSON data, and use lateral joins
  • Choose the right Oracle data types, and understand the pros and cons of each
  • Work with transactions, locks and deadlocks, so you're ready for what happens in a real system

What's included

  • 8 modules and 52 short video lessons (about 5 to 10 minutes each)
  • SQL scripts for every lesson, so you don't need to type them from the video
  • Exercises PDF with all the exercises in the course
  • The complete course as a PDF for offline reading and reference
  • Lifetime access, plus a comments section to ask me questions

"In my pursuits of capturing a reliable and coherent source for specific Oracle based knowledge, I have kissed a many frogs. I say this loud and without anyone persuading me, that Database Star is the finest, most lucid, considerate learning source that I have ever experienced." Mike I

"I like the format and the way the material is presented, with short videos and then an opportunity to practice what is learned in the short videos." Mary Ann R

30-Day Money Back Guarantee

If you're not happy with the course, let me know within 30 days of purchasing and I'll refund the full purchase price.

Frequently Asked Questions

How much SQL should I know first?

You should be comfortable creating tables, writing SELECT, INSERT, UPDATE and DELETE statements, using WHERE, GROUP BY, HAVING and ORDER BY, and joining tables. If you've completed SQL Simplified, this is the next step.

What software do you use?

I use the SQL Developer extension for VS Code with an Oracle database on my computer. You can use SQL Developer or any other editor, because everything shown is SQL.

Is this for other databases too?

The syntax and examples are all for Oracle. Some concepts apply to other databases, and I have separate Mastery courses for SQL Server and PostgreSQL.

My team doesn't use Oracle. Will this help me?

You probably won't use it much in your current role. But it builds skills you can take into future roles, and you'll be ready if your team starts using Oracle.

I don't have much time. Will I get through it?

The lessons are short, you get everything as soon as you enrol, and you keep access for life. The course PDF is there to refresh your memory when you need a feature weeks or months later.