15 books for kids who (you want to) love Linux and open source (opensource.com)

The original article is available at https://opensource.com/article/18/5/books-kids-linux-open-source, but the list without commercial links is below.

  1. Adventures in Raspberry Pi by Carrie Anne Philbin
  2. Automate the Boring Stuff with Python by Al Sweigart
  3. Coding Games in Scratch by Jon Woodcock
  4. Doing Math with Python by Amit Saha
  5. Girls Who Code: Learn to Code and Change the World by Reshma Saujani
  6. Invent Your Own Computer Games with Python by Al Sweigart
  7. Lauren Ipsum: A Story About Computer Science and Other Improbable Things by Carlos Bueno
  8. Learn Java the Easy Way: A Hands-On Introduction to Programming by Bryson Payne
  9. Lifelong Kindergarten by Mitchell Resnick
  10. Python for Kids by Jason Briggs
  11. Scratch Programming Playground by Al Sweigart
  12. Secret Coders by Mike Holmes
  13. So, You Want to Be a Coder?: The Ultimate Guide to a Career in Programming, Video Game Creation, Robotics, and More! by Jane Bedell
  14. Teach Your Kids to Code by Bryson Payne
  15. The Children’s Illustrated Guide to Kubernetes by Matt Butcher, illustrated by Bailey Beougher
  16. BONUS FOR BABIES: CSS for Babies, Javascript for Babies & HTML for Babies by Sterling Children’s

Always support open source.

Database Administration Fundamentals (WS18SQL1002) – Day 2

It is only day 2, but we have already covered how to retrieve fields from multiple tables

SELECT field1, field2 ...
FROM table1
INNER|LEFT|RIGHT JOIN table2
  ON table1.shared_field1 = table2.shared_field1
  AND table1.shared_field2 = table2.shared_field2
  ...
INNER|LEFT|RIGHT JOIN table3
  ON table1.shared_field1 = table3.shared_field1
  AND table1.shared_field2 = table3.shared_field2
  ...

and built-in functions both for strings and numeric values (aggregate).

Download the class notes for day 2.

Database Administration Fundamentals (WS18SQL1001) – Day 5

We are half-way done with the course. We have covered how to retrieve data from table(s) and how to present that data in comprehensible manner.

SELECT [DISTINCT] table1.field1,
  table1.field2,
  ...
  table2.field1,
  table2.field2,
  ..
FROM table1
INNER|LEFT JOIN table2
  ON table1.sharedfile1 = table2.sharedfile1
    AND|OR table1.sharedfile2 = table2.sharedfile3
    ...
INNER|LEFT JOIN table3
  ON table1.sharedfile1 = table3.sharedfile1
    AND|OR table1.sharedfile2 = table3.sharedfile3
    ...
WHERE condition1
  AND|OR condition2
  ...
GROUP BY fields_not_in_aggregate_function
ORDER BY field1,
  field2
  ...;

Download the notes for day 5.