7
votes
What is a good analogy to introduce databases and SQL?
I think that to understand the SELECT queries, the Who is Who? / Guess Who? game could serve as a nice metaphor.
The idea of the game is: you have a group of pictures of persons with different facial ...
- 2,201
6
votes
In self-teaching, how can I move from basic tutorials to more complex work?
The short of it
There are three techniques that should serve you well in this, and future, endeavors to learn practical application of complex subjects:
Apply it,
Dissect it,
RTFM
The long of it (...
- 5,435
5
votes
Accepted
What is a good analogy to introduce databases and SQL?
Beware. "The One True Lecture" is an oxymoron. I have a horror story about trying to create such a lecture to teach elementary statistics. It was perfect in every way and explains sampling without ...
- 36k
3
votes
What is a good analogy to introduce databases and SQL?
As requested by @heather, comment converted to answer:
When my daughter was 6 I introduced her to Ruby and Postgresql because she wanted to know what i did at work. She soon lost interest, but the ...
- 998
2
votes
Easy to use database for HS students
Is there any easy to use database platform that would allow 9th graders to enter data easily (like Google Sheets), and pull data using client-side JS?
Given that you're thinking about Google Sheets ...
- 1,673
2
votes
Will learning relational algebra and calculus help me to learn SQL subqueries?
Learning the algebraic nature of SQL will certainly help you master it.
A number of warnings though.
First, "relational algebra" when referred to in the academic sense - typically meaning ...
- 356
1
vote
Will learning relational algebra and calculus help me to learn SQL subqueries?
You can find the official tutorial on SQL subqueries at: https://beginner-sql-tutorial.com/sql-subquery.htm. The explanation there seems clear enough.
However, I found that understanding both ...
- 36k
1
vote
In self-teaching, how can I move from basic tutorials to more complex work?
If you are starting to learn about computing with databases and SQL, congratulations! you have chosen the very best place to start, because the whole point of computers is to store and manipulate data,...
- 937
1
vote
In self-teaching, how can I move from basic tutorials to more complex work?
Since you have access to people who can help and who are more advanced than yourself, I'd suggest that you ask them, as often as you can, to give you a search task that you can carry out. If they ...
- 36k
1
vote
Easy to use database for HS students
There are some websites that have free APIs. One is JSONPlaceholder, but you can easily request access to some others. For instance, Strava offers some for those interested in developing applications ...
- 111
Only top scored, non community-wiki answers of a minimum length are eligible