Database Application Developer Newsletter Technical news, how-to articles, best practices, and more. ___
March 2022 News Highlights • Oracle Database World 2022 and Oracle CloudWorld 2022 announced • In-database machine learning for MYSQL HeatWave • Oracle Machine Learning for Python (OML4Py) new capabilities • Oracle NoSQL Database - new on-demand mode available • MySQL Heatwave Machine Learning • Low-code development with Oracle APEX • Latest best practices and how-to resources for Oracle Database |
|
|
|
Don't miss Oracle Database World 2022 April 26, 2022 - Americas | April 28, 200 - EMEA June 8, 2022 - JAPAC Get the most out of your data. Gain practical, technical knowledge from the experts and architects behind Oracle Database. The event will feature a track dedicated to AppDev - Learn how Oracle database technologies help you develop apps that are available, scalable, and secure. Developer experts will provide tips, insights, and guidance into Oracle’s converged database, Oracle APEX, Microservices, MySQL HeatWave, and more. Learn more and register for the event |
|
|
|
Save the date: Oracle CloudWorld 2022 October 16–20, 2022, Las Vegas, NV Mark your calendar and plan on joining us in Las Vegas, NV. You can explore the latest technical innovation as well as get product demos, advanced best practices, training, and insights from Oracle experts. Subscribe to get the latest news about event registration, keynote speakers, sessions, and more. Subscribe for updates |
|
|
|
MySQL HeatWave—New Machine Learning Capabilities New in-database machine learning capabilities include everything you need to build, train, deploy, and explain machine learning models within MySQL Heatwave. It eliminates the need for a separate machine learning tool or service. Watch the event replay and get more technical insights |
|
|
|
Now available: Oracle Machine Learning for Python (OML4Py) on Oracle Database 19c & OML4Py "Universal" Client Oracle Machine Learning for Python (OML4Py) is the open source Python programming language and environment that you can operate database data at scale. OML4Py enables you to run Python commands and scripts for statistical analysis and machine learning on data stored in Oracle Database and Oracle Autonomous Database. |
|
|
|
Focused topic: New on-demand capacity in Oracle NoSQL Database Cloud Service Oracle NoSQL Database Cloud Service is the world’s easiest multi-model NoSQL database cloud service for document, columnar and key-value based workloads. It offers ACID transactions, serverless scaling, comprehensive security, and low pay-per-use pricing, including 100% compatibility with on-premises Oracle NoSQL Database. |
|
|
|
| Database workloads to Oracle Cloud, supporting various Oracle Database versions as the source and most Oracle Cloud Database Services as targets. - Ricardo Alonso Gonzalez Acuna |
|
|
|
March quiz Question Which of these terms are part of loop syntax in PL/SQL?
Possible answers: |
|
|
|
| 1. for 2. exit when 3. repeat until 4. while |
5. continue 6. raise 7. forall
|
|
|
|
| Continue reading this newsletter to find out the correct answers! |
|
|
|
Focused Topic: Low-code development with Oracle APEX Oracle Application Express (APEX) is a low-code development platform. Using APEX, you can quickly build scalable, secure enterprise apps without being a technology expert and deliver sophisticated solutions.
Get to know APEX See APEX 21 in action with a live demo of the new maps region, Faceted Search, new Smart Filters, Auto Scale and Progressive Web Apps (PWA) – with Sharron Kennedy and Shakeeb Rahman |
|
|
|
Develop XR with Oracle Cloud, Database on HoloLens, Ep 1: Spatial, AI/ML, Kubernetes, and OpenTelemetry | Ep 2: Property Graphs, Data Visualization, and Metaverse - Paul Parkinson
SQL and PL/SQL SQL in 60 seconds with Chris Saxon - Outer join filtering (0:58) | Partitioned outer join (0:55) Ask Tom: SQL hierarchies using CONNECT BY and recursive WITH (1:00:00) with Chris Saxon Ask Tom: Visualizing SQL Pattern Matching (MATCH_RECOGNIZE) - A Beginner's Guide (1:03:03) with Chris Saxon and Christian Berg Debugging PL/SQL with Visual Studio Code - Christian Shay
Machine Learning, Graph, Spatial Announcing new URLs for Oracle Machine Learning Notebooks and REST Services - Sherry LaMonica Oracle Machine Learning Notebooks for Autonomous Database - Mark Hornick Import Wide Datasets into Nested Columns Using OML4Py - Jie Liu Contact Tracing using Oracle Spatial – Ryota Yamanaka Build SPARQL Endpoint with Autonomous Database Part 1 | Part 2 – Ryota Yamanaka
Scripting Does Python Django use bind variables with Oracle Database? - Christopher Jones Easy wallet-less connections to Oracle Autonomous Databases in Python - Sharad Chandran R Always Use Connection Pools — and How - Christopher Jones Python cx_Oracle Notebooks: the Oracle Database series on best practices - Christopher Jones
.NET Oracle Entity Framework (EF) Core 6 Demo (5:38) with Alex Keh Using Oracle Database with ASP.NET Core Identity – Alex Keh Sample code: Oracle Identity and Access Management Tokens with .NET and Oracle Autonomous Database – Alex Keh April 13, 2022 | AskTom Office: .NET and Visual Studio with Alex Keh and Christian Shay
JSON and Autonomous JSON Database AskTom: Demos and QA: Oracle Database API for MongoDB (55:01) with Beda Hammerschmidt and Roger Ford April 12, 2022 | AskTom: JSON in Oracle Database with Beda Hammerschmidt
DevOps April 21, 2022 |Live Developer Lab: Unified Observability in Grafana with Converged Oracle Database with Paul Parkinson
… And the correct answers to the Dev Gym quiz are: Choices 1, 2, 4, and 5. For further explanations, visit the quiz page (requires Oracle login). For more quizzes, visit the Oracle Dev Gym. |
|
|
|
Thought-provoking success stories Building on OCI: Build an app to pandemic scale A look into the underlying requirements and Oracle’s approach in rapidly building pandemic-scale systems that enabled the most important data collection effort in modern history.
Data Management for Financial Services Read Oracle customer success stories in Financial Services as well as discover how Oracle data management solutions can help financial services firms around the world to rapidly create financial applications, manage high-volume transactions, and analyze data in real-time for personalized banking, fraud detection, and process optimization. |
|
|
|
Get your hands dirty… for free! Get Autonomous Database 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.
Build your Oracle technology muscles at the Oracle Dev Gym by taking workouts, quizzes and even entire classes on SQL, PL/SQL, database design, logic and more. |
|
|
|
|
