Introduction to database management systems, the basic structure of relational databases, and how to manage databases with Structured Query Language (SQL). Read and write simple and complex SQL statements that create tables and views, filter retrieved data, create calculated fields, merge columns, use aggregate functions, and combine fields from multiple tables using joins and subqueries. See how transaction processing, constraints, and indexes are implemented in SQL. Integrate SAS, R, Python, and SQL skills.
 Hours1.5 Credit, 1.5 Lecture, 1.5 Lab
 PrerequisitesSTAT 125
 RecommendedSTAT 126.
 TaughtFall Term 2, Winter Term 2, Spring
 ProgramsContaining STAT 226
Course Outcomes: 

Please contact the individual department for outcome information.