|
|
-- This tutorial shows how you can use SQLite Studio using data exported from Mint.com, -- a personal financial planning tool that aggregates financial data from various accounts. -- I include as…
|
|
|
This tutorial goes over the tutorial in this Google Doc: https://docs.google.com/document/d/1H3wChEZ72VySg6Ub4E-_u5hfHfTbqeUF9Hh7JR5hh3Y/edit?usp=sharing. Note this is an older version of the…
|
|
|
This tutorial introduces two additional ways to interact with SQLite Studio -- using a browser extension (Chrome or Firefox), and using a command line, text-based terminal. Any text or database…
|
|
|
This tutorial shows how to write SQL queries in SQLite Studio. This tutorial shows how tables can be created using SQL commands and how data can be inserted using SQL commands. See the…
|
|
|
This tutorial shows how to install SQLite Studio on Windows and Mac computers and demonstrates how to create a database. See the attachments tab for a link to download the database created in the…
|
|
|
This tutorial shows how to install SQLite Studio and demonstrates how to create a database and write queries. See the attachments tab for a link to download the database created in the video, the…
|
|
|
Illustration of statistics based on an analysis of the self-reported height of students and other data. This second tutorial shows how to calculate a standard error and how to compare averages of…
|
|
|
This tutorial discusses the design of a database that tracks customer orders. Here is a link to a document that discusses the design of the database (click to view). See the attachments for a copy…
|
|
|
Illustration of statistics based on an analysis of the self-reported height of students and other data. Recorded fall 2020. This document contains the analysis I completed (click to view the google…
|