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 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.
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.
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. |
|
|
|
Popular free classes your fellow developers are taking
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 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 |
|
|
|
SQL and PL/SQL
Other Languages
Low-code / APEX
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. |
|
|
|
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. |
|
|
|
Useful links to keep your skills sharp
|
|
|
|
|