Students will gain knowledge on how to model, aggregate, and analyze data using SQL Analytic capabilities. Students will gain knowledge on how to use SQL Hierarchical features to style hierarchical data, omit branches from the tree structure, and grasp the concept of a hierarchical query. Additionally, the built-in features of SQL will be used to teach students how to search for, match, and replace strings using regular expressions and subexpressions.