This lesson provides instruction to help you demonstrate:

Competency$4037\mathrm{.}04\mathrm{.}1$:$$Writing$$Complex SQL Statements

The graduate writes complex SQL statements$$in order to$$implement functions, stored procedures, and triggers to prepare data sets for data analysis and manipulation.

Learning Objectives

Consider these learning objectives as you move through the lesson:

Define dirty data.

Recognize examples of dirty data.

Determine whether dirty data exist in a data set.

Determine appropriate procedures for cleaning dirty data.