26 Mar 15


21 January 15
  • To Complete SQLZoo SELECT basics problems.
    • Go to this website
    • Open a new word document
    • Fix and submit the queries to the SQLZoo website
    • It will tell you when you get it right
    • Copy and Paste answers to word.
    • Save the word document
    • Show me the work when you're done on your screen




Too late to turn in:
11 MAR 15
  • Look up MIN() MAX() SUM() COUNT() functions
  • Write defenitions in your own words for each
  • make a table of which ones you can use with which data types(strings/numbers/dates )
  • write a SELECT statement for each one using the cars or employees table

12 MAR 15
*Some of these are harder to understand but we are going to clear that up on Monday
  • Look up CONCAT(), INST(), LENGTH(), UPPER(), LOWER(), INITCAP(), REPLACE(), SUBSTR(), TRIM(), LPAD(), RPAD()
  • Write defenitions in your own words for each
  • make a table of which ones you can use with which data types(strings/numbers/dates )
  • write a SELECT statement for each one using the cars or employees table