Oracle Database API for MongoDB, free technology training with Dev Gym, latest technology news, and more.
Oracle
February 2022
Database Application Developer Newsletter
Hello Application Developers,

February has been an exciting month with Winter Olympics and, for those of you in the US,  Super Bowl. Hope you had some time to watch and cheer on your favorite athletes.   

Here are some highlights of this month’s issue:

  • New Oracle Database API for MongoDB
  • Free technology training at the Oracle Dev Gym
  • Latest technical best practices and how-to resources for Oracle Database, languages, low-code / APEX, Machine Learning, and more
  • Upcoming developer events - Pi Day and Java Innovations
For more insights and content, check our social media channels and other resources listed at the end of this newsletter.

Kind regards,
- Your Database Application Developer editor
 
Oracle Database API for MonghDB

Oracle Database API for MongoDB

The new Oracle Database API for MongoDB enables developers to use MongoDB APIs with Oracle Autonomous Database, including Autonomous JSON Database. The API allows you to develop and run MongoDB based applications using MongoDB tools, drivers, and frameworks directly with Autonomous Database. You can run SQL and PL/SQL that you know and love over your JSON data. You can also integrate machine learning, graph or spatial analytics, among others, into their applications—all within the Autonomous Database. Existing MongoDB applications can be migrated and run on OCI unchanged, giving you an easy way to finally get your applications running on Autonomous Database. 

Get to know the Oracle Database API for MongoDB
An introductory overview of the new API capabilities.
Blog: At Last, MongoDB Developers Get Full Autonomous Capabilities  – Carl Olofson, Research Vice President, Data Management Software, IDC
Video: theCUBE: Oracle Lures MongoDB Devs With New API for ADB (18:54) – Dave Vellante, theCUBE

Technical how-to articles
A step-by-step tutorial on how to use the Oracle Database API for MongoDB with Autonomous JSON Database. – Roger Ford

How to write an application using the Mongo APIs and Micronaut Java framework to persist and query data in Autonomous Database – Todd Sharp

Ask experts @ Ask Tom JSON in Oracle Database Office Hours
Meet the experts behind the Oracle Database API for MongoDB and Oracle Autonomous JSON Database. Learn how to enable the API and how to write your first program or migrate an existing MongoDB application to Autonomous JSON Database.  
March 8, 2022 | Oracle Database API for MongoDB with Beda Hammerschmidt

Try Oracle Autonomous JSON Database for free
An introductory blog on what Autonomous JSON Database is and how to sign up for Autonomous JSON Database for free.  – Beda Hammerschmidt
 

Focused Topic: Build your technology muscles for free with the Oracle Dev Gym

Did you know you can take FREE technology classes, workouts, and quizzes on SQL, PL/SQL, database design, and more? The Oracle Dev Gym offers free comprehensive on-demand classes, quick workout sessions focused on a specific technology or topic, and more than 2,500 quizzes to check your mastery level. 
Oracle Dev Gym
Popular free classes your fellow developers are taking
Analytic SQL for Developers with Conner McDonald

Let’s check your knowledge with a sample question
You execute these statements:

 

create table qz_bricks (brick_id integer not null primary key,
                        colour varchar2(10) not null,
                        shape varchar2(10) not null);

insert into qz_bricks values ( 1, 'red', 'cylinder' );
insert into qz_bricks values ( 2, 'blue', 'cube' );
commit;

create view qz_bricks_v as
select * from qz_bricks where shape = 'cylinder'
with check option;
 

Which choices run a DML statement against the view that complete successfully (without error)?

1) insert into qz_bricks_v values ( 3, 'green', 'cylinder' );
2) insert into qz_bricks_v values ( 4, 'yellow', 'cube' );
3) update qz_bricks_v set colour = 'blue' where brick_id = 1;
4) update qz_bricks_v set shape = 'cube' where brick_id = 1;
5) delete qz_bricks_v where shape = 'cube';

Continue reading this newsletter to find out the correct answers!
 
Developer events - Pi Day

Developer events

March 14, 2022: Pi Day
Join an online extravaganza with highly technical content and demos that developers will love. You’ll receive a free swag kit by registering, and if you’re one of the first 500 to sign up for a OCI free tier account, you can score a bonus prize. Look for the confirmation email for more details. Check out the event page(www.314piday.com)!

Oracle Developer Live: Java Innovations
Boost your Java skills with technical content from experts at Oracle and the Java community. For more details and registration, visit the event page.
March 22, 2022 | Americas
March 24, 2022 | Europe, Middle East, and Africa, Japan, Asia-Pacific

 

What’s new in database application development

Oracle Database and Oracle Autonomous Database
Blog: A conversation on the query optimizer – Connor McDonald
Ask Tom Recording: Database In-Memory External Tables (54:01) with Andy Rivenes and Roger MacNicol
What’s new

SQL and PL/SQL
Video: SQL in 60 seconds with Chris Saxon - Inner Joins | Outer Joins
Ask Tom Recording: Visualizing SQL window functions (55:14) with Chris Saxon

Other Languages
Video: Data Handling Techniques in Python for Oracle Database (32:36) with Christopher Jones
Blog: Accessing Autonomous Database with IAM token using Java - Nirmala Sundarappa, Jean De Lavarene, and Michael McMahon

Low-code / APEX
Ask Tom Recording: Developer Tips from the APEX Team (1:04:38)

Machine Learning, Graph, Spatial
Ask Tom Recording: Feature highlights for new Oracle Machine Learning notebook templates with Marcos Arancibia – Extraction (28:12) | Clustering (28:28)

Oracle NoSQL Database


… And the correct answers to the Dev Gym quiz are:
Choices 1, 3, and 5.  For further explanations, visit the quiz page (requires Oracle login).  For more quizzes, visit the Oracle Dev Gym.
 

Technology announcements

The release induces new features, such as consolidated export file and standard export file formats, as well as several UX and UI enhancements and fixes. – Praveen Patil

Access Oracle Database World on demand! Discover how Oracle’s latest database innovations can help you create a data-driven organization. 
Technology announcements
 
Free Hands-on

Get your hands dirty… for free!

     1. Oracle Cloud Free Tier plus 30-day free trial
     2. $300 in credits for Cloud services

Get hands-on experience on hundreds of Oracle solutions 24x7, for free on Oracle LiveLabs.

Learn, Write, and share SQL at a free interactive Oracle Live SQL site, built with Oracle APEX running on Oracle Database.
More Info

Keep in touch
 
Facebook
 
Twitter
 
YouTube
 
LinkedIn