SQLite for Beginners

Learn how to query relational databases using SQL, including SQLite, with actions such as select, delete, and insert, identify tables, apply conditions, and use semicolons and comments.

Create and drop tables in SQLite using DB Browser, choosing data types like integer, text, blob, reel, numeric, and applying constraints such as not null, primary key, autoincrement, and unique.

Discover how to use select statements to query the countries table, filter by continent and population, apply like and wildcard searches, limit results, and compute max and min values.

Delete records from table countries using delete with a where clause (e.g., where country = Brazil); use modifiers like and, max, and verify results with a select.

Explore the in statement to run subqueries in SQL, filtering the languages table by countries in North America through an inner query whose results feed the outer query.

Sort SQL query results with order by to arrange records by continent and then by country in ascending or descending order.

Learn how to group query results by a common field with group by, and use aggregate functions like count, average, and sum to summarize data per continent.

Master the insert into command to add records in SQLite, including specifying columns and handling text versus integer data types with proper quoting.

Use SQLite update statement to set a country’s population to 2000, ensure a precise where clause targets a single row, and verify with a select.

Explore how SQLite joins merge data across tables, including inner joins, left joins, and cross joins, using country and language tables to illustrate matching and retrieval.

Learn how SQLite integrates with Python by importing the SQLite module, creating a database and a table with a multi-line SQL create statement, and viewing the result in DB Browser.

Define a Python function with two parameters to insert a record into SQLite. Use a parameterized SQL statement, then connect, commit, and verify in the countries table on DB Browser.

Learn to run a select query on a sample SQLite database by creating a connection and cursor, executing SQL, fetching and printing results, then committing and closing.