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.
March 20, 2016
bit.ly/cunySQLp2
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 . . .
Rename your "Uncategorized" category
You can change the default category to any alternate name you choose.
November 02, 2015
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, . . .