Oracle SQL for Beginners | SQL Full Course | SQL Tutorial
Oracle 21c is the latest version, which is a cloud-based computing and cloud-backed database. Follow
the below instructions to download and install the software:
Download the software in the description.
Extract the software by using Winrar or any other zip extraction tool.
Install Oracle 21c database.
Once installed, we can configure the SQL Developer and import the HR schema. The installation may
take several minutes, around 15 to 20 minutes or even half an hour, so be patient.
After the installation, you will see a particular page, and you can take a screenshot of it. In 21c, we do
not have an HR schema by default, and we have to import it manually. We can connect to HR schema
tables, and you can also create any other schema on the right-hand side, such as a test schema for
development using the Oracle Database Express edition.
To connect to the underlying database using SQL Developer, follow these steps:
Click on the "Test" button to ping the database.
If the test is successful, click on "Connect".
If you want to save the password, click "Save Password".
Once connected, the workspace will appear on the right-hand side.
To query the database, type "SELECT * FROM all_tables" in the workspace.
Note: The path to the unzipped HR dump may be different on your system. Make sure to double-check
the path we are giving and replace it with the correct path on your system.
To create a chart user in the admin schema, execute the following steps:
Oracle 21c is the latest version, which is a cloud-based computing and cloud-backed database. Follow
the below instructions to download and install the software:
Download the software in the description.
Extract the software by using Winrar or any other zip extraction tool.
Install Oracle 21c database.
Once installed, we can configure the SQL Developer and import the HR schema. The installation may
take several minutes, around 15 to 20 minutes or even half an hour, so be patient.
After the installation, you will see a particular page, and you can take a screenshot of it. In 21c, we do
not have an HR schema by default, and we have to import it manually. We can connect to HR schema
tables, and you can also create any other schema on the right-hand side, such as a test schema for
development using the Oracle Database Express edition.
To connect to the underlying database using SQL Developer, follow these steps:
Click on the "Test" button to ping the database.
If the test is successful, click on "Connect".
If you want to save the password, click "Save Password".
Once connected, the workspace will appear on the right-hand side.
To query the database, type "SELECT * FROM all_tables" in the workspace.
Note: The path to the unzipped HR dump may be different on your system. Make sure to double-check
the path we are giving and replace it with the correct path on your system.
To create a chart user in the admin schema, execute the following steps:
