Learn SQL with these free courses

Oracle Dev Gym has many classes to help you learn Oracle technology. All the classes include a free certificate of completion.

Databases for Developers: Foundations

Learn SQL in this FREE 12-part class. It covers the basics of SQL in Oracle AI Database, teaching you how to:

  • Create tables
  • Query and join tables
  • Add, change, and remove rows with insert, update, and delete

The course is a series of videos to teach you database concepts, interactive SQL tutorials, and quizzes to reinforce the ideas.

Databases for Developers: Next Level

Databases for Developers: Performance

Once you’ve mastered writing SQL, the next step is to learn how to make it fast. This class teaches you the basics of optimizing SQL. It shows you how to:

  • Get and read execution plans to understand how the database processes SQL
  • Make statements faster by creating indexes and materialized views
  • Find slow SQL

With a range of other tuning techniques, this class will start you on the path to being a SQL tuning expert. It follows the winning formula of videos, interactive SQL tutorials, and quizzes to teach you how to tune SQL.

Analytic SQL for Developers

This 6 module boot camp helps you become an expert with Oracle Analytic SQL functions. This course is a deeper dive into analytic functions. It teaches you how the over () clause works and use it to solve problems, including :

  • Rank rows
  • Get running totals
  • Find values from the next or previous row
  • Convert rows to string lists

Each module has a series of videos and quizzes to give you a thorough understanding of each topic.

Free access to Oracle AI Database

Oracle Cloud Free Tier

Oracle’s Always Free cloud services are the perfect way to get started with Oracle AI Database. These give you unlimited access to:

  • 2 Oracle Autonomous AI Databases, 20 GB each
  • Up to 4 instances of Arm Compute
  • 200 GB block volume
  • 10 GB object storage

Oracle Database Free

If you want a local database get Oracle AI Database 26ai Free.

Oracle AI Database 26ai Free is the same, powerful Oracle AI Database that businesses throughout the world rely on. It offers a full-featured experience and is packaged for ease of use and simple download – for free.

With Oracle AI Database 26ai Free you can use up to:

  • 12 GB of user data
  • 2 GB of database RAM
  • 2 CPU threads

This makes it an ideal local environment for you to tinker with Oracle AI Database.

Oracle Live SQL

Live SQL is a free, browser-based SQL client. With Live SQL you can save and share your SQL scripts. You can also access the code library. This has thousands of scripts made by community members and a range of interactive tutorials from Oracle experts.

Oracle Live Labs

To help you get started with Oracle’s cloud services, Oracle LiveLabs has an extensive catalogue of workshops. These tutorials gives you free access to Oracle Cloud tools while you run the lab. With hundreds of workshops to choose from, you can get to grips with Oracle technologies. Whether you’re a developer, DBA, or data scientist, you’ll find labs to help you learn how these work.

Oracle APEX AI Application Generator

Oracle APEX is the world’s most popular enterprise AI application platform, enabling you to build scalable, secure web and mobile apps. Using APEX, developers can quickly develop and deploy compelling apps that solve real problems and provide immediate value.

Request a free workspace on apex.oracle.com to see how fast it is to build complete applications with APEX.

Stay in touch

Ask the Oracle Mentors (TOM)

Founded by Tom Kyte, Ask TOM is a place to get your questions about Oracle AI Database and related products answered by a team of Oracle experts. Submit your questions to the team or join the live Ask TOM Office Hours sessions.

Oracle Developer Community Newsletters

Subscribe to these monthly newsletters to hear about the latest blog posts, videos, and product announcements from Oracle.

X

Keep up-to-date with the latest Oracle news by following these X accounts:

  • @OracleDatabase – The official Oracle Database X channel
  • @OracleDevs – Oracle Developers is a community for developers by developers
  • @SQLDaily – SQL tips every weekday by Oracle Developer Advocates

Summary graphic