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
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.
Querying Microsoft SQL Server
Course Code: ITMT-1073
Program Area: Computer Science & Information Technology
This course provides students with the technical skills required to write basic Transact-SQL queries for Microsoft SQL Server. This course is the foundation for all SQL Server-related disciplines; namely, Database Administration, Database Development, and Business Intelligence. This course helps people prepare for exam 70-761. Prerequisite: General computer knowledge.
Software Developer Bootcamp
Course Code: ITSX-3036
Program Area: Computer Science & Information Technology
This intensive program will prepare you for a job as a Web Developer. It will teach you how to design, develop, test and deploy front-end, back-end, database and services in the cloud using highly sought after technologies today. You will immerse in HTML, CSS, JavaScript, JQuery, ReactJS, Linux, Git, AWS etc. You will learn how to design and build backend systems including SQL database schemas, RESTful APIs and services. You will learn how to work in a multi-developer team, using tools like Git, Github and Atlassian Jira. Suggested prerequisite is basic computer knowledge. Prior programming language is not required, but would help you navigate the bootcamp materials and projects.
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.
