# CS-GY 6083: Principles of Database Systems

## main

- [Introduction](https://vikram-bajaj.gitbook.io/cs-gy-6083-principles-of-database-systems/main-1/undefined.md)
- [DBMS Basics](https://vikram-bajaj.gitbook.io/cs-gy-6083-principles-of-database-systems/main-1/chapter1.md)
- [Introduction to DBMS](https://vikram-bajaj.gitbook.io/cs-gy-6083-principles-of-database-systems/main-1/chapter1/introduction-to-dbms.md)
- [Why use a DBMS instead of a File System?](https://vikram-bajaj.gitbook.io/cs-gy-6083-principles-of-database-systems/main-1/chapter1/why-use-a-dbms-instead-of-a-file-system.md)
- [Levels of Abstraction](https://vikram-bajaj.gitbook.io/cs-gy-6083-principles-of-database-systems/main-1/chapter1/levels-of-abstraction.md)
- [Instances and Schemas](https://vikram-bajaj.gitbook.io/cs-gy-6083-principles-of-database-systems/main-1/chapter1/i-nstances-and-schemas.md)
- [Data Models](https://vikram-bajaj.gitbook.io/cs-gy-6083-principles-of-database-systems/main-1/data-models.md)
- [Introduction to Data Models](https://vikram-bajaj.gitbook.io/cs-gy-6083-principles-of-database-systems/main-1/data-models/introduction-to-data-models.md)
- [Database Languages](https://vikram-bajaj.gitbook.io/cs-gy-6083-principles-of-database-systems/main-1/data-models/database-languages.md)
- [Database Design](https://vikram-bajaj.gitbook.io/cs-gy-6083-principles-of-database-systems/main-1/data-models/database-design.md)
- [DBMS Internals](https://vikram-bajaj.gitbook.io/cs-gy-6083-principles-of-database-systems/main-1/dbms-internals.md)
- [Introduction to DBMS Internals](https://vikram-bajaj.gitbook.io/cs-gy-6083-principles-of-database-systems/main-1/dbms-internals/introduction-to-dbms-internals.md)
- [Storage Manager](https://vikram-bajaj.gitbook.io/cs-gy-6083-principles-of-database-systems/main-1/dbms-internals/storage-manager.md)
- [Query Processor](https://vikram-bajaj.gitbook.io/cs-gy-6083-principles-of-database-systems/main-1/dbms-internals/query-processor.md)
- [Transaction Management](https://vikram-bajaj.gitbook.io/cs-gy-6083-principles-of-database-systems/main-1/dbms-internals/trabsaction-management.md)
- [Database Users](https://vikram-bajaj.gitbook.io/cs-gy-6083-principles-of-database-systems/main-1/dbms-internals/database-users.md)
- [Database Architecture](https://vikram-bajaj.gitbook.io/cs-gy-6083-principles-of-database-systems/main-1/dbms-internals/database-architecture.md)
- [DBMS History](https://vikram-bajaj.gitbook.io/cs-gy-6083-principles-of-database-systems/main-1/dbms-history.md)
- [Some Popular Database Systems](https://vikram-bajaj.gitbook.io/cs-gy-6083-principles-of-database-systems/main-1/some-popular-database-systems.md)
- [OLTP, OLAP, and Data Mining](https://vikram-bajaj.gitbook.io/cs-gy-6083-principles-of-database-systems/main-1/oltp-olap-and-data-mining.md)
- [Databases vs. Information Retrieval](https://vikram-bajaj.gitbook.io/cs-gy-6083-principles-of-database-systems/main-1/databases-vs-information-retrieval.md)
- [The Entity-Relationship Model - Details](https://vikram-bajaj.gitbook.io/cs-gy-6083-principles-of-database-systems/main-1/the-entity-relationship-model-details.md)
- [Introduction](https://vikram-bajaj.gitbook.io/cs-gy-6083-principles-of-database-systems/main-1/the-entity-relationship-model-details/introduction.md)
- [Cardinality Constraints](https://vikram-bajaj.gitbook.io/cs-gy-6083-principles-of-database-systems/main-1/the-entity-relationship-model-details/cardinality-constraints.md)
- [ER Diagram Components](https://vikram-bajaj.gitbook.io/cs-gy-6083-principles-of-database-systems/main-1/the-entity-relationship-model-details/er-diagram-components.md)
- [ER Diagram to Relational Schema](https://vikram-bajaj.gitbook.io/cs-gy-6083-principles-of-database-systems/main-1/the-entity-relationship-model-details/er-diagram-to-relational-schema.md)
- [Design Issues](https://vikram-bajaj.gitbook.io/cs-gy-6083-principles-of-database-systems/main-1/the-entity-relationship-model-details/design-issues.md)
- [The Relational Model - Details](https://vikram-bajaj.gitbook.io/cs-gy-6083-principles-of-database-systems/main-1/the-relational-model-details.md)
- [Relations](https://vikram-bajaj.gitbook.io/cs-gy-6083-principles-of-database-systems/main-1/the-relational-model-details/relation.md)
- [Keys](https://vikram-bajaj.gitbook.io/cs-gy-6083-principles-of-database-systems/main-1/the-relational-model-details/keys.md)
- [Relational Query Languages](https://vikram-bajaj.gitbook.io/cs-gy-6083-principles-of-database-systems/main-1/the-relational-model-details/relational-query-languages.md)
- [Relational Algebra](https://vikram-bajaj.gitbook.io/cs-gy-6083-principles-of-database-systems/main-1/the-relational-model-details/relational-query-languages/relational-algebra.md)
- [Relational Calculus](https://vikram-bajaj.gitbook.io/cs-gy-6083-principles-of-database-systems/main-1/the-relational-model-details/relational-query-languages/relational-calculus.md)
- [Relative Expressive Power](https://vikram-bajaj.gitbook.io/cs-gy-6083-principles-of-database-systems/main-1/the-relational-model-details/relational-query-languages/relative-expressive-power.md)
- [Relational Operators](https://vikram-bajaj.gitbook.io/cs-gy-6083-principles-of-database-systems/main-1/the-relational-model-details/relational-operators.md)
- [SQL](https://vikram-bajaj.gitbook.io/cs-gy-6083-principles-of-database-systems/main-1/sql.md)
- [Introduction to SQL](https://vikram-bajaj.gitbook.io/cs-gy-6083-principles-of-database-systems/main-1/sql/introduction-to-sql.md)
- [Domain Types in SQL](https://vikram-bajaj.gitbook.io/cs-gy-6083-principles-of-database-systems/main-1/sql/domain-types-in-sql.md)
- [DDL Commands](https://vikram-bajaj.gitbook.io/cs-gy-6083-principles-of-database-systems/main-1/sql/ddl-commands.md)
- [Creating a Table](https://vikram-bajaj.gitbook.io/cs-gy-6083-principles-of-database-systems/main-1/sql/ddl-commands/creating-a-table.md)
- [Alter and Drop](https://vikram-bajaj.gitbook.io/cs-gy-6083-principles-of-database-systems/main-1/sql/ddl-commands/alter-and-drop.md)
- [DML Commands](https://vikram-bajaj.gitbook.io/cs-gy-6083-principles-of-database-systems/main-1/sql/dml-commands.md)
- [Basic Query Structure](https://vikram-bajaj.gitbook.io/cs-gy-6083-principles-of-database-systems/main-1/sql/dml-commands/basic-query-structure.md)
- [Select](https://vikram-bajaj.gitbook.io/cs-gy-6083-principles-of-database-systems/main-1/sql/dml-commands/select.md)
- [From](https://vikram-bajaj.gitbook.io/cs-gy-6083-principles-of-database-systems/main-1/sql/dml-commands/from.md)
- [Where](https://vikram-bajaj.gitbook.io/cs-gy-6083-principles-of-database-systems/main-1/sql/dml-commands/where.md)
- [Joins](https://vikram-bajaj.gitbook.io/cs-gy-6083-principles-of-database-systems/main-1/sql/dml-commands/joins.md)
- [Rename](https://vikram-bajaj.gitbook.io/cs-gy-6083-principles-of-database-systems/main-1/sql/dml-commands/rename.md)
- [String Operations](https://vikram-bajaj.gitbook.io/cs-gy-6083-principles-of-database-systems/main-1/sql/dml-commands/string-operations.md)
- [Ordering](https://vikram-bajaj.gitbook.io/cs-gy-6083-principles-of-database-systems/main-1/sql/dml-commands/ordering.md)
- [Set Operations](https://vikram-bajaj.gitbook.io/cs-gy-6083-principles-of-database-systems/main-1/sql/dml-commands/set-operations.md)
- [Group By and Having](https://vikram-bajaj.gitbook.io/cs-gy-6083-principles-of-database-systems/main-1/sql/dml-commands/group-by-and-having.md)
- [Nested Subqueries](https://vikram-bajaj.gitbook.io/cs-gy-6083-principles-of-database-systems/main-1/sql/dml-commands/nested-subqueries.md)
- [Test for Empty Relations](https://vikram-bajaj.gitbook.io/cs-gy-6083-principles-of-database-systems/main-1/sql/dml-commands/test-for-empty-relations.md)
- [Test for Duplicate Tuples](https://vikram-bajaj.gitbook.io/cs-gy-6083-principles-of-database-systems/main-1/sql/dml-commands/test-for-duplicate-tuples.md)
- [Derived Relations](https://vikram-bajaj.gitbook.io/cs-gy-6083-principles-of-database-systems/main-1/sql/dml-commands/derived-relations.md)
- [With](https://vikram-bajaj.gitbook.io/cs-gy-6083-principles-of-database-systems/main-1/sql/dml-commands/with.md)
- [Database Modification](https://vikram-bajaj.gitbook.io/cs-gy-6083-principles-of-database-systems/main-1/sql/dml-commands/database-modification.md)
- [Intermediate SQL](https://vikram-bajaj.gitbook.io/cs-gy-6083-principles-of-database-systems/main-1/sql/intermediate-sql.md)
- [Joins Revisited](https://vikram-bajaj.gitbook.io/cs-gy-6083-principles-of-database-systems/main-1/sql/intermediate-sql/joins-revisited.md)
- [Views](https://vikram-bajaj.gitbook.io/cs-gy-6083-principles-of-database-systems/main-1/sql/intermediate-sql/views.md)
- [Transactions](https://vikram-bajaj.gitbook.io/cs-gy-6083-principles-of-database-systems/main-1/sql/intermediate-sql/transactions.md)
- [Integrity Constraints](https://vikram-bajaj.gitbook.io/cs-gy-6083-principles-of-database-systems/main-1/sql/intermediate-sql/integrity-constraints.md)
- [More SQL Data Types and Schemas](https://vikram-bajaj.gitbook.io/cs-gy-6083-principles-of-database-systems/main-1/sql/intermediate-sql/more-sql-data-types-and-schemas.md)
- [Other Features](https://vikram-bajaj.gitbook.io/cs-gy-6083-principles-of-database-systems/main-1/sql/intermediate-sql/more-sql-data-types-and-schemas/other-features.md)
- [Authorization](https://vikram-bajaj.gitbook.io/cs-gy-6083-principles-of-database-systems/main-1/sql/intermediate-sql/authorization.md)
- [Advanced SQL](https://vikram-bajaj.gitbook.io/cs-gy-6083-principles-of-database-systems/main-1/sql/advanced-sql.md)
- [Accessing SQL From a Programming Language](https://vikram-bajaj.gitbook.io/cs-gy-6083-principles-of-database-systems/main-1/sql/advanced-sql/accessing-sql-from-a-programming-language.md)
- [ODBC and JDBC](https://vikram-bajaj.gitbook.io/cs-gy-6083-principles-of-database-systems/main-1/sql/advanced-sql/accessing-sql-from-a-programming-language/odbc-and-jdbc.md)
- [Embedded SQL](https://vikram-bajaj.gitbook.io/cs-gy-6083-principles-of-database-systems/main-1/sql/advanced-sql/accessing-sql-from-a-programming-language/embedded-sql.md)
- [PHP](https://vikram-bajaj.gitbook.io/cs-gy-6083-principles-of-database-systems/main-1/sql/advanced-sql/accessing-sql-from-a-programming-language/php.md)
- [Some Security Issues](https://vikram-bajaj.gitbook.io/cs-gy-6083-principles-of-database-systems/main-1/sql/advanced-sql/accessing-sql-from-a-programming-language/some-security-issues.md)
- [Accessing Metadata](https://vikram-bajaj.gitbook.io/cs-gy-6083-principles-of-database-systems/main-1/sql/advanced-sql/accessing-metadata.md)
- [Text Operations](https://vikram-bajaj.gitbook.io/cs-gy-6083-principles-of-database-systems/main-1/sql/advanced-sql/text-operations.md)
- [Like](https://vikram-bajaj.gitbook.io/cs-gy-6083-principles-of-database-systems/main-1/sql/advanced-sql/text-operations/like.md)
- [Contains](https://vikram-bajaj.gitbook.io/cs-gy-6083-principles-of-database-systems/main-1/sql/advanced-sql/text-operations/contains.md)
- [Cursors](https://vikram-bajaj.gitbook.io/cs-gy-6083-principles-of-database-systems/main-1/sql/advanced-sql/cursors.md)
- [Functions and Procedures](https://vikram-bajaj.gitbook.io/cs-gy-6083-principles-of-database-systems/main-1/sql/advanced-sql/functions-and-procedures.md)
- [Procedural Constructs](https://vikram-bajaj.gitbook.io/cs-gy-6083-principles-of-database-systems/main-1/sql/advanced-sql/functions-and-procedures/procedural-constructs.md)
- [External Language Routines](https://vikram-bajaj.gitbook.io/cs-gy-6083-principles-of-database-systems/main-1/sql/advanced-sql/functions-and-procedures/external-language-routines.md)
- [Triggers](https://vikram-bajaj.gitbook.io/cs-gy-6083-principles-of-database-systems/main-1/sql/advanced-sql/triggers.md)
- [Ranking](https://vikram-bajaj.gitbook.io/cs-gy-6083-principles-of-database-systems/main-1/sql/advanced-sql/ranking.md)
- [Windowing](https://vikram-bajaj.gitbook.io/cs-gy-6083-principles-of-database-systems/main-1/sql/advanced-sql/windowing.md)
- [OLAP](https://vikram-bajaj.gitbook.io/cs-gy-6083-principles-of-database-systems/main-1/sql/advanced-sql/olap.md)

## 1.0.0

- [Introduction](https://vikram-bajaj.gitbook.io/cs-gy-6083-principles-of-database-systems/master.md)
- [DBMS Basics](https://vikram-bajaj.gitbook.io/cs-gy-6083-principles-of-database-systems/chapter1.md)
- [Introduction to DBMS](https://vikram-bajaj.gitbook.io/cs-gy-6083-principles-of-database-systems/chapter1/introduction-to-dbms.md)
- [Why use a DBMS instead of a File System?](https://vikram-bajaj.gitbook.io/cs-gy-6083-principles-of-database-systems/chapter1/why-use-a-dbms-instead-of-a-file-system.md)
- [Levels of Abstraction](https://vikram-bajaj.gitbook.io/cs-gy-6083-principles-of-database-systems/chapter1/levels-of-abstraction.md)
- [Instances and Schemas](https://vikram-bajaj.gitbook.io/cs-gy-6083-principles-of-database-systems/chapter1/i-nstances-and-schemas.md)
- [Data Models](https://vikram-bajaj.gitbook.io/cs-gy-6083-principles-of-database-systems/data-models.md)
- [Introduction to Data Models](https://vikram-bajaj.gitbook.io/cs-gy-6083-principles-of-database-systems/data-models/introduction-to-data-models.md)
- [Database Languages](https://vikram-bajaj.gitbook.io/cs-gy-6083-principles-of-database-systems/data-models/database-languages.md)
- [Database Design](https://vikram-bajaj.gitbook.io/cs-gy-6083-principles-of-database-systems/data-models/database-design.md)
- [DBMS Internals](https://vikram-bajaj.gitbook.io/cs-gy-6083-principles-of-database-systems/dbms-internals.md)
- [Introduction to DBMS Internals](https://vikram-bajaj.gitbook.io/cs-gy-6083-principles-of-database-systems/dbms-internals/introduction-to-dbms-internals.md)
- [Storage Manager](https://vikram-bajaj.gitbook.io/cs-gy-6083-principles-of-database-systems/dbms-internals/storage-manager.md)
- [Query Processor](https://vikram-bajaj.gitbook.io/cs-gy-6083-principles-of-database-systems/dbms-internals/query-processor.md)
- [Transaction Management](https://vikram-bajaj.gitbook.io/cs-gy-6083-principles-of-database-systems/dbms-internals/trabsaction-management.md)
- [Database Users](https://vikram-bajaj.gitbook.io/cs-gy-6083-principles-of-database-systems/dbms-internals/database-users.md)
- [Database Architecture](https://vikram-bajaj.gitbook.io/cs-gy-6083-principles-of-database-systems/dbms-internals/database-architecture.md)
- [DBMS History](https://vikram-bajaj.gitbook.io/cs-gy-6083-principles-of-database-systems/dbms-history.md)
- [Some Popular Database Systems](https://vikram-bajaj.gitbook.io/cs-gy-6083-principles-of-database-systems/some-popular-database-systems.md)
- [OLTP, OLAP, and Data Mining](https://vikram-bajaj.gitbook.io/cs-gy-6083-principles-of-database-systems/oltp-olap-and-data-mining.md)
- [Databases vs. Information Retrieval](https://vikram-bajaj.gitbook.io/cs-gy-6083-principles-of-database-systems/databases-vs-information-retrieval.md)
- [The Entity-Relationship Model - Details](https://vikram-bajaj.gitbook.io/cs-gy-6083-principles-of-database-systems/the-entity-relationship-model-details.md)
- [Introduction](https://vikram-bajaj.gitbook.io/cs-gy-6083-principles-of-database-systems/the-entity-relationship-model-details/introduction.md)
- [Cardinality Constraints](https://vikram-bajaj.gitbook.io/cs-gy-6083-principles-of-database-systems/the-entity-relationship-model-details/cardinality-constraints.md)
- [ER Diagram Components](https://vikram-bajaj.gitbook.io/cs-gy-6083-principles-of-database-systems/the-entity-relationship-model-details/er-diagram-components.md)
- [ER Diagram to Relational Schema](https://vikram-bajaj.gitbook.io/cs-gy-6083-principles-of-database-systems/the-entity-relationship-model-details/er-diagram-to-relational-schema.md)
- [Design Issues](https://vikram-bajaj.gitbook.io/cs-gy-6083-principles-of-database-systems/the-entity-relationship-model-details/design-issues.md)
- [The Relational Model - Details](https://vikram-bajaj.gitbook.io/cs-gy-6083-principles-of-database-systems/the-relational-model-details.md)
- [Relations](https://vikram-bajaj.gitbook.io/cs-gy-6083-principles-of-database-systems/the-relational-model-details/relation.md)
- [Keys](https://vikram-bajaj.gitbook.io/cs-gy-6083-principles-of-database-systems/the-relational-model-details/keys.md)
- [Relational Query Languages](https://vikram-bajaj.gitbook.io/cs-gy-6083-principles-of-database-systems/the-relational-model-details/relational-query-languages.md)
- [Relational Algebra](https://vikram-bajaj.gitbook.io/cs-gy-6083-principles-of-database-systems/the-relational-model-details/relational-query-languages/relational-algebra.md)
- [Relational Calculus](https://vikram-bajaj.gitbook.io/cs-gy-6083-principles-of-database-systems/the-relational-model-details/relational-query-languages/relational-calculus.md)
- [Relative Expressive Power](https://vikram-bajaj.gitbook.io/cs-gy-6083-principles-of-database-systems/the-relational-model-details/relational-query-languages/relative-expressive-power.md)
- [Relational Operators](https://vikram-bajaj.gitbook.io/cs-gy-6083-principles-of-database-systems/the-relational-model-details/relational-operators.md)
- [SQL](https://vikram-bajaj.gitbook.io/cs-gy-6083-principles-of-database-systems/sql.md)
- [Introduction to SQL](https://vikram-bajaj.gitbook.io/cs-gy-6083-principles-of-database-systems/sql/introduction-to-sql.md)
- [Domain Types in SQL](https://vikram-bajaj.gitbook.io/cs-gy-6083-principles-of-database-systems/sql/domain-types-in-sql.md)
- [DDL Commands](https://vikram-bajaj.gitbook.io/cs-gy-6083-principles-of-database-systems/sql/ddl-commands.md)
- [Creating a Table](https://vikram-bajaj.gitbook.io/cs-gy-6083-principles-of-database-systems/sql/ddl-commands/creating-a-table.md)
- [Alter and Drop](https://vikram-bajaj.gitbook.io/cs-gy-6083-principles-of-database-systems/sql/ddl-commands/alter-and-drop.md)
- [DML Commands](https://vikram-bajaj.gitbook.io/cs-gy-6083-principles-of-database-systems/sql/dml-commands.md)
- [Basic Query Structure](https://vikram-bajaj.gitbook.io/cs-gy-6083-principles-of-database-systems/sql/dml-commands/basic-query-structure.md)
- [Select](https://vikram-bajaj.gitbook.io/cs-gy-6083-principles-of-database-systems/sql/dml-commands/select.md)
- [From](https://vikram-bajaj.gitbook.io/cs-gy-6083-principles-of-database-systems/sql/dml-commands/from.md)
- [Where](https://vikram-bajaj.gitbook.io/cs-gy-6083-principles-of-database-systems/sql/dml-commands/where.md)
- [Joins](https://vikram-bajaj.gitbook.io/cs-gy-6083-principles-of-database-systems/sql/dml-commands/joins.md)
- [Rename](https://vikram-bajaj.gitbook.io/cs-gy-6083-principles-of-database-systems/sql/dml-commands/rename.md)
- [String Operations](https://vikram-bajaj.gitbook.io/cs-gy-6083-principles-of-database-systems/sql/dml-commands/string-operations.md)
- [Ordering](https://vikram-bajaj.gitbook.io/cs-gy-6083-principles-of-database-systems/sql/dml-commands/ordering.md)
- [Set Operations](https://vikram-bajaj.gitbook.io/cs-gy-6083-principles-of-database-systems/sql/dml-commands/set-operations.md)
- [Group By and Having](https://vikram-bajaj.gitbook.io/cs-gy-6083-principles-of-database-systems/sql/dml-commands/group-by-and-having.md)
- [Nested Subqueries](https://vikram-bajaj.gitbook.io/cs-gy-6083-principles-of-database-systems/sql/dml-commands/nested-subqueries.md)
- [Test for Empty Relations](https://vikram-bajaj.gitbook.io/cs-gy-6083-principles-of-database-systems/sql/dml-commands/test-for-empty-relations.md)
- [Test for Duplicate Tuples](https://vikram-bajaj.gitbook.io/cs-gy-6083-principles-of-database-systems/sql/dml-commands/test-for-duplicate-tuples.md)
- [Derived Relations](https://vikram-bajaj.gitbook.io/cs-gy-6083-principles-of-database-systems/sql/dml-commands/derived-relations.md)
- [With](https://vikram-bajaj.gitbook.io/cs-gy-6083-principles-of-database-systems/sql/dml-commands/with.md)
- [Database Modification](https://vikram-bajaj.gitbook.io/cs-gy-6083-principles-of-database-systems/sql/dml-commands/database-modification.md)
- [Intermediate SQL](https://vikram-bajaj.gitbook.io/cs-gy-6083-principles-of-database-systems/sql/intermediate-sql.md)
- [Joins Revisited](https://vikram-bajaj.gitbook.io/cs-gy-6083-principles-of-database-systems/sql/intermediate-sql/joins-revisited.md)
- [Views](https://vikram-bajaj.gitbook.io/cs-gy-6083-principles-of-database-systems/sql/intermediate-sql/views.md)
- [Transactions](https://vikram-bajaj.gitbook.io/cs-gy-6083-principles-of-database-systems/sql/intermediate-sql/transactions.md)
- [Integrity Constraints](https://vikram-bajaj.gitbook.io/cs-gy-6083-principles-of-database-systems/sql/intermediate-sql/integrity-constraints.md)
- [More SQL Data Types and Schemas](https://vikram-bajaj.gitbook.io/cs-gy-6083-principles-of-database-systems/sql/intermediate-sql/more-sql-data-types-and-schemas.md)
- [Other Features](https://vikram-bajaj.gitbook.io/cs-gy-6083-principles-of-database-systems/sql/intermediate-sql/more-sql-data-types-and-schemas/other-features.md)
- [Authorization](https://vikram-bajaj.gitbook.io/cs-gy-6083-principles-of-database-systems/sql/intermediate-sql/authorization.md)
- [Advanced SQL](https://vikram-bajaj.gitbook.io/cs-gy-6083-principles-of-database-systems/sql/advanced-sql.md)
- [Accessing SQL From a Programming Language](https://vikram-bajaj.gitbook.io/cs-gy-6083-principles-of-database-systems/sql/advanced-sql/accessing-sql-from-a-programming-language.md)
- [ODBC and JDBC](https://vikram-bajaj.gitbook.io/cs-gy-6083-principles-of-database-systems/sql/advanced-sql/accessing-sql-from-a-programming-language/odbc-and-jdbc.md)
- [Embedded SQL](https://vikram-bajaj.gitbook.io/cs-gy-6083-principles-of-database-systems/sql/advanced-sql/accessing-sql-from-a-programming-language/embedded-sql.md)
- [PHP](https://vikram-bajaj.gitbook.io/cs-gy-6083-principles-of-database-systems/sql/advanced-sql/accessing-sql-from-a-programming-language/php.md)
- [Some Security Issues](https://vikram-bajaj.gitbook.io/cs-gy-6083-principles-of-database-systems/sql/advanced-sql/accessing-sql-from-a-programming-language/some-security-issues.md)
- [Accessing Metadata](https://vikram-bajaj.gitbook.io/cs-gy-6083-principles-of-database-systems/sql/advanced-sql/accessing-metadata.md)
- [Text Operations](https://vikram-bajaj.gitbook.io/cs-gy-6083-principles-of-database-systems/sql/advanced-sql/text-operations.md)
- [Like](https://vikram-bajaj.gitbook.io/cs-gy-6083-principles-of-database-systems/sql/advanced-sql/text-operations/like.md)
- [Contains](https://vikram-bajaj.gitbook.io/cs-gy-6083-principles-of-database-systems/sql/advanced-sql/text-operations/contains.md)
- [Cursors](https://vikram-bajaj.gitbook.io/cs-gy-6083-principles-of-database-systems/sql/advanced-sql/cursors.md)
- [Functions and Procedures](https://vikram-bajaj.gitbook.io/cs-gy-6083-principles-of-database-systems/sql/advanced-sql/functions-and-procedures.md)
- [Procedural Constructs](https://vikram-bajaj.gitbook.io/cs-gy-6083-principles-of-database-systems/sql/advanced-sql/functions-and-procedures/procedural-constructs.md)
- [External Language Routines](https://vikram-bajaj.gitbook.io/cs-gy-6083-principles-of-database-systems/sql/advanced-sql/functions-and-procedures/external-language-routines.md)
- [Triggers](https://vikram-bajaj.gitbook.io/cs-gy-6083-principles-of-database-systems/sql/advanced-sql/triggers.md)
- [Ranking](https://vikram-bajaj.gitbook.io/cs-gy-6083-principles-of-database-systems/sql/advanced-sql/ranking.md)
- [Windowing](https://vikram-bajaj.gitbook.io/cs-gy-6083-principles-of-database-systems/sql/advanced-sql/windowing.md)
- [OLAP](https://vikram-bajaj.gitbook.io/cs-gy-6083-principles-of-database-systems/sql/advanced-sql/olap.md)