Chris Saxon
Chris Saxon
Helping You Learn SQL

Developer Advocate

Chris Saxon

Ask me your SQL questions on Ask TOM

chris-headshot.jpg

LEARN SQL

 
 
dfd-title-oa-foundations.png

Databases for developers: Foundations

Learn the basics of SQL in this free 12-part course. In this course you’ll learn:

  • How to create tables

  • Write queries and join tables

  • Aggregate rows with group by

  • Change data with insert, update, delete

 
dfd-title-oa-next-level.png

Databases for developers: next level

Got the basics covered and want to improve your SQL skills? This free 10-part tutorial will take your SQL to the next level. Join this course to learn how to:

  • Write subqueries and deal with null

  • Sort data and run top-N queries

  • Get running totals, convert rows-to-columns, and write hierarchical queries

  • Understand when changes are visible to other users

 
dfd-title-oa-next-performance.png

Databases for Developers: Performance

Learn the basics of SQL performance tuning in this free 10-part class. Join this course to learn how to:

  • Get and read an execution plan

  • Create indexes and materialized views

  • Make inserts, updates, and deletes faster

  • Find slow SQL statements

Howdy!

I'm Chris Saxon, Oracle Developer Advocate in of Gerald Venzl's Oracle Advocate team. I'm also author of the database design quiz on the Oracle Dev Gym.

If you have questions about SQL, please submit them to me on Ask TOM.

For more info on me follow the links below:

I also blog regularly and create YouTube videos about Oracle Database and SQL. Head to the following places to see these:

Besides Oracle Database, I enjoy games, quizzes and running:

 

Practice SQL

 
 
Guess the SQL statement from the clues provided: "fname = 'Al'" and "AND email IS NULL". Choose from the 24 options below to complete it

Guess the sql STATEMENT

SQuizL is a free guess the SQL statement quiz. Every day there’s a new statement for you to figure out from the clues provided. Choose which of the SQL fragments below complete it in six tries or less.

Come back each day for a new SQuizL to solve.

Get In touch

TWitter: @chrisrsaxon