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

SQL (PostgreSQL, MySQL, SQLite)

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

Coming soon 22 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.

Planned outline

  1. Module 1

    Start here: databases and your first query

    Coming soon
  2. Module 2

    Filtering and sorting rows

    Coming soon
  3. Module 3

    Data types and built-in functions

    Coming soon
  4. Module 4

    Aggregates and GROUP BY

    Coming soon
  5. Module 5

    Joining tables

    Coming soon
  6. Module 6

    Subqueries and set operations

    Coming soon
  7. Module 7

    Common table expressions and recursive queries

    Coming soon
  8. Module 8

    Window functions

    Coming soon
  9. Module 9

    Creating tables and constraints

    Coming soon
  10. Module 10

    Changing data: INSERT, UPDATE, DELETE and UPSERT

    Coming soon
  11. Module 11

    Transactions, isolation and locking

    Coming soon
  12. Module 12

    Indexes, query plans and performance

    Coming soon
  13. Module 13

    Designing database schemas

    Coming soon
  14. Module 14

    Views, functions, procedures and triggers

    Coming soon
  15. Module 15

    JSON in SQL

    Coming soon
  16. Module 16

    Text: collations, regular expressions and full-text search

    Coming soon
  17. Module 17

    Security: injection, privileges and data protection

    Coming soon
  18. Module 18

    Using SQL from application code

    Coming soon
  19. Module 19

    SQL for data analysis

    Coming soon
  20. Module 20

    Dialects and portability

    Coming soon
  21. Module 21

    SQL Server and Oracle side by side

    Coming soon
  22. Module 22

    SQL interview preparation

    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. CSV Editor & Viewer Open, fix and save CSV files in a spreadsheet grid — large files included.

Official documentation

More in Programming languages