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.
Data+
Course Code: ITNW-2077
Program Area: Computer Science & Information Technology
CompTIA Data+ is an early-career data analytics certification for professionals tasked with developing and promoting data-driven business decision-making.
Learn to analyze and interpret data, mine data more effectively, communicate insights, and create the appropriate visualization in the form of a report or dashboard with the proper design components. Suggested Prerequisites: ITNW-2073 Analytics with Excel, ITNW-2074 Data Analytics, ITNW-2075 SQL Database Essentials, ITSE-2009 Database Programming with SQL and Python, or equivalent experience. CompTIA recommends 18�"24 months of experience in a report/business analyst job role, exposure to databases and analytical tools, a basic understanding of statistics, and data visualization experience
Required Material: CompTIA Data+ Study Guide: Exam DA0-001 (Sybex Study Guide) 1st Edition, Mike Chapple and Sharif Nijim, ISBN 978-1119845256
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.