The Stack Overflow podcast is back! Listen to an interview with our new CEO.

Hot answers tagged

6

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 (tl;dr) Apply it Install a database manager on your own computer. (Your personal home computer by choice, but a work computer is possible if the learning is ...


6

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 features. One gamer selects one of them and the other gamer has to make questions to try to eliminate the ones that are not relevant and try to guess which one ...


6

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 ambiguity. It. Was. Perfect - for me. A generous evaluation of it would suggest I reached maybe 15% of my students. The problem was (and often is) "Your students ...


2

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 as a data entry method, I understand that your goals don't extend to getting the students to implement server-side form handling. But in that case, why do you ...


2

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 analogy I used for her was "cubbies" like she stored her stuff in at kindergarten. Cubbies come in blocks, which are assembled into larger installations. A ...


1

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, usually lots of it. SQL is not the same kind of 'language' as most programming, but it is so well-suited and understandable that it is a great introduction. ...


1

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 start with only moderately difficult ones and work toward the more complex you will probably be able to figure it out with the practice. In general, the best way ...


1

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 from running / swimming / biking data; all you need is an account, which can be made at no cost! So in regards to the challenge at hand, you could use these ...


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