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

Students must meet eligibility to enroll in ENGL&101 Composition I and MATH 098 Intermediate Algebra. These courses do not have to be taken to complete the certificate. Prior to enrolling in the Database Administration & Development program, you should complete the following courses with a minimum grade of a 2.0 GPA.

IT 100: Information Systems Concepts
5 credits
Intro to computers and information systems, including hardware, software, data organization, data communications, systems development and the evolving role of computers in society. Waiver for prior experience or test out is possible.

Database Core Courses

All courses must be passed with a 2.0 or better.

IT 111: Intro to Programming
5 credits
Intro to basic computing concepts and object oriented programming. Prerequisite: eligibility for MAT 088, or instructor permission.

IT 120: Database Development
5 credits
Overview of database theory and systems. Work with relational databases, simple ADO, SQL and XML.

IT 115 Intro to Software Development & Versioning
5 credits
Introduces hardware architecture and software systems that support web applications as well as development environments and systems used to build, test and deploy applications. Explores processes utilized by developers to manage, version, test and deploy their work across *nixes, BSD's, and windows systems. Prerequisite: IT w/2.0 or higher.

IT 161: Web Authoring 1
5 credits
This course covers the fundamental mechanics of web page production starting with the absolute basics of creating properly structured websites using the Hyper Text Markup Language (HTML) and Cascading Style Sheets (CSS). Students will learn how to write their own code to create web pages that include text, links, images, tables and forms as well as learn how to launch their own website on the internet using the File Transfer Protocol (FTP). Prerequisite: SAM Challenge.

Choose Database Development Area and 1 of these 5 additional Specialty Areas:

Database Development - 25 Credits

IT 112: Python for Web Development
5 credits

IT 221: SQL​​​​​​​
5 credits

IT 225: Systems Analysis​​​​​​​
5 credits

IT 222 Designing Database Solutions​​​​​​​
5 credits

IT 223 Database Administration​​​​​​​
5 credits

Mobile Development - 25 Credits

IT 116: Programming and Web Page Concepts​​​​​​​
5 credits

IT 212: Data Structures and Algorithms​​​​​​​
5 credits

IT 216: Android App Dev 1​​​​​​​
5 credits​​​​​​​

IT 225: Systems Analysis​​​​​​​
5 credits

Software Development - 15 Credits

IT 211: Object oriented Programmin​​​​​​​g
5 credits

IT 212: Data Structures and Algorithms​​​​​​​
5 credits

IT 225: Systems Analysis​​​​​​​
5 credits

Web Scripting - 15 Credits

IT 162: Web Authoring 2
5 credits

WEB 150: Intro to JavaScript
5 credits

IT 122: Advanced JavaScript
5 credits

Web Development - 25 Credits

IT 162: Web Authoring 2
5 credits

IT 112​​​​​​​: Python Web Programming
5 credits

IT 261​​​​​​​: Web Application Programming 1
5 credits

IT 262: Web Application Programming 2
5 credits

IT 263​​​​​​​: Web Application Programming 3
5 credits

Web Design - 25 Credits

IT 16​​​​​​​2: Web Authoring 2
5 credits

IT 163​​​​​​​: Web Authoring 3
5 credits

IT 171: Theory of Web Design
5 credits

IT 172​​​​​​​: User Centered Design
5 credits

IT 174​​​​​​​: Research Methods
5 credits

Database Administration & Development Certificate

  • Database Core: 20 Credits
  • 2 of the 6 Specialty Areas: 29-52 Credits
  • IT 289 Career Strategies: 2 Credits

Based on the chosen tracks, students may need either take an additional 5-15 credits of IT Electives or Internship or some combination of both to make the 60 credits required for this certificate.

Total Credits 62-73

Class Schedule