MySmartCoPilot

Your country

Tools that support it use your country for local currency, number formats, units and paper size. Your choice is saved only in this browser.

Programming languages

PL/SQL & T-SQL (Oracle and SQL Server)

The planned outline of 16 modules. Lessons are written, run and reviewed before they are published.

Coming soon 16 modules

Coming soon. This track is being written. Below is its planned outline: a lesson appears here once its examples have been run and its technical review is signed off.

Before this track

Planned outline

  1. Module 1

    Start here: two engines, versions and a verified lab

    Coming soon
  2. Module 2

    T-SQL foundations: batches, variables and routines

    Coming soon
  3. Module 3

    T-SQL errors and transactions

    Coming soon
  4. Module 4

    Working with sets: temporary tables, MERGE and cursors

    Coming soon
  5. Module 5

    Window functions in T-SQL

    Coming soon
  6. Module 6

    Dynamic SQL and triggers in T-SQL

    Coming soon
  7. Module 7

    Execution plans and performance in SQL Server

    Coming soon
  8. Module 8

    Production T-SQL: concurrency, security, new features and tests

    Coming soon
  9. Module 9

    PL/SQL foundations: blocks, types, SQL and exceptions

    Coming soon
  10. Module 10

    Cursors, collections and bulk processing

    Coming soon
  11. Module 11

    Subprograms, packages and robust error logging

    Coming soon
  12. Module 12

    Triggers in Oracle

    Coming soon
  13. Module 13

    Dynamic SQL and security in PL/SQL

    Coming soon
  14. Module 14

    Performance: plans, PL/SQL called from SQL and table functions

    Coming soon
  15. Module 15

    Production PL/SQL: staging, concurrency, JSON and tests

    Coming soon
  16. Module 16

    Across both engines: porting and concurrency

    Coming soon

Related tools

SQL Formatter Readable, consistently indented SQL for 20 dialects — or a safe one-line copy. CSV to SQL Converter Typed CREATE TABLE and batched INSERTs, upserts or bulk-load scripts for six databases. Mock Data Generator Design the columns, link the tables, and download up to a million rows of test data. JSON Formatter Pretty-print, minify and fix JSON with exact error locations. UUID Generator Random v4 and time-ordered v7 UUIDs, in bulk — plus a UUID inspector. Text Diff See what changed between two versions — by line, word or character.

Official documentation

More in Programming languages