Information Technology Solutions

Course Code: ITS 5101

Operating Systems is a course designed to give the user knowledge of one of the most popular and powerful operating systems used today. In this course the student will acquire an understanding of Linux and compare it with the UNIX operating system. The student will learn how to create shell-script programs and how to control and manipulate the user environment

Course Code: ITS 5102

In this introductory course in programming, students learn the programming fundamentals that must be acquired for any programming language. Emphasis is placed on objects and object-oriented programming. Java is the language used to learn these concepts. Introductory programming applications will be built, tested, and debugged to practice these skills. The course focuses on the three fundamental logical structures (sequences, decisions, and loops.

Course Code: ITS 5103

This course is an introduction to web design. The technical aspects of web design and interface development are covered with a focus on the programming languages: XHTML, JavaScript and Flash scripting. Beginning with basic XHTML the student will learn valid mark up while focusing on layout and effective site navigation. The student will develop an understanding of JavaScript followed by an introduction to multimedia content, Flash animation and design and Flash scripting.

Course Code: ITS 5104

The study of database design and management of a database is an essential component of the business IT world today. Through this course the student will gain a strong theoretical background in database design. The student will work with Entity-Relationship Diagrams (ERD) to learn and implement the basic database design. Students will also use the Normalization principles to also to enhance and further develop the database design. Using Oracle 10g SQL, the students will apply the design principles to actually create and develop a working database. The students will use a data-modeling tool to design the ERD for a database and then create the required SQL commands from this design to implement a database. This course is designed to help students integrate theoretical material with practical knowledge to implement a database. Students will also use SQL commands to query single and multiple tables. Single and group functions will also be used in addition to subqueries to query data. Manipulating of data in the database is also covered.

Course Code:

Course Code: ITS 5201

This course continues the study of object-oriented programming concepts begun in Java Programming 1 and also introduces many of the most important library classes that form part of the Java language. Students will make use of the these concepts to write Java applications that use object-oriented principles to perform tasks such as generating graphical user interfaces, handling exceptions, reading from and writing to files, and communicating with other computers over a network. Using technologies such as Java Database Connectivity (JDBC), the student gain experience in developing applications with the Java programming language that make use of the Oracle database.

Course Code: ITS 5202

This course is an introduction to project management. Students will be exposed to the basic theories, techniques, and rationales of project management. Working in teams, students will be engaged in project management activities: meetings, documentation, and writing. These will culminate in a final presentation where students will have to describe what they have done and why in a project management and information technology context. Microsoft Project will be used in this course

Course Code: ITS 5203

This course is an introduction to XML, Extensible Mark up Language. This major technology is platform independent and versatile. Students will learn how to employ XML in different data exchange applications, for the web, e-commerce and n-tier architectures. Theory reinforced with practical examples and real life solutions will be covered. Ajax architecture is introduced in the course. Integration with XML and its supporting technologies is demonstrated in web-based applications.

Course Code: ITS 5204

This course will introduce the students to networking fundamentals as well as computer system architecture. They will learn about the different components and their functionality used in building the computer system as well as a computer network. They will also compare the different operating systems used in the mobile devices, as well as their architecture. Linux will be explored to support the networking.

Course Code: ITS 5205

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 anonymous PL/SQL blocks, stored procedures, and functions. They learn about declaring variables and trapping exceptions. Students will also learn to develop stored procedures, functions, packages, and database triggers. Students will learn to manage PL/SQL program units manage dependencies, manipulate large objects, and use some of the Oracle-supplied packages. Students use Oracle SQL Developer to develop these program units. Demonstrations and hands-on practice reinforce the fundamental concepts.

Course Code: ITS 5301

This course will introduce the students to networking fundamentals as well as computer system architecture. They will learn about the different components and their functionality used in building the computer system as well as a computer network. They will also compare the different operating systems used in the mobile devices as well as their architecture. Linux will be explored to support the networking.

Course Code: ITS 5302

This course is designed to give students a firm foundation in basic administration of Oracle Database 11g. In this class, students will learn how to install and maintain Oracle Database 11g. Students will gain a conceptual understanding of the Oracle database architecture and how its components work and interact with one another. You will learn how to create an operational database and properly manage the various structures in an effective and efficient manner including performance monitoring, database security, user management, and backup/recovery techniques.

Course Code: ITS 5303

This course introduces the architecture of Oracle WebLogic Server 11g and enables the participants to effectively install and manage it. The participants learn how to access and use Oracle WebLogic server management tools, and practice the basic management components. The participants gain hands-on experience in configuring the WebLogic server. They also learn to deploy J2EE applications. You will also setup a Java Database Connectivity (JDBC) connection. This course is designed to prepare you for the corresponding Oracle Certified Associate exam.

Course Code: ITS 5304

In this course, students study the issues involved in planning, building, populating, and maintaining a data warehouse. During the course, students examine Oracle warehouse technology, and the Oracle database features that support data warehousing. Students are presented with the basic concepts, fundamental issues, and techniques for the design of a data warehouse or data mart. Students examine all phases and tasks of the extract, transform and load (ETL) process for data warehouses.

Course Code:

Course Code: ITS 5306

In this course students will learn an introduction to programming with Microsoft Transact SQL using the SQL Server database. This course is intended to give you the necessary information to be able to work with databases in the SQL Server environment. You will be introduced to Microsoft Transact SQL using statements to create and access database objects, user-defined functions, procedures, cursors and database triggers. This course assumes you are familiar with SQL. You will implement tables, partitioned tables, views, and indexes. This course is based on the Microsoft?s MCTS ? SQL Server Database Development exam requirements.

Course Code: ITS 5401

This course takes Oracle 11g, database administration (DBA) training to the next level and prepares you for Oracle Certified Professional (OCP) certification. Students learn about Oracle Recovery Manager (RMAN) and Oracle backup and recovery strategies in depth. Students build an automatic storage management (ASM) database and learn about tuning, database performance, resource and memory management, scheduling and Oracle flash bask technologies. Students not only learn the theory but will apply it hands-on in the comprehensive labs that accompany the course material.

Course Code: ITS 5402

This course is intended for those who wish to maintain and use data warehouses. Before attending this course, you should be familiar with relational database concepts and basic data warehouse theory. The course will look at materialized views, the extract, transform and load (ETL) framework, and loading data from various sources. Several tools will be utilized to work with the data warehouse. SQL*Loader, data pump, and import and export. The benefits of parallelization and query rewrite will also be covered. Materialized views, and partitioning will be discussed in detail.

Course Code: ITS 5403

In this hands-on course, students learn how to use the features of online analytical processing (OLAP) to derive critical information from multidimensional data stored in the Oracle database, release 10g. This includes learning OLAP concepts, building an analytic workspace and multidimensional objects with the Oracle database 10g analytic workspace manager (AWN10g) toolkit, enhancing analytic content, and using tolls for OLAP analysis. Students will also learn concepts and terminology, and create dimensions and cubes with the AWN10g. Analytical reports that access the multidimensional data in the analytical workspace will be built using Oracle business intelligence enterprise edition (OBIEE). Students will learn how to use OBIEE to query, report, and analyze corporate data. They will learn how to use OBIEE to perform ad hoc analyses against relational data sources, and how to use OBIEE to create dashboards.

Course Code: ITS 5404

This course will introduce students about how to manage, implement, and troubleshoot a Microsoft SQL Server database. They will learn the basics of installing and configuring SQL Server, how to create and implement database objects, implement high availability and disaster recovery. Additionally students will secure instance databases and database objects and monitor and troubleshoot SQL Sever instances. This course is based on the Microsoft?s MCTS ? SQL Server implementation and Maintenance exam requirements.

Course Code: ITS 5405

The capstone project, students integrate and apply the programming and database skills and knowledge acquired in the program on a real-world project. Students design an application and develop, document and test it. They will use all the skills like design patterns, data structures, web/mobile/windows application development skills in the project. Students demonstrate project management, professional behaviour, effective communication skills, problem-solving abilities and display the transition progress from trainee to professional. Students are expected to work independently or in group setting and in consultation with assigned faculty.

Course Code: ITS 5101

Operating Systems is a course designed to give the user knowledge of one of the most popular and powerful operating systems used today. In this course the student will acquire an understanding of Linux and compare it with the UNIX operating system. The student will learn how to create shell-script programs and how to control and manipulate the user environment

Course Code: ITS 5102

In this introductory course in programming, students learn the programming fundamentals that must be acquired for any programming language. Emphasis is placed on objects and object-oriented programming. Java is the language used to learn these concepts. Introductory programming applications will be built, tested, and debugged to practice these skills. The course focuses on the three fundamental logical structures (sequences, decisions, and loops.

Course Code: ITS 5103

This course is an introduction to web design. The technical aspects of web design and interface development are covered with a focus on the programming languages: XHTML, JavaScript and Flash scripting. Beginning with basic XHTML the student will learn valid mark up while focusing on layout and effective site navigation. The student will develop an understanding of JavaScript followed by an introduction to multimedia content, Flash animation and design and Flash scripting.

Course Code: ITS 5104

The study of database design and management of a database is an essential component of the business IT world today. Through this course the student will gain a strong theoretical background in database design. The student will work with Entity-Relationship Diagrams (ERD) to learn and implement the basic database design. Students will also use the Normalization principles to also to enhance and further develop the database design. Using Oracle 10g SQL, the students will apply the design principles to actually create and develop a working database. The students will use a data-modeling tool to design the ERD for a database and then create the required SQL commands from this design to implement a database. This course is designed to help students integrate theoretical material with practical knowledge to implement a database. Students will also use SQL commands to query single and multiple tables. Single and group functions will also be used in addition to subqueries to query data. Manipulating of data in the database is also covered.

Course Code:

Course Code: ITS 5201

This course continues the study of object-oriented programming concepts begun in Java Programming 1 and also introduces many of the most important library classes that form part of the Java language. Students will make use of the these concepts to write Java applications that use object-oriented principles to perform tasks such as generating graphical user interfaces, handling exceptions, reading from and writing to files, and communicating with other computers over a network. Using technologies such as Java Database Connectivity (JDBC), the student gain experience in developing applications with the Java programming language that make use of the Oracle database.

Course Code: ITS 5203

This course is an introduction to XML, Extensible Mark up Language. This major technology is platform independent and versatile. Students will learn how to employ XML in different data exchange applications, for the web, e-commerce and n-tier architectures. Theory reinforced with practical examples and real life solutions will be covered. Ajax architecture is introduced in the course. Integration with XML and its supporting technologies is demonstrated in web-based applications.

Course Code: ITS 5204

This course will introduce the students to networking fundamentals as well as computer system architecture. They will learn about the different components and their functionality used in building the computer system as well as a computer network. They will also compare the different operating systems used in the mobile devices, as well as their architecture. Linux will be explored to support the networking.

Course Code: ITS 5212

This course introduce students to the internals of .NET programming with C# using Microsoft Visual Studio. .NET framework is used in the development of all windows applications and enhancement of the existing applications. Students will learn how to develop windows applications using the WinForms, as well as Windows Presentation Foundation (WPF). They will be introduced to develop database-based windows applications.

Course Code: ITS 5213

This course provides an introduction to design patterns. It presents the common design patterns as defined by Gamma et al., and gives students opportunities to make use of these patterns in designing and implementing programs.
The course also presents an introduction to most common data structures like list, stacks, queues, linked list, sorted linked list, dictionaries, and sets. Students will develop the applications in .NET developing and using these data structures.

Course Code: ITS 5202

This course is an introduction to project management. Students will be exposed to the basic theories, techniques, and rationales of project management. Working in teams, students will be engaged in project management activities: meetings, documentation, and writing. These will culminate in a final presentation where students will have to describe what they have done and why in a project management and information technology context. Microsoft Project will be used in this course

Course Code: ITS 5301

This course will introduce the students to networking fundamentals as well as computer system architecture. They will learn about the different components and their functionality used in building the computer system as well as a computer network. They will also compare the different operating systems used in the mobile devices as well as their architecture. Linux will be explored to support the networking.

Course Code: ITS 5311

Programming in Perl enables websites to deliver fast, dynamic data to their users. Perl has evolved into a powerful programming language capable of solving any enterprise-level problem. With approximately sixty per cent of the web server market hosted by Apache Web Servers, common administration tasks and custom web applications have Perl as the underlying language. PHP a Perl-like wrapper is an open-source language supporting rapid database and e-commerce solutions. The MySQL database is a lightweight (in terms of server resources), yet powerful enough tool to meet small- and medium-size database requirements. The four tools, Perl, PHP, MySQL and Apache come packaged with most distributions of the Linux operating system and form what is commonly called LAMP. Students in this course will learn how the four work together to solve most web application requirements.

Course Code: ITS 5312

This course is designed to extend the students? knowledge of ASP.NET. The course will focus on advanced controls and being able to customize applications by developing custom controls and generating web interfaces programmatically. Web security will be introduced and the student will earn how to perform both authentication and authorization. AJAX will be used to create highly responsive interfaces.

Course Code: ITS 5313

Students will learn how to program java based web applications. Java based servers and clients form the basis of many enterprise deployments. The fundamental java network classes are covered with an emphasis on client server communication. Servlets and Java server pages form the basis of application development. Database integration and business object modelling are included in the projects and assignments.

Course Code: ITS 5314

This course provides an introduction to the programming of Android. Android is the system running a new generation of smart phones and is based on the Linux operating system. It is programmed by creating Java applications which run under the control of the operating system. Students will learn the concepts of Android and how to create applications that display a user interface and can store and manage data on the device.

Course Code: ITS 5405

The capstone project, students integrate and apply the programming and database skills and knowledge acquired in the program on a real-world project. Students design an application and develop, document and test it. They will use all the skills like design patterns, data structures, web/mobile/windows application development skills in the project. Students demonstrate project management, professional behaviour, effective communication skills, problem-solving abilities and display the transition progress from trainee to professional. Students are expected to work independently or in group setting and in consultation with assigned faculty.

Course Code: ITS 5411

All distributed systems are based on a set of principles, paradigms, models and design patterns, which have been founded, developed and refined through scientific and business research, as well as commercial enterprise application development. This course presents this collective knowledge of best practices application design as it applies to the latest .NET technology.

Course Code: ITS 5412

This course will introduce some of the recent technologies of Enterprise Java Programming and distributed computing. The course will look at integrating the business layer using JavaBeans and Enterprise JavaBeans (Session, Entity and Message Driven Beans). Different data layer needs and data types will be tied together by employing Java's cross-platform ability.

Course Code: ITS 5413

Enterprise Services Architecture (ESA) offers a sound, flexible architecture for adapting business processes in response to changing market conditions. Harnessing web services, electronic data interchange (EDI) and legacy applications, has become the goal of most modern organizations. Service-oriented architecture (SOA) under ESA can simplify the creation and maintenance of large-scale applications. When a project involves a large set of web services-based components, or connects legacy applications to modern business processes, knowledge of ESA and SOA can create a structured approach to managing and designing future business applications. This course examines a Java-based approach to SOA, dealing with most of the issues service-based architectures face today.

Course Code: ITS 5414

In this course students will extend their concepts learned in the application development for the mobile development in ITS 5205. They will learn how to developing the applications for the iPad and iPhone using the objective C.