# Sources and editorial scope

Reviewed 14 October 2026. The teaching explanations, synthetic dataset, queries, exercises and diagrams in this package are newly authored for Aabha AI Academy. They are not copied from an Oracle PL/SQL course or a third-party tutorial. Official references support syntax and runtime details; the retail metric policy is a stated course assumption.

## Public course alignment

- https://aabhaai.com/courses/sql-data-ai/ — live direct retrieval showed “Planned” and “This course is in preparation. Enrolment is not open.” Its described goal is retrieving and shaping data for analysis or an AI application; preparation is comfort with tables, rows and columns. The direct page snapshot is saved in sources/public-outline.html for traceability.
- https://aabhaai.com/courses/ — a search result indexed an older fuller catalogue including a 13-module SQL listing. Because it conflicts with the live course page, it was not treated as the canonical current syllabus. The 13-module structure here is an authored design proposal.

## Primary technical references

- PostgreSQL tutorial: https://www.postgresql.org/docs/18/tutorial.html
- Joins and matching semantics: https://www.postgresql.org/docs/18/tutorial-join.html
- Queries and logical processing: https://www.postgresql.org/docs/18/sql-select.html
- NULL comparisons: https://www.postgresql.org/docs/18/functions-comparison.html
- Aggregates and empty input: https://www.postgresql.org/docs/18/functions-aggregate.html
- Dates and date_trunc: https://www.postgresql.org/docs/18/functions-datetime.html
- WITH and CTEs: https://www.postgresql.org/docs/18/queries-with.html
- Window functions and frames: https://www.postgresql.org/docs/18/tutorial-window.html
- Constraints: https://www.postgresql.org/docs/18/ddl-constraints.html
- Input validity helpers: https://www.postgresql.org/docs/18/functions-info.html
- Read-only transactions: https://www.postgresql.org/docs/18/sql-set-transaction.html
- EXPLAIN and execution: https://www.postgresql.org/docs/18/sql-explain.html
- PGlite setup and query interface: https://pglite.dev/docs/
- PGlite project and licenses: https://github.com/electric-sql/pglite
- Official Node downloads: https://nodejs.org/en/download
- Official PostgreSQL downloads: https://www.postgresql.org/download/

Versions are pinned for reproducibility rather than a claim to always use the newest release. Check official release and support information before maintaining this package later. No third-party installation binary or dependency is bundled in the ZIP; npm retrieves the pinned dependency when the learner runs setup.