Oracle SQL Developer is an Integrated development environment for working with SQL in Oracle databases.
- Worksheets 01 -> done ☑️
- Worksheets 02 -> done ☑️
- Worksheets 03 -> done ☑️
You can find the online documentation of the Oracle Database under docs.oracle.com/en/database/
Some of the examples that you see within this repository can be executed in the free web-based tool: LiveSQL.oracle.com.
LiveSQL is also an excellent resource for getting started with Oracle Database.
If you would like to challenge yourself, you can take quizzes, workouts and classes at DevGym.oracle.com
We are here using basic SQL syntax to show how our DB works.
CREATETABLEstudents ( contact_id NUMBER(10) NOTNULL, last_name VARCHAR2(50) NOTNULL, first_name VARCHAR2(50) NOTNULL, address VARCHAR2(50), city VARCHAR2(50), uni_assignment VARCHAR2(50), CONSTRAINTstudents_pkPRIMARY KEY (contact_id) ); 
You can create and provision tables in Oracle DB using PL/SQL syntax for more advanced needs.
If you enjoyed this gist, feel free to fork and share it! Thanks.