Alex Popoutsis Profile picture
Experienced tech professional focused on data engineering, web development, and home automation. SQL | Python | JavaScript | C# | Dad Jokes
Oct 12, 2021 7 tweets 2 min read
SQL Resources for Beginners 🧵

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:

datacamp.com/courses/introd…
Oct 12, 2021 7 tweets 2 min read
SQL Server Tip Thread: Using INFORMATION_SCHEMA

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:

apop.tech/posts/searchin…

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.