Students taking this course should have the following prerequisite skills:
- Ability to write basic SQL SELECT statements, including a SELECT list, FROM clause, WHERE clause, GROUP BY clause, HAVING clause, and ORDER BY clause.
- Ability to perform basic SQL INSERT, UPDATE, and DELETE operations.
- Ability to utilize basic SQL scalar functions, such as the DECIMAL function, and SQL column functions, such as SUM.
- Ability to write basic non-correlated subqueries.
Students may obtain these skills by taking the dashDB SQL for Basic Queries and the dashDB for Functions, Grouping, Union, Subqueries, and Updates courses, or through equivalent experience.