Official website

of the Commonwealth of Pennsylvania

Course Search Results

  • 3.00 Credits

    Introduces students to local area client/server networking using the current generation of Microsoft Windows Servers. While providing students with the knowledge and skills necessary to install and configure the current Microsoft Windows operating system on stand-alone and client computers that are part of a workgroup or domain, this course also emphasizes the skills and knowledge necessary to install, configure, and administer Active directory. A course fee is required. Prerequisite: CNT 120 with a grade of C or higher. Prerequisite:    CNT 120
  • 4.00 Credits

    Introduces Systems Analysis and Design, using the Systems Development Life Cycle (SDLC) as an organizing tool, to take the student from Planning and Selection through Implementation and Operation. This course presents current practices, as well as accepted concepts and principles of system development, with an understanding of the processes, techniques, and end products. In addition, this course provides extensive coverage of oral and written communication skills including documentation, project management, and team management. Prerequisite: CNT 120 with a grade of C or higher; and one of the following with a grade of C or higher: CIS 238, 245; CPS 115, 121, 135, 230; WEB 140, 143, 144, 220, 240, 242, 244, 246. Prerequisite:    CPS 121 or CPS 113 or DAT 105 or WEB 143 Corequisite:    CPS 121, CPS 113, DAT 105, WEB 143
  • 3.00 Credits

    Provides skills needed to operate and manage in a technical support environment. The course covers technical support, troubleshooting, escalation channels, communication skills, and developing professional interaction with end users. Also included is an in-depth study of help desk software with an emphasis on call and asset management. Prerequisite: CNT 120, and CIS 222 or 249 or 264 or 265 with grades of C or higher. Prerequisite:    CNT 120 & ( CIS 222 or CIS 249 or CIS 264 or CIS 265 )
  • 3.00 Credits

    Covers the development of static and interactive reports for print, web, and mobile technologies. This course covers the use of reporting services to manage data sources and create paginated reports. Students are taught how to stylize reports and add visual elements, such as images and charts. In addition, this course covers the creation of Key Performance Indicator (KPI) dashboards and interactive menus. Prerequisite: CIS 241 with a grade of C or higher. Prerequisite:    CIS 241
  • 3.00 Credits

    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
  • 3.00 Credits

    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
  • 3.00 Credits

    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
  • 3.00 Credits

    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
  • 3.00 Credits

    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
  • 3.00 Credits

    Data Visualization Prerequisite:    CIS 105 or CIS 105H or GIS 141 or WEB 125
(external site) (opens in a new tab)