SQLite-Demo

Learn and play with SQL Database: make query for data reading, creating, updating, deleting

Implemented based on LinkedIn learning course: SQL Essential Training

Local set up

To be ready execute queries:

• Download and install SQLite Browser app.
• Open SQLite Browser app and import database schema and data from this file.

Run queries

Open SQLite Browser app, go to Execute SQL tab and paste queries from next examples:

• Simple select query: SELECT AS, WHERE, ORDER BY, LIMIT
• Filter query: CASE WHEN THEN ELSE END, AND, OR, BETWEEN, IN, LIKE, DATE
• Join query: INNER JOIN ON
• Modification Functions query: UPPER, LENGTH, REPLACE(value, signFrom, signTo), IFNULL(value, default), SUBSTR(column, index, lenght), ||, STRFDATE(dateformat, datevalue)
• Aggregation Functions query: SUM, AVG, MAX, MIN, COUNT, and functional ROUND(value, decimalDigitsNumber)
• Grouping query: GROUP BY, HAVING
• Nested query: IS
• Add, update, delete queries: INSERT INTO ... VALUES ..., UPDATE ... SET ... WHERE, DELETE FROM ... WHERE