ACCT 3030 - SQL & Python for Accounting

Institution:

Utah Tech University

Subject:

Description:

This course will introduce essential concepts in SQL and Python as it relates to data analytics. Students will be required to gain competency in cleaning , organizing, and analyzing data in ways that are common to accounting. **COURSE LEARNING OUTCOMES (CLOs) At the successful conclusion of this course, students will be able to: 1. Demonstrate proficiency in building tables, inserting and deleting data, and updating existing data. 2. Demonstrate proficiency in querying the database including joining tables, including specific rows, and including specific columns. 3. Demonstrate proficiency utilizing subqueries, aggregates , group by , and having statements. 4. Demonstrate proficiency building stored procedures to extract understanding from the data. 5. Apply Python to read in data sets and include data oriented libraries. 6. Utilize Python to perform basic data analysis including descriptive statistics as well as aggregate statistics. 7. Utilize Python to Identify independent and dependent variables to perform extensive regression analysis. 8. Demonstrate a working proficiency in using regression analysis to gain insight into business problems. Prerequisites: ISA 2010. FA, SP

Credits:

3.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

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.