With SQL you can answer questions using a database, the ultimate system of record for most organizations. 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.

This course will teach you how to explore, modify, and export data from a database.

  • 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 stored procedures.

Class Notes & Related Courses

  • This course will use MySQL, an advanced open-source database.

  • Concepts from this course will apply equally to other databases such as Postgres and SQL Server, with the minor syntax differences noted during class.

  • A PC with MySQL will be provided for use during the class.

  • Register for Postgres SQL Bootcamp at our coding school, Noble Desktop. For courses in SQL Server, see all our SQL classes and our SQL Server Bootcamp.

What You'll Learn

  • Explore and alter data using a graphical user interface
  • Write queries to search through tables programmatically
  • Understanding various data types and convert data between them
  • Combine information across tables with join statements
  • Advanced techniques like subqueries and stored procedures