Skip to content

STRATEGICRepublic of San Marino

Contact

AI courses for DBAs

AI for DBAs: Claude and ChatGPT for the people who administer your databases

An advanced course for people who administer Oracle databases and for people who write SQL. You learn to use Claude and ChatGPT for queries, tuning, upgrades and security, remotely or on site. The AI always works read-only, and every script is reviewed and tested before it is used.

Example from the AI course for DBAs. The assistant connects through a dedicated read-only account to a synchronised copy of the Oracle database. Asked in plain language for the top ten customers by revenue, it suggests a SQL query, which stays visible. The DBA reads it, checks the execution plan and tests it on the copy before use.
Example · the tables, account and query shown are not real
Advanced level
for DBAs, developers who write SQL and systems administrators
Read-only AI
dedicated accounts, an in-sync copy, the query always visible
Remote or on site
across Italy, in San Marino and at partner venues in Turin and Rome

01 · copy the link to this sectionThe situation

AI writes the query in seconds. Checking it is still the DBA’s job

Claude and ChatGPT are already part of the working day for many DBAs and developers. Often there are no rules on what they can read, or on who checks what they write.

Asking an AI assistant for a SQL query, an explanation of an execution plan or an upgrade script is now an everyday habit. The answer arrives straight away, well written and confident. That does not make it right.

A query can return figures that look plausible but are wrong. A suggested index can speed up a report and slow down the ERP (your business management software). A script can run fine on the test copy and fail in production. And to get help, someone pastes a table of real data into the assistant, or the connection string with the password in it.

This is where the course starts. It teaches you to use AI where it helps, to check it where it can go wrong, and never to give it more access than it needs.

Typical scenario

The month-end report is slow. A developer asks an AI assistant to rewrite the query and puts it into production. The report gets faster. A week later, the accounts team notices that discounted invoices are missing. The new query left them out, and nobody had read it before it went live.

The rules of the course

02 · copy the link to this sectionWhat you will learn

Six areas of database work, with help from AI

They come from everyday work on an Oracle database. In each one, the AI suggests and the DBA decides.

DBASQL

SQL queries, written and explained

You write new queries with the assistant and have it explain inherited ones line by line. The AI gets the table structure, not the data. The result is checked on a copy against a known figure before anyone relies on it. Courses for developers
DBAPerformance (tuning)

Execution plans and tuning

AI helps you read an execution plan, spot a missing index or a poorly chosen data access path, and review code that runs inside the database. Every suggestion is measured before and after, with the tools covered by the company’s licences. Performance and tuning
DBAUpgrades

Patches, upgrades and migrations

With help from AI, you prepare patch scripts, upgrade scripts from 19c to 26ai and migration scripts. They are reviewed line by line and tested on a copy before the agreed window. The way back to the original system is prepared and tested before the switch. Oracle versions and support deadlines
DBABackups

Backups and restore tests

AI helps you write and document backup and restore procedures. The restore test itself is still carried out for real, on a schedule, and formally recorded. The record shows how long it takes to get running again and up to what point the data can be recovered. Backups, recovery and continuity
DBASecurity

Database security

The usual problems are accounts with more privileges than they need, shared accounts and access that nobody logs. With AI you read permissions and logs and prepare the fixes. Then least privilege, encryption where needed and access auditing are put in place. Securing the database
DBAOracle 26ai

Vector search in 26ai

26ai brings search by meaning, rather than by exact word, into the database itself. This is vector search, and Oracle states that it is included with no extra fee. You see what it is useful for, for example an assistant that answers questions about the company’s documents and data, and how to set it up on a test database. The Company Brain

Which areas to go into, and for whom, is agreed with your team before we start.

The Oracle & Database Engineering division

03 · copy the link to this sectionThe rules

Four rules for using AI on a database

They apply during the course and stay in writing for everyday work.

  • The AI reads, and only reads. It uses dedicated accounts and, where needed, an always-in-sync copy instead of the live database. That way it cannot change the data and does not slow anyone down.

  • The query is always visible. Every answer about the data shows the query that produced it. Whoever receives the answer can have the query checked.

  • Every script is reviewed and tested before use. First on a copy, then in production in the agreed window. There is always a verified backup and a planned way back.

  • No credentials or real data in unapproved tools. Passwords, server addresses and data extracts are never pasted into an assistant the organisation has not approved. The AI only needs the table structure and test data.

The course ends with a practical exercise that follows the same rules. A case from your environment is rebuilt on a test database, with test data and no access to live systems. It might be, for example, a slow query that you analyse and fix with AI, measuring performance before and after. Every activity goes into the training record, which stays with the organisation.

The training record

04 · copy the link to this sectionData and the Company Brain

Plain-language questions about your data, with the query in view

Many companies want to ask questions of their data in plain language. First, someone has to decide what the assistant can read.

The Company Brain is the company’s own searchable memory. An AI assistant that answers questions about orders, stock levels or a customer’s terms has to read the ERP. Before it is connected, you decide which tables or views it can see, with what permissions and on which copy of the data, so that it does not slow anyone down. These are DBA decisions.

The course prepares DBAs for this role. Every answer comes with the query that produced it. That way the DBA can always check where a figure comes from. When the company decides to build the assistant, the work continues with the Company Brain and the Oracle & Database Engineering division.

Company BrainOracle & Database Engineering

05 · copy the link to this sectionWho and where

Who the course is for and where it takes place

  • Who it is for. DBAs, developers who write SQL and systems administrators who manage the database servers.

  • Advanced level. You need to know SQL and your own database. The course starts from the foundations shared by all our courses, meaning what AI can do and where it goes wrong.

  • Remote or on site. Online, at your premises anywhere in Italy, at Strategic’s premises in San Marino or at partner venues in Turin and Rome. The place and schedule are set in the programme.

Where the courses take placeChatGPT and Claude courses for office teamsAll AI training courses

06 · copy the link to this sectionFrequently asked questions

Frequently asked questions about AI for DBAs

Can AI write queries instead of the DBA?
It can write a first version, often in seconds. On its own, it does not know what the company’s data means, which exceptions apply or how heavy the query is on the live database. That is why the decision stays with the DBA. The query is read, tested on a copy and compared with a known result before it is used. The course teaches exactly this kind of check.
Which is the best AI for writing SQL?
We don’t rank tools. Claude and ChatGPT both write convincing SQL, and both can get it wrong. That is why method matters more. To write a query, the assistant only needs the table structure, not the data. The result is checked on a copy, and performance is measured before and after. The course uses the tool your organisation has approved. If two tools are approved, they are tested on the same tasks against written criteria.
Can Claude or ChatGPT be connected to the database?
Yes, with rules agreed in advance. The assistant reads without being able to change anything, through dedicated accounts and only on the tables or views it needs. Where needed, it works on an always-in-sync copy instead of the live database. In Oracle Enterprise Edition this copy is a paid option, and we say so up front. Access is logged.
Does this apply to databases other than Oracle?
The rules do. Read-only access, dedicated accounts, visible queries and scripts tested before use apply to any database. The examples and the practical exercise, however, use Oracle, the database our Oracle & Database Engineering division works on.
What changes with Oracle 26ai?
26ai is the long-term release of Oracle Database and the destination for the next upgrades from 19c. It brings search by meaning, known as vector search, into the database itself, and Oracle states that this is included with no extra fee. It does require the database to be organised differently, and before the switch you check that your ERP vendor supports the new version. In the course, AI helps prepare and review the upgrade scripts, and vector search is tried out on a test database.

More questions about the courses? Frequently asked questions about AI training

07 · copy the link to this sectionObservatory

From the Observatory: data, Oracle and AI

Analysis and guides from the Strategic editorial team.

All articles on data and Oracle

08 · copy the link to this sectionContact

An AI course for the people who work on your databases

A few lines are enough. Tell us which databases and versions you use, who would take part and whether Claude or ChatGPT are already in use. We reply by email, usually within two working days.

Please do not put passwords, server addresses or data extracts in the form.

On WhatsApp, messages are answered by Strategic’s AI assistant. Please do not use it for confidential information.

Your requestAIAI training courses

Do any of these questions sound familiar? tick the ones that apply to you

The form opens with the topic and the questions already filled in.