Database Specialist

Program Overview

The Computer Information Systems - Database Specialist program is a sequence of courses designed to provide students with an understanding of the concepts, principles, and techniques required in computer information processing. Graduates are to be competent in the general areas of humanities or fine arts, social or behavioral sciences, and natural sciences or mathematics, as well as in the technical areas of computer terminology and concepts, program design and development, and computer networking. Program graduates are qualified for employment as database specialists.

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
General Core Curriculum (60 - 61 hours)
General Education Courses (15 hours)
Area I - Language Arts/Communication (6 hours)
3
45
Explores the analysis of literature and articles about issues in the humanities and in society. Students practice various modes of writing, ranging from exposition to argumentation and persuasion. The course includes a review of standard grammatical and stylistic usage in proofreading and editing. An introduction to library resources lays the foundation for research. Topics include writing analysis and practice, revision, and research. Students write a research paper using library resources and using a formatting and documentation style appropriate to the purpose and audience.
Select One Of The Following (3 hours)
3
45
Emphasizes the student\\\'s ability to read literature analytically and meaningfully and to communicate clearly. Students analyze the form and content of literature in historical and philosophical contexts. Topics include reading and analysis of fiction, poetry, and drama; research; and writing about literature.
SPCH
1101
3
45
Introduces the student to the fundamentals of oral communication. Topics include selection and organization of materials, preparation and delivery of individual and group presentations, analysis of ideas presented by others, and professionalism.
Area II - Social/Behavioral Sciences (3 hours)
Select One Of The Following (3 hours)
3
45
Provides a description and analysis of economic operations in contemporary society. Emphasis is placed on developing an understanding of economic concepts and policies as they apply to everyday life. Topics include basic economic principles; economic forces and indicators; capital and labor; price, competition, and monopoly; money and banking; government expenditures, federal and local; fluctuations in production, employment, and income; and United States economy in perspective
Introduces the major fields of contemporary psychology. Emphasis is on fundamental principles of psychology as a science. Topics include research design, the organization and operation of the nervous system, sensation and perception, learning and memory, motivation and emotion, thinking and intelligence, lifespan development, personality, psychopathology and interventions, stress and health, and social psychology.
3
45
Explores the sociological analysis of society, its culture, and structure. Sociology is presented as a science with emphasis placed on its methodology and theoretical foundations. Topics include basic sociological concepts, socialization, social interaction and culture, social groups and institutions, deviance and social control, social stratification, social change, and marriage and family.
Area III - Natural Sciences/Mathematics (3 hours)
MATH
1111
3
45
Emphasizes techniques of problem solving using algebraic concepts. Topics include fundamental concepts of algebra, equations and inequalities, functions and graphs, and systems of equations; optional topics include sequences, series, and probability or analytic geometry.
Area IV - Humanities/Fine Arts (3 hours)
3
45
Emphasizes American literature as a reflection of culture and ideas. A survey of important works in American literature. Includes a variety of literary genres: short stories, poetry, drama, nonfiction, and novels. Topics include literature and culture, essential themes and ideas, literature and history, and research skills.
Technical Courses (45 - 46 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.
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.
IT Analysis, Design, and Project Management will provides a review and application of systems life cycle development methodologies and project management. Topics include: Systems planning, systems analysis, systems design, systems implementation, evaluation, and project management.
XXX
xxx
CIS Programming Language Course
4
0
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.
Oracle Specialization (23 - 24 hours)
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.
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.
XXX
xxx
Elective
4
0
Choose One of the Following Operating Systems Courses (3 - 4 hours)
Provides an overview of modern operating systems and their use in home and small business environments. Activities will utilize the graphical user interface (GUI) and command line environment (CLI This will include operating system fundamentals; installing, configuring, and upgrading operating systems; managing storage, file systems, hardware and system resources; troubleshooting, diagnostics, and maintenance of operating systems; and networking.
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.