Thursday Apr 09, 2015

Using the SQL Developer to Browse NoSQL Datastores

Written by Eugene Simos

With the latest early adopter release of the SQL Developer, it's possible to browse your NoSQL datastores.We will use the BigData lite virtualbox appliance, and the latest early adopter SQL Developer, to demonstrate this feature.

The receipt is very simple:

1) Download the virtualbox Big Data lite appliance from:
http://www.oracle.com/technetwork/database/bigdata-appliance/oracle-bigdatalite-2104726.html
Follow the instructions to assemble the bits of the virtualbox into one single "ova" file. Import this file into your virtualbox installation, create the BigData lite VM and start it.

2) Download the Oracle SQL Developer 4.1 EA2 (4.1.0.18.37) release from:
http://www.oracle.com/technetwork/developer-tools/sql-developer/downloads/sqldev-41ea-2372780.html
I used the "Other Platforms" distribution (see below image). Download the Java 8 JDK (see below image).

Image1

3) Upload the SQL developer and the jdk to the virtualbox BigData Lite VM.

4) Install the jdk8 and the SQL Developer 4.1 into their own directories (I created a stage directory into an Oracle user home directory).

5) Start the NoSQL services from the panel of the virtualbox as below:

Image2

Start your SQL Developer 4.1 EA2 instance, from your installation directory.


Then in the right tab on the NoSQL connection, right click the link NoSQL connections.

Image3

Then provide all the connectivity information to your NoSQL store. In our case, the out-of-the box NoSQL installation is using the 5000 port, so we just accept the settings.

Image4

And finally, you will see the tables that are created in your NoSQL datastore. With this connection we are able to browse – i.e read only – the data as seen in the picture below:

Image5

Enjoy the rest of your developments on NoSQL with this new feature of the SQL developer.

If you would like to find out more about using Oracle NoSQL, I suggest taking the following Oracle University course:

Using Oracle NoSQL Database (4 days).

Explore all of the available training for Big Data appliance products.

About the Author

Eugen Simos

Eugene Simos is based in France and joined Oracle through the BEA-Weblogic Acquisition, where he worked for the Professional Service, Support and Education for major accounts across the EMEA Region. He worked in the banking sector, ATT and Telco companies giving him extensive experience on production environments. Eugene currently specializes in Oracle Fusion Middleware, teaching an array of courses on Weblogic/Webcenter, Content,BPM /SOA/Identity-Security/GoldenGate/Virtualisation/Unified Comm Suite) throughout the EMEA region.

Tuesday Dec 02, 2014

Oracle SQL Developer Data Modeler – A Perfect Tool to Data Modeling

Written by Priya Shridhar, Senior Curriculum Developer, Oracle Database Application Development Curriculum Development Team

Oracle SQL Developer Data Modeler is a graphical data modeling tool that aids and enhances communication between data architects, database administrators, application developers and users.

It simplifies the data modeling development process.

In today's development environments, designers use an existing data model as a beginning point to enhance the database design. To ensure the database design follows the rules of a relational database design, it's important to check and enforce the integrity and consistency of the design.

All this and more can be achieved using Oracle SQL Developer Data Modeler.


Oracle SQL Developer Data Modeler offers a wide range of data modeling capabilities:

  • Captures business rules and information.
  • Creates process, logical, relational, physical and multidimensional models.
  • Imports data models from a variety of sources, including Oracle Designer, VAR files, Erwin and more.
  • Applies design rules to check and enforce integrity and consistency of designs.
  • Stores metadata information in XML files.
  • Synchronizes the relational model with the data dictionary.
  • Engineers from a logical model to a relational model and vice versa.

Explore related data modeling training offerings here.

Tuesday Apr 02, 2013

Java Certification: Your Burning Questions Answered

We get a ton of questions from many of you who already hold a Java certification, or have considered one in the past. So, we thought it would be helpful to share some of the answers to our most frequently asked Java questions.

Q: I’ve been a Java Developer for years.  Why should I get Java Certified?

A:  Certifications hold much more value when combined with solid experience - so you're actually a perfect candidate for certification. Certification doesn't just validate what you know, it demonstrates your commitment to skill development. Check out our "Wanted: Java Certified Experts" post for more on this topic.

Q: I am a Sun Certified Java Programmer (SCJP). Does that make me an OCPJP now?

A: When you passed your exam, you achieved a “Sun Certified Java Programmer” certification. It's still completely valid and is the equivalent of the Oracle Certified Professional Java Programmer certification, but your credential is still Sun branded. If you're interested in getting an Oracle Certified credential, you can upgrade your certification to the latest version. You can also select another Oracle certification in Java to pursue.

Q: I am certified on Java SE 1.4. Is my certification even still valid?

A: If you were certified on Java 1.4, your certifications are still valid for the version of Java that you are certified in. Upgrade exams are available for the OCP, Java Programmer exams and OCE, Java EE 6 exams to demonstrate your ability to work with the latest versions.

Q: Do I need to buy training classes from Oracle University in order to earn my Java certification?

A: Training is not currently a requirement for the OCA, OCP or OCE level Java certifications. Training is only a requirement for the Oracle Certified Master level certifications, which includes the OCM, Java SE 6 Developer and Java Enterprise Architect certifications. Master certifications are the most advanced credentials so we require training to help prepare candidates for the hands on nature of the exam and to ensure candidates have an in-depth expertise of the technology area.

Q: How different are the Java SE 7 certifications compared to the Java SE 6 certifications?

A: There are significant differences. We saw an opportunity to improve the Java SE 7 OCA and OCP exams to test a broader range of features and skills so they're more relevant to real-world job functions.  Both exams include more advanced content, which gives the credentials more value in the marketplace. We’ve also revised the path to require individuals to achieve their OCA certification before pursuing their OCP exam.  For those who already hold a SCJP or OCP credential, upgrade exams are available to the OCP, Java SE 7 Programmer certification without having to take the OCA exam first.

Q: For the Java SE 7 Certifications, why is OCA now a prerequisite for OCP?

A: With the release of Java SE 7, we saw an opportunity to improve both the OCA and OCP Certifications. In the past, the OCA exam covered more introductory and fundamental concepts so it was not highly sought-after or valued by hiring managers. The Java SE 7 OCA exam now covers more advanced content, content that was previously covered on the OCP exam. We also added additional objectives to the OCP exam to give it more value.  The result is that we now have two improved exams that will test you on a greater breadth of skills and position you for greater success.

What other questions do you have? Let us know in the comments below.

-Kate, Oracle University Market Development Manager

About

Oracle University is THE trusted provider of quality, expert Oracle training & certification. All training is delivered by our Elite global team of Oracle experts and made available in multiple learning formats for anytime, anywhere training. Delivery methods include:
- Traditional classroom,
- Live Virtual Class,
- Oracle Learning Streams,
- Oracle Learning Cloud and
- Training On Demand.
For buying confidence all our training is backed by the unique 100% student satisfaction guarantee.

Subscribe to the Latest OU Blog Posts by Email

OU Website

Subscribe to OU Training Newsletters

Oracle Certification Blog

Search

Archives
« September 2015
SunMonTueWedThuFriSat
  
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
   
       
Today