Databases

Working with data isn't something people set out to do when they become programmers - they sort of fall into it. Lucky them! There aren't many skills more useful than learning SQL and how databases work.

Using Constraints to Protect Calendar Data in PostgreSQL

Using Constraints to Protect Calendar Data in PostgreSQL

Think about the lines of code you would have to write in order to manage a scheduling system. Duration checks, start and end time requirements as well as checking for overlap! You could spend a few days writing all that code or you could let PostgreSQL do it better with 5 lines of SQL.

Hello PostgreSQL

Hello PostgreSQL

In this production, a SQL Server DBA (Rob Sullivan) and a developer (Rob Conery) take a deep dive into PostGreSQL (v9.1) and are surprised by just how capable, intelligent and *fast* PostGreSQL is.

SQL and Data Science Fundamentals

Paid-members only

Databases Featured

SQL and Data Science Fundamentals

Many data science pros will tell you: learning SQL was one of the best investments in their career, even though the language is basic and obtuse. See why so many developers become data pros in this 2-hour video tutorial featuring data from the Cassini mission.

Database Normalization

Database Normalization

How does a spreadsheet become a highly-tuned set of tables in a relational system? There are rules for this - the rules of normalization - which is an essential skill for any developer working with data