TCC Home Page                               

TEXT ONLY

Welcome CenterAcademicsWorkforce DevelopmentNew StudentsCurrent StudentsFaculty and StaffDonorsCommunity
rollover the links above to activate the sub menus
Bb, Email, SIS
myTCC myTCC Library

Information Technology Design and Database (ITD)
Course Descriptions

 

ITD 110 Web Page Design I
4 credits

Stresses a working knowledge of web site designs, construction, and management using HTML or XHTML. Includes headings, lists, links, images, image maps, tables, forms, and frames. Lecture 4 hours per week.

ITD 112 Designing Web Page Graphics
4 credits

Explores the creation of digital graphics for web design. Explores basic design elements such as color and layout utilizing a computer graphics program(s). Lecture 4 hours per week.

ITD 132 Structured Query Language
4 credits

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

ITD 134 PL/SQL Programming
4 credits

Presents a working introduction to PL/SQL programming within the Oracle RDBMS environment. Includes PL/SQL fundamentals of block program structure, variables, cursors and exceptions, and creation of program units of procedures, functions, triggers and packages. Prerequisite: ITD 132 or SQL knowledge. Lecture 4 hours per week.

ITD 136 Database Management Software
4 credits

Covers an introduction to relational database theory and how to administer and query databases using multiple commercial database systems. Prerequisite: ITD 132 or SQL knowledge. Lecture 4 hours per week.

ITD 152 Oracle Forms Developer
4 credits

Provides a working introduction to building and testing interactive Oracle applications. Includes customizing forms with user input items such as check boxes, list items, and radio groups for use in a graphical user interface (GUI) environment. Includes modification of data access by creating event-related triggers. Prerequisite: ITD 134 or SQL and PL/SQL knowledge. Lecture 4 hours per week.

ITD 210 Web Page Design II
4 credits

Incorporates advanced techniques in web site planning, design, usability, accessibility, advanced site management, and maintenance utilizing web editor software(s). Prerequisite: ITD 110. Lecture 4 hours per week.

ITD 212 Interactive Web Design
4 credits

Provides techniques in interactive design concepts to create cross-platform, low-bandwidth animations utilizing a vector based application. Emphasizes the importance of usability, accessibility, optimization and performance. Note: Students should be proficient in graphic image creation and manipulation.  Prerequisite: ITD 112. Lecture 4 hours per week.

ITD 250 Database Architecture and Administration
4 credits

Involves in-depth instruction about the underlying architecture of databases and the handling of database administration. Prerequisites: ITD 132 and ITN 171. Lecture 4 hours per week.

ITD 251 Database System Development
3 credits

Provides the student the opportunity to solve a business problem from identification of the problem through the logical design and implementation on a database. Makes use of the knowledge that was gained in the prerequisite courses. Prerequisites: ITD 250 and ITD 260.  Lecture 3 hours per week.

ITD 252 Database Backup and Recovery
3 credits

Concentrates instruction in the key tasks required to plan and implement a database backup and recovery strategy. Includes instruction in multiple strategies to recover from multiple types of failure. Prerequisite: ITD 250. Lecture 3 hours per week.

ITD 258 Database Performance and Tuning
4 credits

Emphasizes instruction to optimize the performance of a database management system. Includes methods for tuning data access and storage and discussions of resolving data performance problems. Prerequisite: ITD 250. Lecture 4 hours per week.

ITD 260 Data Modeling and Design
4 credits

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 or co-requisite: ITD 132.  Lecture 4 hours per week.


2011-2012 Catalog

top