Course Outline

COURSE OUTLINE IT DIPLOMA 

Description:  

This leading edge course covers e-Commerce development using Java beans, Servlets, JSP, UML, Enterprise Java Beans (EJB), XML, XSL and CSS.  At the end of course student will do hand-on-extensive project workshop of 30 days to utilize learned in this course.

  Status:   Approved from Oracle Corporation Canada

Objective:  Student should be prepare for the following industry leading edge e-Commerce

Certification     Level 1: Sun Certified Programmer for the Java Platform

                       Test 1Z0-501 Sun Certified Programmer for the Java 2 Platform

                       Level 2: Oracle Certified Solution Developer –Jdeveloper

                       Test 1Z0-502 Oracle Jdeveloper: Develop Database Application with Java

                       Test 1Z0-503 Object Oriented Analysis and Design with UML

                         Level 3: Oracle Certified Enterprise Developer – Oracle Internet Platform

                        Test 1Z0-504 Enterprise Connectivity with Java Technology

                        Test1Z0- 505 Enterprise Developments on the Oracle Internet Platform

  Pre-Requisite: Grade 12 or up 

North American School of Information Technology

3609 Sheppard Ave. East. Scarborough, Ont. M1T 3K8

Ph: 416 –335-6178 Fax: 416-335-6179

Course #:   EC-101

Course   :   Database Concepts and Design

  Description

This course covers the essential elements in database design, including how to gather and present relevant information for review, use and draw Entity-Relation diagrams, and normalize data structures. Students will learn how to define business information requirements and to transform the requirements into an initial database design.

  Objective

-          Understand the terminology used in conceptual modeling

-          Understand the terminology used in logical modeling and state the principles of normalization

-          Develop an entity relationship model to express the user requirements

-          Recognize and model exclusive relationships and entities

-          Recognize and model recursive relationships

-          Understand the principles of transferability and referential integrity

-          Develop an initial relational database design from an entity relationship model

-          Understand the components of an entity relationship diagram

-          Analyze user information requirements

Course Outline

-          Data Systems; Data Models; Database Design Process.

-          The Business Narrative

-          Normalization

-          Entity-Relationship Diagrams

-          Designing the Database

-          Table Instance Charts

-          SQL Tables

-          Data Flow Diagrams

 3609 Sheppard Ave. East. Scarborough, Ont. M1T 3K8

Ph: 416 –335-6178 Fax: 416-335-6179

Course #:   EC-102, ID-103

Course   :   e-Commerce Platform

  Description

This course covers the overview of e-Commerce, architecture and framework of e-Commerce sites. It also emphases on designing successful architecture, common failures, Best practices to the design and forecast hits on e-Commerce sites. Student will learn known e-Commerce tools available and their industry research about their popularity.

  Objective

·         Understand e-Commerce World

·         Knowledge about architecture and framework of e-Commerce.

·         Familiarity with available e-Commerce tools available in the market.

Course Outline

The course outline is being compiled.

3609 Sheppard Ave. East. Scarborough, Ont. M1T 3K8

Ph: 416 –335-6178 Fax: 416-335-6179 

Course #:   EC-103, ID-101

Course   : Java Programming 

Description

This course teaches participants how to develop Java applications and applets. The course focuses on teaching the Java language, plus practical object-oriented principals. In addition to coding in Java, participants will learn how to use the graphical capabilities of Oracle JDeveloper to aid rapid application development.

  Objective

·         Develop Java applets

·         Build, generate, and test applications using Oracle JDeveloper 3.0

·         Build the essential elements of database forms using the features of Oracle JDeveloper

·         Write standalone applications with the Java programming language 

Course Outline

·         Introduction to Java

·         Basic Java Concepts

·         Oracle JDeveloper

·         Data Types and Operators

·         Controlling Program Flow

·         Object-Oriented Principles

·         Working with Classes and Objects

·         More on Working with Classes

·         Using Arrays, Strings and Wrapper Classes

·         Reusing Code Through Inheritance

·         Structuring Code using Abstract Classes and Interfaces

·         Handling Exceptions

·         Multi-Threading

·         Creating a Dataform

·         Adding User Interface Components

·         Developing a Form Layout

·         Building and Deploying Applets

·         File I/O

·         Internationalization

North American School of Information Technology

3609 Sheppard Ave. East. Scarborough, Ont. M1T 3K8

Ph: 416 –335-6178 Fax: 416-335-6179

Course #:   EC-201

Course   :   Introduction to Oracle: SQL & PL/SQL

Description

This course offers students an extensive introduction to data server technology. The class covers concepts for both relational and object relational databases and the powerful SQL and PL/SQL programming languages. Students are taught to create and maintain database objects and

store, retrieve, and manipulate data. In addition, students learn to create PL/SQL blocks of application code that can be shared by multiple forms, reports, and data management applications. Demonstrations and hands-on practice reinforce the fundamental concepts.

  Objective

·         Control data/user access

·         Describe relational database concepts

·         Retrieve, insert, update, and delete data

·         Create and maintain database objects

·         Describe the features and syntax of PL/SQL

·         Handle runtime errors

·         Control transactions

·         Conditionally control code flow (loops, control structures, and explicit cursors)

·         Use basic SQL*Plus commands

  Course Outline

·         Introduction

·         Writing a Basic SQL Statement

·         Restricting and Sorting Data

·         Single Row Functions

·         Displaying Data from Multiple Tables

·         Aggregating Data using Group Functions

·         Writing Subqueries

·         Multi-Column Subqueries

·         Producing Readable Output with SQL*Plus

·         Manipulating Data

·         Creating and Managing Tables

·         Including Constraints

·         Creating Views

·         Other Database Objects

·         Controlling User Access

·         Declaring Variables

·         Writing Executable Statements

·         Interacting with the Oracle Server

·         Writing Control Structures Course #:   EC-202

3609 Sheppard Ave. East. Scarborough, Ont. M1T 3K8

Ph: 416 –335-6178 Fax: 416-335-6179  

Course   :   Develop PL/SQL Program Units

Description

This course enables participants to learn how to write PL/SQL procedures, functions and packages. Working with Procedure Builder and the SQL*Plus environments, participants will learn how to create and manage PL/SQL program units and database triggers. Participants will also learn how

 to use some of the Oracle-supplied packages. 

Objective

·         Create, execute, and maintain procedures, functions, packages and database triggers

·         Describe the PL/SQL development environments

·         Manage PL/SQL program constructs

·         Manipulate large objects (LOB)

·         Describe Oracle supplied packages

  Course Outline

·         Overview of PL/SQL

·         Working with Procedure Builder

·         Creating Procedures

·         Creating Functions

·         Creating Packages

·         Creating Database Triggers

·         Managing Subprograms

3609 Sheppard Ave. East. Scarborough, Ont. M1T 3K8

Ph: 416 –335-6178 Fax: 416-335-6179

  Course #:   EC-203, ID-102

Course   :   Develop Database Applications with Java

  Description

In this course, participants learn to write Java applications that access an Oracle database. Participants will learn to create visual, data-aware applets and applications, and develop and deploy Java-stored procedures and triggers in Oracle8i. Topics include the JDBC and SQLJ standard protocols for database access with Java, plus an introduction to Java servlets. The development environment used for this course is Oracle JDeveloper 2.0. In  addition to coding in Java, participants will learn to use the JDeveloper's wizards and data-aware controls to create application components.

  Objective

·         Build form-based database applications using JDeveloper 2.0

·         Use JDBC to execute dynamic SQL queries in a Java application

·         Use SQLJ to embed static SQL queries in a Java application

·         Access and manipulate database information in Java applications

  Course Outline

·         Introduction to Database Programming with Java

·         Review of the JDeveloper Tool

·         Building Forms with the InfoBus Data Form Wizard

·         Customizing a Form Created by the InfoBus Data Form Wizard

·         Creating a New Form with the Data-Aware Controls

·         Building a Data-Aware Form: Advanced Topics

·         Building Components with JavaBeans

·         Building Database Servlets

·         Accessing a Database using Java Database Connectivity (JDBC)

·         Embedding SQL Statements in Java Code

·         Writing Applications with SQLJ

·         Developing and Deploying Stored Procedures with JDeveloper

·         Creating Database Triggers

3609 Sheppard Ave. East. Scarborough, Ont. M1T 3K8

Ph: 416 –335-6178 Fax: 416-335-6179  

Course #:   EC-204, ID-201

Course   :   Object-Oriented Analysis and Design Using

                    Unified Modeling Language (UML)

  Description

This course teaches you how to apply object-oriented analysis and design techniques. Students will learn how to model user requirements of a problem domain and capture the analysis results in static and dynamic models on object relational world.

  Objective

Provides an opportunity to explore object technology, which is becoming widely accepted in the information technology industry, and learn how to use the Unified Modeling Language (UML) to create a number of object models.

  Course Outline

·         Object-oriented concepts, analysis and design principles.

·         Object-oriented analysis and design techniques using the Unified Modeling Language (UML).

·         Incremental vs. iterative development

·         View-model-persistence segmentation architecture

·         Types of object relationships - aggregation, generalization, association

·         multiplicity/cardinality of object relationships and qualified associations

·         Responsibility-driven design technique

·         Use case model

·         Object interaction diagram, activity diagram

·         Deployment diagram, state transition diagram

·         CRC card

·         Encapsulation, inheritance, polymorphism

·         Packages

·         UML notation

Course #:   EC-301, ID-301

Course   :   Sun Java Web Server

  Description

This course teaches students administration of Sun Java Web Server, deployment of web-based applications with web Server.  It also explains common application server available in the market

  Objective

·         Through Knowledge of working of application servers

·         Through understanding of  Java Web Server Administration

·         Hands on experience of deployment of web-based application on Java Web Server

·         Knowledge of common issues and their resolutions

  Course Outline

·         Introduction to Web Servers

·         Understanding of Java Web Servers

·         Working with Web Servers as an Administrator

·         Working with Web Servers as an Developer

·         Step by Step administration

·        Step by Step web-based application deployment

  North American School of Information Technology

3609 Sheppard Ave. East. Scarborough, Ont. M1T 3K8

Ph: 416 –335-6178 Fax: 416-335-6179  

Course #:   EC-302, ID-203

Course   :   Web-Enabled Applications with Server-Side Java  

Description

This course teaches Java programmers how to generate HTML-based interfaces for their applications, using servlets and Java server pages (JSP). The student will use Oracle JDeveloper 3.0 to build and test components, and will learn how to deploy them for use on Web-enabled servers.

  Objective

·         Plan the use of servlets and JavaServer pages within an enterprise Java application

·         Develop and test Java server pages using Oracle JDeveloper 3.0

·         Develop and test JavaServer Pages using Oracle JDeveloper 3.0

·         Identify steps for deploying servlets on Web-enabled servers, such as Oracle Application Server 

Course Outline

·         Servlets: Architecture and Concepts

·         Developing an HTTP Servlet

·         JavaServer Pages (JSP)

·         Producing Dynamic HTML

·         Packaging for Deployment

·         Server-Side Applications

  North American School of Information Technology

3609 Sheppard Ave. East. Scarborough, Ont. M1T 3K8

Ph: 416 –335-6178 Fax: 416-335-6179  

Course #:   EC-203

Course   :   Develop Web-Based Applications with Enterprise Java Beans  

Description

This course teaches developers how to develop component-based Java applications using Enterprise JavaBeans. Participants learn how to structure distributed applications using the Enterprise JavaBeans model, and generate them with the aid of Oracle’s Java development environment, JDeveloper. The course also discusses application deployment considerations for Oracle8i and Oracle Application Server.

Objective

·         Develop Enterprise JavaBeans components using JDeveloper 3.0

·         Distribute components on Oracle8i and Oracle Application Server

·         Develop client applications that exercise the deployed components 

Course Outline

·         Java for the Enterprise - a tour: CORBA, EJB, IIOP, RMI, Business Components for Java, Enterprise Java Beans, servlets and Java server pages

·         EJB architecture and concepts

·         Developing Enterprise Java Beans

·         Generating EJB with Oracle JDeveloper 3.0

·         Developing Client Applications

·         Connecting to EJB Components

·         Using JDBC and SQLJ in an EJB Component

·         Access control for EJB: the JNDI Context Interface, protection mechanisms in Oracle8i and Oracle Application Server

·         Handling Transactions

·         Deployment considerations for Oracle8i and Oracle Application Server

  North American School of Information Technology

3609 Sheppard Ave. East. Scarborough, Ont. M1T 3K8

Ph: 416 –335-6178 Fax: 416-335-6179  

 Course #:   EC-401

Course   :   Working with XML technology  

Description

eXtensible Markup Language  (XML) offers tremendous promise as the packaging and transfer mechanism of choice for the information age. Designing, authoring and/or automatically generating, warehousing and distributing XML documents will be at the heart of every Internet-connected business in the very near future. This course will introduce you to the standards and the technology which are making this possible. Concrete examples include hands-on experience.

  Objective

-          Define role of XML in the Network Computing Architecture

-          Use of XML in real business scenarios

  Course Outline

-          Introduction to XML

-          How XML can be used

-          XML Syntax

-          Document Type Definition (DTD)

-          XML support in Netscape and Explorer

-          The Microsoft XML Parser

-          The XML DOM

-          DTD Syntax

-          DTD Elements

-          DTD Attributes

-          DTD Entities

-          DTD Validation

-          XML Workshop   

North American School of Information Technology

3609 Sheppard Ave. East. Scarborough, Ont. M1T 3K8

Ph: 416 –335-6178 Fax: 416-335-6179 

Course #:   EC-402

Course   :   Working with XSL and CSS Technology  

Description

XSL can be used to define how an XML file should be displayed by transforming the XML file into a format that is recognizable to a browser. One such format is HTML. Normally XSL do this by transforming each XML element into an HTML element. XSL can also add completely new elements into an output file, or remove elements. It can rearrange and sort the elements, test and make decisions about which elements to display, and a lot more. Cascading Style Sheets are an essential addition to HTML 4.0.

  Objective

-          Can define XSL and CSS

-          Can identify use of  XSL and CSS in real world

-          Can describe benefits of using XSL versus CSS

-          Generalize the format, layout, and presentation of your Web sites and applications 

Course Outline

eXtensible Stylesheet Language (XSL )

-          Introduction

-          Transformation

-          on the Client

-          on the Server

-          Sorting

-          Filtering

-          Conditional IF

-          Conditional Choose 

Cascading Style Sheets (CSS)

-          Introduction

-          Syntax

-          Different ways of style sheet

-          Background

-          Text

-          Font

-          Border

-          Margin

-          Padding

-          Classification

-          Positioning

  North American School of Information Technology

3609 Sheppard Ave. East. Scarborough, Ont. M1T 3K8

Ph: 416 –335-6178 Fax: 416-335-6179  

Course #:   EC-403, ID-204

Course   :   Workshop

 Description: 

This hands-on extensive workshop delivers student to develop and deploy an e-Commerce site. This will be based on case-study approach. Student will be involved from  analysis to implemtation life cycle implementation knowledge and experience. 

Objective

-          Hands-on experience of using technologies learned in this course.

-          Know practical aspects of tool used in the case-study.