{"version":1,"pages":[{"id":"4aUs2GWiqH2zOHLmEAdV","title":"Table of contents","pathname":"/databases","siteSpaceId":"sitesp_5E36h","description":""},{"id":"oUCsGwH9ZrejmJWCdkVX","title":"SQL","pathname":"/databases/sql","siteSpaceId":"sitesp_5E36h","description":""},{"id":"qHE22xOzKxuddUWgHx7k","title":"Getting Started","pathname":"/databases/sql/getting-started","siteSpaceId":"sitesp_5E36h","description":"","breadcrumbs":[{"label":"SQL"}]},{"id":"CpMB7KtjyBd4dYsJNmgt","title":"PgAdmin Tool","pathname":"/databases/sql/getting-started/administration-task","siteSpaceId":"sitesp_5E36h","description":"","breadcrumbs":[{"label":"SQL"},{"label":"Getting Started"}]},{"id":"-MguJR52GW0YvEMqMb0M","title":"Data Types","pathname":"/databases/sql/data-types","siteSpaceId":"sitesp_5E36h","description":"","breadcrumbs":[{"label":"SQL"}]},{"id":"zfybcY3ceYQYV2Mbau43","title":"Arrays","pathname":"/databases/sql/data-types/arrays","siteSpaceId":"sitesp_5E36h","description":"","breadcrumbs":[{"label":"SQL"},{"label":"Data Types"}]},{"id":"-MguJR558AcbJ6j3QElc","title":"Date/Time/Stamps","pathname":"/databases/sql/data-types/date-time-stamps","siteSpaceId":"sitesp_5E36h","description":"","breadcrumbs":[{"label":"SQL"},{"label":"Data Types"}]},{"id":"-MguJR53sZXp-B_xi2Zg","title":"JSON","pathname":"/databases/sql/data-types/json","siteSpaceId":"sitesp_5E36h","description":"the usual","breadcrumbs":[{"label":"SQL"},{"label":"Data Types"}]},{"id":"-MguJR58fKzDyAxrhTXN","title":"Internal Functions","pathname":"/databases/sql/data-types/miscellaneous-1","siteSpaceId":"sitesp_5E36h","description":"one day, you will need them","breadcrumbs":[{"label":"SQL"},{"label":"Data Types"}]},{"id":"-MguJR56Slnr4RqSlPBl","title":"Sequences","pathname":"/databases/sql/data-types/sequences","siteSpaceId":"sitesp_5E36h","description":"","breadcrumbs":[{"label":"SQL"},{"label":"Data Types"}]},{"id":"-MguJR548OCwqPoTbH_s","title":"User Defined Data Types","pathname":"/databases/sql/data-types/user-defined-data-types","siteSpaceId":"sitesp_5E36h","description":"yours truely","breadcrumbs":[{"label":"SQL"},{"label":"Data Types"}]},{"id":"bQi952vTzOEsEVsaOAF7","title":"Database","pathname":"/databases/sql/working-with-database","siteSpaceId":"sitesp_5E36h","description":"","breadcrumbs":[{"label":"SQL"}]},{"id":"-MguJR5AM77oBXM5hk-I","title":"Schema","pathname":"/databases/sql/working-with-database/schema","siteSpaceId":"sitesp_5E36h","description":"","breadcrumbs":[{"label":"SQL"},{"label":"Database"}]},{"id":"39QBqJ6wiV23Wx7MoSRc","title":"Table","pathname":"/databases/sql/tables","siteSpaceId":"sitesp_5E36h","description":"","breadcrumbs":[{"label":"SQL"}]},{"id":"-MguJR5H36EH2et5ERJe","title":"Aggregation","pathname":"/databases/sql/tables/aggregation","siteSpaceId":"sitesp_5E36h","description":"","breadcrumbs":[{"label":"SQL"},{"label":"Table"}]},{"id":"-MguJR5OZUs-26vI4sqt","title":"Usefull Functions","pathname":"/databases/sql/tables/coalesce","siteSpaceId":"sitesp_5E36h","description":"","breadcrumbs":[{"label":"SQL"},{"label":"Table"}]},{"id":"pKX28J07gdhGotHR9kV1","title":"Combining Tables","pathname":"/databases/sql/tables/combining-tables","siteSpaceId":"sitesp_5E36h","description":"","breadcrumbs":[{"label":"SQL"},{"label":"Table"}]},{"id":"-MguJR5INgR3W1zn2vKs","title":"Constraints","pathname":"/databases/sql/tables/constraints","siteSpaceId":"sitesp_5E36h","description":"","breadcrumbs":[{"label":"SQL"},{"label":"Table"}]},{"id":"-MguJR5TnVLPBIU2lgGZ","title":"Common Table Expression","pathname":"/databases/sql/tables/cte","siteSpaceId":"sitesp_5E36h","description":"","breadcrumbs":[{"label":"SQL"},{"label":"Table"}]},{"id":"-MguJR5FnWIczayEltWa","title":"GROUP BY and HAVING","pathname":"/databases/sql/tables/group-by-and-having","siteSpaceId":"sitesp_5E36h","description":"","breadcrumbs":[{"label":"SQL"},{"label":"Table"}]},{"id":"-MguJR5E-wRnkN5K9gJJ","title":"OPERATORS","pathname":"/databases/sql/tables/miscellaneous","siteSpaceId":"sitesp_5E36h","description":"bodmas 3000","breadcrumbs":[{"label":"SQL"},{"label":"Table"}]},{"id":"-MguJR5Cswu_EAN855SR","title":"ORDER BY and DISTINCT","pathname":"/databases/sql/tables/order-by","siteSpaceId":"sitesp_5E36h","description":"a clause","breadcrumbs":[{"label":"SQL"},{"label":"Table"}]},{"id":"-MguJR5SBhgVj0Zoh47f","title":"Views","pathname":"/databases/sql/tables/views","siteSpaceId":"sitesp_5E36h","description":"","breadcrumbs":[{"label":"SQL"},{"label":"Table"}]},{"id":"-MguJR5DvOF8nio9YbTL","title":"WHERE Clause","pathname":"/databases/sql/tables/where","siteSpaceId":"sitesp_5E36h","description":"??","breadcrumbs":[{"label":"SQL"},{"label":"Table"}]},{"id":"-MhvfK6el59FYTcoLDoe","title":"Order of SQL Execution","pathname":"/databases/sql/order-of-sql-execution","siteSpaceId":"sitesp_5E36h","description":"","breadcrumbs":[{"label":"SQL"}]},{"id":"9sgIionNayMu0KuqPXjK","title":"Advance Table","pathname":"/databases/sql/advance-tables","siteSpaceId":"sitesp_5E36h","description":"","breadcrumbs":[{"label":"SQL"}]},{"id":"-MhMpZ4glpdsNf0-lClS","title":"Internals","pathname":"/databases/sql/advance-tables/internals","siteSpaceId":"sitesp_5E36h","description":"","breadcrumbs":[{"label":"SQL"},{"label":"Advance Table"}]},{"id":"-MhRfx4Xghx-ZAc74O-_","title":"Managing Tables","pathname":"/databases/sql/advance-tables/managing-tables","siteSpaceId":"sitesp_5E36h","description":"","breadcrumbs":[{"label":"SQL"},{"label":"Advance Table"}]},{"id":"-MguJR5_paet4LqX0QVk","title":"Partitioning Tables","pathname":"/databases/sql/advance-tables/paritioning-tables","siteSpaceId":"sitesp_5E36h","description":"","breadcrumbs":[{"label":"SQL"},{"label":"Advance Table"}]},{"id":"-MgyAwEcS9HHj0zFxC9O","title":"Pivotal or Crosstab Tables","pathname":"/databases/sql/advance-tables/pivotal-or-crosstab-tables","siteSpaceId":"sitesp_5E36h","description":"","breadcrumbs":[{"label":"SQL"},{"label":"Advance Table"}]},{"id":"oDsmasmhtfZ6myK7j7aN","title":"Joins","pathname":"/databases/sql/joins","siteSpaceId":"sitesp_5E36h","description":"","breadcrumbs":[{"label":"SQL"}]},{"id":"-MguJR5NweWwBrQs-WD_","title":"Cross & Natural Joins","pathname":"/databases/sql/joins/cross-join","siteSpaceId":"sitesp_5E36h","description":"","breadcrumbs":[{"label":"SQL"},{"label":"Joins"}]},{"id":"HBOfA6OCSrcXuwVdnC3u","title":"Full, Multiple & Self Joins","pathname":"/databases/sql/joins/full-multiple-and-self-joins","siteSpaceId":"sitesp_5E36h","description":"","breadcrumbs":[{"label":"SQL"},{"label":"Joins"}]},{"id":"UbPUXjHcu1AHweiuSL0M","title":"Inner Join","pathname":"/databases/sql/joins/inner-join","siteSpaceId":"sitesp_5E36h","description":"","breadcrumbs":[{"label":"SQL"},{"label":"Joins"}]},{"id":"Hmh435Y8odxXRDq56tpl","title":"Left and Right JOIN","pathname":"/databases/sql/joins/left-and-right-join","siteSpaceId":"sitesp_5E36h","description":"","breadcrumbs":[{"label":"SQL"},{"label":"Joins"}]},{"id":"-MguJR5aVedmll1KVTH5","title":"Functions","pathname":"/databases/sql/functions","siteSpaceId":"sitesp_5E36h","description":"","breadcrumbs":[{"label":"SQL"}]},{"id":"-MguJR5fKc1d9B7vEK3n","title":"Cursors","pathname":"/databases/sql/functions/cursors","siteSpaceId":"sitesp_5E36h","description":"","breadcrumbs":[{"label":"SQL"},{"label":"Functions"}]},{"id":"-MguJR5bE3YoH9g4HEZP","title":"PL/pgSQL","pathname":"/databases/sql/functions/pl-pgsql","siteSpaceId":"sitesp_5E36h","description":"","breadcrumbs":[{"label":"SQL"},{"label":"Functions"}]},{"id":"-MguJR5cBieRKeaups7k","title":"Stored Procedures","pathname":"/databases/sql/functions/stored-procedures","siteSpaceId":"sitesp_5E36h","description":"","breadcrumbs":[{"label":"SQL"},{"label":"Functions"}]},{"id":"-MguJR5eoW1g-Lj71XV4","title":"Triggers","pathname":"/databases/sql/functions/triggers","siteSpaceId":"sitesp_5E36h","description":"","breadcrumbs":[{"label":"SQL"},{"label":"Functions"}]},{"id":"Oi6Lb6oYAxIqYjKJ5Clq","title":"More on Triggers","pathname":"/databases/sql/functions/triggers/more-on-triggers","siteSpaceId":"sitesp_5E36h","description":"","breadcrumbs":[{"label":"SQL"},{"label":"Functions"},{"label":"Triggers"}]},{"id":"-MguJR5PLvcX9UyzPTTr","title":"Indexing","pathname":"/databases/sql/indexing","siteSpaceId":"sitesp_5E36h","description":"","breadcrumbs":[{"label":"SQL"}]},{"id":"-MhXhbylol9CG4aU-8h-","title":"Custom Indexes","pathname":"/databases/sql/indexing/custom-indexes","siteSpaceId":"sitesp_5E36h","description":"","breadcrumbs":[{"label":"SQL"},{"label":"Indexing"}]},{"id":"n96w3HXMXSZ42bL4rfem","title":"GIN Index","pathname":"/databases/sql/indexing/gin-index","siteSpaceId":"sitesp_5E36h","description":"","breadcrumbs":[{"label":"SQL"},{"label":"Indexing"}]},{"id":"-MguJR5U3ffSBPOe5TsL","title":"Indexes","pathname":"/databases/sql/indexing/indexes","siteSpaceId":"sitesp_5E36h","description":"","breadcrumbs":[{"label":"SQL"},{"label":"Indexing"}]},{"id":"2i1MZLzNXT9A5zSrokXg","title":"SQL","pathname":"/databases/sql/indexing/sql","siteSpaceId":"sitesp_5E36h","description":"","breadcrumbs":[{"label":"SQL"},{"label":"Indexing"}]},{"id":"-MguJR5VzpREhJct4C8v","title":"Unique Index","pathname":"/databases/sql/indexing/unique-index","siteSpaceId":"sitesp_5E36h","description":"","breadcrumbs":[{"label":"SQL"},{"label":"Indexing"}]},{"id":"-MguJR5XvlWOatzbQuXO","title":"Summarization","pathname":"/databases/sql/summarization","siteSpaceId":"sitesp_5E36h","description":"","breadcrumbs":[{"label":"SQL"}]},{"id":"-MguJR5Zgbt9YMOXPWRW","title":"SubQueries","pathname":"/databases/sql/summarization/subqueries","siteSpaceId":"sitesp_5E36h","description":"","breadcrumbs":[{"label":"SQL"},{"label":"Summarization"}]},{"id":"-MguJR5Y9voqtHKbcVEQ","title":"Window","pathname":"/databases/sql/summarization/window","siteSpaceId":"sitesp_5E36h","description":"","breadcrumbs":[{"label":"SQL"},{"label":"Summarization"}]},{"id":"ZbZ3VfAOfavcHj3CYNCz","title":"MongoDB","pathname":"/databases/mongodb","siteSpaceId":"sitesp_5E36h","description":""},{"id":"-MhT7a1dalsixHL9mjqX","title":"Mongo Administration","pathname":"/databases/mongodb/mongo-administration","siteSpaceId":"sitesp_5E36h","description":"","breadcrumbs":[{"label":"MongoDB"}]},{"id":"jXt2YbCtOnvhVq84vqoQ","title":"MongoDB Aggregation","pathname":"/databases/mongodb/mongodb-aggregation","siteSpaceId":"sitesp_5E36h","description":"","breadcrumbs":[{"label":"MongoDB"}]},{"id":"-MguKpSJt3sFdUIwZn42","title":"MQL","pathname":"/databases/mongodb/mql","siteSpaceId":"sitesp_5E36h","description":"","breadcrumbs":[{"label":"MongoDB"}]},{"id":"M55Q5Z4mBFFPUDIbnvFV","title":"Redis","pathname":"/databases/redis","siteSpaceId":"sitesp_5E36h","description":""},{"id":"aFV81P7g8XEXreTafE0J","title":"Cassandra","pathname":"/databases/cassandra","siteSpaceId":"sitesp_5E36h","description":"SycllaDB to be precise"},{"id":"-MguKInPdOKiJrI4ZPm4","title":"CQL","pathname":"/databases/cassandra/cql","siteSpaceId":"sitesp_5E36h","description":"","breadcrumbs":[{"label":"Cassandra"}]},{"id":"-MguKBVPgnyTg13oGvI8","title":"Data Modelling","pathname":"/databases/cassandra/data-modelling","siteSpaceId":"sitesp_5E36h","description":"","breadcrumbs":[{"label":"Cassandra"}]},{"id":"KPKthfRpkjijnoG50ilm","title":"Advance Data Modelling","pathname":"/databases/cassandra/data-modelling/advance-data-modelling","siteSpaceId":"sitesp_5E36h","description":"","breadcrumbs":[{"label":"Cassandra"},{"label":"Data Modelling"}]},{"id":"tiMaJgSYNJfkaskBJryS","title":"Cassandra Administration","pathname":"/databases/cassandra/cassandra-administration","siteSpaceId":"sitesp_5E36h","description":"","breadcrumbs":[{"label":"Cassandra"}]},{"id":"uhaGNuPGS15S5Kxz4bXe","title":"Cassandra Features","pathname":"/databases/cassandra/cassandra-features","siteSpaceId":"sitesp_5E36h","description":"","breadcrumbs":[{"label":"Cassandra"}]}]}