SQLite Lesson 2
This lesson is adapted from information provided by Investigative Reporters and Editors. Much of the following includes IRE practice data for the purpose of training. I've included additional info to further clarify difficult concepts and to make it a little bit fun.
Queries in the movies
For part 2 of this intro to SQL, we'll tackle how to group, sum and count. Part 3 will cover how to join.
Keeping with the data about US dams from the previous lesson, let's think of a few . . .
How to produce a FIRST TAKE photo essay
Follow these steps to build a strong gallery that works well on the web.
To turnaround a photo essay, make the photos web-ready and upload them to WordPress
The basic workflow is to:
- Copy the photos from the camera to the computer
- Reduce them in size/weight (typically 1200x900)
- Upload them WordPress' media library
- Include a caption for each photo
- Insert them as a gallery . . .
Setup Chartbuilder locally
Getting going isn't hard, here's how to setup a great data viz tool locally on your Mac.
Click the 'Download ZIP' button (look at the bottom of the right-side nav).
Go to your default downloads directory (folder) and unzip it.
Optional but ideal - move this new 'Chartbuilder-master' directory to a sensible directory . . .
Log in to sqlite3 via the command line
The sky is the limit with SQLite -- once you're logged in. Here's the first crucial step.
Open your command line utility (Terminal on the Mac).
Use a few UNIX commands to get your whereabouts:
pwd (print working directory) to see your directory location.
ls (list) to view which files are in that directory.
cd (change directory) followed by the desired directory's path.
Once . . .
Rename your "Uncategorized" category
You can change the default category to any alternate name you choose.
If you find that WordPress' default category name is pointless, don't ignore it or hide it -- rename it!
FOLLOW THESE STEPS
1. Enter your admin dashboard
2. Navigate to POSTS » CATEGORIES
3. Find "Uncategorized" and click its EDIT link (notice that it cannot be deleted)
4. Edit its Name, . . .
Produce Screencasts on a Mac
Record screen capture videos using QuickTime's basic and advanced features
Help your readers who are visual learners by capturing the actions you describe in your tutorials in brief, clear videos of your screen and your voice.
Follow these tips to produce an efficient screencast
A. Think about the few things that your viewers want to watch instead of . . .
Techniques for reporters
Find the right people to interview
- authorities and experts
- man on the street
- do background research
Properly attribute subjects
- name, age, where you're from
- get the right spelling
- job titles, business names
- relationships and . . .