Whether you are a student or teacher of SQL, relational database, or application development, you can use Oracle APEX to greatly enrich your educational experience.
Get hands-on with SQL — it's the best way to learn! Strengthen your résumé with hands-on experience on Oracle, the leading SQL database that businesses, governments, and other employers rely on worldwide.
Once you have your free Oracle APEX Workspace, you are ready to start learning SQL! You can complete assignments, share work with group members, and get results to your teacher. Also, because Oracle APEX runs on a real relational database, work is saved by default, so you can pick up next time wherever you left off.Get Started for Free
Learning SQL and Relational Database
Start by signing in and opening APEX SQL Workshop in your web browser. From there, you can explore database objects (e.g. tables, views, indexes), query data with SQL, and more.
The SQL Workshop in Oracle APEX allows you to create, view, and maintain all of the database objects within your workspace.Getting Started with SQL Workshop
Learning Application Development
Once you are familiar with Oracle APEX and database schemas, start building data centric apps, interactive reports, dashboards, and visualizations.
Oracle APEX is one of the world’s most popular low-code app development frameworks. The APEX App Builder enables you to rapidly create and deploy web apps that look beautiful on mobile and desktop browsers. It frees you from manual UI coding and enables you focus on the data. You can get a taste of APEX development using the included sample app.
The App Builder in Oracle APEX provides all of the functionality to develop your apps, including adding pages, managing shared components, and using Page Designer.Getting Started with App Builder
This site augments your instruction with helpful tools and accelerates learning about SQL databases and Oracle APEX apps. Once you have created a free account, it is easy to give student users and groups access to a live APEX Workspace and Oracle Database schema. Students can utilize these resources from most web browsers.
Teachers also can leverage Oracle's library of training materials to develop course curriculum. These materials cover multiple APEX and database topics. You can focus curriculum on core SQL and relational database or on related areas such as low-code app development, SQL data science, and data visualization.
Setting up your Students
Here are step-by-step instructions your students can follow to sign up for their own workspaces.
- Visit apex.oracle.com
- Click on Get Started for Free
- Click on Request a Free Workspace
- Follow the instructions in the wizard to request your workspace
- Check your email for a message from
If you have not received an email within 5 minutes, check your spam folder. If not go back to Step 3
- Open the email and click on the Create Workspace button
- Click Continue to Sign In Screen
- In the Oracle APEX Sign In page, enter your new password.
Congratulations! You have successfully created your APEX workspace.
Now you need to set up your teacher in your workspace.
- In the Oracle APEX App Builder, click on the toolbar entry for Administration (third icon from the right)
- From the menu, select Manage Users and Groups
- On the Manage Users and Groups page, click Create User
- In the Create User page, enter Username (your teacher's email address),
select Yes for User is a workspace administrator,
enter Password and Confirm Password. Note: Passwords are case sensitive.
Click Create User
- Send an email to your teacher with your workspace name and the teacher's password
You should also sign up for your own environment on apex.oracle.com to use for demonstrations.
Oracle Academy courses are designed to provide students with foundational knowledge and skills. The following list highlights several database related courses that you can use for your own classes.
This course introduces students to basic relational database concepts. The course teaches students relational database terminology, as well as data modeling concepts, building Entity Relationship Diagrams (ERDs), and mapping ERDs.
This course teaches students to analyze complex business scenarios, design and create data models, and create databases using SQL. Oracle SQL Developer Data Modeler and Application Express (APEX) are utilized to provide practical, hands-on, engaging activities.
This course introduces students to PL/SQL, Oracle's procedural extension language for SQL and the Oracle relational database. Participants explore the differences between SQL and PL/SQL and explore how PL/SQL is used to extend and automate SQL in administering the Oracle database.
Application Development Curriculum
This curriculum is designed to introduce students to the design, development and deployment of beautiful, responsive, database-driven applications. The free course content consists of presentations, hands-on labs, and required source files.
This course introduces students to the techniques and tools required to develop database driven web applications. The course teaches students how to design, develop, and deploy beautiful, responsive, database-driven web applications using Oracle Application Express. Oracle Application Express is utilized to provide practical, hands-on, engaging activities.
The hands on labs from this curriculum are also available in markdown format on the Oracle Learning Library repository on GitHub. Note: The presentations are currently being redeveloped into a markdown like format. The APEX Development Team plans to release the presentations together with the hands on labs when the course material is refreshed in the near future.
This same course content is also offered in a hosted interactive form by Oracle Academy, complete with quizzes. Oracle Academy also provides both educator and student curriculum. For more information, please visit Oracle Academy.
Additional Learning Materials
There are also numerous tutorials available to gain even more knowledge and experience building apps.Go to Tutorials
Oracle University Courses
For professionals wanting to learn more about Oracle APEX and Oracle Database, Oracle University provides a series of courses.
This Oracle Application Express Workshop I Ed 2 training teaches you how to quickly and efficiently develop database-centric web applications using Oracle Application Express. Explore implementing security in your applications, managing application navigation, basic validation and debugging techniques used while developing an application in Oracle Application Express.
This Oracle Application Express Workshop II Ed 2 training will build on the knowledge learned in the 5-day Oracle Application Express Workshop I course. You'll examine topics that including learning how to use collections, add dynamic actions, create and customize plug-ins, and create and consume a RESTful Web Service.
In the Oracle Application Express: Administration Ed 2 course, students will learn the different ways in which Oracle Application Express can be installed and will perform a full development environment installation on a multitenant architecture of Oracle Database 12c. They will identify the three options of configuring a web server for Oracle Application Express and will install and configure the Oracle REST Data Services.
Not sure which course to take or which certification to pursue? Looking for on-site options or a custom course? Need help placing an order? Please contact Oracle University Global Sales or call 1.800.529.0165 (905.366.4190 for International).