Introduction to SQL

4 hours of instruction

This course builds on foundational data skills to teach students how to effectively manipulate data in SQL. SQL is one of the most popular database management languages available and is critical in storing and retrieving data. By the end of this course, students will be able to describe database structures, import data into a database, and combine and manipulate data within a single table.

OBJECTIVES

1. Program proficiently in SQL
2. Discuss principles of databases, constraints and keys
3. Manipulate data to prepare for analysis

PREREQUISITES

This course is best suited to students who are comfortable working with data in Excel.

SYLLABUS & TOPICS COVERED

1. Introduction To SQL
   • Identifying use cases for SQL
   • Defining databases and entity relationship diagrams
   • Discussing ways to create databases
2. Manipulating data with SQL
   • Querying and displaying data using DDL commands
   • Summarizing data types and constraints
   • Filtering data based upon conditions
   • Using numeric functions and working with temporal data

SOFTWARE REQUIREMENTS

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