| Course ID: | BUSN 3020E. 1.5 hours. |
| Course Title: | Structured Query Language (SQL) Skills for Business Analytics |
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. |
| Oasis Title: | SQL for Bus Analytics |
| Nontraditional 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 |