{"version":1,"pages":[{"id":"Nc87dXWbo3sgCkrGHix3","title":"Need of Database","pathname":"/database-engineering","siteSpaceId":"sitesp_CtO4Z"},{"id":"OmzYmKum5j8hcPVCgvFw","title":"Database and Database Management System","pathname":"/database-engineering/database-and-database-management-system","siteSpaceId":"sitesp_CtO4Z"},{"id":"wrDe8oxUibKllXqKlVcy","title":"What is Relational Database Model ?","pathname":"/database-engineering/what-is-relational-database-model","siteSpaceId":"sitesp_CtO4Z"},{"id":"WTdvjbViRh6iMW08TZFr","title":"Installing Postgresql","pathname":"/database-engineering/installing-postgresql","siteSpaceId":"sitesp_CtO4Z"},{"id":"1ku7zENWMcXeVXn4LccT","title":"Installing PostgreSQL on Linux","pathname":"/database-engineering/installing-postgresql/installing-postgresql-on-linux","siteSpaceId":"sitesp_CtO4Z","breadcrumbs":[{"label":"Installing Postgresql"}]},{"id":"E7zEq8n03FPVH4Nh3OFK","title":"Installing PostgreSQL on Windows","pathname":"/database-engineering/installing-postgresql/installing-postgresql-on-windows","siteSpaceId":"sitesp_CtO4Z","breadcrumbs":[{"label":"Installing Postgresql"}]},{"id":"xwZVvMwFSNVOhCJzk8O7","title":"Installing PostgreSQL on Mac","pathname":"/database-engineering/installing-postgresql/installing-postgresql-on-mac","siteSpaceId":"sitesp_CtO4Z","breadcrumbs":[{"label":"Installing Postgresql"}]},{"id":"v8mptttyTOndSMI8zYF5","title":"Postgres in Docker","pathname":"/database-engineering/installing-postgresql/postgres-in-docker","siteSpaceId":"sitesp_CtO4Z","breadcrumbs":[{"label":"Installing Postgresql"}]},{"id":"GWC8ZXMqbdJaG4Yt3FRF","title":"What happens during the initial installation ?","pathname":"/database-engineering/what-happens-during-the-initial-installation","siteSpaceId":"sitesp_CtO4Z"},{"id":"aREdmDFlp8Uo7XfrpcVB","title":"Roles, Users & Groups","pathname":"/database-engineering/what-happens-during-the-initial-installation/roles-users-and-groups","siteSpaceId":"sitesp_CtO4Z","breadcrumbs":[{"label":"What happens during the initial installation ?"}]},{"id":"z1Ik5SqGwwSQqpuGEJL6","title":"More examples on Roles","pathname":"/database-engineering/what-happens-during-the-initial-installation/more-examples-on-roles","siteSpaceId":"sitesp_CtO4Z","breadcrumbs":[{"label":"What happens during the initial installation ?"}]},{"id":"2bQ5pzs1ZunVspLyjC87","title":"Sample Databases","pathname":"/database-engineering/sample-databases","siteSpaceId":"sitesp_CtO4Z"},{"id":"tFzMgOrModS7ksHAYzlq","title":"DVD Rental Database","pathname":"/database-engineering/sample-databases/dvd-rental-database","siteSpaceId":"sitesp_CtO4Z","breadcrumbs":[{"label":"Sample Databases"}]},{"id":"S1vcebXlRQRouvEkeYM1","title":"SELECT Query","pathname":"/database-engineering/querying-data/select-query","siteSpaceId":"sitesp_CtO4Z","breadcrumbs":[{"label":"Querying Data"}]},{"id":"RAIrWIdmrP5s71NwjvNG","title":"Column Aliases","pathname":"/database-engineering/querying-data/column-aliases","siteSpaceId":"sitesp_CtO4Z","breadcrumbs":[{"label":"Querying Data"}]},{"id":"zBAIP8j9U4TPX1fiMxdZ","title":"Order By","pathname":"/database-engineering/querying-data/order-by","siteSpaceId":"sitesp_CtO4Z","breadcrumbs":[{"label":"Querying Data"}]},{"id":"4AEoEWAMf6G1QJcs9cuX","title":"SELECT DISTINCT","pathname":"/database-engineering/querying-data/select-distinct","siteSpaceId":"sitesp_CtO4Z","breadcrumbs":[{"label":"Querying Data"}]},{"id":"Z8E08PrGstXroclI8YY8","title":"DB-TASK-001","pathname":"/database-engineering/querying-data/db-task-001","siteSpaceId":"sitesp_CtO4Z","breadcrumbs":[{"label":"Querying Data"}]},{"id":"6W9EKMI5BawLbzaXouOp","title":"WHERE ?","pathname":"/database-engineering/filtering-data/where","siteSpaceId":"sitesp_CtO4Z","breadcrumbs":[{"label":"Filtering Data"}]},{"id":"wOkYm02Fsl6FPsQlUdxF","title":"AND Operator","pathname":"/database-engineering/filtering-data/and-operator","siteSpaceId":"sitesp_CtO4Z","breadcrumbs":[{"label":"Filtering Data"}]},{"id":"fWLjlcv09zflGqWITZ9q","title":"OR Operator","pathname":"/database-engineering/filtering-data/or-operator","siteSpaceId":"sitesp_CtO4Z","breadcrumbs":[{"label":"Filtering Data"}]},{"id":"fudYfzpCwTVF5i4z83QM","title":"LIMIT","pathname":"/database-engineering/filtering-data/limit","siteSpaceId":"sitesp_CtO4Z","breadcrumbs":[{"label":"Filtering Data"}]},{"id":"PNkEE5tcU596z7cDEHCd","title":"FETCH","pathname":"/database-engineering/filtering-data/fetch","siteSpaceId":"sitesp_CtO4Z","breadcrumbs":[{"label":"Filtering Data"}]},{"id":"U9UEJkrGziRusqlpbpW4","title":"IN","pathname":"/database-engineering/filtering-data/in","siteSpaceId":"sitesp_CtO4Z","breadcrumbs":[{"label":"Filtering Data"}]},{"id":"EWazSvog8XZY3TqgqtGM","title":"BETWEEN","pathname":"/database-engineering/filtering-data/between","siteSpaceId":"sitesp_CtO4Z","breadcrumbs":[{"label":"Filtering Data"}]},{"id":"riYlOdT1kN0T3162jNxS","title":"LIKE","pathname":"/database-engineering/filtering-data/like","siteSpaceId":"sitesp_CtO4Z","breadcrumbs":[{"label":"Filtering Data"}]},{"id":"0856TQoJBImPEOaVyqkJ","title":"SIMILAR TO","pathname":"/database-engineering/filtering-data/similar-to","siteSpaceId":"sitesp_CtO4Z","breadcrumbs":[{"label":"Filtering Data"}]},{"id":"6JDcmit0NGjtIykwb4XS","title":"IS NULL","pathname":"/database-engineering/filtering-data/is-null","siteSpaceId":"sitesp_CtO4Z","breadcrumbs":[{"label":"Filtering Data"}]},{"id":"Cn97hOYa7CaFtXq2ajFX","title":"ESCAPE","pathname":"/database-engineering/filtering-data/escape","siteSpaceId":"sitesp_CtO4Z","breadcrumbs":[{"label":"Filtering Data"}]},{"id":"FVKzqc3aIdUNwi78cV4T","title":"DB-TASK-002","pathname":"/database-engineering/filtering-data/db-task-002","siteSpaceId":"sitesp_CtO4Z","breadcrumbs":[{"label":"Filtering Data"}]},{"id":"NgvKsRfvriPghQjl5lBj","title":"What is an ER Diagram ?","pathname":"/database-engineering/entity-relationship-diagram/what-is-an-er-diagram","siteSpaceId":"sitesp_CtO4Z","breadcrumbs":[{"label":"Entity Relationship Diagram"}]},{"id":"2QF6klOoU5aWtN7RG01J","title":"Entity","pathname":"/database-engineering/entity-relationship-diagram/entity","siteSpaceId":"sitesp_CtO4Z","breadcrumbs":[{"label":"Entity Relationship Diagram"}]},{"id":"6tha7oEFJRb0k9YIu1My","title":"Identifiers","pathname":"/database-engineering/entity-relationship-diagram/identifiers","siteSpaceId":"sitesp_CtO4Z","breadcrumbs":[{"label":"Entity Relationship Diagram"}]},{"id":"ui0GTAQCdQ9PmDwqo7oa","title":"Relationship","pathname":"/database-engineering/entity-relationship-diagram/relationship","siteSpaceId":"sitesp_CtO4Z","breadcrumbs":[{"label":"Entity Relationship Diagram"}]},{"id":"yiMtCoVrH63k5esCwOZd","title":"Attributes","pathname":"/database-engineering/entity-relationship-diagram/attributes","siteSpaceId":"sitesp_CtO4Z","breadcrumbs":[{"label":"Entity Relationship Diagram"}]},{"id":"y6bwQvEN2n58HSgzDNBV","title":"Cardinality","pathname":"/database-engineering/entity-relationship-diagram/cardinality","siteSpaceId":"sitesp_CtO4Z","breadcrumbs":[{"label":"Entity Relationship Diagram"}]},{"id":"TIvZH02VzvZ7QvGie8f7","title":"Entity Relationship Diagram Tutorial","pathname":"/database-engineering/entity-relationship-diagram/entity-relationship-diagram-tutorial","siteSpaceId":"sitesp_CtO4Z","breadcrumbs":[{"label":"Entity Relationship Diagram"}]},{"id":"5GbCIfy5d7mFDiWU0vW4","title":"DB-TASK-003","pathname":"/database-engineering/entity-relationship-diagram/db-task-003","siteSpaceId":"sitesp_CtO4Z","breadcrumbs":[{"label":"Entity Relationship Diagram"}]},{"id":"qV85fuWdTgF74MGSI9dT","title":"Joins","pathname":"/database-engineering/joins/joins","siteSpaceId":"sitesp_CtO4Z","breadcrumbs":[{"label":"Joins"}]},{"id":"bAwXSIXtsyxYZLAOmaKJ","title":"Joins With Employee and Departments","pathname":"/database-engineering/joins/joins-with-employee-and-departments","siteSpaceId":"sitesp_CtO4Z","breadcrumbs":[{"label":"Joins"}]},{"id":"gar7h4E5iPxrnz02SBqw","title":"Joins on E-Commerce","pathname":"/database-engineering/joins-on-e-commerce","siteSpaceId":"sitesp_CtO4Z","description":""}]}