> For the complete documentation index, see [llms.txt](https://vikram-bajaj.gitbook.io/cs-gy-6083-principles-of-database-systems/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://vikram-bajaj.gitbook.io/cs-gy-6083-principles-of-database-systems/main-1/sql/advanced-sql.md).

# Advanced SQL

This chapter discusses:

* Accessing SQL From a Programming Language
  * Dynamic SQL: JDBC and ODBC
  * Embedded SQL
  * PHP Overview
* Accessing metadata
* Text Operations
* Functions and Procedural Constructs
* Triggers
* Advanced Aggregation Features
* OLAP