Need to query a database to get data for your project? You’ll likely need to use “Structured Query Language”, or SQL. With all of the different SQL “dialects” out there, it can be difficult to know where to start, but we have some resources to help!
- For a brief introduction to what SQL is, what it’s used for, and the basic structure of a SQL query, check out What is SQL? and Demystifying SQL.
- Database normalization - This learning module discusses the concept of normalization and why it’s important for organizing complicated data in relational databases.
- SQL Basics - Learn how to do basic SQL queries on single tables, by using code, hands-on.
- SQL, Intermediate Level - Learn how to do intermediate SQL queries on single tables.
- SQL Joins - Learn about SQL joins, what they accomplish, and how to write them.
- Cartesian Result Sets- This is an article about a common issue that can happen when using SQL, and how to deal with it.
If you’re interested in practicing more with SQL, there are free database browsers that you can download. One of our favorites (and the one used in the webinars above) is DB Browser for SQLite, an open-source tool that lets you search, edit, and even create databases.
For a fun way to practice the SQL skills you’ve learned, consider checking out SQL Murder Mystery.
Need more personalized advice? Ask for an educational consult by emailing dlarcuseducation@email.chop.edu.
Good luck learning more about SQL!