The things you need to do to build the Oracle SQL practice environment are as follows.
1. Create an Oracle Cloud Account
2. Oracle Cloud Login
3. Create database
4. Issuing database keys
5. Download and Install SQL Developer
6. Database Connection
The reason for using the above cloud is simple.
Cloud service is used because a large amount of data cannot be stored in limited computing resources.
Create a free tier cloud account.
Enter the relevant details and receive e-mail verification.
After verifying your email, you will be prompted to create an account.
After that, log in to the Oracle Cloud with the created account.
To create a database, click Create an ADW database to install it.
Write the name demo and scroll down.
Let’s set the password as Oracle123456. Then click the Create Database button.
A yellow icon is displayed during installation, and after installation is complete,
The word “available” and the icon change to green.
Now it’s time to make an important DB Connection.
Click DB Connection and enter Oracle123456 as the password you specified earlier.
Download and save the key.
Now install SQL Developer.
If you search google for sql developer download
A site with oracle.com at the top will be found.
Now, download the platform that matches your computer specifications from here.
Membership registration is required to download here as well.
The previous download is from Oracle cloud and this is the Oracle site.
After entering and creating an account, the download proceeds, and the downloaded file is unzipped.
run the application.
Click the green + button to the left of the Oracle program
It is linked with the cloud account. User information is the same as in the cloud
Click on the connection type cloud e-wallet and select Browse configuration file → Wallet_demo.
SQL Developer installation is now complete.