LEARN SQL
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
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
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:
@SQLDaily - Daily tips on using SQL
I also blog regularly and create YouTube videos about Oracle Database and SQL. Head to the following places to see these:
All Things SQL - A celebration of all that is SQL!
The Magic of SQL - A combination of magic tricks and SQL information
Besides Oracle Database, I enjoy games, quizzes and running:
Practice SQL
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.