Greg Gornic.com

Course Descriptions:
Indiana University of Pennsylvania

COSC 105 Fundamentals of Computer Science
The first course for Computer Science majors. Required of all Computer Science students and appropriate for other Natural Sciences and Mathematics students. Topics include the fundamental concepts of computer architecture, algorithm development and analysis, programming languages, software engineering, data organization and representation, and systems software. Hands-on introduction to computer usage with an emphasis on terminology and the underlying connections within the discipline.

COSC 110 Problem Solving and Structured Programming

For Science, Mathematics, and Computer Science majors and for others who have a sufficiently quantitative orientation. Basic structure of modern digital computers; problem analysis and computer solution using flowcharting and the C++ language. Exemption or credit by examination possible.

COSC 220 Applied Computer Programming
Structured programming principles and techniques, as implemented through the ANSI COBOL language; program design using top-down techniques; program and project documentation; introduction to sequential and random file algorithms and integrated file systems.

COSC 300 Assembly Language Programming
An examination of structure and languages of machines; representation of data, addressing techniques, symbolic coding, assemblers, macros, etc.; problem solution using assembly language.

COSC 310 Data Structures
Fundamental concepts of data design and implementation, data abstraction, data structures, arrays, linked-lists, stacks, queues, recursion, trees, graphs, and hashing. Also covers sorting algorithms, divide and conquer techniques, greedy methods, and analysis of algorithms. The object-oriented paradigm will be employed in this course using an object-oriented language.

COSC 352 LAN Design and Installation
A study of fundamental local area networking concepts. Detailed study of the basics of local area network (LAN) technology. Comparative study of commercially available LAN systems and products. Features a hands-on laboratory implementation of a LAN. Cross-listed as IFMG 352. Either course may be substituted for the other for D/F repeats but may not be taken for duplicate credit.

COSC 355 Computer Graphics
The use of computer graphics hardware and software. An overview of current applications and experience with representative software will introduce current practice. Foundations in primitives, geometry, and algorithms of passive computer graphics are the principal focus of the course. A brief introduction to interactive computer graphics will be included.

COSC 362 Unix Systems
An introduction to the features, syntax, applications, and history of UNIX. Coverage includes utilities, system administration, development environments, and networking concerns including distributed systems, client-server computing, and providing Web services.

ENGL 322 Technical Writing I
Focuses on helping the student to acquire and to apply communication skills essential to the technical and professional writer.

back to top

Course Descriptions:
Thiel College

CSci 269 Theory of Programming Languages
A thorough study of the design and implementation of high-level programming languages. In order to write efficient, well engineered programs, it is necessary to understand how programming languages work. The course will focus on syntactic and semantic specification of language constructs and the implementation of data types, control structures, and sub-programs. Examples will be drawn from several languages to illustrate different approaches to solving common programming language problems.

CSci 319 Database Management
An introduction to issues in the design and implementation of database management systems. Major topics include database system components, conceptual modeling, database applications, normal forms and the societal impact of database systems. Emphasis is given to the relational data model. Students are required to use a high-level language to write programs to access databases.

CSci 369 Design and Analysis of Algorithms
A review and continuation of complexity analysis, and an introduction to different strategies used to construct algorithms in the solution of computer-solvable problems. Types of algorithms considered include greedy, divide-and-conquer, and backtracking as well as those appropriate for heuristic searching.

CSci 427 Operating Systems
The design and implementation of operating systems are studied. Special emphasis is placed on the basic principles involved in memory, processor, input-output and file system management

CSci 439 Data Communications and Networks
An introduction to data communications principles, network design, and network management. Topics include data communications concepts, terminology, and standards; network topologies and protocols with an emphasis on the ISO/OSI layered model; error correction and detection techniques; security issues and compression. Specific networks are studied as illustrations of these concepts.

Phys 213 Analog Electronics
This course is laboratory based. It begins at a level suitable for those with no previous exposure to electronics, but with a basic knowledge of electricity. The treatment is largely non-mathematical with an emphasis on hands-on experience. This course involves circuits with diodes, transistors, operational amplifiers, and power supplies.

back to top

Course Descriptions:
Tri-State Business Institute

Oracle 9i: Program with PL/SQL
This course introduces students to PL/SQL and helps them understand the benefits of this powerful programming language. In the class, students learn to create PL/SQL blocks of application code that can be shared by multiple forms, reports, and data management applications. Students learn to create procedures, functions, packages, and database triggers.
Students use iSQL*Plus to develop these program units. Students also learn to manage PL/SQL program units and database triggers, to manage dependencies, to manipulate large objects, and to use some of the Oracle-supplied packages.

Oracle 9i: Database Administration Fundamentals I
Oracle DBAs manage the industry's most advanced information systems and command some of the highest salaries. This course is your first step towards success as an Oracle professional, designed to give you a firm foundation in basic database tasks. In this class, you'll learn how to design, create, and maintain an Oracle database.
Students will gain a conceptual understanding of the Oracle database architecture and how its components work and interact with one another. Students will also learn how to create an operational database and properly manage the various structures in an effective and efficient manner. The lesson topics are reinforced with structured hands-on practices.

Oracle 9i: Database Administration Fundamentals II
Students learn about transporting data between databases and the utilities used to perform these activities. Students are also introduced to networking concepts and configuration parameters, as well as how to solve some common network problems. In hands-on exercises, students configure network parameters so that database clients and tools can communicate with the Oracle database server.
This course also addresses backup and recovery techniques, and examines various backup, failure, restore and recovery scenarios. Students also examine backup methodologies based on business requirements in a mission critical enterprise. Students use multiple strategies and Oracle Recovery Manager to perform backups, and restore and recovery operations. This course includes two interactive workshops that provide participants with the opportunity to walk through numerous real-world networking, backup, and recovery case studies.

Oracle 9i: Performance Tuning
This class will cover Oracle9i and Oracle9i Release 2 features. Database performance tuning is critical to any effective information system. Reducing wait times, increasing users' productivity and maximizing the performance of your Oracle database are critical to success. Learn from the experts the value of intelligent database design and methods for tuning an Oracle database for maximum performance.
This course will introduce participants to the importance of good initial database design, and the method used to tune a production Oracle9i database. The focus is on Database and Instance tuning rather than specific operating system performance issues. Participants will gain practical experience tuning an Oracle database. Using the available Oracle tools, such as Oracle Enterprise Manager (with the Diagnostics and Tuning Packs) and STATSPACK participants also learn how to recognize, troubleshoot and resolve common performance related problems in administering an Oracle database.

back to top