Information Technology Design and Database (ITD)

Stresses a working knowledge of Web site designs, construction, and management using HTML or XHTML. Course content includes headings, lists, links, images, image maps, tables, forms, and frames. Lecture 3 hours per week.

Incorporates a working introduction to commands, functions and operators used in SQL for extracting data from standard databases. Lecture 3 hours per week.

Presents a working introduction to PL/SQL programming within the Oracle RDBMS environment. Course content includes PL/SQL fundamentals of block program structure, variables, cursors and exceptions, and creation of program units of procedures, functions, triggers and packages. Lecture 3 hours per week.

Introduces students to artificial intelligence and machine learning. Examines basic theory, algorithms, and applications. Focuses on feature engineering and machine learning applications within the larger world of artificial intelligence. Part I of II. Lecture 3 hours per week.

Reviews the fundamentals of descriptive and inferential statistics, probability, and distributions, as well as basic dataset manipulation and plotting techniques. Focuses on application to real datasets using graphical user interface (GUI) software tools as well as Python. Lecture 3 hours per week.

Exploration of topical areas of interest to or needed by students. May be used also for special honors courses. May be repeated for credit. Variable hours.

Incorporates advanced techniques in Web site planning, design, usability, accessibility, advanced site management, and maintenance utilizing Web editor software(s). Lecture 3 hours per week.

Examines theory, algorithms, applications, and issues within the subfield of pattern recognition and machine learning, including feature engineering and extraction, supervised and unsupervised learning. Focuses on theory and practice, with coverage of underlying mathematical and heuristic concepts. Part II of II. Lecture 3 hours per week.

Surveys Big Data and data analytics, including demonstrations and applications of widely used tools and methods. Offers practice in data extraction and visualization. Lecture 3 hours per week.

Focuses in-depth instruction in the handling of critical tasks of planning and implementing large databases. Course content includes an introduction to concepts of advanced data warehousing and database configuration. Lecture 3 hours per week.

Introduces life cycle application development methodologies in a systematic approach to developing relational databases and designing applications. Presents content introducing functional and business process modeling, using modeling information to produce application designs, analyzing data requirements as entities, attributes, and relationships and map an entity relationship diagram to an initial database design. Identifies the available automated development tools and utilizes Oracle Developer software to perform practical applications of these concepts. Prerequisite: Oracle or SQL programming including DDL, DML, transaction control & queries with SELECT statement and some exposure to procedural language programming. Lecture 3 hours per week.

Exploration of topical areas of interest to or needed by students. May be used also for special honors courses. May be repeated for credit. Variable hours.