Oracle-SQL

Oracle SQL Developer is an Integrated development environment for working with SQL in Oracle databases.

Year 3 semester 1 DS module Worksheets

• Worksheets 01 -> done ☑️
• Worksheets 02 -> done ☑️
• Worksheets 03 -> done ☑️

Documentation

You can find the online documentation of the Oracle Database under docs.oracle.com/en/database/

LiveSQL

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.

Dev Gym

If you would like to challenge yourself, you can take quizzes, workouts and classes at DevGym.oracle.com

Basic SQL syntax

We are here using basic SQL syntax to show how our DB works.

CREATE TABLE students 
  ( 
     contact_id     NUMBER(10) NOT NULL, 
     last_name      VARCHAR2(50) NOT NULL, 
     first_name     VARCHAR2(50) NOT NULL, 
     address        VARCHAR2(50), 
     city           VARCHAR2(50), 
     uni_assignment VARCHAR2(50), 
     CONSTRAINT students_pk PRIMARY 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.