| Title | Winter | Spring | Summer | Fall |
Introduction to Programming using Java (1.00 Unit)
I&C SCI X460.20
This course enables a person with no programming experience to understand programming concepts using Java programming language. It will teach you how to think like a programmer, introduce you to the algorithm design, user interaction, code reusability, and basics of Java programming language. You will learn all this through hands-on examples, fun exercises, quizzes, and creative projects. By the end of this course you will have a solid understanding of the foundations of programming, allowing you to move to more advanced programming courses in the future. Prerequisites: This course assumes no prior experience with programming. Upon completion of this course, students will be able to start I&C SCI X460.10 Java Programming 1 beginning July 10.
|
|
|
|
|
Introduction to Python Programming (2.00 Units)
I&C SCI X426.64
Introduction to Python is a beginner introduction to the Python programming language. After this course, students may want to take a more intermediate or advanced Python course. The following topics will be covered: How to use: variable types, flow control, and functions How to interact with the system via Python How to write simple scripts to process text How to use Jupyter, a popular development tool for Python.
|
Online
|
Online
|
to be scheduled
|
to be scheduled
|
Intermediate Python (2.00 Units)
I&C SCI X426.59
This course will introduce students to basic computer science knowledge to get more efficient with python programming. Topics will include recursion, linear data structures (arrays, stacks, queues, linked lists, doubly linked lists), trees and graphs, maps and hash tables. Students will also learn the basics of object-oriented programming using Python classes. The course will focus on data-science applications for these concepts. By the end of the course, students will be able to think computationally when solving data-related problems and assess and develop algorithms. Students will also be able to be self-sufficient taking on more advanced concepts and advanced courses. Prerequisites: I&C SCI X426.64 Introduction to Python Programming.
|
Online
|
|
to be scheduled
|
|
Data Structures and Algorithms (2.50 Units)
I&C SCI X460.37
Gain a solid background in data structures and their associated algorithms. This course approaches data structures from an advanced viewpoint with a focus on basic principles of modern software engineering. It provides a good foundation for further study in object-oriented programming. Course topics are presented in a language-neutral fashion which may be adapted to any number of modern programming languages. Assignments will require use of pseudo-code to stress the design and architecture. You'll learn how to analyze large-scale problems and create solutions by identifying the data structures and relevant algorithms, evaluate efficiency tradeoffs in competing designs, and modularize programs by encapsulating data structures with their accompanying algorithms. Prerequisites: Knowledge of computers and some programming experience is helpful but not required.
|
|
to be scheduled
|
|
|
R Basics (2.50 Units)
I&C SCI X427.19
This course will focus on foundational concepts of getting started with R programming which is used for math and statistics and data analysis. The programmatic interface and graphic capabilities of R will also be explored. Several case studies will be covered and examined using R. Prerequisites: I&C SCI X425.99 Practical Math & Stats for Data Science and basic experience with programming.
|
Online
|
|
|
|
Intro to Web Programming w/ HTML5 & CSS3 (2.50 Units)
I&C SCI X470.90
This course provides intermediate level knowledge and skills for web development, along with an introduction to basic programming concepts and the three web development languages: HTML, CSS, and JavaScript. Furthermore, students of this course will learn how to apply these languages to create web-based applications. An introduction to more advanced topics such as prototypal inheritance, software frameworks, and software development tooling will be covered.
|
|
Online
|
|
to be scheduled
|
Web Programming II: JavaScript & React (2.50 Units)
I&C SCI X470.91
Web Programming II: JavaScript & React covers the basics of JavaScript and React. You will learn to incorporate logic, functions, and classes into your programming. You will also learn to build an interactive website and deploy web applications. Throughout the course, you will learn skills that will apply to an ongoing project that will highlight your new knowledge of server-side web applications. Prerequisite: I&C SCI X470.90 Intro to Web Programming w/ HTML5 and CSS, OR, I&C SCI X471.03 Introduction to Web Programming w/ HTML5, CSS3, and Javascript
|
Online
|
|
to be scheduled
|
|
Introduction to SQL Programming (2.50 Units)
I&C SCI X450.72
Install SQL Server to your desktop and run complex queries using the Structured Query Language (SQL). This course will cover database table structures, column data types, and the T-SQL language components that go into querying against a database. Reading data from a table, row filtering, and column based functions will be discussed. We will also write queries that combine data from multiple tables, use conditional logic, and create aggregated result sets (sum, average, min, max). Database administration features of SQL will also be discussed. Prerequisites: Familiarity with data processing concepts and techniques.
|
Online
|
Online
|
|
|
Intermediate SQL Programming (2.50 Units)
I&C SCI X450.79
Expand your SQL toolkit in this Intermediate SQL course. SQL is a language used in programming and designed for managing data held in a relational database management system (RDBMS). This intermediate course will focus on using MS SQL Server and T-SQL. Topics covered in this course include: Data aggregation using aggregate functions, writing sub-queries, recursive queries, and common table expressions. Students will also gain experience creating views, stored procedures, functions, and triggers using different looping and database locking mechanisms. Specific areas in the SQL Server database using data file structures, database schemas, setting properties, snapshots, data space and type usage and identity columns will be covered. SQL tuning and use of execution plans will also be addressed. Prerequisites: I&C SCI X450.72 Introduction to SQL Programming.
|
|
|
to be scheduled
|
to be scheduled
|