Oracle Database Administrator (OD11)  Technical Certificate of Credit


An Oracle Database Administrator (DBA) certificate program provides an opportunity for IT professionals to obtain knowledge to become database administrator.

Occupational Courses (34 Credits)
Required Courses: (30 Credits)
COMP 1001Computer Concepts
CIST 1001

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
CIST 1200

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.

4
CIST 1210
Prerequisite: CIST 1001

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.

4
CIST 1305

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.

3
CIST 2212
Prerequisite: CIST 1210

This course enables thedatabase student to implement and administer Oracle databases. Topics include: oracle logical architecture and administration tools Oracle physical architecture and data dictionary views performance monitoring and database security.

4
CIST 2214
Prerequisite: CIST 2212

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
CIST 2216
Prerequisite: CIST 1210

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
Select ONE programming course elective below: (4 Credits)
CIST 2311
Prerequisite: CIST 1305

Visual Basic I introduces event-driven programming. Common elements of Windows applications will be discussed created and manipulated using Microsofts Visual Studio development environment. Topics include numeric data types and variables decision making structures arrays validating input with strings and functions repetition and multiple forms test files lists and common dialog controls.

4
CIST 2312
Prerequisite: CIST 2311

Visual Basic II teaches client-server systems n-tier development environments relational databases use of SQL to access data the use of ADO.NET objects methods and properties to access and update relational and XML databases. Advanced features of Visual Basic are explored.

4
CIST 2341
Prerequisite: CIST 1305

This course is designed to teach the basic concepts and methods of objected-oriented design and C#.Net programming. Use practical problems to illustrate C#.Net application building techniques and concepts. Develop an understanding of C#.Net vocabulary. Create an understanding of where C#.Net fits in the application development landscape. Create an understanding of the C#.Net Development Environment Visual Studio and how to develop debug and run C#.Net applications using the Visual Studio. Continue to develop student*s programming logic skills. Topics include: C#.NET Language History C#.NET Variable Definitions C#.NET Control Structures C#.NET Functions C#.NET Classes C#.NET Objects and C#.NET Graphics.

4
CIST 2342
Prerequisite: CIST 2341

This course is an intermediate course in C#.NET Programming. It is assumed that the student knows the C#.NET syntax as well as basic object oriented concepts. Intermediate C#.NET teaches client-server systems n-tier development environments relational databases use of SQL to access data the use of ADO.NET objects methods and properties to access and update relational databases. Advanced features of C# windows programming are explored.

4
CIST 2371
Prerequisite: CIST 1305

This course is designed to teach the basic concepts and methods of objected-oriented design and Java programming. Use practical problems to illustrate Java application building techniques and concepts. Develop an understanding of Java vocabulary. Create an understanding of where Java fits in the application development landscape. Create an understanding of the Java Development Kit and how to develop debug and run Java applications using the JDK. Continue to develop student*s programming logic skills. Topics include: JAVA Language History JAVA Variable Definitions JAVA Control Structures JAVA Methods JAVA Classes JAVA Objects and JAVA Graphics.

4
CIST 2372
Prerequisite: CIST 2371

This course is an intermediate course in Java Programming. It is assumed that the student knows the Java syntax as well as basic object oriented concepts. The student will use classes and objects provided by the core Java API. They will use these classes to accomplish tasks such as Database access File access exception handling running threads using sockets to talk across a network and remotely calling methods using RMI techniques.

4
CIST 2381
Prerequisite: CIST 1305

This course explores mobile guidelines, standards, and techniques. This course includes design and development techniques for multiple mobile devices, platforms, and operating systems. Students will develop mobile applications using state of practice development tools, languages and devices.

4
CIST 2382
Prerequisite: CIST 2381

This course provides an opportunity to develop a working knowledge of mobile programming that Includes creating, editing, executing, and debugging mobile applications. Students learn how to use mobile development technologies and toolkits to develop mobile applications.

4
CIST 2383
Prerequisite: CIST 2382

This course introduces students to Human-Computer Interaction (HCI) concepts and best-practices used in mobile application development with purpose of improving user experiences. In this course students will utilize User Experience Design (UXD) for developing mobile applications in any mobile application platform. The UXD concepts explored in this course will include visual design, information architecture, interaction design, and usability.

4
Up one level
Programs of Study