Join Mark Niemann-Ross for an in-depth discussion in this video Create a demographic split table, part of Database Clinic: SQLite.
- [Instructor] The first part of the overall solution…is to find out how educational demand fluctuates…based on known data.…The known educational data is found in…California Educational Attainment and Personal Income…and I've already imported this…into DB Browser for SQLite.…We'll use three fields from this dataset…to produce a coefficient for forecasting.…The relationship looks like this.…
Given an age, a gender, and a population.…Return the population split…across five educational attainments.…Here's an example.…If I know that the age range is 18 to 64 years…and a gender is female…and the population is 73 million…then I can generate the following table.…There are five rows,…one for each educational attainment,…children under 15,…no high school diploma,…high school or equivalent,…some college, and a bachelor's degree.…
The second column is the coefficient…and then the third column…is the coefficient times the population…so the result will be that coefficient times the population…which is the amount of people in a particular area.…
- Strengths and weaknesses of SQLite
- Creating a database
- Joining data sets
- Calculations with SQLite and Python
- Searching a database
- Subqueries and queries in SQLite
- CRUD operations in SQLite with R
Skill Level Intermediate
1. SQLite in Five Minutes
2. Create a Database
3. Join Two Datasets
4. Search a Database
5. Create, Read, Update, and Delete Operations
6. Averages and Calculations
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.