...

How to Install SQLite on Windows: A Visual Walkthrough

Quite a few students in my SQL course have asked me about how to install SQLite on Windows. On the surface, it seems pretty simple: download some...

...

SQL for Marketers: Dominate Data Analytics, Data Science, and Big Data

This is an annoucement along with free and discount coupons for my new course, SQL for Marketers: Dominate data analytics, data science, and big...

...

Why databases?

This article has been a long time coming. I wrote a shitty version years ago, but wanted to update it with new and current info, in a more organized...

...

MyISAM vs. InnoDB, and how to switch engines on existing tables

Summary: MyISAM is better for selects InnoDB is better for inserts and updates To switch your table to MyISAM: ALTER TABLE table_name...

...

Installing the Python-MySQL (MySQLdb) connector using the Yum package manager and easy_install

You’ll notice if you try to just do this: sudo easy_install MySQL-python You’ll get some errors. That’s because you’re probably missing...

...

Backing up and restoring databases and tables in MySQL

My extreme laziness combined with my terrible memory means that I have to look up the backup/restore commands for MySQL almost every time I do it....