School of Code: Making A Website

School of Code
My super-smart engineer brother-in-law wants to make a website for his upcoming wedding. He spent the last few years of his career ensuring the core processors of your iPhone worked correctly, and he recently moved to a systems position. Changing from hard-core chip fab excellence to a jack-of-all-trades is no easy feat. He first needed to pick up SQL and databases, and he's picking up C# here and there. Now, it's time for a wedding website 'from scratch', so he can learn a little HTML and CSS. Don't do it. My advice to anyone looking to make their own website: don't do it. The skills and patience required to make a website are kind of like some of those mathematical skills you learned in high school.. If all you want…
Read More

School of Code Part 1: Squirrel (SQL)

School of Code
My brother-in-law recently moved into a position where he needs to pick up some systems programming basics. I could write him long emails about which references to check out, or I could just write the info here, so you too can benefit. For starters, my brother-in-law needs to learn the basics of SQL for reporting needs. SQL (or Squirrel, as my wife calls it), is a standarized database querying language. To understand SQL, you need to understand a database. A database is a system that organizes data, like a spreadsheet sort of, and provides powerful tools to add, change, and inspect that data. Almost every website you interact with is essentially a database, with software in front of that database to make pretty web pages to push and pull data…
Read More