Course Description
Introduces students to the language of databases, SQL. Covers the querying of data from databases and manipulating the results of those queries to perform quick and easy analytics. Students will learn how to query multiple tables in a single SQL query. A variety of operations that can be performed on the data retrieved from the tables are also covered. The course will conclude with an exercise to evaluate learning and synthesizing concepts covered in the course.
Athena Title
SQL for Bus Analytics
Non-Traditional Format
This course will be taught 95% or more online.
Grading System
S/U (Satisfactory/Unsatisfactory)
Course Objectives
Learning Outcomes: • Databases and the relational model • SQL • Single- and multi-entity queries • Data manipulation using SQL
Topical Outline
• Course introduction • Motivation behind analytics SQL language fundamentals • Single table • Multi-table JOINs • Ordering results • Selecting data • Aggregation operations • Subquery’ing Data manipulation with SQL • String/numerical functions • Date/time functions • Regular expressions Putting it together • Data analysis exercise • Course wrap-up and review session
Syllabus