Analyze data using Excel, an essential foundation for the interdisciplinary field of Data Analytics. Analyzing data through knowledge of mean, median, mode, average, sum, macros, and pivot tables, while solidifying predictions to influence business data is the building blocks to this course. Suggested prerequisites: Excel Intermediate or equivalent knowledge. Required material: Microsoft Excel 2013 or higher.
Data Analytics
Course Code: ITNW-2074
Program Area: Computer Science & Information Technology
This course introduces the student to the scope and application of data analysis. It covers data manipulation, data visualization, predictive analytics, and decision analytics tools. Learn how to review data and present it in an understandable format to facilitate making business decisions. Suggested prerequisites: Analytics with Excel or equivalent knowledge. Required textbook: Data Analytics Made Accessible: 2020 edition (Kindle Edition) by Maheshwari, Anil. ASIN: B00K2I2JL8.
Database Programming with SQL and Python
Course Code: ITSE-2009
Program Area: Computer Science & Information Technology
Database development using database programming techniques emphasizing database structures, modeling, and database access. Learn to use Python with SQL quickly and effectively. Analyze data and communicate results to support inform data-driven decisions. Introduction to the analysis and utilization of data requirements and organization into normalized tables, exploration of different data types, expressions, and data manipulation. Course includes hands-on assignments and a final project. Suggested Prerequisites: ITNW 2075 SQL Database Essentials or equivalent knowledge and experience.
SQL Database Essentials
Course Code: ITNW-2075
Program Area: Computer Science & Information Technology
Learn to use SQL quickly and effectively. You will learn to read and write complex queries to a database using some of the most in-demand skills PostgreSQL and PgAdmin. These skills are also applicable to any other major SQL database, such as MySQL, Microsoft SQL Server, Amazon Redshift, Oracle, and many more. Suggested prerequisites: middle school math. Required software: MySQL; link to free download will be provided by the instructor.