Experiencing Oracle Cloud – Database Service

Oracle Cloud is one of the industry’s most complete enterprise cloud. Today I will experience its Database Service in the cloud.

(For all of the images pasted in this post, you can open and view it on a new window)

(If you want to experience it by yourself, you can request a trail from https://cloud.oracle.com/mycloud/f?p=service:home:0

Step 1: Sign in to Oracle Cloud

logon

Identity Domain:

Every Oracle Cloud Service belongs to an Identity Domain. Identity Domains control service user authentication and authorization. Service users in an identity domain can have different levels of access.

Below is the email I got for my 30 day trial with Oracle Cloud.

details

In the email, you can see it is providing me a service with Java (Oracle Java Cloud Service) and database (Oracle Database Cloud Service) and both are Trial only.

Step 2. After I logged in Oracle Cloud, there is a Services Panel. In this article I am experiencing its database services so I click in the ‘Launch Service’ for database.

servicespanel

Step 3. The Panel of Oracle Cloud – Database.

paneldb

Step 4. It has four drop-down menus.

fullmenu

Step 5. Application Builder

— Basically in Application Builder, it provides you rich tools to create database reports just in a click. For example, I have created a database report just in seconds with its demo table.

sampleapps

Here is the detailed report:

report

report2

In the Application Builder, it also provides some other packaged applications and you can install them in minutes. They are fully functional and ready to use and those packaged applications developed by Oracle for no additional charge. I think in future this feature may be extended to be as a APPS store.

You can also import or export below elements for your database application,
File Type: Database Application, Page or Component Export
Websheet Application Export
Plug-in
CSS Export
Image Export
File Export
Theme Export
User Interface Defaults
Team Development Feedback

In a word, Application Builder is a place with fully support of Wizard-based that you can build your database application with fully support from Oracle and also you can install applications developed by Oracle for free

Step 6. SQL Workshop

SQL Workshop provides you utilities for browsing/creating/managing database objects, and running SQL and scripts. You can consider it as a simplified SQL Developer in the cloud with additional support for RESTful Web Services.

Browsing Objects,

browsering

Creating objects,

creating

Besides these, SQL Workshop also provides developers rich utilities, like Query Builder, Data Workshop, Schema Conmparison, Recycle Bin, etc.

Step 7. Team Development

In Team Development, it provides support to help improve team development. You can use its Milestones to manage your release plans, use Features/To Dos to manage your development affairs, use Bugs to track bugs and enhancement., and use Feedback to enhance team communication.

team

Step 8. Administration

For the Administration, it didn’t give me a ‘wow’ like other features. Here it just provides services as other administration console, like manage users and groups, monitor activity, dashboards, about, etc.

Conclusion:

Oracle Database Cloud provides its world’s leading database with Oracle Database 11g Release 2 Enterprise Edition. It has fully support in Database Development as well as Application Development and Web Services (RESTful). It has full capabilities of the Oracle Database, including SQL and PL/SQL support. You can deploy your application in the Cloud in minutes. It also provides lots of Pre-built business productivity applications.