Intermediate SQL

4 hours of instruction

This course deepens learners understanding of using SQL to store and retrieve data. Building on their knowledge of basic calls, learners will perform more complex operations by expanding their knowledge of SQL syntax. By the end of this program, students will be able to handle querying multiple data tables at once, join multiple tables, and optimize SQL queries to discover new insights.

OBJECTIVES

1. Program proficiently in SQL
2. Join multiple tables and work with aggregate functions
3. Optimize SQL querying

PREREQUISITES

This course is best suited to students who are comfortable working with data in Excel and have basic knowledge of database frameworks.

SYLLABUS & TOPICS COVERED

1. Intermediate SQL
   • Joining tables
   • Grouping data and query using aggregate functions
   • Working with subqueries
2. Optimizing querying using SQL
   • Working with views
   • Querying data using case statements
   • Using temporary tables Implementing stored procedures

SOFTWARE REQUIREMENTS

Snowflake, You will have access to a Python-based JupyterHub environment for this course. No additional download or installation is required.