ISA 3020 - Structured Query Language for Business Users

Institution:

Utah Tech University

Subject:

Description:

This course seeks to introduce students to the basic Stuctured Query Language (SQL) commands that can be used in most relational Database Management Systems (DBMS) such as Oracle, SQL Server, mySQL, Microsoft Access, SAP, DB2, and PostgreSQL. This course will not only provide a theoretical foundation, but also hands-on practice executing and experimenting with those commands in multiple DBMS with a focus on business user's needs to solve business problems or aid decision making. **COURSE LEARNING OUTCOMES (CLOs) At the successful conclusion of this course, students will be able to: 1. Demonstrate proficiency in the fundamentals of the basic structure of relational databases and the relevance of SQL in any relational DBMS. 2. Show an understanding of the basic SQL syntax useful to typical business users. 3. Create SQL code in at least two different DBMS and illustrate similarities and differences in the code between these DBMS. 4. Use SQL to analyze a complex business situation, and identify how the SQL results can lead to better decision making, and suggest viable courses of action. 5. Identify and defend personal, ethical, and organizational issues related to the use and misuse of SQL. FA, SP

Credits:

1.00

Credit Hours:

Prerequisites:

Corequisites:

Exclusions:

Level:

Instructional Type:

Lecture

Notes:

Additional Information:

Historical Version(s):

Institution Website:

www.utahtech.edu/

Phone Number:

(435) 652-7500

Regional Accreditation:

Northwest Commission on Colleges and Universities

Calendar System:

Semester

General Education

• No items found

The Course Profile information is provided and updated by third parties including the respective institutions. While the institutions are able to update their information at any time, the information is not independently validated, and no party associated with this website can accept responsibility for its accuracy.