{"id":2,"date":"2015-11-23T03:46:31","date_gmt":"2015-11-23T03:46:31","guid":{"rendered":"https:\/\/web.archive.org\/web\/20251112112743\/http:\/\/www.sqlitetutorial.net\/?page_id=2"},"modified":"2024-05-05T08:41:49","modified_gmt":"2024-05-05T01:41:49","slug":"sqlite-tutorial","status":"publish","type":"page","link":"https:\/\/web.archive.org\/web\/20251112112743\/https:\/\/www.sqlitetutorial.net\/","title":{"rendered":"SQLite Tutorial"},"content":{"rendered":"<div class=\"wp-block-image\">\n<figure class=\"alignright size-large is-resized\"><img decoding=\"async\" src=\"https:\/\/www.sqlitetutorial.net\/wp-content\/uploads\/2021\/04\/sqlite-tutorial-homepage.svg\" alt=\"SQLite Tutorial\" class=\"wp-image-2687\" style=\"width:225px;height:107px\"\/><\/figure><\/div>\n\n\n<p>This<strong> SQLite tutorial <\/strong>teaches you everything you need to know to start using SQLite effectively. In this tutorial, you will learn SQLite step by step through extensive hands-on practice.<\/p>\n\n\n\n<p>This SQLite tutorial is designed for developers who want to use SQLite as the back-end database or to manage structured data in applications, including desktop, web, and mobile apps;<\/p>\n\n\n\n<p>SQLite is an open-source, zero-configuration, self-contained, stand-alone, transaction relational database engine designed to be embedded into an application.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Getting started with SQLite<\/h2>\n\n\n\n<p>You should go through this section if this is the first time you have worked with SQLite. Follow these 4-easy steps to get started with SQLite fast.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>First, help you answer the first and important question: <a href=\"https:\/\/www.sqlitetutorial.net\/what-is-sqlite\/\">what is SQLite<\/a>? You will have a brief overview of SQLite.<\/li>\n\n\n\n<li>Second, show you step-by-step <a href=\"https:\/\/www.sqlitetutorial.net\/download-install-sqlite\/\">how to download and install the SQLite tools<\/a> on your computer.<\/li>\n\n\n\n<li>Third, introduce you to an <a href=\"https:\/\/www.sqlitetutorial.net\/sqlite-sample-database\/\">SQLite sample database<\/a> and walk you through the steps of using the sample database for practice.<\/li>\n\n\n\n<li>Finally, guide you on how to use the <a href=\"https:\/\/www.sqlitetutorial.net\/sqlite-commands\/\">sqlite3 commands<\/a>.<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\">Basic SQLite tutorial<\/h2>\n\n\n\n<p>This section presents basic SQL statements that you can use with SQLite. You will first start querying data from the <a href=\"https:\/\/www.sqlitetutorial.net\/sqlite-sample-database\/\">sample database<\/a>. If you are already familiar with SQL, you will notice the differences between SQL standard and the SQL dialect used in SQLite.<\/p>\n\n\n\n<div class=\"wp-block-group\"><div class=\"wp-block-group__inner-container is-layout-flow wp-block-group-is-layout-flow\">\n<h3 class=\"wp-block-heading\">Section 1. Simple query<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li><a href=\"https:\/\/www.sqlitetutorial.net\/sqlite-select\/\">Select<\/a> &#8211; query data from a single table using <code>SELECT<\/code> statement.<\/li>\n<\/ul>\n<\/div><\/div>\n\n\n\n<div class=\"wp-block-group\"><div class=\"wp-block-group__inner-container is-layout-flow wp-block-group-is-layout-flow\">\n<h3 class=\"wp-block-heading\">Section 2. Sorting rows<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li><a href=\"https:\/\/www.sqlitetutorial.net\/sqlite-order-by\/\">Order By<\/a> &#8211; sort the result set in ascending or descending order.<\/li>\n<\/ul>\n<\/div><\/div>\n\n\n\n<div class=\"wp-block-group\"><div class=\"wp-block-group__inner-container is-layout-flow wp-block-group-is-layout-flow\">\n<h3 class=\"wp-block-heading\">Section 3. Filtering data<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li><a href=\"https:\/\/www.sqlitetutorial.net\/sqlite-distinct\/\">Select Distinct<\/a> &#8211; query unique rows from a table using the&nbsp;DISTINCT clause.<\/li>\n\n\n\n<li><a href=\"https:\/\/www.sqlitetutorial.net\/sqlite-where\/\">Where<\/a>&nbsp; &#8211; filter rows of a result set using various conditions.<\/li>\n\n\n\n<li><a href=\"https:\/\/www.sqlitetutorial.net\/sqlite-and-operator\/\">AND<\/a> &#8211; filter rows by combining multiple conditions.<\/li>\n\n\n\n<li><a href=\"https:\/\/www.sqlitetutorial.net\/sqlite-or-operator\/\">OR<\/a> &#8211; combine multiple conditions and filter rows based on at least a specified condition being true.<\/li>\n\n\n\n<li><a href=\"https:\/\/www.sqlitetutorial.net\/sqlite-limit\/\">Limit<\/a> &#8211; constrain the number of rows a query returns and how to get only the necessary data from a table.<\/li>\n\n\n\n<li><a href=\"https:\/\/www.sqlitetutorial.net\/sqlite-between\/\">Between<\/a>&nbsp;&#8211; test whether a value is in a range of values.<\/li>\n\n\n\n<li><a href=\"https:\/\/www.sqlitetutorial.net\/sqlite-in\/\">In<\/a>&nbsp;&#8211; check if a value matches any value in a list of values or subquery.<\/li>\n\n\n\n<li><a href=\"https:\/\/www.sqlitetutorial.net\/sqlite-like\/\">Like<\/a> &#8211; query data based on pattern matching using wildcard characters: percent sign (%) and underscore (_).<\/li>\n\n\n\n<li><a href=\"https:\/\/www.sqlitetutorial.net\/sqlite-glob\/\">Glob<\/a> &#8211; determine whether a string matches a specific UNIX pattern.<\/li>\n\n\n\n<li><a href=\"https:\/\/www.sqlitetutorial.net\/sqlite-is-null\/\">IS NULL<\/a> &#8211; check if a value is null or not.<\/li>\n<\/ul>\n<\/div><\/div>\n\n\n\n<div class=\"wp-block-group\"><div class=\"wp-block-group__inner-container is-layout-flow wp-block-group-is-layout-flow\">\n<h3 class=\"wp-block-heading\">Section 4. Joining tables<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li><a href=\"https:\/\/www.sqlitetutorial.net\/sqlite-inner-join\/\">Inner Join<\/a> &#8211; query data from multiple tables using the inner join clause.<\/li>\n\n\n\n<li><a href=\"https:\/\/www.sqlitetutorial.net\/sqlite-left-join\/\">Left Join<\/a> &#8211; combine data from multiple tables using the left join clause.<\/li>\n\n\n\n<li><a href=\"https:\/\/www.sqlitetutorial.net\/sqlite-right-join\/\">Right Join<\/a> &#8211; combine rows from two tables based on a related column.<\/li>\n\n\n\n<li><a href=\"https:\/\/www.sqlitetutorial.net\/sqlite-cross-join\/\">Cross Join<\/a> &#8211; show you how to use the cross join clause to produce a cartesian product of result sets of the tables involved in the join.<\/li>\n\n\n\n<li><a href=\"https:\/\/www.sqlitetutorial.net\/sqlite-self-join\/\">Self Join<\/a> &#8211; join a table with itself to create a result set that joins rows with other rows within the same table.<\/li>\n\n\n\n<li><a href=\"https:\/\/www.sqlitetutorial.net\/sqlite-full-outer-join\/\">Full Outer Join<\/a> &#8211; show you how to use the full outer join in the SQLite.<\/li>\n\n\n\n<li><a href=\"https:\/\/www.sqlitetutorial.net\/sqlite-join\/\">SQLite joins<\/a> &#8211; recap the joins including inner join, left join, right join, full outer join, and cross join.<\/li>\n<\/ul>\n<\/div><\/div>\n\n\n\n<div class=\"wp-block-group\"><div class=\"wp-block-group__inner-container is-layout-flow wp-block-group-is-layout-flow\">\n<h3 class=\"wp-block-heading\">Section 5. Grouping data<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li><a href=\"https:\/\/www.sqlitetutorial.net\/sqlite-group-by\/\">Group By<\/a> &#8211; combine a set of rows into groups based on specified criteria. The <code>GROUP BY<\/code> clause helps you summarize data for&nbsp;reporting purposes.<\/li>\n\n\n\n<li><a href=\"https:\/\/www.sqlitetutorial.net\/sqlite-having\/\">Having<\/a> &#8211; specify the conditions to filter the groups summarized by the <code>GROUP BY<\/code> clause.<\/li>\n<\/ul>\n<\/div><\/div>\n\n\n\n<div class=\"wp-block-group\"><div class=\"wp-block-group__inner-container is-layout-flow wp-block-group-is-layout-flow\">\n<h3 class=\"wp-block-heading\">Section 6. Set operators<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li><a href=\"https:\/\/www.sqlitetutorial.net\/sqlite-union\/\">Union<\/a> &#8211; combine result sets of multiple queries into a single result set. We also discuss the differences between <code>UNION<\/code> and <code>UNION ALL<\/code> clauses.<\/li>\n\n\n\n<li><a href=\"https:\/\/www.sqlitetutorial.net\/sqlite-except\/\">Except<\/a> &#8211; compare the result sets of two queries and return distinct rows from the left query that are not output by the right query.<\/li>\n\n\n\n<li><a href=\"https:\/\/www.sqlitetutorial.net\/sqlite-intersect\/\">Intersect<\/a> &#8211;&nbsp;compare the result sets of two&nbsp;queries&nbsp;and returns distinct rows that are output by both queries.<\/li>\n<\/ul>\n<\/div><\/div>\n\n\n\n<div class=\"wp-block-group\"><div class=\"wp-block-group__inner-container is-layout-flow wp-block-group-is-layout-flow\">\n<h3 class=\"wp-block-heading\">Section 7. Subquery &amp; CTE<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li><a href=\"https:\/\/www.sqlitetutorial.net\/sqlite-subquery\/\">Subquery<\/a> &#8211; introduce you to the SQLite subquery and correlated subquery.<\/li>\n\n\n\n<li><a href=\"https:\/\/www.sqlitetutorial.net\/sqlite-exists\/\">Exists<\/a> operator &#8211; test for the existence of rows returned by a subquery.<\/li>\n\n\n\n<li><a href=\"https:\/\/www.sqlitetutorial.net\/sqlite-cte\/\">Common Table Expressions (CTE) <\/a>&#8211; use CTEs to simplify your queries and make them more readable.<\/li>\n<\/ul>\n<\/div><\/div>\n\n\n\n<div class=\"wp-block-group\"><div class=\"wp-block-group__inner-container is-layout-flow wp-block-group-is-layout-flow\">\n<h3 class=\"wp-block-heading\">Section 8. More querying techniques<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li><a href=\"https:\/\/www.sqlitetutorial.net\/sqlite-case\/\">Case<\/a> &#8211; add conditional logic to the query.<\/li>\n<\/ul>\n<\/div><\/div>\n\n\n\n<div class=\"wp-block-group\"><div class=\"wp-block-group__inner-container is-layout-flow wp-block-group-is-layout-flow\">\n<h3 class=\"wp-block-heading\">Section 9. Changing data<\/h3>\n\n\n\n<p>This section guides you on updating data in the table using insert, update, delete, and replace statements.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><a href=\"https:\/\/www.sqlitetutorial.net\/sqlite-insert\/\">Insert<\/a> &#8211; insert rows into a table<\/li>\n\n\n\n<li><a href=\"https:\/\/www.sqlitetutorial.net\/sqlite-update\/\">Update<\/a> &#8211; update existing rows in a table.<\/li>\n\n\n\n<li><a href=\"https:\/\/www.sqlitetutorial.net\/sqlite-delete\/\">Delete<\/a> &#8211; delete rows from a table.<\/li>\n\n\n\n<li><a href=\"https:\/\/www.sqlitetutorial.net\/sqlite-replace-statement\/\">Replace<\/a> &#8211;&nbsp;insert a new row or replace the existing row in a table.<\/li>\n\n\n\n<li><a href=\"https:\/\/www.sqlitetutorial.net\/sqlite-upsert\/\">Upsert<\/a> &#8211; perform an insert if the row does not exist or update otherwise.<\/li>\n\n\n\n<li><a href=\"https:\/\/www.sqlitetutorial.net\/sqlite-returning\/\">RETURNING clause<\/a> &#8211; return the inserted, updated, and deleted rows.<\/li>\n<\/ul>\n<\/div><\/div>\n\n\n\n<div class=\"wp-block-group\"><div class=\"wp-block-group__inner-container is-layout-flow wp-block-group-is-layout-flow\">\n<h3 class=\"wp-block-heading\">Section 10. Transactions<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li><a href=\"https:\/\/www.sqlitetutorial.net\/sqlite-transaction\/\">Transaction<\/a> &#8211; show you how to handle transactions in SQLite.<\/li>\n<\/ul>\n<\/div><\/div>\n\n\n\n<div class=\"wp-block-group\"><div class=\"wp-block-group__inner-container is-layout-flow wp-block-group-is-layout-flow\">\n<h3 class=\"wp-block-heading\">Section 11. Data definition<\/h3>\n\n\n\n<p>In this section, you&#8217;ll learn how to create database objects such as tables, views, and indexes using SQL data definition language.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><a href=\"https:\/\/www.sqlitetutorial.net\/sqlite-data-types\/\">SQLite Data Types<\/a> &#8211; introduce you to the SQLite dynamic type system and its important concepts: storage classes, manifest typing, and type affinity.<\/li>\n\n\n\n<li><a href=\"https:\/\/www.sqlitetutorial.net\/sqlite-create-table\/\">Create Table<\/a> &#8211; show you how to create a new table in the database.<\/li>\n\n\n\n<li><a href=\"https:\/\/www.sqlitetutorial.net\/sqlite-alter-table\/\">Alter Table<\/a> &#8211;&nbsp;show you how to modify the structure of an existing table.<\/li>\n\n\n\n<li><a href=\"https:\/\/www.sqlitetutorial.net\/sqlite-rename-column\/\">Rename column<\/a> &#8211; learn step by step how to rename a column of a table.<\/li>\n\n\n\n<li><a href=\"https:\/\/www.sqlitetutorial.net\/sqlite-drop-table\/\">Drop Table<\/a> &#8211; guide you on how to remove a table from the database.<\/li>\n\n\n\n<li><a href=\"https:\/\/www.sqlitetutorial.net\/sqlite-vacuum\/\">VACUUM<\/a> &#8211; show you how to optimize database files.<\/li>\n<\/ul>\n<\/div><\/div>\n\n\n\n<div class=\"wp-block-group\"><div class=\"wp-block-group__inner-container is-layout-flow wp-block-group-is-layout-flow\">\n<h3 class=\"wp-block-heading\">Section 12. Constraints<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li><a href=\"https:\/\/www.sqlitetutorial.net\/sqlite-primary-key\/\">Primary Key <\/a>&#8211; show you how to define the&nbsp;primary key for a table.<\/li>\n\n\n\n<li><a href=\"https:\/\/www.sqlitetutorial.net\/sqlite-not-null-constraint\/\">NOT NULL constraint<\/a> &#8211; learn how to enforce values of columns that are not NULL.<\/li>\n\n\n\n<li><a href=\"https:\/\/www.sqlitetutorial.net\/sqlite-unique-constraint\/\">UNIQUE constraint<\/a> &#8211; ensure values in a column or a group of columns are unique.<\/li>\n\n\n\n<li><a href=\"https:\/\/www.sqlitetutorial.net\/sqlite-check-constraint\/\">CHECK constraint<\/a> &#8211; ensure the values in a column meet a specified condition defined by an expression.<\/li>\n\n\n\n<li><a href=\"https:\/\/www.sqlitetutorial.net\/sqlite-autoincrement\/\">AUTOINCREMENT <\/a>&#8211; explain how the <code>AUTOINCREMENT<\/code> column attribute works and why you should avoid using it.<\/li>\n<\/ul>\n<\/div><\/div>\n\n\n\n<div class=\"wp-block-group\"><div class=\"wp-block-group__inner-container is-layout-flow wp-block-group-is-layout-flow\">\n<h3 class=\"wp-block-heading\">Section 13. Views<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li><a href=\"https:\/\/www.sqlitetutorial.net\/sqlite-create-view\/\">Create View<\/a> &#8211; introduce you to the view concept and show you how to create a new view in the database.<\/li>\n\n\n\n<li><a href=\"https:\/\/www.sqlitetutorial.net\/sqlite-drop-view\/\">Drop View<\/a> &#8211; show you how to drop a view from its database schema.<\/li>\n<\/ul>\n<\/div><\/div>\n\n\n\n<div class=\"wp-block-group\"><div class=\"wp-block-group__inner-container is-layout-flow wp-block-group-is-layout-flow\">\n<h3 class=\"wp-block-heading\">Section 14. Indexes<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li><a href=\"https:\/\/www.sqlitetutorial.net\/sqlite-index\/\">Index<\/a> &#8211; teach you about the index and how to utilize indexes to speed up your queries.<\/li>\n\n\n\n<li><a href=\"https:\/\/www.sqlitetutorial.net\/sqlite-index-expression\/\">Index for Expressions<\/a> &#8211; show you how to use the expression-based index.<\/li>\n<\/ul>\n<\/div><\/div>\n\n\n\n<div class=\"wp-block-group\"><div class=\"wp-block-group__inner-container is-layout-flow wp-block-group-is-layout-flow\">\n<h3 class=\"wp-block-heading\">Section 15. Triggers<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li><a href=\"https:\/\/www.sqlitetutorial.net\/sqlite-trigger\/\">Trigger<\/a> &#8211; manage triggers in the SQLite database.<\/li>\n\n\n\n<li><a href=\"https:\/\/www.sqlitetutorial.net\/sqlite-instead-of-triggers\/\">Create INSTEAD OF triggers<\/a> &#8211; learn about <code>INSTEAD OF<\/code> triggers and how to create an <code>INSTEAD OF<\/code> trigger to update data via a view.<\/li>\n<\/ul>\n<\/div><\/div>\n\n\n\n<div class=\"wp-block-group\"><div class=\"wp-block-group__inner-container is-layout-flow wp-block-group-is-layout-flow\">\n<h3 class=\"wp-block-heading\">Section 16. Full-text search<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li><a href=\"https:\/\/www.sqlitetutorial.net\/sqlite-full-text-search\/\">Full-text search<\/a> &#8211;&nbsp;get started with the full-text search in SQLite.<\/li>\n<\/ul>\n<\/div><\/div>\n\n\n\n<div class=\"wp-block-group\"><div class=\"wp-block-group__inner-container is-layout-flow wp-block-group-is-layout-flow\">\n<h3 class=\"wp-block-heading\">Section 17. SQLite tools<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li><a href=\"https:\/\/www.sqlitetutorial.net\/sqlite-commands\/\">SQLite Commands<\/a> &#8211; show you the most commonly used command in the sqlite3 program.<\/li>\n\n\n\n<li><a href=\"https:\/\/www.sqlitetutorial.net\/sqlite-show-tables\/\">SQLite Show Tables<\/a>&nbsp;&#8211; list all tables in a database.<\/li>\n\n\n\n<li><a href=\"https:\/\/www.sqlitetutorial.net\/sqlite-describe-table\/\">SQLite Describe Table<\/a>&nbsp;&#8211; show the structure of a table.<\/li>\n\n\n\n<li><a href=\"https:\/\/www.sqlitetutorial.net\/sqlite-dump\/\">SQLite Dump<\/a>&nbsp;&#8211; how to use the <code>.dump<\/code> command to back up and restore a database.<\/li>\n\n\n\n<li><a href=\"https:\/\/www.sqlitetutorial.net\/sqlite-import-csv\/\">SQLite Import CSV<\/a>&nbsp;&#8211;  import CSV files into a table.<\/li>\n\n\n\n<li><a href=\"https:\/\/www.sqlitetutorial.net\/sqlite-export-csv\/\">SQLite Export CSV<\/a>&nbsp;&#8211;  export an SQLite database to CSV files.<\/li>\n<\/ul>\n<\/div><\/div>\n\n\n\n<h2 class=\"wp-block-heading\">SQLite Resources<\/h2>\n\n\n\n<p>If you want to know more information about SQLite, you can go through <a href=\"https:\/\/www.sqlitetutorial.net\/sqlite-resources\/\">a well-organized SQLite resources<\/a> page that contains links to useful SQLite sites.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>This SQLite tutorial teaches you everything you need to know to start using SQLite effectively. You will learn SQLite through extensive hands-on practices.<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":1,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-2","page","type-page","status-publish","hentry"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v22.7 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>SQLite Tutorial - An Easy Way to Master SQLite Fast<\/title>\n<meta name=\"description\" content=\"This SQLite tutorial teaches you everything you need to know to start using SQLite effectively. You will learn SQLite via extensive hands-on practices.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.sqlitetutorial.net\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SQLite Tutorial - An Easy Way to Master SQLite Fast\" \/>\n<meta property=\"og:description\" content=\"This SQLite tutorial teaches you everything you need to know to start using SQLite effectively. You will learn SQLite via extensive hands-on practices.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.sqlitetutorial.net\/\" \/>\n<meta property=\"og:site_name\" content=\"SQLite Tutorial\" \/>\n<meta property=\"article:modified_time\" content=\"2024-05-05T01:41:49+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.sqlitetutorial.net\/wp-content\/uploads\/2021\/04\/sqlite-tutorial-homepage.svg\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"6 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.sqlitetutorial.net\/\",\"url\":\"https:\/\/www.sqlitetutorial.net\/\",\"name\":\"SQLite Tutorial - An Easy Way to Master SQLite Fast\",\"isPartOf\":{\"@id\":\"https:\/\/www.sqlitetutorial.net\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.sqlitetutorial.net\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.sqlitetutorial.net\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.sqlitetutorial.net\/wp-content\/uploads\/2021\/04\/sqlite-tutorial-homepage.svg\",\"datePublished\":\"2015-11-23T03:46:31+00:00\",\"dateModified\":\"2024-05-05T01:41:49+00:00\",\"description\":\"This SQLite tutorial teaches you everything you need to know to start using SQLite effectively. You will learn SQLite via extensive hands-on practices.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.sqlitetutorial.net\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.sqlitetutorial.net\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.sqlitetutorial.net\/#primaryimage\",\"url\":\"https:\/\/www.sqlitetutorial.net\/wp-content\/uploads\/2021\/04\/sqlite-tutorial-homepage.svg\",\"contentUrl\":\"https:\/\/www.sqlitetutorial.net\/wp-content\/uploads\/2021\/04\/sqlite-tutorial-homepage.svg\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.sqlitetutorial.net\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.sqlitetutorial.net\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SQLite Tutorial\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.sqlitetutorial.net\/#website\",\"url\":\"https:\/\/www.sqlitetutorial.net\/\",\"name\":\"SQLite Tutorial\",\"description\":\"A Step-by-step SQLite Tutorial\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.sqlitetutorial.net\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.sqlitetutorial.net\/#\/schema\/person\/6d69b968cad0102e30d6694ed8dc6427\",\"name\":\"admin\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"SQLite Tutorial - An Easy Way to Master SQLite Fast","description":"This SQLite tutorial teaches you everything you need to know to start using SQLite effectively. You will learn SQLite via extensive hands-on practices.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/web.archive.org\/web\/20251112112743\/https:\/\/www.sqlitetutorial.net\/","og_locale":"en_US","og_type":"article","og_title":"SQLite Tutorial - An Easy Way to Master SQLite Fast","og_description":"This SQLite tutorial teaches you everything you need to know to start using SQLite effectively. You will learn SQLite via extensive hands-on practices.","og_url":"https:\/\/web.archive.org\/web\/20251112112743\/https:\/\/www.sqlitetutorial.net\/","og_site_name":"SQLite Tutorial","article_modified_time":"2024-05-05T01:41:49+00:00","og_image":[{"url":"https:\/\/web.archive.org\/web\/20251112112743\/https:\/\/www.sqlitetutorial.net\/wp-content\/uploads\/2021\/04\/sqlite-tutorial-homepage.svg"}],"twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"6 minutes"},"schema":{"@context":"https:\/\/web.archive.org\/web\/20251112112743\/https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/web.archive.org\/web\/20251112112743\/https:\/\/www.sqlitetutorial.net\/","url":"https:\/\/web.archive.org\/web\/20251112112743\/https:\/\/www.sqlitetutorial.net\/","name":"SQLite Tutorial - An Easy Way to Master SQLite Fast","isPartOf":{"@id":"https:\/\/web.archive.org\/web\/20251112112743\/https:\/\/www.sqlitetutorial.net\/#website"},"primaryImageOfPage":{"@id":"https:\/\/web.archive.org\/web\/20251112112743\/https:\/\/www.sqlitetutorial.net\/#primaryimage"},"image":{"@id":"https:\/\/web.archive.org\/web\/20251112112743\/https:\/\/www.sqlitetutorial.net\/#primaryimage"},"thumbnailUrl":"https:\/\/web.archive.org\/web\/20251112112743\/https:\/\/www.sqlitetutorial.net\/wp-content\/uploads\/2021\/04\/sqlite-tutorial-homepage.svg","datePublished":"2015-11-23T03:46:31+00:00","dateModified":"2024-05-05T01:41:49+00:00","description":"This SQLite tutorial teaches you everything you need to know to start using SQLite effectively. You will learn SQLite via extensive hands-on practices.","breadcrumb":{"@id":"https:\/\/web.archive.org\/web\/20251112112743\/https:\/\/www.sqlitetutorial.net\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/web.archive.org\/web\/20251112112743\/https:\/\/www.sqlitetutorial.net\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/web.archive.org\/web\/20251112112743\/https:\/\/www.sqlitetutorial.net\/#primaryimage","url":"https:\/\/web.archive.org\/web\/20251112112743\/https:\/\/www.sqlitetutorial.net\/wp-content\/uploads\/2021\/04\/sqlite-tutorial-homepage.svg","contentUrl":"https:\/\/web.archive.org\/web\/20251112112743\/https:\/\/www.sqlitetutorial.net\/wp-content\/uploads\/2021\/04\/sqlite-tutorial-homepage.svg"},{"@type":"BreadcrumbList","@id":"https:\/\/web.archive.org\/web\/20251112112743\/https:\/\/www.sqlitetutorial.net\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/web.archive.org\/web\/20251112112743\/https:\/\/www.sqlitetutorial.net\/"},{"@type":"ListItem","position":2,"name":"SQLite Tutorial"}]},{"@type":"WebSite","@id":"https:\/\/web.archive.org\/web\/20251112112743\/https:\/\/www.sqlitetutorial.net\/#website","url":"https:\/\/web.archive.org\/web\/20251112112743\/https:\/\/www.sqlitetutorial.net\/","name":"SQLite Tutorial","description":"A Step-by-step SQLite Tutorial","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/web.archive.org\/web\/20251112112743\/https:\/\/www.sqlitetutorial.net\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/web.archive.org\/web\/20251112112743\/https:\/\/www.sqlitetutorial.net\/#\/schema\/person\/6d69b968cad0102e30d6694ed8dc6427","name":"admin"}]}},"_links":{"self":[{"href":"https:\/\/web.archive.org\/web\/20251112112743\/https:\/\/www.sqlitetutorial.net\/wp-json\/wp\/v2\/pages\/2","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/web.archive.org\/web\/20251112112743\/https:\/\/www.sqlitetutorial.net\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/web.archive.org\/web\/20251112112743\/https:\/\/www.sqlitetutorial.net\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/web.archive.org\/web\/20251112112743\/https:\/\/www.sqlitetutorial.net\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/web.archive.org\/web\/20251112112743\/https:\/\/www.sqlitetutorial.net\/wp-json\/wp\/v2\/comments?post=2"}],"version-history":[{"count":5,"href":"https:\/\/web.archive.org\/web\/20251112112743\/https:\/\/www.sqlitetutorial.net\/wp-json\/wp\/v2\/pages\/2\/revisions"}],"predecessor-version":[{"id":3480,"href":"https:\/\/web.archive.org\/web\/20251112112743\/https:\/\/www.sqlitetutorial.net\/wp-json\/wp\/v2\/pages\/2\/revisions\/3480"}],"wp:attachment":[{"href":"https:\/\/web.archive.org\/web\/20251112112743\/https:\/\/www.sqlitetutorial.net\/wp-json\/wp\/v2\/media?parent=2"}],"curies":[{"name":"wp","href":"https:\/\/web.archive.org\/web\/20251112112743\/https:\/\/api.w.org\/{rel}","templated":true}]}}