Course Search Results

  • CIS 240: Advanced Database Management

    3.00 Credits
    Harrisburg Area Community College-Harrisburg

    Builds on the database management applications, concepts, and skills developed in CIS 140. The course provides an opportunity to develop a database application for business using the programming language provided with the database. In addition, full documentation is developed by the student. Prerequisite: CIS 140 with a grade of C or higher; or permission of the Instructor. Prerequisite:    CIS 140
    ShareCIS 240 - Advanced Database Management

  • CIS 241: Database Administration I

    3.00 Credits
    Harrisburg Area Community College-Harrisburg

    Introduces students to the core concepts of databases. This course covers choosing database architecture; hands-on exercises installing the database; creating objects such as tables and indices; applying normalization concepts and performing various backup/recovery scenarios; and writing SQL (Structured Query Language) coding for web, mobile, and application development. Prerequisite: CIS 140 or WEB 143 with a grade of C or higher; or permission of the Instructor. Prerequisite:    CIS 140 or MIS 103 or WEB 143
    ShareCIS 241 - Database Administration I

  • CIS 243: Database Administration II

    3.00 Credits
    Harrisburg Area Community College-Harrisburg

    Builds upon the database administration concepts developed in CIS 241. This course covers Relational Database Management System (RDBMS) features for Oracle. Data manipulation and data conversion, using built-in database functions and advanced query techniques, are reviewed. Security, Storage Management, Back-Up and Recovery, and Recovery Manager (RMAN) are also introduced. Accessing data in a heterogeneous environment, managing database objects using the data dictionary, and evaluating performance are all reviewed. Prerequisite: CIS 241 with a grade of C or higher; or permission of the Instructor. Prerequisite:    CIS 241
    ShareCIS 243 - Database Administration II

  • CIS 245: Database Programming

    3.00 Credits
    Harrisburg Area Community College-Harrisburg

    Covers Structured Query Language (SQL) commands to manage a database. This course allows students to create, store, retrieve, and maintain database objects using Data Definition Language (DDL) and Data Manipulation Language (DML) and establish access and security to database objects using Data Control Language (DCL). In addition, students learn to retrieve data using Joins, Sub- queries, Scalar and Vector statements, and write SQL code to manage distributed data and transactions. Prerequisite: CIS 140 or WEB 143 with a grade of C or higher; or permission of the Instructor. Prerequisite:    CIS 140 or CIS 241 or WEB 143
    ShareCIS 245 - Database Programming

  • CIS 247: Database Backup and Recovery

    3.00 Credits
    Harrisburg Area Community College-Harrisburg

    Introduces the critical task of planning and implementing database backup and recovery strategies. This course addresses backup and recovery techniques and examines various backup, failure, restore, and recovery scenarios. Backup methodologies, based on business requirements in a mission critical enterprise, are also addressed. Prerequisite: CIS 243 with a grade of C or higher; or permission of the Instructor Prerequisite:    CIS 243
    ShareCIS 247 - Database Backup and Recovery

  • CIS 249: Fundamentals of the UNIX Operating System

    3.00 Credits
    Harrisburg Area Community College-Harrisburg

    Covers the UNIX operating system and environment as well as similarities with LINUX. Topics include logging onto UNIX, the UNIX file system, basic operating system commands, processing and system resources, login profiles, and beginning shell scripting. Hands-on experience with the vi editor, the UNIX help system, and other UNIX tools and utilities is also covered. Prerequisite: CIS 105 with a grade of C or higher; or permission of the Instructor. Prerequisite:    CIS 105
    ShareCIS 249 - Fundamentals of the UNIX Operating System

  • CIS 253: Linux Development

    3.00 Credits
    Harrisburg Area Community College-Harrisburg

    Explores the various development environments, tools, and best practices available with the Linux and Micro-Controller operating system. This course focuses on contemporary languages in the latest distributions available for this operating system. System installation and Object-Oriented Programming, with the latest languages such as CPP, Qt, Python and JAVA Development, may also be covered. Prerequisite: CIS 249 with a grade of C or higher. Prerequisite:    CIS 249
    ShareCIS 253 - Linux Development

  • CIS 257: Data Warehousing

    3.00 Credits
    Harrisburg Area Community College-Harrisburg

    Introduces the fundamental theory of data warehouse development and application. This course addresses development requirements, data warehouse architecture, dimensional model design, and physical database design. Skills to manipulate the data in the warehouse for updating, maintenance, and data extraction are also covered. This course presents applications of business intelligence techniques within the data warehousing framework. Prerequisite: CIS 140 or 241 with a grade of C or higher; or permission of the Instructor. Prerequisite:    CIS 140 or CIS 241
    ShareCIS 257 - Data Warehousing

  • CIS 258: Data Mining

    3.00 Credits
    Harrisburg Area Community College-Harrisburg

    Introduces the concepts and application of data mining to discover useful and "interesting" patterns from large data sets. This course specifically covers computational algorithms to develop patterns and forecasts from databases, data selection, cleaning, coding, statistical and machine learning techniques, and visualization of generated structures. The course uses data mining software and examples to illustrate the process. Prerequisite: CIS 110 or WEB 143, and CIS 135 with grades of C or higher. Or permission of the Instructor. Prerequisite:    ( CIS 110 or WEB 143 ) & CIS 135
    ShareCIS 258 - Data Mining

  • CIS 259: Data Visualization

    3.00 Credits
    Harrisburg Area Community College-Harrisburg

    Data Visualization Prerequisite:    CIS 105 or CIS 105H or GIS 141 or WEB 125
    ShareCIS 259 - Data Visualization