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
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:
PLUS, you receive $300 of credits for 30 days to use on these services:
Container Engine for Kubernetes
2) Go back to cloud.oracle.com
Sign into your new account :)
3) Scroll down to Launch Resources
4) Click Create an ATP database
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 ActionsIf your orange 🟠 icon has turned green 🟢, your database is ready! :)
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 ;D
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:
I hope this helped you get started with Oracle SQL Developer Web AND Oracle's Cloud Infrastructure! 🧡
See ya in my next post! :)