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.
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.
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.
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.