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!
- What is SQL?- A brief introduction to what SQL is, what it’s used for, and the basic structure of a SQL query.
- Webinar: SQL 101- This webinar will go into how to start crafting SQL queries.
- Webinar: SQL 102- The continuation of SQL 101, this webinar focuses on more advanced SQL techniques.
- 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.
Need more personalized advice? Ask for an educational consult by emailing dlarcuseducation@email.chop.edu.
Good luck learning more about SQL!