Database Administrator

Program Overview

The Database Administrator Program provides educational opportunities to students that will enable them to obtain the knowledge, skills, and attitudes necessary to succeed in the field of database management and administration.

Entrance Requirements

* Must be 16 years of age * Completion of high school diploma or GED and submission of official transcript required to apply * Achievement of minimum program admission scores in Reading, English, and Math * Transfer of previous post-secondary credits will be determined by the registrar. Student Performance/Graduation Requirements: Students must maintain a 2.0 grade point average and complete all required courses to graduate.

 

Course Overview

Contact Hours
Credit Hours
Curriculum (38 hours)
Technical Courses (38 hours)
CIST
1001
4
90
Provides an overview of information systems, computers and technology. Topics include: Information Systems and Technology Terminology, Computer History, Data Representation, Data Storage Concepts, Fundamentals of Information Processing, Fundamentals of Information Security, Information Technology Ethics, Fundamentals of Hardware Operation, Fundamentals of Networking, Fundamentals of the Internet, Fundamentals of Software Design Concepts, Fundamentals of Software, (System and Application), System Development Methodology, Computer Number Systems conversion (Binary and Hexadecimal), Mobile computing.
4
90
Provides an overview of the skills and knowledge of database application systems which are used in business government and industry. Topics include: history, database terminology and concepts, database system logical organization, data manipulation, database design concepts, models, normalization, Entity Relationship diagramming, physical database, networking and databases, and database security.
This course provides an introduction to the Oracle database management system platform and to Structured Query Language (SQL). Topics include database vocabulary, normalization, Oracle DML and DDL statements, SQL Statements, views and constraints.
Includes basic database design concepts and solving database retrieval and modification problems using the SQL language. Topics include: database Vocabulary, Relational Database Design, Date retrieval using SQL, Data Modification using SQL, Developing and Using SQL Procedures.
An introductory course that provides problem solving and programming concepts for those that develop user applications. An emphasis is placed on developing logic, troubleshooting, and using tools to develop solutions. Topics include: problem solving and programming concepts, structured programming, the four logic structures, file processing concepts, and arrays.
This course enables the database student to implement and adminsister oracle databases. Topics include: oracle logical architecture and adminsistration tools, Oracle physical architecture and data dictionary views, performance monitoring and database security.
This course introduces participants to the critical task of planning and implementing database backup and recovery strategies. Topics include Backup and Recovery, Resource Management and Performance tuning, Globalization Support, and Diagnostic Tools.
4
90
This course enables the database student to integrate database content and theory. The student will use Oracle application development tools and utilities to create and manage realistic database development projects. Topics include SQL and PL/SQL, Oracle Forms, Database Reports and Integrated Database Applications.
4
90
This course introduces the UNIX/Linux operating system skills necessary to perform entry-level user functions. Topics include: history of UNIX/Linux, login and logout, the user environment, user password change, the file system, hierarchy tree, editors, file system commands as they relate to navigating the file system tree, UNIX/Linux manual help pages, using the UNIX/Linux graphical desktop, and command options. In addition, the student must be able to perform directory and file displaying, creation, deletion, redirection, copying, moving, linking files, wildcards, determining present working directory and changing directory locations.
3
75
Introduces the fundamental concepts, terminology, and operations necessary to use computers. Emphasis is placed on basic functions and familiarity with computer use. Topics include an introduction to computer terminology, the Windows environment, Internet and email, word processing software, spreadsheet software, database software, and presentation software.