SQL Bootcamp

Learn SQL fundamentals including data types and queries.

Why SQL?

Upwards of 90% of time on data wrangling is spent cleaning and manipulating data. With SQL you can easily address these challenges with English-like queries to a database. The gap between the supply and demand of people skilled in SQL is huge. As nearly every industry is moving toward being more data-driven, having this skill will give you a larger role in decision-making wherever you work.

You’ll be introduced to foundational concepts like tables, data types, and queries. Once you understand the basics of viewing tables, you’ll be introduced to more advanced querying techniques like filtering and aggregating. You will be able to drill down into specific cases or step back and see larger patterns. You’ll also learn how to combine information from different tables using join statements and views. The final day of the course will cover advanced techniques like creating subqueries and using timestamp functions.

This course will use Postgres, an advanced open-source database. Concepts from this course will apply equally to other databases such as MySQL and SQL Server, with the minor syntax differences noted during class.

What You’ll Learn:

• Explore and alter data using a graphical user interface
• Write queries to search through tables programmatically
• Understand different data types and converting between them
• Combine information across tables with join statements
• Advanced techniques like subqueries and timestamp functions

Learn more about SQL Bootcamp at Practical Programming.