{"version":1,"pages":[{"id":"-MTYAqQWDjXjy6iyDuIW","title":"Introduction","pathname":"/cs-gy-6083-principles-of-database-systems/main-1","siteSpaceId":"sitesp_j7Hzy","description":""},{"id":"-MTYAqPDj3mO8euZuw3Z","title":"DBMS Basics","pathname":"/cs-gy-6083-principles-of-database-systems/main-1/chapter1","siteSpaceId":"sitesp_j7Hzy","description":""},{"id":"-MTYAqPEKBcjP1dfMZoq","title":"Introduction to DBMS","pathname":"/cs-gy-6083-principles-of-database-systems/main-1/chapter1/introduction-to-dbms","siteSpaceId":"sitesp_j7Hzy","description":"","breadcrumbs":[{"label":"DBMS Basics"}]},{"id":"-MTYAqPFe5e-CJPZOdWV","title":"Why use a DBMS instead of a File System?","pathname":"/cs-gy-6083-principles-of-database-systems/main-1/chapter1/why-use-a-dbms-instead-of-a-file-system","siteSpaceId":"sitesp_j7Hzy","description":"","breadcrumbs":[{"label":"DBMS Basics"}]},{"id":"-MTYAqPGwebDNyzmxbov","title":"Levels of Abstraction","pathname":"/cs-gy-6083-principles-of-database-systems/main-1/chapter1/levels-of-abstraction","siteSpaceId":"sitesp_j7Hzy","description":"","breadcrumbs":[{"label":"DBMS Basics"}]},{"id":"-MTYAqPHxxt87KBygXlb","title":"Instances and Schemas","pathname":"/cs-gy-6083-principles-of-database-systems/main-1/chapter1/i-nstances-and-schemas","siteSpaceId":"sitesp_j7Hzy","description":"","breadcrumbs":[{"label":"DBMS Basics"}]},{"id":"-MTYAqPICYp9Kmkc-BoG","title":"Data Models","pathname":"/cs-gy-6083-principles-of-database-systems/main-1/data-models","siteSpaceId":"sitesp_j7Hzy","description":""},{"id":"-MTYAqPJ2pYmewOYjseS","title":"Introduction to Data Models","pathname":"/cs-gy-6083-principles-of-database-systems/main-1/data-models/introduction-to-data-models","siteSpaceId":"sitesp_j7Hzy","description":"","breadcrumbs":[{"label":"Data Models"}]},{"id":"-MTYAqPKzwjeah0iL0BJ","title":"Database Languages","pathname":"/cs-gy-6083-principles-of-database-systems/main-1/data-models/database-languages","siteSpaceId":"sitesp_j7Hzy","description":"","breadcrumbs":[{"label":"Data Models"}]},{"id":"-MTYAqPLgFd4Gwr_-jD1","title":"Database Design","pathname":"/cs-gy-6083-principles-of-database-systems/main-1/data-models/database-design","siteSpaceId":"sitesp_j7Hzy","description":"","breadcrumbs":[{"label":"Data Models"}]},{"id":"-MTYAqPMVnKJKLychheA","title":"DBMS Internals","pathname":"/cs-gy-6083-principles-of-database-systems/main-1/dbms-internals","siteSpaceId":"sitesp_j7Hzy","description":""},{"id":"-MTYAqPNvs6YZZjItM7H","title":"Introduction to DBMS Internals","pathname":"/cs-gy-6083-principles-of-database-systems/main-1/dbms-internals/introduction-to-dbms-internals","siteSpaceId":"sitesp_j7Hzy","description":"","breadcrumbs":[{"label":"DBMS Internals"}]},{"id":"-MTYAqPOdvUHBC__54Ev","title":"Storage Manager","pathname":"/cs-gy-6083-principles-of-database-systems/main-1/dbms-internals/storage-manager","siteSpaceId":"sitesp_j7Hzy","description":"","breadcrumbs":[{"label":"DBMS Internals"}]},{"id":"-MTYAqPP4lzHIIJbHxVT","title":"Query Processor","pathname":"/cs-gy-6083-principles-of-database-systems/main-1/dbms-internals/query-processor","siteSpaceId":"sitesp_j7Hzy","description":"","breadcrumbs":[{"label":"DBMS Internals"}]},{"id":"-MTYAqPQjj1oujZot0Kr","title":"Transaction Management","pathname":"/cs-gy-6083-principles-of-database-systems/main-1/dbms-internals/trabsaction-management","siteSpaceId":"sitesp_j7Hzy","description":"","breadcrumbs":[{"label":"DBMS Internals"}]},{"id":"-MTYAqPRcP_u-EaykxUr","title":"Database Users","pathname":"/cs-gy-6083-principles-of-database-systems/main-1/dbms-internals/database-users","siteSpaceId":"sitesp_j7Hzy","description":"","breadcrumbs":[{"label":"DBMS Internals"}]},{"id":"-MTYAqPSwNUT1PAOXk2g","title":"Database Architecture","pathname":"/cs-gy-6083-principles-of-database-systems/main-1/dbms-internals/database-architecture","siteSpaceId":"sitesp_j7Hzy","description":"","breadcrumbs":[{"label":"DBMS Internals"}]},{"id":"-MTYAqPTfP5WA90iSfJv","title":"DBMS History","pathname":"/cs-gy-6083-principles-of-database-systems/main-1/dbms-history","siteSpaceId":"sitesp_j7Hzy","description":""},{"id":"-MTYAqPUgfxPImTG2uSh","title":"Some Popular Database Systems","pathname":"/cs-gy-6083-principles-of-database-systems/main-1/some-popular-database-systems","siteSpaceId":"sitesp_j7Hzy","description":""},{"id":"-MTYAqPVSec93Eh_l7kx","title":"OLTP, OLAP, and Data Mining","pathname":"/cs-gy-6083-principles-of-database-systems/main-1/oltp-olap-and-data-mining","siteSpaceId":"sitesp_j7Hzy","description":""},{"id":"-MTYAqPWC-8kWa0_wBf3","title":"Databases vs. Information Retrieval","pathname":"/cs-gy-6083-principles-of-database-systems/main-1/databases-vs-information-retrieval","siteSpaceId":"sitesp_j7Hzy","description":""},{"id":"-MTYAqPXCWQCGfrYHGeD","title":"The Entity-Relationship Model - Details","pathname":"/cs-gy-6083-principles-of-database-systems/main-1/the-entity-relationship-model-details","siteSpaceId":"sitesp_j7Hzy","description":""},{"id":"-MTYAqPYkaEjwJ6iAARY","title":"Introduction","pathname":"/cs-gy-6083-principles-of-database-systems/main-1/the-entity-relationship-model-details/introduction","siteSpaceId":"sitesp_j7Hzy","description":"","breadcrumbs":[{"label":"The Entity-Relationship Model - Details"}]},{"id":"-MTYAqPZdmX1mofNr596","title":"Cardinality Constraints","pathname":"/cs-gy-6083-principles-of-database-systems/main-1/the-entity-relationship-model-details/cardinality-constraints","siteSpaceId":"sitesp_j7Hzy","description":"","breadcrumbs":[{"label":"The Entity-Relationship Model - Details"}]},{"id":"-MTYAqP_R-arBQobz454","title":"ER Diagram Components","pathname":"/cs-gy-6083-principles-of-database-systems/main-1/the-entity-relationship-model-details/er-diagram-components","siteSpaceId":"sitesp_j7Hzy","description":"","breadcrumbs":[{"label":"The Entity-Relationship Model - Details"}]},{"id":"-MTYAqPaGoAJf0FEVLn8","title":"ER Diagram to Relational Schema","pathname":"/cs-gy-6083-principles-of-database-systems/main-1/the-entity-relationship-model-details/er-diagram-to-relational-schema","siteSpaceId":"sitesp_j7Hzy","description":"","breadcrumbs":[{"label":"The Entity-Relationship Model - Details"}]},{"id":"-MTYAqPbzBMNi2HeNY_P","title":"Design Issues","pathname":"/cs-gy-6083-principles-of-database-systems/main-1/the-entity-relationship-model-details/design-issues","siteSpaceId":"sitesp_j7Hzy","description":"","breadcrumbs":[{"label":"The Entity-Relationship Model - Details"}]},{"id":"-MTYAqPclegRe3dJEr3Z","title":"The Relational Model - Details","pathname":"/cs-gy-6083-principles-of-database-systems/main-1/the-relational-model-details","siteSpaceId":"sitesp_j7Hzy","description":""},{"id":"-MTYAqPdRuCLOstyZ_pz","title":"Relations","pathname":"/cs-gy-6083-principles-of-database-systems/main-1/the-relational-model-details/relation","siteSpaceId":"sitesp_j7Hzy","description":"","breadcrumbs":[{"label":"The Relational Model - Details"}]},{"id":"-MTYAqPeioa3V9K5pVBX","title":"Keys","pathname":"/cs-gy-6083-principles-of-database-systems/main-1/the-relational-model-details/keys","siteSpaceId":"sitesp_j7Hzy","description":"","breadcrumbs":[{"label":"The Relational Model - Details"}]},{"id":"-MTYAqPfN6D4HxpWRn4Y","title":"Relational Query Languages","pathname":"/cs-gy-6083-principles-of-database-systems/main-1/the-relational-model-details/relational-query-languages","siteSpaceId":"sitesp_j7Hzy","description":"","breadcrumbs":[{"label":"The Relational Model - Details"}]},{"id":"-MTYAqPgNFotxqy93Gar","title":"Relational Algebra","pathname":"/cs-gy-6083-principles-of-database-systems/main-1/the-relational-model-details/relational-query-languages/relational-algebra","siteSpaceId":"sitesp_j7Hzy","description":"","breadcrumbs":[{"label":"The Relational Model - Details"},{"label":"Relational Query Languages"}]},{"id":"-MTYAqPhr8qPNYyZlALW","title":"Relational Calculus","pathname":"/cs-gy-6083-principles-of-database-systems/main-1/the-relational-model-details/relational-query-languages/relational-calculus","siteSpaceId":"sitesp_j7Hzy","description":"","breadcrumbs":[{"label":"The Relational Model - Details"},{"label":"Relational Query Languages"}]},{"id":"-MTYAqPii4AWBxmKsWpf","title":"Relative Expressive Power","pathname":"/cs-gy-6083-principles-of-database-systems/main-1/the-relational-model-details/relational-query-languages/relative-expressive-power","siteSpaceId":"sitesp_j7Hzy","description":"","breadcrumbs":[{"label":"The Relational Model - Details"},{"label":"Relational Query Languages"}]},{"id":"-MTYAqPjRTumoG25VhU9","title":"Relational Operators","pathname":"/cs-gy-6083-principles-of-database-systems/main-1/the-relational-model-details/relational-operators","siteSpaceId":"sitesp_j7Hzy","description":"","breadcrumbs":[{"label":"The Relational Model - Details"}]},{"id":"-MTYAqPkOzXTMYGnKkkT","title":"SQL","pathname":"/cs-gy-6083-principles-of-database-systems/main-1/sql","siteSpaceId":"sitesp_j7Hzy","description":""},{"id":"-MTYAqPlcbnBnAftnmUy","title":"Introduction to SQL","pathname":"/cs-gy-6083-principles-of-database-systems/main-1/sql/introduction-to-sql","siteSpaceId":"sitesp_j7Hzy","description":"","breadcrumbs":[{"label":"SQL"}]},{"id":"-MTYAqPmHRbaBoiIJ6r4","title":"Domain Types in SQL","pathname":"/cs-gy-6083-principles-of-database-systems/main-1/sql/domain-types-in-sql","siteSpaceId":"sitesp_j7Hzy","description":"","breadcrumbs":[{"label":"SQL"}]},{"id":"-MTYAqPn9uIgcZGsSDpg","title":"DDL Commands","pathname":"/cs-gy-6083-principles-of-database-systems/main-1/sql/ddl-commands","siteSpaceId":"sitesp_j7Hzy","description":"","breadcrumbs":[{"label":"SQL"}]},{"id":"-MTYAqPospr2QdaGJxeU","title":"Creating a Table","pathname":"/cs-gy-6083-principles-of-database-systems/main-1/sql/ddl-commands/creating-a-table","siteSpaceId":"sitesp_j7Hzy","description":"","breadcrumbs":[{"label":"SQL"},{"label":"DDL Commands"}]},{"id":"-MTYAqPpvpm6t8_E2dme","title":"Alter and Drop","pathname":"/cs-gy-6083-principles-of-database-systems/main-1/sql/ddl-commands/alter-and-drop","siteSpaceId":"sitesp_j7Hzy","description":"","breadcrumbs":[{"label":"SQL"},{"label":"DDL Commands"}]},{"id":"-MTYAqPqQu-wfhicFOCr","title":"DML Commands","pathname":"/cs-gy-6083-principles-of-database-systems/main-1/sql/dml-commands","siteSpaceId":"sitesp_j7Hzy","description":"","breadcrumbs":[{"label":"SQL"}]},{"id":"-MTYAqPrpRceaiOSNDSU","title":"Basic Query Structure","pathname":"/cs-gy-6083-principles-of-database-systems/main-1/sql/dml-commands/basic-query-structure","siteSpaceId":"sitesp_j7Hzy","description":"","breadcrumbs":[{"label":"SQL"},{"label":"DML Commands"}]},{"id":"-MTYAqPsuUNyDwBnjz9h","title":"Select","pathname":"/cs-gy-6083-principles-of-database-systems/main-1/sql/dml-commands/select","siteSpaceId":"sitesp_j7Hzy","description":"","breadcrumbs":[{"label":"SQL"},{"label":"DML Commands"}]},{"id":"-MTYAqPtZIjXZvMF_tl9","title":"From","pathname":"/cs-gy-6083-principles-of-database-systems/main-1/sql/dml-commands/from","siteSpaceId":"sitesp_j7Hzy","description":"","breadcrumbs":[{"label":"SQL"},{"label":"DML Commands"}]},{"id":"-MTYAqPuIIGeDYDsGQI8","title":"Where","pathname":"/cs-gy-6083-principles-of-database-systems/main-1/sql/dml-commands/where","siteSpaceId":"sitesp_j7Hzy","description":"","breadcrumbs":[{"label":"SQL"},{"label":"DML Commands"}]},{"id":"-MTYAqPvOf7tChav5NqF","title":"Joins","pathname":"/cs-gy-6083-principles-of-database-systems/main-1/sql/dml-commands/joins","siteSpaceId":"sitesp_j7Hzy","description":"","breadcrumbs":[{"label":"SQL"},{"label":"DML Commands"}]},{"id":"-MTYAqPw7glej94ekCx1","title":"Rename","pathname":"/cs-gy-6083-principles-of-database-systems/main-1/sql/dml-commands/rename","siteSpaceId":"sitesp_j7Hzy","description":"","breadcrumbs":[{"label":"SQL"},{"label":"DML Commands"}]},{"id":"-MTYAqPxlDQX7g2y0Qq2","title":"String Operations","pathname":"/cs-gy-6083-principles-of-database-systems/main-1/sql/dml-commands/string-operations","siteSpaceId":"sitesp_j7Hzy","description":"","breadcrumbs":[{"label":"SQL"},{"label":"DML Commands"}]},{"id":"-MTYAqPykSIyiKGa5HFx","title":"Ordering","pathname":"/cs-gy-6083-principles-of-database-systems/main-1/sql/dml-commands/ordering","siteSpaceId":"sitesp_j7Hzy","description":"","breadcrumbs":[{"label":"SQL"},{"label":"DML Commands"}]},{"id":"-MTYAqPz-0p4vyI-r3YA","title":"Set Operations","pathname":"/cs-gy-6083-principles-of-database-systems/main-1/sql/dml-commands/set-operations","siteSpaceId":"sitesp_j7Hzy","description":"","breadcrumbs":[{"label":"SQL"},{"label":"DML Commands"}]},{"id":"-MTYAqQ-MIh_J4v9Q5KC","title":"Group By and Having","pathname":"/cs-gy-6083-principles-of-database-systems/main-1/sql/dml-commands/group-by-and-having","siteSpaceId":"sitesp_j7Hzy","description":"","breadcrumbs":[{"label":"SQL"},{"label":"DML Commands"}]},{"id":"-MTYAqQ0tJaxfO371PuA","title":"Nested Subqueries","pathname":"/cs-gy-6083-principles-of-database-systems/main-1/sql/dml-commands/nested-subqueries","siteSpaceId":"sitesp_j7Hzy","description":"","breadcrumbs":[{"label":"SQL"},{"label":"DML Commands"}]},{"id":"-MTYAqQ1356BX6Sk-ahR","title":"Test for Empty Relations","pathname":"/cs-gy-6083-principles-of-database-systems/main-1/sql/dml-commands/test-for-empty-relations","siteSpaceId":"sitesp_j7Hzy","description":"","breadcrumbs":[{"label":"SQL"},{"label":"DML Commands"}]},{"id":"-MTYAqQ27sfAgEcFpaVp","title":"Test for Duplicate Tuples","pathname":"/cs-gy-6083-principles-of-database-systems/main-1/sql/dml-commands/test-for-duplicate-tuples","siteSpaceId":"sitesp_j7Hzy","description":"","breadcrumbs":[{"label":"SQL"},{"label":"DML Commands"}]},{"id":"-MTYAqQ3M90U8njoDBYF","title":"Derived Relations","pathname":"/cs-gy-6083-principles-of-database-systems/main-1/sql/dml-commands/derived-relations","siteSpaceId":"sitesp_j7Hzy","description":"","breadcrumbs":[{"label":"SQL"},{"label":"DML Commands"}]},{"id":"-MTYAqQ4cV4IzRRvRBcu","title":"With","pathname":"/cs-gy-6083-principles-of-database-systems/main-1/sql/dml-commands/with","siteSpaceId":"sitesp_j7Hzy","description":"","breadcrumbs":[{"label":"SQL"},{"label":"DML Commands"}]},{"id":"-MTYAqQ5OOFWahDFeMrQ","title":"Database Modification","pathname":"/cs-gy-6083-principles-of-database-systems/main-1/sql/dml-commands/database-modification","siteSpaceId":"sitesp_j7Hzy","description":"","breadcrumbs":[{"label":"SQL"},{"label":"DML Commands"}]},{"id":"-MTYAqQ6ZZB52sCm1l7t","title":"Intermediate SQL","pathname":"/cs-gy-6083-principles-of-database-systems/main-1/sql/intermediate-sql","siteSpaceId":"sitesp_j7Hzy","description":"","breadcrumbs":[{"label":"SQL"}]},{"id":"-MTYAqQ73zWH9Yv2Voxj","title":"Joins Revisited","pathname":"/cs-gy-6083-principles-of-database-systems/main-1/sql/intermediate-sql/joins-revisited","siteSpaceId":"sitesp_j7Hzy","description":"","breadcrumbs":[{"label":"SQL"},{"label":"Intermediate SQL"}]},{"id":"-MTYAqQ88LjcxD9MxUQE","title":"Views","pathname":"/cs-gy-6083-principles-of-database-systems/main-1/sql/intermediate-sql/views","siteSpaceId":"sitesp_j7Hzy","description":"","breadcrumbs":[{"label":"SQL"},{"label":"Intermediate SQL"}]},{"id":"-MTYAqQ9UwzTM2DsGvOy","title":"Transactions","pathname":"/cs-gy-6083-principles-of-database-systems/main-1/sql/intermediate-sql/transactions","siteSpaceId":"sitesp_j7Hzy","description":"","breadcrumbs":[{"label":"SQL"},{"label":"Intermediate SQL"}]},{"id":"-MTYAqQAleMRdIYrgjIg","title":"Integrity Constraints","pathname":"/cs-gy-6083-principles-of-database-systems/main-1/sql/intermediate-sql/integrity-constraints","siteSpaceId":"sitesp_j7Hzy","description":"","breadcrumbs":[{"label":"SQL"},{"label":"Intermediate SQL"}]},{"id":"-MTYAqQBjkFe4Nvl_0wZ","title":"More SQL Data Types and Schemas","pathname":"/cs-gy-6083-principles-of-database-systems/main-1/sql/intermediate-sql/more-sql-data-types-and-schemas","siteSpaceId":"sitesp_j7Hzy","description":"","breadcrumbs":[{"label":"SQL"},{"label":"Intermediate SQL"}]},{"id":"-MTYAqQCGrgN8H85urPB","title":"Other Features","pathname":"/cs-gy-6083-principles-of-database-systems/main-1/sql/intermediate-sql/more-sql-data-types-and-schemas/other-features","siteSpaceId":"sitesp_j7Hzy","description":"","breadcrumbs":[{"label":"SQL"},{"label":"Intermediate SQL"},{"label":"More SQL Data Types and Schemas"}]},{"id":"-MTYAqQDmjduiUbJoQcs","title":"Authorization","pathname":"/cs-gy-6083-principles-of-database-systems/main-1/sql/intermediate-sql/authorization","siteSpaceId":"sitesp_j7Hzy","description":"","breadcrumbs":[{"label":"SQL"},{"label":"Intermediate SQL"}]},{"id":"-MTYAqQEYKFNShJYbu-E","title":"Advanced SQL","pathname":"/cs-gy-6083-principles-of-database-systems/main-1/sql/advanced-sql","siteSpaceId":"sitesp_j7Hzy","description":"","breadcrumbs":[{"label":"SQL"}]},{"id":"-MTYAqQFQCFpSYN-PxTF","title":"Accessing SQL From a Programming Language","pathname":"/cs-gy-6083-principles-of-database-systems/main-1/sql/advanced-sql/accessing-sql-from-a-programming-language","siteSpaceId":"sitesp_j7Hzy","description":"","breadcrumbs":[{"label":"SQL"},{"label":"Advanced SQL"}]},{"id":"-MTYAqQGujuFJSR3Vwqe","title":"ODBC and JDBC","pathname":"/cs-gy-6083-principles-of-database-systems/main-1/sql/advanced-sql/accessing-sql-from-a-programming-language/odbc-and-jdbc","siteSpaceId":"sitesp_j7Hzy","description":"","breadcrumbs":[{"label":"SQL"},{"label":"Advanced SQL"},{"label":"Accessing SQL From a Programming Language"}]},{"id":"-MTYAqQHsAgFEIGEma0Z","title":"Embedded SQL","pathname":"/cs-gy-6083-principles-of-database-systems/main-1/sql/advanced-sql/accessing-sql-from-a-programming-language/embedded-sql","siteSpaceId":"sitesp_j7Hzy","description":"","breadcrumbs":[{"label":"SQL"},{"label":"Advanced SQL"},{"label":"Accessing SQL From a Programming Language"}]},{"id":"-MTYAqQIBNz3rKyh-Ycr","title":"PHP","pathname":"/cs-gy-6083-principles-of-database-systems/main-1/sql/advanced-sql/accessing-sql-from-a-programming-language/php","siteSpaceId":"sitesp_j7Hzy","description":"","breadcrumbs":[{"label":"SQL"},{"label":"Advanced SQL"},{"label":"Accessing SQL From a Programming Language"}]},{"id":"-MTYAqQJKOGHqEEFhJ-Z","title":"Some Security Issues","pathname":"/cs-gy-6083-principles-of-database-systems/main-1/sql/advanced-sql/accessing-sql-from-a-programming-language/some-security-issues","siteSpaceId":"sitesp_j7Hzy","description":"","breadcrumbs":[{"label":"SQL"},{"label":"Advanced SQL"},{"label":"Accessing SQL From a Programming Language"}]},{"id":"-MTYAqQK_nydlSjqNHXp","title":"Accessing Metadata","pathname":"/cs-gy-6083-principles-of-database-systems/main-1/sql/advanced-sql/accessing-metadata","siteSpaceId":"sitesp_j7Hzy","description":"","breadcrumbs":[{"label":"SQL"},{"label":"Advanced SQL"}]},{"id":"-MTYAqQLH0tN8d9df7sj","title":"Text Operations","pathname":"/cs-gy-6083-principles-of-database-systems/main-1/sql/advanced-sql/text-operations","siteSpaceId":"sitesp_j7Hzy","description":"","breadcrumbs":[{"label":"SQL"},{"label":"Advanced SQL"}]},{"id":"-MTYAqQMpBmlfN1gjfcx","title":"Like","pathname":"/cs-gy-6083-principles-of-database-systems/main-1/sql/advanced-sql/text-operations/like","siteSpaceId":"sitesp_j7Hzy","description":"","breadcrumbs":[{"label":"SQL"},{"label":"Advanced SQL"},{"label":"Text Operations"}]},{"id":"-MTYAqQNx330rWyiiMRr","title":"Contains","pathname":"/cs-gy-6083-principles-of-database-systems/main-1/sql/advanced-sql/text-operations/contains","siteSpaceId":"sitesp_j7Hzy","description":"","breadcrumbs":[{"label":"SQL"},{"label":"Advanced SQL"},{"label":"Text Operations"}]},{"id":"-MTYAqQOBwo3fwJkYfNN","title":"Cursors","pathname":"/cs-gy-6083-principles-of-database-systems/main-1/sql/advanced-sql/cursors","siteSpaceId":"sitesp_j7Hzy","description":"","breadcrumbs":[{"label":"SQL"},{"label":"Advanced SQL"}]},{"id":"-MTYAqQPPg-4KG_TVepU","title":"Functions and Procedures","pathname":"/cs-gy-6083-principles-of-database-systems/main-1/sql/advanced-sql/functions-and-procedures","siteSpaceId":"sitesp_j7Hzy","description":"","breadcrumbs":[{"label":"SQL"},{"label":"Advanced SQL"}]},{"id":"-MTYAqQQMFiHS_VMylP7","title":"Procedural Constructs","pathname":"/cs-gy-6083-principles-of-database-systems/main-1/sql/advanced-sql/functions-and-procedures/procedural-constructs","siteSpaceId":"sitesp_j7Hzy","description":"","breadcrumbs":[{"label":"SQL"},{"label":"Advanced SQL"},{"label":"Functions and Procedures"}]},{"id":"-MTYAqQR86xV830MJKgp","title":"External Language Routines","pathname":"/cs-gy-6083-principles-of-database-systems/main-1/sql/advanced-sql/functions-and-procedures/external-language-routines","siteSpaceId":"sitesp_j7Hzy","description":"","breadcrumbs":[{"label":"SQL"},{"label":"Advanced SQL"},{"label":"Functions and Procedures"}]},{"id":"-MTYAqQSNckHGdqAvXZz","title":"Triggers","pathname":"/cs-gy-6083-principles-of-database-systems/main-1/sql/advanced-sql/triggers","siteSpaceId":"sitesp_j7Hzy","description":"","breadcrumbs":[{"label":"SQL"},{"label":"Advanced SQL"}]},{"id":"-MTYAqQTZPqVSNRBR0N6","title":"Ranking","pathname":"/cs-gy-6083-principles-of-database-systems/main-1/sql/advanced-sql/ranking","siteSpaceId":"sitesp_j7Hzy","description":"","breadcrumbs":[{"label":"SQL"},{"label":"Advanced SQL"}]},{"id":"-MTYAqQUud_usr8VCcJG","title":"Windowing","pathname":"/cs-gy-6083-principles-of-database-systems/main-1/sql/advanced-sql/windowing","siteSpaceId":"sitesp_j7Hzy","description":"","breadcrumbs":[{"label":"SQL"},{"label":"Advanced SQL"}]},{"id":"-MTYAqQVWB1ErnC3j1IG","title":"OLAP","pathname":"/cs-gy-6083-principles-of-database-systems/main-1/sql/advanced-sql/olap","siteSpaceId":"sitesp_j7Hzy","description":"","breadcrumbs":[{"label":"SQL"},{"label":"Advanced SQL"}]},{"id":"-M5-0RGVxtpkw1dapREE","title":"Introduction","pathname":"/cs-gy-6083-principles-of-database-systems","siteSpaceId":"sitesp_HvXfJ","description":""},{"id":"-M5-0X3bmWPii6ohXlNx","title":"DBMS Basics","pathname":"/cs-gy-6083-principles-of-database-systems/chapter1","siteSpaceId":"sitesp_HvXfJ","description":""},{"id":"-M5-0X3cWtqSu-iu2MMW","title":"Introduction to DBMS","pathname":"/cs-gy-6083-principles-of-database-systems/chapter1/introduction-to-dbms","siteSpaceId":"sitesp_HvXfJ","description":"","breadcrumbs":[{"label":"DBMS Basics"}]},{"id":"-M5-0X3duvPuWB9xqdqJ","title":"Why use a DBMS instead of a File System?","pathname":"/cs-gy-6083-principles-of-database-systems/chapter1/why-use-a-dbms-instead-of-a-file-system","siteSpaceId":"sitesp_HvXfJ","description":"","breadcrumbs":[{"label":"DBMS Basics"}]},{"id":"-M5-0X3e7BD-iQw-0TKg","title":"Levels of Abstraction","pathname":"/cs-gy-6083-principles-of-database-systems/chapter1/levels-of-abstraction","siteSpaceId":"sitesp_HvXfJ","description":"","breadcrumbs":[{"label":"DBMS Basics"}]},{"id":"-M5-0X3ft23k_ARU2zNU","title":"Instances and Schemas","pathname":"/cs-gy-6083-principles-of-database-systems/chapter1/i-nstances-and-schemas","siteSpaceId":"sitesp_HvXfJ","description":"","breadcrumbs":[{"label":"DBMS Basics"}]},{"id":"-M5-0X3gCuolj40kv1Fm","title":"Data Models","pathname":"/cs-gy-6083-principles-of-database-systems/data-models","siteSpaceId":"sitesp_HvXfJ","description":""},{"id":"-M5-0X3h_qyjoYHN5_Hq","title":"Introduction to Data Models","pathname":"/cs-gy-6083-principles-of-database-systems/data-models/introduction-to-data-models","siteSpaceId":"sitesp_HvXfJ","description":"","breadcrumbs":[{"label":"Data Models"}]},{"id":"-M5-0X3i8FQaSWEjGDvZ","title":"Database Languages","pathname":"/cs-gy-6083-principles-of-database-systems/data-models/database-languages","siteSpaceId":"sitesp_HvXfJ","description":"","breadcrumbs":[{"label":"Data Models"}]},{"id":"-M5-0X3j-8YmNUHnM8EQ","title":"Database Design","pathname":"/cs-gy-6083-principles-of-database-systems/data-models/database-design","siteSpaceId":"sitesp_HvXfJ","description":"","breadcrumbs":[{"label":"Data Models"}]},{"id":"-M5-0X3kCuOTRf4fJHgd","title":"DBMS Internals","pathname":"/cs-gy-6083-principles-of-database-systems/dbms-internals","siteSpaceId":"sitesp_HvXfJ","description":""},{"id":"-M5-0X3l1nuvxM-FUTGt","title":"Introduction to DBMS Internals","pathname":"/cs-gy-6083-principles-of-database-systems/dbms-internals/introduction-to-dbms-internals","siteSpaceId":"sitesp_HvXfJ","description":"","breadcrumbs":[{"label":"DBMS Internals"}]},{"id":"-M5-0X3mbPF9IIFXJwxk","title":"Storage Manager","pathname":"/cs-gy-6083-principles-of-database-systems/dbms-internals/storage-manager","siteSpaceId":"sitesp_HvXfJ","description":"","breadcrumbs":[{"label":"DBMS Internals"}]},{"id":"-M5-0X3nTeETpYaWi-_K","title":"Query Processor","pathname":"/cs-gy-6083-principles-of-database-systems/dbms-internals/query-processor","siteSpaceId":"sitesp_HvXfJ","description":"","breadcrumbs":[{"label":"DBMS Internals"}]},{"id":"-M5-0X3oA_Ojtaiu2yFX","title":"Transaction Management","pathname":"/cs-gy-6083-principles-of-database-systems/dbms-internals/trabsaction-management","siteSpaceId":"sitesp_HvXfJ","description":"","breadcrumbs":[{"label":"DBMS Internals"}]},{"id":"-M5-0X3pi6WO3nB8Ry2a","title":"Database Users","pathname":"/cs-gy-6083-principles-of-database-systems/dbms-internals/database-users","siteSpaceId":"sitesp_HvXfJ","description":"","breadcrumbs":[{"label":"DBMS Internals"}]},{"id":"-M5-0X3qP8jx_cjVHJ90","title":"Database Architecture","pathname":"/cs-gy-6083-principles-of-database-systems/dbms-internals/database-architecture","siteSpaceId":"sitesp_HvXfJ","description":"","breadcrumbs":[{"label":"DBMS Internals"}]},{"id":"-M5-0X3rA-GxhQiRk01J","title":"DBMS History","pathname":"/cs-gy-6083-principles-of-database-systems/dbms-history","siteSpaceId":"sitesp_HvXfJ","description":""},{"id":"-M5-0X3sdulZYhpM8w7a","title":"Some Popular Database Systems","pathname":"/cs-gy-6083-principles-of-database-systems/some-popular-database-systems","siteSpaceId":"sitesp_HvXfJ","description":""},{"id":"-M5-0X3tbeRRWTROoWCA","title":"OLTP, OLAP, and Data Mining","pathname":"/cs-gy-6083-principles-of-database-systems/oltp-olap-and-data-mining","siteSpaceId":"sitesp_HvXfJ","description":""},{"id":"-M5-0X3u8F89riYkXFov","title":"Databases vs. Information Retrieval","pathname":"/cs-gy-6083-principles-of-database-systems/databases-vs-information-retrieval","siteSpaceId":"sitesp_HvXfJ","description":""},{"id":"-M5-0X3vtBfhHeumNYOe","title":"The Entity-Relationship Model - Details","pathname":"/cs-gy-6083-principles-of-database-systems/the-entity-relationship-model-details","siteSpaceId":"sitesp_HvXfJ","description":""},{"id":"-M5-0X3wZuczgDlubdMG","title":"Introduction","pathname":"/cs-gy-6083-principles-of-database-systems/the-entity-relationship-model-details/introduction","siteSpaceId":"sitesp_HvXfJ","description":"","breadcrumbs":[{"label":"The Entity-Relationship Model - Details"}]},{"id":"-M5-0X3xh1e4w1lxpyTq","title":"Cardinality Constraints","pathname":"/cs-gy-6083-principles-of-database-systems/the-entity-relationship-model-details/cardinality-constraints","siteSpaceId":"sitesp_HvXfJ","description":"","breadcrumbs":[{"label":"The Entity-Relationship Model - Details"}]},{"id":"-M5-0X3yv9MqIzciNzwi","title":"ER Diagram Components","pathname":"/cs-gy-6083-principles-of-database-systems/the-entity-relationship-model-details/er-diagram-components","siteSpaceId":"sitesp_HvXfJ","description":"","breadcrumbs":[{"label":"The Entity-Relationship Model - Details"}]},{"id":"-M5-0X3zVqMvVpmdmM94","title":"ER Diagram to Relational Schema","pathname":"/cs-gy-6083-principles-of-database-systems/the-entity-relationship-model-details/er-diagram-to-relational-schema","siteSpaceId":"sitesp_HvXfJ","description":"","breadcrumbs":[{"label":"The Entity-Relationship Model - Details"}]},{"id":"-M5-0X4-I0dSd4C6xB9R","title":"Design Issues","pathname":"/cs-gy-6083-principles-of-database-systems/the-entity-relationship-model-details/design-issues","siteSpaceId":"sitesp_HvXfJ","description":"","breadcrumbs":[{"label":"The Entity-Relationship Model - Details"}]},{"id":"-M5-0X401qjRm1bWHYqs","title":"The Relational Model - Details","pathname":"/cs-gy-6083-principles-of-database-systems/the-relational-model-details","siteSpaceId":"sitesp_HvXfJ","description":""},{"id":"-M5-0X41t46NoPORYjm9","title":"Relations","pathname":"/cs-gy-6083-principles-of-database-systems/the-relational-model-details/relation","siteSpaceId":"sitesp_HvXfJ","description":"","breadcrumbs":[{"label":"The Relational Model - Details"}]},{"id":"-M5-0X42F6bjYsOceeFK","title":"Keys","pathname":"/cs-gy-6083-principles-of-database-systems/the-relational-model-details/keys","siteSpaceId":"sitesp_HvXfJ","description":"","breadcrumbs":[{"label":"The Relational Model - Details"}]},{"id":"-M5-0X43ixDJ7CS9jQX6","title":"Relational Query Languages","pathname":"/cs-gy-6083-principles-of-database-systems/the-relational-model-details/relational-query-languages","siteSpaceId":"sitesp_HvXfJ","description":"","breadcrumbs":[{"label":"The Relational Model - Details"}]},{"id":"-M5-0X44F9BnqFv2N2zr","title":"Relational Algebra","pathname":"/cs-gy-6083-principles-of-database-systems/the-relational-model-details/relational-query-languages/relational-algebra","siteSpaceId":"sitesp_HvXfJ","description":"","breadcrumbs":[{"label":"The Relational Model - Details"},{"label":"Relational Query Languages"}]},{"id":"-M5-0X45sgCPtdlSAlWQ","title":"Relational Calculus","pathname":"/cs-gy-6083-principles-of-database-systems/the-relational-model-details/relational-query-languages/relational-calculus","siteSpaceId":"sitesp_HvXfJ","description":"","breadcrumbs":[{"label":"The Relational Model - Details"},{"label":"Relational Query Languages"}]},{"id":"-M5-0X46-LYqcuEaFHrw","title":"Relative Expressive Power","pathname":"/cs-gy-6083-principles-of-database-systems/the-relational-model-details/relational-query-languages/relative-expressive-power","siteSpaceId":"sitesp_HvXfJ","description":"","breadcrumbs":[{"label":"The Relational Model - Details"},{"label":"Relational Query Languages"}]},{"id":"-M5-0X47BzNx8nkRVPeD","title":"Relational Operators","pathname":"/cs-gy-6083-principles-of-database-systems/the-relational-model-details/relational-operators","siteSpaceId":"sitesp_HvXfJ","description":"","breadcrumbs":[{"label":"The Relational Model - Details"}]},{"id":"-M5-0X48riatNbTBjYL_","title":"SQL","pathname":"/cs-gy-6083-principles-of-database-systems/sql","siteSpaceId":"sitesp_HvXfJ","description":""},{"id":"-M5-0X49TlQqOBrkByBR","title":"Introduction to SQL","pathname":"/cs-gy-6083-principles-of-database-systems/sql/introduction-to-sql","siteSpaceId":"sitesp_HvXfJ","description":"","breadcrumbs":[{"label":"SQL"}]},{"id":"-M5-0X4A0eKn3pztWCdF","title":"Domain Types in SQL","pathname":"/cs-gy-6083-principles-of-database-systems/sql/domain-types-in-sql","siteSpaceId":"sitesp_HvXfJ","description":"","breadcrumbs":[{"label":"SQL"}]},{"id":"-M5-0X4ByWl1LIanCTFv","title":"DDL Commands","pathname":"/cs-gy-6083-principles-of-database-systems/sql/ddl-commands","siteSpaceId":"sitesp_HvXfJ","description":"","breadcrumbs":[{"label":"SQL"}]},{"id":"-M5-0X4CiXRg1TXxnRne","title":"Creating a Table","pathname":"/cs-gy-6083-principles-of-database-systems/sql/ddl-commands/creating-a-table","siteSpaceId":"sitesp_HvXfJ","description":"","breadcrumbs":[{"label":"SQL"},{"label":"DDL Commands"}]},{"id":"-M5-0X4DQln8FiSi3DS2","title":"Alter and Drop","pathname":"/cs-gy-6083-principles-of-database-systems/sql/ddl-commands/alter-and-drop","siteSpaceId":"sitesp_HvXfJ","description":"","breadcrumbs":[{"label":"SQL"},{"label":"DDL Commands"}]},{"id":"-M5-0X4EBwiqQnRYjosK","title":"DML Commands","pathname":"/cs-gy-6083-principles-of-database-systems/sql/dml-commands","siteSpaceId":"sitesp_HvXfJ","description":"","breadcrumbs":[{"label":"SQL"}]},{"id":"-M5-0X4FgShmgoJ0lIPu","title":"Basic Query Structure","pathname":"/cs-gy-6083-principles-of-database-systems/sql/dml-commands/basic-query-structure","siteSpaceId":"sitesp_HvXfJ","description":"","breadcrumbs":[{"label":"SQL"},{"label":"DML Commands"}]},{"id":"-M5-0X4GLc-PPZp4WUya","title":"Select","pathname":"/cs-gy-6083-principles-of-database-systems/sql/dml-commands/select","siteSpaceId":"sitesp_HvXfJ","description":"","breadcrumbs":[{"label":"SQL"},{"label":"DML Commands"}]},{"id":"-M5-0X4HD39_aujUnrnN","title":"From","pathname":"/cs-gy-6083-principles-of-database-systems/sql/dml-commands/from","siteSpaceId":"sitesp_HvXfJ","description":"","breadcrumbs":[{"label":"SQL"},{"label":"DML Commands"}]},{"id":"-M5-0X4I82OVjayRkRru","title":"Where","pathname":"/cs-gy-6083-principles-of-database-systems/sql/dml-commands/where","siteSpaceId":"sitesp_HvXfJ","description":"","breadcrumbs":[{"label":"SQL"},{"label":"DML Commands"}]},{"id":"-M5-0X4J7fSLOl4ejC1p","title":"Joins","pathname":"/cs-gy-6083-principles-of-database-systems/sql/dml-commands/joins","siteSpaceId":"sitesp_HvXfJ","description":"","breadcrumbs":[{"label":"SQL"},{"label":"DML Commands"}]},{"id":"-M5-0X4KOI4dOjFlJ8CP","title":"Rename","pathname":"/cs-gy-6083-principles-of-database-systems/sql/dml-commands/rename","siteSpaceId":"sitesp_HvXfJ","description":"","breadcrumbs":[{"label":"SQL"},{"label":"DML Commands"}]},{"id":"-M5-0X4LrGVMlkTOhxSL","title":"String Operations","pathname":"/cs-gy-6083-principles-of-database-systems/sql/dml-commands/string-operations","siteSpaceId":"sitesp_HvXfJ","description":"","breadcrumbs":[{"label":"SQL"},{"label":"DML Commands"}]},{"id":"-M5-0X4MWFFsc49ysa8g","title":"Ordering","pathname":"/cs-gy-6083-principles-of-database-systems/sql/dml-commands/ordering","siteSpaceId":"sitesp_HvXfJ","description":"","breadcrumbs":[{"label":"SQL"},{"label":"DML Commands"}]},{"id":"-M5-0X4N_GOPIuuQvQYt","title":"Set Operations","pathname":"/cs-gy-6083-principles-of-database-systems/sql/dml-commands/set-operations","siteSpaceId":"sitesp_HvXfJ","description":"","breadcrumbs":[{"label":"SQL"},{"label":"DML Commands"}]},{"id":"-M5-0X4OvFq9vlrJudSj","title":"Group By and Having","pathname":"/cs-gy-6083-principles-of-database-systems/sql/dml-commands/group-by-and-having","siteSpaceId":"sitesp_HvXfJ","description":"","breadcrumbs":[{"label":"SQL"},{"label":"DML Commands"}]},{"id":"-M5-0X4PyPFUq_jZyyQU","title":"Nested Subqueries","pathname":"/cs-gy-6083-principles-of-database-systems/sql/dml-commands/nested-subqueries","siteSpaceId":"sitesp_HvXfJ","description":"","breadcrumbs":[{"label":"SQL"},{"label":"DML Commands"}]},{"id":"-M5-0X4QoupccV_Q2RaX","title":"Test for Empty Relations","pathname":"/cs-gy-6083-principles-of-database-systems/sql/dml-commands/test-for-empty-relations","siteSpaceId":"sitesp_HvXfJ","description":"","breadcrumbs":[{"label":"SQL"},{"label":"DML Commands"}]},{"id":"-M5-0X4RsL4qqjUEflJQ","title":"Test for Duplicate Tuples","pathname":"/cs-gy-6083-principles-of-database-systems/sql/dml-commands/test-for-duplicate-tuples","siteSpaceId":"sitesp_HvXfJ","description":"","breadcrumbs":[{"label":"SQL"},{"label":"DML Commands"}]},{"id":"-M5-0X4SHU3soTCUYH_8","title":"Derived Relations","pathname":"/cs-gy-6083-principles-of-database-systems/sql/dml-commands/derived-relations","siteSpaceId":"sitesp_HvXfJ","description":"","breadcrumbs":[{"label":"SQL"},{"label":"DML Commands"}]},{"id":"-M5-0X4TRLigqvUJGAop","title":"With","pathname":"/cs-gy-6083-principles-of-database-systems/sql/dml-commands/with","siteSpaceId":"sitesp_HvXfJ","description":"","breadcrumbs":[{"label":"SQL"},{"label":"DML Commands"}]},{"id":"-M5-0X4UhLap-igPI6nQ","title":"Database Modification","pathname":"/cs-gy-6083-principles-of-database-systems/sql/dml-commands/database-modification","siteSpaceId":"sitesp_HvXfJ","description":"","breadcrumbs":[{"label":"SQL"},{"label":"DML Commands"}]},{"id":"-M5-0X4V0CngnSAcy0m1","title":"Intermediate SQL","pathname":"/cs-gy-6083-principles-of-database-systems/sql/intermediate-sql","siteSpaceId":"sitesp_HvXfJ","description":"","breadcrumbs":[{"label":"SQL"}]},{"id":"-M5-0X4WZRuTpUEmI1Un","title":"Joins Revisited","pathname":"/cs-gy-6083-principles-of-database-systems/sql/intermediate-sql/joins-revisited","siteSpaceId":"sitesp_HvXfJ","description":"","breadcrumbs":[{"label":"SQL"},{"label":"Intermediate SQL"}]},{"id":"-M5-0X4X8-DHFAkjTRZQ","title":"Views","pathname":"/cs-gy-6083-principles-of-database-systems/sql/intermediate-sql/views","siteSpaceId":"sitesp_HvXfJ","description":"","breadcrumbs":[{"label":"SQL"},{"label":"Intermediate SQL"}]},{"id":"-M5-0X4Yk5vrZ6BIZFyy","title":"Transactions","pathname":"/cs-gy-6083-principles-of-database-systems/sql/intermediate-sql/transactions","siteSpaceId":"sitesp_HvXfJ","description":"","breadcrumbs":[{"label":"SQL"},{"label":"Intermediate SQL"}]},{"id":"-M5-0X4ZyXz3EEWT7UB4","title":"Integrity Constraints","pathname":"/cs-gy-6083-principles-of-database-systems/sql/intermediate-sql/integrity-constraints","siteSpaceId":"sitesp_HvXfJ","description":"","breadcrumbs":[{"label":"SQL"},{"label":"Intermediate SQL"}]},{"id":"-M5-0X4_1neRKg1LI2_V","title":"More SQL Data Types and Schemas","pathname":"/cs-gy-6083-principles-of-database-systems/sql/intermediate-sql/more-sql-data-types-and-schemas","siteSpaceId":"sitesp_HvXfJ","description":"","breadcrumbs":[{"label":"SQL"},{"label":"Intermediate SQL"}]},{"id":"-M5-0X4aVhHnuAH-XMu6","title":"Other Features","pathname":"/cs-gy-6083-principles-of-database-systems/sql/intermediate-sql/more-sql-data-types-and-schemas/other-features","siteSpaceId":"sitesp_HvXfJ","description":"","breadcrumbs":[{"label":"SQL"},{"label":"Intermediate SQL"},{"label":"More SQL Data Types and Schemas"}]},{"id":"-M5-0X4bkiqoC4tmnY4N","title":"Authorization","pathname":"/cs-gy-6083-principles-of-database-systems/sql/intermediate-sql/authorization","siteSpaceId":"sitesp_HvXfJ","description":"","breadcrumbs":[{"label":"SQL"},{"label":"Intermediate SQL"}]},{"id":"-M5-0X4cEM2yC1n_gPyF","title":"Advanced SQL","pathname":"/cs-gy-6083-principles-of-database-systems/sql/advanced-sql","siteSpaceId":"sitesp_HvXfJ","description":"","breadcrumbs":[{"label":"SQL"}]},{"id":"-M5-0X4d_4rrBfD9kqSy","title":"Accessing SQL From a Programming Language","pathname":"/cs-gy-6083-principles-of-database-systems/sql/advanced-sql/accessing-sql-from-a-programming-language","siteSpaceId":"sitesp_HvXfJ","description":"","breadcrumbs":[{"label":"SQL"},{"label":"Advanced SQL"}]},{"id":"-M5-0X4e2d3RfSopH1pQ","title":"ODBC and JDBC","pathname":"/cs-gy-6083-principles-of-database-systems/sql/advanced-sql/accessing-sql-from-a-programming-language/odbc-and-jdbc","siteSpaceId":"sitesp_HvXfJ","description":"","breadcrumbs":[{"label":"SQL"},{"label":"Advanced SQL"},{"label":"Accessing SQL From a Programming Language"}]},{"id":"-M5-0X4fUVo79qjDhbz1","title":"Embedded SQL","pathname":"/cs-gy-6083-principles-of-database-systems/sql/advanced-sql/accessing-sql-from-a-programming-language/embedded-sql","siteSpaceId":"sitesp_HvXfJ","description":"","breadcrumbs":[{"label":"SQL"},{"label":"Advanced SQL"},{"label":"Accessing SQL From a Programming Language"}]},{"id":"-M5-0X4g37krE1c3o0jS","title":"PHP","pathname":"/cs-gy-6083-principles-of-database-systems/sql/advanced-sql/accessing-sql-from-a-programming-language/php","siteSpaceId":"sitesp_HvXfJ","description":"","breadcrumbs":[{"label":"SQL"},{"label":"Advanced SQL"},{"label":"Accessing SQL From a Programming Language"}]},{"id":"-M5-0X4hDeRm2Emhtk0K","title":"Some Security Issues","pathname":"/cs-gy-6083-principles-of-database-systems/sql/advanced-sql/accessing-sql-from-a-programming-language/some-security-issues","siteSpaceId":"sitesp_HvXfJ","description":"","breadcrumbs":[{"label":"SQL"},{"label":"Advanced SQL"},{"label":"Accessing SQL From a Programming Language"}]},{"id":"-M5-0X4iyBaD2jF7kkjX","title":"Accessing Metadata","pathname":"/cs-gy-6083-principles-of-database-systems/sql/advanced-sql/accessing-metadata","siteSpaceId":"sitesp_HvXfJ","description":"","breadcrumbs":[{"label":"SQL"},{"label":"Advanced SQL"}]},{"id":"-M5-0X4jLMLU0zH1ZVtW","title":"Text Operations","pathname":"/cs-gy-6083-principles-of-database-systems/sql/advanced-sql/text-operations","siteSpaceId":"sitesp_HvXfJ","description":"","breadcrumbs":[{"label":"SQL"},{"label":"Advanced SQL"}]},{"id":"-M5-0X4ksMkDXcIz6RFl","title":"Like","pathname":"/cs-gy-6083-principles-of-database-systems/sql/advanced-sql/text-operations/like","siteSpaceId":"sitesp_HvXfJ","description":"","breadcrumbs":[{"label":"SQL"},{"label":"Advanced SQL"},{"label":"Text Operations"}]},{"id":"-M5-0X4lMl55eq5PToZs","title":"Contains","pathname":"/cs-gy-6083-principles-of-database-systems/sql/advanced-sql/text-operations/contains","siteSpaceId":"sitesp_HvXfJ","description":"","breadcrumbs":[{"label":"SQL"},{"label":"Advanced SQL"},{"label":"Text Operations"}]},{"id":"-M5-0X4moudZX0Muoh_7","title":"Cursors","pathname":"/cs-gy-6083-principles-of-database-systems/sql/advanced-sql/cursors","siteSpaceId":"sitesp_HvXfJ","description":"","breadcrumbs":[{"label":"SQL"},{"label":"Advanced SQL"}]},{"id":"-M5-0X4nxiw_E4jhXDm1","title":"Functions and Procedures","pathname":"/cs-gy-6083-principles-of-database-systems/sql/advanced-sql/functions-and-procedures","siteSpaceId":"sitesp_HvXfJ","description":"","breadcrumbs":[{"label":"SQL"},{"label":"Advanced SQL"}]},{"id":"-M5-0X4oAEzl1WJoiECp","title":"Procedural Constructs","pathname":"/cs-gy-6083-principles-of-database-systems/sql/advanced-sql/functions-and-procedures/procedural-constructs","siteSpaceId":"sitesp_HvXfJ","description":"","breadcrumbs":[{"label":"SQL"},{"label":"Advanced SQL"},{"label":"Functions and Procedures"}]},{"id":"-M5-0X4plmD21iMTGWla","title":"External Language Routines","pathname":"/cs-gy-6083-principles-of-database-systems/sql/advanced-sql/functions-and-procedures/external-language-routines","siteSpaceId":"sitesp_HvXfJ","description":"","breadcrumbs":[{"label":"SQL"},{"label":"Advanced SQL"},{"label":"Functions and Procedures"}]},{"id":"-M5-0X4qDPWPOc4PKTMa","title":"Triggers","pathname":"/cs-gy-6083-principles-of-database-systems/sql/advanced-sql/triggers","siteSpaceId":"sitesp_HvXfJ","description":"","breadcrumbs":[{"label":"SQL"},{"label":"Advanced SQL"}]},{"id":"-M5-0X4roJEeyaJ8bBGT","title":"Ranking","pathname":"/cs-gy-6083-principles-of-database-systems/sql/advanced-sql/ranking","siteSpaceId":"sitesp_HvXfJ","description":"","breadcrumbs":[{"label":"SQL"},{"label":"Advanced SQL"}]},{"id":"-M5-0X4sVuPo_0YZtffJ","title":"Windowing","pathname":"/cs-gy-6083-principles-of-database-systems/sql/advanced-sql/windowing","siteSpaceId":"sitesp_HvXfJ","description":"","breadcrumbs":[{"label":"SQL"},{"label":"Advanced SQL"}]},{"id":"-M5-0X4tIbDXpjgXxY_Y","title":"OLAP","pathname":"/cs-gy-6083-principles-of-database-systems/sql/advanced-sql/olap","siteSpaceId":"sitesp_HvXfJ","description":"","breadcrumbs":[{"label":"SQL"},{"label":"Advanced SQL"}]}]}