Layla

Creating an ATP Database with Oracle SQL Developer Web

Cover Image for Creating an ATP Database with Oracle SQL Developer Web

Howdy coders! As some of you may have seen on Twitter, I'm spending my whole Summer interning at Oracle on the Database Tools team!!

And something INSANELY cool that a lot of folks don't know about Oracle, is that they have a free web version of their Oracle Database, that includes a web version of SQL Developer... Yep. That's right. No more downloading, no more setting up a virtual machine. It's ALL stored on the OC (Oracle Cloud) and it's free.

LET THE SET UP TUTORIAL COMMENCE!

Or you can watch the Youtube video of this tutorial from my Youtube channel:

STEPS

1) Create an Oracle Cloud account

Follow the steps to create your Oracle Cloud account! It's free to sign up, and the 'Always Free' access will always include these services:

  • Autonomous Database

  • Object storage

PLUS, you receive $300 of credits for 30 days to use on these services:

  • Container Engine for Kubernetes

  • Analytics Cloud

  • Data Integration

pic1.png

2) Go back to cloud.oracle.com

Sign into your new account :)

3) Scroll down to *Launch Resources*

4) Click *Create an ATP database*

pic2.png

5) Configure your ATP database

These are the settings I use to create my Autonomous Transaction Processing Database (I basically keep everything the same EXCEPT for "Choose License and Oracle Database Edition", for that section I choose "License Included". Also - make sure to toggle 'Always Free' on) - but you're more than welcome to use your own :^)

'Provisioning' is just a fancy word for setting up! Wait a few minutes before moving onto the next step if you see the orange ๐ŸŸ  icon:

6) Press *Database Actions*

If your orange ๐ŸŸ  icon has turned green ๐ŸŸข, your database is ready!

picc.png

Now, it may take a second or two to 'initialize database actions', but it should take you to your Database Actions Launchpad pretty quickly!

In your launchpad, there will be a handful of tools for you to use - BUT, if you're trying to get straight into the SQL, click 'SQL' to visit the SQL Developer Web application and follow the guided tour:

PIC4.png

If you're an SQL beginner, like myself, or even if you're an SQL veteran: I highly recommend taking the time to go through the guided tour of the environment. It's very straight to the point, but shows you exactly where all your necessary tools are to dive straight into creating queries! โœ๐Ÿฝ

  • here's an example of how the SQL command line runs in SQL Developer Web:

    pic5.png


I hope this helped you get started with Oracle SQL Developer Web AND Oracle's Cloud Infrastructure! ๐Ÿงก

I'm spending my Summer at Oracle, and plan on creating more Oracle/SQL content! If you'd like to make sure you see my next post, give me a follow here on Hashnode OR follow me on Twitter :D

See ya in my next post! :)