Free developer resources to help you get started with Oracle Database

July 16, 2021 | 4 minute read
Chris Saxon
Developer Advocate
Text Size 100%:

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 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

This 10-part course continues where Databases for Developers: Foundations left off, taking you further on your SQL journey. It covers many data manipulation methods, including:

  • Sorting data
  • Getting running totals
  • Converting rows to columns
  • Hierarchical queries

As with Foundations, each module includes a video, interactive tutorials, and quizzes to test you.

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 Database

Oracle Cloud Free Tier

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

  • 2 Autonomous 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 Database 23c Free.

Oracle Database 23c Free is the same, powerful Oracle 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 Database 23c 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 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

Oracle Application Express (APEX) is a low-code development environment. 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 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.

Twitter

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

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

Summary graphic

List of free database resources provided by Oracle

Chris Saxon

Developer Advocate

Chris Saxon is an Oracle Developer Advocate for SQL. His job is to help you get the best out of the Oracle Database and have fun with SQL!

To help you with this he blogs at All Things SQL. He also creates videos combining SQL and magic on YouTube at the The Magic of SQL.

If you have questions about working with Oracle Database technology, please reach out to him. You can do this via Twitter or on Ask Tom.


Previous Post

How to generate days, weeks, or months between two dates in Oracle Database

Chris Saxon | 25 min read

Next Post


How to split comma separated value strings into rows in Oracle Database

Chris Saxon | 10 min read