ITDB Database (ITDB)

ITDB 1300 Introduction to Database Theory 2 Credits

Prerequisite: ITIS 1007 or permission of instructor.

This course provides a foundation in relational database theory. Students will learn various concepts as they apply to relational database management including the importance of database in application, data modeling, database normalization, and SQL for data processing. Students will also be introduced to concepts in data analytics and database administration.

(2.5 contact hours: 1.5 lecture, 1 lab)

ITDB 1400 Introduction to SQL 2 Credits

Prerequisite: ITIS 1005 or ITIS 1007 or permission of instructor.

This course provides an introduction to SQL (Structured Query Language) to create and maintain database objects, manipulate data, and to produce readable output displays and reports. Students will use the Oracle relational database management system along with DDL (Data Definition Language), DML (Data Manipulation Language), and SQL*Plus format commands. This course and ITDB 1405 Introduction to Oracle SQL/PL help students prepare for the Introduction to Oracle: SQL and PL/SQL certification exam. Although it is not a prerequisite for this course, students may benefit from taking a programming course prior to taking this course.

(3 contact hours: 1 lecture, 2 lab)

ITDB 1405 Oracle PL/SQL Programming 2 Credits

Prerequisite: ITCS 1010, ITDB 1400; or permission of instructor.

This course continues the study of the Oracle relational database management system by providing an introduction to the Oracle PL (Procedural Language). Students will write PL with embedded SQL (Structured Query Language) to interact with an Oracle Server, create control structures, write explicit cursors, and handle exceptions. Additional concepts include procedures, functions, packages, and triggers. This course helps students prepare for Oracle certification.

(3.25 contact hours: 0.75 lecture, 2.5 lab)

ITDB 1406 Microsoft SQL Concepts 2 Credits

Prerequisite: ITIS 1005 or ITIS 1007 or permission of instructor.

This course provides students with knowledge about SQL (Structured Query Language) along with an introduction to programming objects using Microsoft SQL. Students will use Microsoft SQL Server to write queries, create and modify data, and create database objects such as views, stored procedures and functions, and triggers. This course helps students prepare for Microsoft SQL Server certification. Although it is not a prerequisite for this course, students may benefit from taking ITDB 1400 Introduction to SQL prior to taking this course.

(3 contact hours: 1 lecture, 2 lab)

ITDB 1430 Microsoft Access Relational Database 3 Credits

Prerequisite: ITIS 1000 or ITIS 1005 or ITIS 1007 or permission of instructor This course provides a comprehensive study of database management in a Microsoft Windows environment.

Students will develop database structures, create and maintain tables, run and save queries, sort and filter records, and create and customize forms and reports. Advanced topics include creating and running macros, creating switchboards, and writing Visual Basic code. This course is cross-listed as ITIS 1530 Microsoft Office Access: Skills and Techniques and ITDB 1430 Microsoft Access Relational Database. Students who have taken this course under the alternative course ID should not take this course.

(4.5 contact hours: 1.5 lecture, 3 lab)

ITDB 2417 Oracle Database Administration 3 Credits

Prerequisite: ITDB 1405 or permission of instructor.

This course introduces students to various database administrative skills, including installing, starting up and shutting down, and maintaining an Oracle database, as well as advanced skills, including networking, backup and recovery, automating database management, managing resources, and transferring data. The course helps students prepare for the Oracle Database Administration certification exams.

(4 contact hours: 2 lecture, 2 lab)

ITDB 2427 Microsoft SQL Server Administration 3 Credits

Prerequisite: ITDB 1406 or permission of instructor.

This course instructs students in programming and implementing a Microsoft SQL Server database. Students will gain technical skills in creating and managing database objects, such as views and stored procedures. Students will gain additional knowledge in the maintenance of SQL elements, including indexes, data types, and constraints. This course also provides an understanding of database optimization and analysis. This course provides students with various database administrative skills, such as installing, maintaining, backing up, and recovering a Microsoft SQL Server database. Students will also learn how to perform other administrative tasks, including configuring and troubleshooting. This course helps students prepare for the Microsoft certification exams.

(4 contact hours: 2 lecture, 2 lab)

ITDB 2500 Data Analytics 3 Credits

Prerequisite: ITDB 1405, ITCS 1880; or permission of instructor.

This course provides students with a range of concepts, techniques and applications of data analytics in various settings. Students will gain experience in data storage, processing, analysis, visualization, and application issues as well as hands-on experience using various tools for data analysis.

(4.5 contact hours: 1.5 lecture, 3 lab)