Oracle SQL
Query fundamentals through to analytic functions, taught against a real schema rather than toy tables. This track is being written now. Tell us you want it and we will send it the day it goes live — and we can deliver it as instructor-led training before then.
What the track will cover
This is the working outline. It shifts with what people actually ask for, so if something important to you is missing, say so — we would rather hear it now than after it is written.
SELECT, filtering and sorting
Joins: inner, outer, self and anti-joins
Aggregate functions and GROUP BY
Subqueries, inline views and WITH clauses
Set operators and conditional expressions
DDL, DML and transaction control
Constraints, views, sequences and indexes
Analytic and window functions
Reading an execution plan and writing SQL that scales
Two things you can do today
Read the AWS Cloud Foundations course
Our first free track is live in full — eleven modules, labs, a glossary and a 50-question final test. It is the honest sample of how we teach.
Book this as instructor-led training
Everything in the outline can be delivered live to your team now, tailored to your environment, without waiting for the written track.
Consulting, IT consulting and corporate trainers, delivered worldwide.
Contact
pc@pitcsolutions.com
+91 70492 35525
Indore, India · map
PITC LLC, United States