Introduction to SQL

8 hours of instruction (SQL)

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 program, students will be able to describe database structures, import and combine multiple data types, and manipulate data to discover new insights.

OBJECTIVES

1. Program proficiently in SQL
2. Manipulate data to prepare for analysis Join multiple tables and data types

PREREQUISITES

This program 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
   • Summarizing data types and constraints
2. Manipulating data with SQL
   • Filtering data based upon conditions
   • Joining data tables
   • Defining set operations
   • Applying various functions
3. Diving into multiple data types
   • Working with temporal data
   • Working with views, indexes, and SQL subqueries
   • Implementing stored procedures and SQL transactions

SOFTWARE REQUIREMENTS

SQL