The objective of the Data Science and Analytics program is to academically prepare students to become Certified Database Administrators, Data Scientists, Database Developers, and Data Analysts. Students will learn how to manage and maintain database management system software for enterprise software systems, in addition to analyzing and designing applications that interface with Structure Query Language (SQL). This program covers the development of SQL databases, Data mining and analysis with Python/R, data visualization, as well as writing and testing code by way of Microsoft SQL Server and Oracle MySQL.


 

Occupations: Database Administrator, Database Developer, SQL Developer, Data Analyst, Business Intelligence Analyst, Business Analyst, Data Warehouse Analyst, Application Analyst, Software Analyst

Prerequisites: High School Diploma, or GED, or equivalent of a high school diploma from a home school.

Total Credit Hours: 46 (45 Weeks)

Course Listing:

    • Introduction to Computing

This course provides a substantive overview of computer systems including but not limited to computer hardware, operating systems, and software. Software topics include the Internet, word processors, spreadsheets, and access databases. Current issues such as the effect of computers on society, the history and use of computers in business, educational, and other modern settings are also studied.

    • Programming Fundamentals I

This course provides an introduction to the syntax, semantics, and structure of basic computer programming. Using the Python programming language, we will survey pragmatic applications for numerical computation, multivariate statistics, text processing, graphics, image processing, and networking, and their use in solving problems.

    • Data Mining and SQL Development

This course provides methodologies for extracting, transforming, loading, and querying large sums of data from relational databases. It serves as an introduction to many well-known database concepts, tasks, and techniques used for enterprise data mining. Using SQL Server Management Studio and Oracle MySQL, students will learn the SQL programming language, SQL development, creating and dropping tables, querying, scalability, and data analysis.

    • Data Management and Administration

This course is an overview of database administration and management practice including but not limited to performance, access, and security. This course will review the foundational concepts and cover the architecture, roles, and processes of being a database administrator. Topics will include the SQL programming language, managing schema projects, performing backups and recovery, administering alerts, and maintaining metrics.

    • Business Intelligence Analytics

This course evaluates the management and improvement of business processes and projects through the use of relational data. The course aims at creating business value by use of raw data. Using SQL Server Reporting Services, this course will cover the key concepts in effective report writing. Students will learn to create, deploy, and manage reports organizationally. Topics covered include interactive, tabular, graphical, and free-form data retrieval from relational databases. Reports can include rich data visualization, including charts, maps, and sparklines, all of which can be viewed over a web-based connection.

    • Data Visualization

Leveraging Tableau and Excel, you will be introduced to data visualization with Tableau’s various libraries and resources as a means of  demonstrating best practices for data visualization and generating key performance indicators. You will view examples from real world business cases and other related circumstances.

    • Microsoft Solutions/Oracle Certified Associate Certification

This course provides a review of the basic concepts learned throughout this program in lieu of obtaining the Microsoft Solutions Expert Certification and the Oracle Certified Associate/Expert Certification. The course culminates with students taking the exam, which either determines if they are certified or not. It is optional for students to take BOTH exams; however, they must choose one.

    • CAPSTONE/Internship

Survey course that allows students to choose an area of interest to apply the knowledge and skills gained throughout the program. Students may either take part in an internship or complete a project that must be approved by the instructor. The practicum cannot be completed until the student has passed 1 of the required certification exams for this program. ( Microsoft Solutions Expert Certification and the Oracle Certified Associate/Expert Certification)

    • Career Counseling

The objective of this course is to assist students in making career choices. This course focuses on self-assessment in terms of educational and career opportunities and reasonable possibilities in the world of work. It includes assessment for personal/career interests, values, needs, attitudes, skills, and other potential, and exploration of occupational information to establish career and educational goals. Upon completion of this course, students will be prepared to make sound career choices.