SQL

Catalog description

This course focuses on learning how to write Structured Query Language (SQL) to interact with databases for various data retrieval and reporting needs. Students will create tables, constraints, indexes, and views; insert, update, delete, and query data. SQL activities examine how to write cross joins inner joins, outer joins, common table expressions (CTEs), subqueries, and composite queries that use set operators. SQL statements explore built-in database functions, data fabrication, hierarchical queries, pivot operations, and conditional logic.