Using Oracle and MySQL to review the basics of SQL and perform: multiple DDL and DML operations, creation of users, permissions, PK, FK, CK, and other basics/complex queries to handle the data. Additionally, I took this course to review the basics of SQL: https://learn.oracle.com/ols/learning-path/mysql-explorer/51871/79674.
•Installation • Structure • Run it • Credits
- Download and Configure Oracle Database Express depending on your operative system: https://www.oracle.com/database/technologies/xe-downloads.html.
- Download and Configure MySQL depending on your operative system: https://dev.mysql.com/downloads/mysql/
- Clone the repository
# Clone this repository
$ git clone https://github.com/luisfelipe7/SQL-Review-With-Oracle-MySQL/
- Go into the repository
# Go into the repository
$ cd SQL-Review-With-Oracle-MySQL
We have simple scripts in charge of creating tables and performing multiple DML and DDL operations. Both of them perform the same things, but they have some differences because of the syntax on each database:
- SQL-Basics-Review-With-Oracle.sql : Script for Oracle Database Express Edition, designed to work with Oracle.
- SQL-Basics-Review-With-MySQL.sql : Script for MySQL, designed to work with MySQL.
Here is an image of the simple model that I am using on the database to perform the operations:
To execute the Oracle Script just follow these steps:
- Open the terminal.
- Locate in the path of the script:
# Move to the path
$ cd pathOfTheScript
- Then, execute this command to enter the Oracle Database:
# Initialize the Oracle Database
$ sqlplus
- Enter the user and password.
- After that execute the script using:
# Executing the script
$ @SQL-Basics-Review-With-Oracle.sql
You are going to see all the errors and outputs.
To execute the MySQL Script just follow these steps:
- Open MySQL Worbench.
- Then, open the script using MySQL Workbench: File->Open SQL Script.
- Using the lightning bolt located on the interface execute the script.
Thanks to UNA (Universidad Nacional de Costa Rica) for teaching everything about SQL and Oracle University for the free course to review the basics of SQL.
GitHub @luisfelipe7 ·