I've had people ask me about good places to start when learning SQL. I mainly learned in a classroom setting in college and then additional on-the-job and just-in-time training. So I did some searching to try and find some beginner resources.
DataCamp has a four-hour, free introduction to SQL basics:
Those are both fairly platform-agnostic, but if you are wanting to learn a specific flavor of SQL, there are some great free resources out there as well. For example, I mainly work with MS SQL Server these days. Here are some SQL Server free resources:
Do you have any SQL resources you're particularly fond of? Feel free to drop them below!
I'm also going to be creating a lot more SQL content coming up. If you have any SQL topics you'd like to learn more about, I would love to create some content around your suggestions!
• • •
Missing some Tweet in this thread? You can try to
force a refresh
INFORMATION_SCHEMA lets you query tables, columns, and other metadata about your database. Knowing how to use it, and how to further leverage it to create SQL statements dynamically, can make you a more efficient SQL developer.
If you want to view this thread as an expanded blog post, you can also go check it out at:
I go into detail there about how I combined INFORMATION_SCHEMA with SQL cursors, dynamic SQL, and a temporary table to find data across 20+ different tables.
As a basic example, if you need to search across a large number of tables for one or more values, and the tables have a common pattern in their name, you can query INFORMATION_SCHEMA to find all of the tables you need to search.