BUSN 172 : Introduction to SQL for Business Users
Class Hours3 lecture
Prereq: "C" or higher in ICS 101.
This course is the study of concepts of Structured Query Language (SQL) and universal database programming language. Students will learn how to read and write SQL statements, use SQL to sort and filter retrieved data, reformat retrieved data with calculated fields, and merge columns and create alternate names for columns. Students will also learn how to gather significant statistics from data using aggregate functions and to extract data from multiple tables simultaneously using joins and subqueries. In addition, students will learn how to manipulate data using the INSERT, UPDATE, and DELETE statements. Finally, students will learn how to report and automate query results using ODBC connections to Microsoft Office applications.