Discover how to combine information from multiple tables using JOINs in MySQL! This beginner-friendly guide explains INNER JOINs (and friends) with fun library metaphors, approachable SQL examples, and practical tips to help you unlock the true power of your relational database.

MySQL HeatWave feature announcements at Oracle AI World

This blog post introduces WebAssembly (Wasm) support in MySQL Heatwave! For the first time, you can bring high-performance, portable code, compiled from Rust, C++, and many more languages, directly to your MySQL data, unlocking a new universe of speed, flexibility, and innovation.

MySQL HeatWave Lakehouse enables queries on file formats like Parquet, Avro, ND-JSON and CSV in an object store. This blog introduces support for the Delta Lake table format, thereby enabling ACID-compliant applications on data in the object store.

This blog is focused on Model Context Protocol (MCP). MCP is an open standard enabling seamless integration between applications powered by large language models (LLMs) and external data sources and/or tools. The MySQL HeatWave MCP Server provides a collection of specialized tools that help you leverage the full capabilities of both MySQL HeatWave and MySQL AI.

This blog explains Hybrid Search capabilities within MySQL HeatWave, describing how it combines the strengths of keyword-based (BM25) and semantic (embedding) search. It explains the benefits for advanced information retrieval and Retrieval Augmented Generation (RAG) pipelines, highlighting how hybrid search supports complex business scenarios that require both contextual understanding and exact match capabilities.

Unlock the secrets to reliable databases with primary and foreign keys! This beginner-friendly post uses engaging library metaphors and approachable SQL examples to show how keys keep your MySQL tables organized and your data relationships strong. Learn how to build, enforce, and practice these essential building blocks in your own projects.

This document provides a walk-through of the MySQL HeatWave Python SDK. It offers helpful tips on how to use the SDK to accelerate your application development culminating in three demonstrations of developing applications to solve real-world problems with, a Retrieval Augmented Generation (RAG) bot, an LLM-based agent with tool-calling, and a machine learning pipeline for fraud detection.

Big news for our public sector customers! Oracle's MySQL HeatWave has achieved Authorization to Operate (ATO) in both the OC2 (FedRAMP High / DISA IL4) and OC3 (DISA IL5) realms of the Oracle Cloud Infrastructure (OCI) Government Cloud. This is a massive milestone that unlocks powerful new capabilities for government agencies, contractors, and other public sector organizations. Let's break down what this means and why it's so important.

Explore the top 50 MySQL interview questions and answers fit both for newbies and experienced devs. Get prepared with real-world MySQL queries.

The post Top 50 MySQL Interview Questions and Answers for Every Skill Level  appeared first on Devart Blog.