Database Administration & Development - Course Planning

As a Database Administration & Development student, you will share many core classes with students in other IT programs to give you a complete understanding of working on a web team and on IT projects. The database classes round out the program, giving students a strong, project-based and hands-on learning experience.

Prerequisites

Prior to enrolling in the Database Administration & Development program, you should complete the following courses with a minimum grade of a 2.0 GPA.

Skill Development Courses
Prefix Course Credits
MATH 119 Math Behind Information Technology 3
Learn basic aspects of discrete mathematics common to information technology: scientific notation; binary and hexadecimal number systems; logical operations and the design of logical networks; set theory; relations and functions; combinatorics; graphs and directed graphs; regular expressions; and finite–state machines.
ENGL 106 Technical Writing 3
Writing strategies geared to target audiences. Emphasis on research and problem–solving requiring critical reading and writing; development of ideas and argumentation. Includes layout and design, use of illustration, schematics and mathematics.
BTM 111 Business Applications Support I 5
Intro to Word Processing, Spreadsheets, and Personal Information Management and Presentation software. Creating letters, business correspondence, spreadsheets and presentations commonly used in business settings. Previously known as MIC 101.
ITC 102 Information Computer Concepts 3
Intro to computers and information systems, including hardware, software, data organization, data communications, systems development and the evolving role of computers in society.

Program Courses

First Quarter
Prefix Course Credits
ITC 110 Introduction to Programming 5
Intro to basic computing concepts such as Input–Processing–Output, control structures, arrays, structured programming and object oriented programming using C#.NET as an example language.
ITC 220 Database Fundamentals 5
Overview of database theory and systems. Work with relational databases, simple ADO, SQL and XML.
ITC 136 Unix 5
Intro to the Linux/Unix client operating system, including the fundamental Linux/Unix commands in both the command line interface and graphics user interface. Not a Server Administration class.
Second Quarter
Prefix Course Credits
ITC 172 Visual Basic w/ASP.NET 5
Intro to object–oriented, event–driven programming using Visual Basic (VB) in the Visual Studio.NET environment. Create Windows applications and write Windows interfaces to existing applications. Study of Visual Basic forms and tools and writing VB code modules, processing and functions. Intro to web applications.
ITC 222 SQL w/Server 5
Intro to the use of Structured Query language (SQL) to access and summarize database information, create and alter database objects, set constraints and create views. Intro to SQL embedded in programming environments such as ASP or CGI, or Net. Learn to use SQL to create and manage databases on a relational database management system.
WEB 110 Web Authoring 1 4
Covers the mechanics of web page production starting with absolute basics. Covers document structure, text elements, list elements, links, tables and working with images and creating framesets. Focuses on creating HTML/XHTML files by hand with emphasis on browser compatibility issues and HTML/XHTML validation.
Third Quarter
Prefix Course Credits
BUS 140 Customer Relations 5
Develops skills to identify and resolve customer complaints, handle difficult customers and utilize effective verbal and nonverbal communication methods. Learn appropriate professional use of various electronic media and contribute positively to the service culture of an organization. Examines future trends and changes in work environments.
ITC 240 Web Application Programming 1 5
Covers the fundamentals of programming using a server side scripting language such as PHP. Learn basic programming skills such as Variables, Control Structures, and Arrays, how to elegantly incorporate their scripts into their websites and gather data from HTML forms.
ITC 255 Systems Analysis 5
Identify when a system needs to be upgraded or replaced. Analyze system components and requirements, charting process flow and data structures, determining feasibilities and providing alternate solutions.
Fourth Quarter
Prefix Course Credits
ITC 224 Database Programming 5
Explore developing, testing and deploying database solutions.
ITC 226 Database Administration 5
Provides practice with administrative activities, security and backup on a Relational Database Management System, using Administrative SQL and other tools offered by the Relational Database Management System.
ITC 250 Web Application Programming 2 5
Covers more advanced server–side scripting. Learn how to collect data from forms and to store and retrieve data from a database. Emphasizes proper coding conventions, security, and code organization.

Total Certificate Credits = 60-71

Class Schedule