BUSN 172 : Introduction to SQL for Business Users

Credits

3

Class Hours

3 lecture

Prerequisites

Prereq: "C" or higher in ICS 101.

Semester Offered

Spring

Description

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.