For 17.1.20

Learning SQL

There are many ways to learn. For this next week, build some speed and depth: aim to learn a dozen SQL statements and what they do and why they are important and explore one or more of them in the ways discussed in my examples below.

SQL – Learning Differently

  • Write up a paragraph explaining what advice you found in someone else’s work AND, based on that, what you might do differently — how differently you might organize your work, use different resources, and otherwise learn from someone else (working in teams, stepping outside your comfort zone, exploring different ways so you might understand different people, etc.)

SQL – Learning from Daniel

  • How he learned from Nana. Study his interest in and analysis and reporting of what Nana had done and use this as a model for your study of another student’s work: note how he observed her questions and the way she built an outline around these questions: how her questioning led to exploration, and then apply this method to your examples
  • Daniel’s sentence construction. Study and model how he explained things as they might be turned to good business use, the highlighted parts at the end of each sentence: build some sentences like this
  • A sophisticated simple list of functions. Study how he created a notebook and create a notebook page like this, where a list is limited to essentials and with simple definitions of each element: note how he designed this to be read and understood later, a notebook for use
  • Explain things in your own words. Observe how he explained things in his own words, yours will be different: by putting things into your own words you make them your own, they will have the “ring of truth,” because you used your own expressions, worked on them, and so integrated them into your own thinking: do that
  • Walk your reader through the illustration. Observe how he must have listed every thing in the illustration so that, on reading what he said, you see each element in the illustration, as evidence, and so making clear in idea and reality, what is to be found there
  • Reflect on what you’ve done, then plan your next steps. You can complete this assignment with just a few examples, as long as they are good ones — examples of principles, the larger things, that go to the heart of understanding SQL; once you’ve done things your way, identify some other way that you might explore next

Approaching your topic as questions, not answers

In the examples from Denise and Rami, we explored how to put the illustrations or problem first, and as questions, then list a number of elements or factors as partial answers

  • In the case of Denise, we saw how she used citations as quotations “proving” what she might well have started with; we then turned her outline upside-down, putting the citations first, and then listing 2-3 things about each of them: really read the passages
  • In the case of Rami, we saw how he identified a business problem, one of engaging participants, and then offered one single answer; we turned his work upside-down, too, by reframing his business problem as a question with multiple answers and then explored a number of different ways of explaining the problem: don’t prove, do explore