Skip to main content
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 ...
Nuno Gil Fonseca's user avatar
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 (...
Gypsy Spellweaver's user avatar
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 ...
Buffy's user avatar
  • 36.4k
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 ...
pojo-guy's user avatar
  • 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 ...
Peter Taylor's user avatar
  • 1,683
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 ...
Steve's user avatar
  • 501
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 ...
Buffy's user avatar
  • 36.4k
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,...
Scott Rowe's user avatar
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 ...
Buffy's user avatar
  • 36.4k
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 ...
natn2323's user avatar
  • 111

Only top scored, non community-wiki answers of a minimum length are eligible