{"product_id":"learn-sqlite-in-24-hours","title":"Learn SQLite in 24 Hours","description":"\u003cp\u003eSQLite is a very lightweight database, with no installation required, zero configuration, and no server required. SQLite is widely used as a database of choice in mobile apps, camera, home electronic devices and other embedded systems.\u003c\/p\u003e\n\u003cp\u003eThis book is designed for beginners with little or no prior database experience.\u003c\/p\u003e\n\u003cp\u003e\u003cstrong\u003eHere is what you will learn:\u003c\/strong\u003e\u003c\/p\u003e\n\u003cp\u003e\u003cstrong\u003eChapter 1: Introduction\u003c\/strong\u003e\u003c\/p\u003e\n\u003cp\u003e\u003cstrong\u003eChapter 2: Create Database\u003c\/strong\u003e\u003c\/p\u003e\n\u003col\u003e\n\u003cli\u003eCREATE Database\u003c\/li\u003e\n\u003cli\u003eCREATE Database in a Specific Location\u003c\/li\u003e\n\u003cli\u003eCreate database and populate it with tables from a file\u003c\/li\u003e\n\u003cli\u003eBackup \u0026amp; Database\u003c\/li\u003e\n\u003cli\u003eDrop Database\u003c\/li\u003e\n\u003c\/ol\u003e\n\u003cp\u003e\u003cstrong\u003eChapter 3: Create, Alter, Drop Table\u003c\/strong\u003e\u003c\/p\u003e\n\u003col\u003e\n\u003cli\u003eCreate table\u003c\/li\u003e\n\u003cli\u003eDrop table\u003c\/li\u003e\n\u003cli\u003eAlter table\u003c\/li\u003e\n\u003cli\u003eAdd columns- Using ALTER TABLE Command\u003c\/li\u003e\n\u003cli\u003eInsert value into a table\u003c\/li\u003e\n\u003c\/ol\u003e\n\u003cp\u003e\u003cstrong\u003eChapter 4: Primary \u0026amp; Foreign Key\u003c\/strong\u003e\u003c\/p\u003e\n\u003col\u003e\n\u003cli\u003eSQLite constraint\u003c\/li\u003e\n\u003cli\u003ePrimary Key\u003c\/li\u003e\n\u003cli\u003eNot null constraint\u003c\/li\u003e\n\u003cli\u003eDEFAULT Constraint\u003c\/li\u003e\n\u003cli\u003eUNIQUE constraint\u003c\/li\u003e\n\u003cli\u003eWhat is a SQLite Foreign KEY?\u003c\/li\u003e\n\u003c\/ol\u003e\n\u003cp\u003e\u003cstrong\u003eChapter 5: Data Types\u003c\/strong\u003e\u003c\/p\u003e\n\u003col\u003e\n\u003cli\u003eStorage Classes\u003c\/li\u003e\n\u003cli\u003eAffinity Type\u003c\/li\u003e\n\u003cli\u003eExamples of storing data types in SQLite\u003c\/li\u003e\n\u003c\/ol\u003e\n\u003cp\u003e\u003cstrong\u003eChapter 6: Select, Where, Limit, Count, Group By, Union\u003c\/strong\u003e\u003c\/p\u003e\n\u003col\u003e\n\u003cli\u003eReading data with select\u003c\/li\u003e\n\u003cli\u003eWHERE\u003c\/li\u003e\n\u003cli\u003eLimiting and Ordering\u003c\/li\u003e\n\u003cli\u003eGroup BY\u003c\/li\u003e\n\u003cli\u003eQuery \u0026amp; Subquery\u003c\/li\u003e\n\u003cli\u003eSet Operations -UNION,Intersect\u003c\/li\u003e\n\u003cli\u003eConditional results\u003c\/li\u003e\n\u003cli\u003eAdvanced queries\u003c\/li\u003e\n\u003c\/ol\u003e\n\u003cp\u003e\u003cstrong\u003eChapter 7: Joins\u003c\/strong\u003e\u003c\/p\u003e\n\u003col\u003e\n\u003cli\u003eIntroduction to SQLite JOIN Clause\u003c\/li\u003e\n\u003cli\u003eINNER JOIN\u003c\/li\u003e\n\u003cli\u003eJOIN … USING\u003c\/li\u003e\n\u003cli\u003eNATURAL JOIN\u003c\/li\u003e\n\u003cli\u003eLEFT OUTER JOIN\u003c\/li\u003e\n\u003cli\u003eCROSS JOIN\u003c\/li\u003e\n\u003c\/ol\u003e\n\u003cp\u003e\u003cstrong\u003eChapter 8: INSERT, UPDATE, DELETE\u003c\/strong\u003e\u003c\/p\u003e\n\u003col\u003e\n\u003cli\u003eINSERT\u003c\/li\u003e\n\u003cli\u003eUpdate\u003c\/li\u003e\n\u003cli\u003eDelete\u003c\/li\u003e\n\u003cli\u003eConflict clause\u003c\/li\u003e\n\u003c\/ol\u003e\n\u003cp\u003e\u003cstrong\u003eChapter 9: Index, Trigger \u0026amp; View\u003c\/strong\u003e\u003c\/p\u003e\n\u003col\u003e\n\u003cli\u003eView\u003c\/li\u003e\n\u003cli\u003eIndex\u003c\/li\u003e\n\u003cli\u003eTrigger\u003c\/li\u003e\n\u003c\/ol\u003e\n\u003cp\u003e\u003cstrong\u003eChapter 10: SQLite Functions\u003c\/strong\u003e\u003c\/p\u003e\n\u003col\u003e\n\u003cli\u003eFinding the LENGTH of a string\u003c\/li\u003e\n\u003cli\u003eUPPER Function and LOWER Function\u003c\/li\u003e\n\u003cli\u003eTRIM Function\u003c\/li\u003e\n\u003cli\u003eTYPEOF Function\u003c\/li\u003e\n\u003cli\u003eSQLite LAST_INSERT_ROWID\u003c\/li\u003e\n\u003cli\u003eSQLite library\u003c\/li\u003e\n\u003cli\u003eUser-defined functions\u003c\/li\u003e\n\u003c\/ol\u003e","brand":"None","offers":[{"title":"Kobo eBook","offer_id":46662197674194,"sku":"145c30b9-aa09-3bd1-810d-dcb5a8647568","price":13.73,"currency_code":"CAD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0655\/8980\/5233\/files\/image_38ac1fa0-f46c-4bda-b9d2-9fe2c67955c8.jpg?v=1763105259","url":"https:\/\/www.indigo.ca\/products\/learn-sqlite-in-24-hours","provider":"Indigo","version":"1.0","type":"link"}