A deeper look at our Spotify streaming data that we’ve imported into our Oracle Database. Here I share a few interesting SQL queries and explain how they work.
Importing your personal data from Spotify to a database for learning SQL can be done in just a few clicks with Oracle’s Always Free Autonomous Database!
Oracle REST Data Services (ORDS) comes with a PL/SQL API you can use to quickly publish a TEST module, aka ‘Hello, World!’
Turning on or off storage properties for your Oracle Database objects in your SQLcl Liquibase changeSets. Don’t want the tablespace? Use the ‘set ddl’ command!
How to run Liquibase updates for a specific schema with Oracle SQLcl. Log in as one user, deploy changeSets to another with your favorite Oracle Database cli.
JSON, XML, YAML Liquibase changeSets – you can run those in Oracle SQLcl and here are some examples! Create a table, add columns, and insert rows.
Database Tools Tips & Tricks from Oracle Cloud World 2022. YouTube recording of my 30 minute presentation on SQL Developer, ORDS, and SQLcl.
Tuning REST APIs for Oracle Database often comes down to tuning the SQL that powers them. Here’s some advice and an example of how that could be done.
