Database Design & Administration

Certificate

The Database Administration and Development certificate option in Information Technology is a four-quarter certificate program. Completion of prerequisite courses generally requires an additional quarter. The curriculum, designed with input from Puget Sound industry representatives, includes the skills needed for successful employment. Students in this program share many core classes with students in the Programming, Applications Support and Web Development IT programs. Three new third and fourth quarter database classes round out the program, giving students a strong, project-based and hands-on learning experience. In order to focus on and to build generalized skills, the program is vendor-neutral.

Career Opportunities

Despite the recent economic downturn, the information technology field is still growing faster than any other section of the economy. A recent Department of Labor study indicates that eight of the nine fastest growing occupations between the years 2000-2010 will be in the area of information technology. More than 1,300,000 new IT jobs will be created in the United States by the year 2008. A Washington State Employment Security Department paper confirms these job growth statistics for our state as well, with some computer jobs posting growth rates of 6 % per year and higher. There is a critical shortage of qualified IT professionals, and excellent opportunities exist with both large and small companies and in the public sector.

Databases form the core of Business Information Systems and are crucial to most companies' operations. In a small setting, one person might play several of the following roles. While in a larger company, several people might be assigned to each job: database administrator, database programmer, database designer, security administrator and systems administrator.

Entrance Requirements

  • COMPASS test. (Eligibility for ENG 101 and MAT 098)
  • Prerequisites: Completion of the following core courses with a 2.0 GPA or better: MAT 119, Math behind IT; ENG 106, Technical Writing (both with a 2.0 GPA or better); ability to use Microsoft Office (or MIC 101, Introduction to Computer Applications); previous computer work experience (or ITC 102, Introduction to Computer Information Systems).
  • Equivalent course work or experience will be evaluated for possible substitution.
  • The program begins fall quarter of each year.

The program begins fall quarter of each year. Acceptance into the program for other quarters will be determined on a case-by-case basis. Admission to the program is on a first-come, first-served basis after applicants provide proof that the entrance requirements have been met.

How to Get Started

Students may choose to graduate either under the program of study requirements stated in the college catalog at the time they first enter this program, or under the requirements listed in the catalog in effect at the time they apply for graduation-unless more than five years have elapsed since the student entered the program, and providing that the courses required for completion are still offered.

Graduation Application

Database Administration & Development Certificate

Estimated Training Costs

Curriculum

PrerequisitesCr
Eligibility for MAT 098 and ENG 101
ENGL 106 TECHNICAL WRITING 3
ITC 102 OR INFORMATION COMPUTER CONCEPTS 3
Provides a broad introduction to computers and information systems. Includes hardware, software, data organization, data communications and systems development. Covers the evolving role of computers in society.
Previous computer work experience
MATH 119 Q - MATHEMATICS 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.
MIC 101 OR INTRODUCTION TO MICROCOMPUTER APPLICATIONS 4
Intro to microcomputer applications for Windows. Includes an overview of Windows, the Microsoft Office System featuring Word, Excel, Access, PowerPoint, Internet Browsers, email, along with emerging software application topics and concepts.
Ability to use Microsoft Office
1'st QuarterCr
ITC 110 PROGRAMMING CONCEPTS AND FUNDAMENTALS 5
Intro to basic computing concepts such as Input-Processing-Output, control structures, arrays, structured programming, and object oriented programming using Visual BASIC as an example language.
ITC 136 UNIX OPERATING SYSTEM 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.
ITC 220 DATABASE DEVELOPMENT FOR PROGRAMMERS 5
Provides programmers with an overview of database theory and systems. Provides experience with relational databases, simple ADO, SQL, and XML.
2'nd QuarterCr
ITC 172 VISUAL BASIC WITH ASP NET 5
Intro to object-oriented, event-driven programming using Visual Basic (VB) in the Windows 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.
ITC 222 SQL 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. Introduces 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 I 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 files ?by hand? with emphasis placed on browser compatibility issues and HTML/XHTML validation.
3'rd QuarterCr
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 255 SYSTEMS ANALYSIS 5
Explores the process of identifying when a system needs to be upgraded or replaced. Uses a set of tools and techniques for analyzing system components and requirements, charting process flow and data structures, determining feasibilities and providing alternate solutions.
ITC 280 WEB DATABASES 5
Intro to the skills, tools, and techniques needed to create database driven websites and practical experience. The languages and methods used for database access will remain flexible to account for the most current industry standards.
4'th QuarterCr
ITC 224 DESIGNING DATABASE SOLUTIONS 5
Explore developing, testing and deploying database solutions. Focus on SQL Server 2005 and may change as technologies change. Scenario and case driven.
ITC 281 ADVANCED WEB DATABASES 5
Intro to advanced web development and database topics such as XML, RSS and AJAX..
Total Credits = 67

Total Certificate Credits (before prereqs) 69 -- (after prereqs) 82

NOTE: This curriculum is being developed and revised. Please check with Information Technology Programs, 206 516-3150, for current information.

Students must maintain a grade of 2.0 or better in every class to remain in this program.

Students who intend to complete the Networking AAS-T degree should meet with the Information Technology counselor to plan their courses beyond those listed above. AAS-T degree students must complete the following additional requirements:

ENG 101, Composition
MAT 107, Mathematics a Practical Art
HUM 105, Intercultural Communications
ITC 285, Capstone Project

Total AAS-T degree credits (after prereqs): 98

For Further Information:

Information Technology Programs
Business, Information Technologies& Creative Arts
Seattle Central Community College
1701 Broadway, Room BE1142
Seattle, WA 98122
PHONE: (206) 516-3150
FAX: (206) 587-4088

Program Contact:
Lisa Sandoval lsandoval@sccd.ctc.edu 206.287.5558