Learn SQL commands, such as how and where to type an SQL query; and how to create, populate, alter, and delete tables; customize SQL server's settings; and learn about SQL server's functions; create joins, a common database mechanism for combining tables; perform query development, the use of views, and other derived structures and simple set operations; and write subqueries, aggregate functions, and correlated subqueries, as well as indexes and constraints that can be added to tables in SQL server.
 
Prerequisite:
CIT 150.