Systems Analysis II

Systems Analysis II focuses on developing the implementation model for a business system problem.  In this course participants transform the conceptual model into an implementation model.  The course subject matter includes structure charts, Entity Relationship Diagrams, data repository entries for data structures and processes, systems design tools, project planning, alternative implementation approaches and object oriented design. 

Object-Oriented Analysis and Design

Participant explore techniques, tools and methods used in the object-oriented approach to developing applications.  Participants learn how to model and design system requirements using tools such as Unified Modeling Language (UML), use cases and scenarios, class diagrams and sequence diagrams.

Introduction to Database with Laboratory

This course introduces the concepts and methods fundamental to Database development and use including data analysis and modeling, as well as Structured Query Language (SQL).  Participants also explore basic functions and features of a Database management system (DBMS), with an emphasis on the relational model.

Advanced Database with Laboratory

This course introduces participants to Database implications of efficient and effective transaction processing including error handling, data validation, security, stored procedures and triggers, record locking, commit and rollback.  Data mining and warehousing are also explored.

Database Administration with Lab

Participants are introduced to a variety of Database administration topics including capacity planning, Database management system (DBMS) architecture, performance tuning, backup, recovery and disaster planning, archiving, reorganization and defragmentation.  

Programming Logic and Design with Lab

This course introduces basics of programming logic as well as algorithm design and development using tools such as flowcharts, structure charts or pseudocode.  Participants also learn the basic constructs of programming including constants, variables, expressions and control structures for sequential, iterative and decision processing.

Object Oriented Programming I with Lab

This course introduces object-oriented programming (OOP) concepts including objects, classes, encapsulation, polymorphism and inheritance.  Using an object-oriented programming language such as C#, C++ or Java, participants design, code and document business-oriented programs.

Object-Oriented Programming II with Laboratory

This course elaborates on concepts, theories and applications introduced in Object Oriented Programming I with Lab and introduces concepts such as object libraries and advanced data structures.  Using object-oriented techniques participants learn to design, code, test and document advanced applications.

Object Oriented Programming III

The participant designs, codes and documents programs in an OOP language using Object-Oriented Analysis and Design.  The primary concepts covered include:  Classes, objects, encapsulation, constructors, overloading, polymorphism, and inheritance. 

Systems Analysis I

This course focuses on business analysis using information systems methodologies and technical skills in an organizational environment as part of a business team.  It includes the study of information structuring that will allow an information technology based solution to a business problem and practices techniques for business problem identification, definition, documentation, and the transition from these business requirements to a solution through the development of information models.