
Completed Comprehensive SQLite tutorial on www.sqlitetutorial.net
I fully completed SQLite tutorial on https://www.sqlitetutorial.net/. In this tutorial, I learned SQLite step by step through extensive hands-on practices. This SQLite tutorial is designed for developers who want to use SQLite as the back-end database or to use SQLite to manage structured data in applications including desktop, web, and mobile apps. In this tutorial I learned: • How to build relationships between tables e.g. (1:1), (1:N), (N:N) based on Crow's foot notations. Primary Key and Foreign Key concepts • Joins, group by, having, subquery, case, replace, distinct, in, between, where, offset, like, glob, translate, union, full-text search (FTX), dump, vacuum, import, and export • Windows(Analytical), Aggregate, Data, and String functions • Indexes(performance, in WHERE clause, columns with a lot of data), Triggers(logging, audit, effect other tables and database), and Views • SQL Commands: DDL, DML, TLC, and DQL • API SQLite Python • Using SQLite command line and in_memory database • Pragma foreign_key, pragma user_version (tracking version of database) During this tutorial, I used DBeaver, SQLiteStudio, DbSchema for SQLite, DB Browser, and CMD.