Humber
SEARCH
2012-13 Full-Time Programs
  • Increase
  • Normal
  • Decrease

Current Size: 100%

PROGRAM SEARCH


School of Media Studies & Information Technology

Program Availability

North
Fall 2012:
Open
Type:
Ontario Graduate Certificate
Postgraduate
Campus: North
Program Code:
2094S
2094L
Length:

Two semesters, beginning in September

CONTACT INFORMATION:
Ravinder-Pal Singh, program co-ordinator | 416.675.6622 ext. 5612 | ravinder-pal.singh@humber.ca
  • Our Program

    Humber’s Enterprise Software Development program provides the advanced concepts, skills and knowledge that those currently working in the field, or who are graduates of an information technology or computer studies program, need to increase their employment opportunities in the field of enterprise software development or enterprise database administrator.

    Your Career

    Your Career

    With the highest levels of broadband penetration and the lowest overall communication costs of almost any country in the world, it’s not surprising that Canada has an edge over its competitors when it comes to software development. Canada’s software advantage starts with its world-renowned workforce and mature, technologically advanced telecommunications infrastructure, which provides the backbone for all technology businesses.

    Work as a database administrator, database designer, Oracle programmer, enterprise software developer, junior software developer, intermediate software developer, programmer/analyst, website designer, web programmer, or programmer of mobile devices.
     

  • Admission Requirement
    • A bachelor’s degree in Computer Science or Information Technology. Inter­national credentials will be validated to Canadian standards
    • Proficiency in a C# and Java programming language for Enterprise Software Solutions profile or SQL and database management concepts for Oracle Solutions profile is also required
    • Submission of a detailed resumé describing academic background and work experience (this should include information that indicates an understanding of what the applicant brings to the field)
    • Pre-admissions testing for communi­cation skills and programming at the college level might be required. As a condition of admission, students might be required to take an additional communications course to enhance their written and oral skills, at an additional cost
    • If English is not your first language visit the English Language Proficiency Policy


    Note: For more information visit Selection Procedures.

    Meeting the minimum requirements does not guarantee admission to the program.

    Additional Requirements

    Students are required to own or have guaranteed access to an Internet-enabled personal computer in their home or place of residence.

  • Fees

    The 2012/2013 fee for two semesters is

    – domestic $6,220.46
    – international $12,800.

    Amounts listed are the total of tuition, lab and material fees, student service and auxiliary fees for the first two semesters of the 2012/2013 academic year.

    Fees are subject to change.

    For more information visit Fees and Financial Assistance.

    Additional Costs
    Additional Costs

    Costs vary by profile for textbooks, lab fees, and course packs. 2012/2013 projected ex­penses: $800 – Enterprise Software Solutions Profile. Oracle Solutions Profile: Expenses for students choosing to use Oracle-approved resources will not exceed $2,500.

Curriculum
  • Semester 1 - Enterprise Software Solutions Profile (2094S)

    Course CodeCourseCredits
    ISDV 515XML and Web Services

    XML and Web Services

    Course Code: ISDV 515
    Credits: 4
    Students will learn the extensible markup language (XML), including how to write documents, define new documnet types, and parse and manipulate documents. This will be used as a basis for understanding the technologies used in web services. The web service technologies examined include SOAP (simple object access protocol) for invoking services, WSDL (web service definitiion language) for describing the services and UDDI (universal description, discovery and integration) for locating services. Techniques for securing web services will be presented as well as design patterns for web services.
    4
    ISDV 516WPF Applications

    WPF Applications

    Course Code: ISDV 516
    Credits: 4
    This course covers the Windows Presentation Foundation (WPF), a new presentation framework for Windows XP and Windows Vista. For developers, WPF is a group of new technologies, including a new graphics engine that supports 3D graphics, animation, and more. The structure of the Windows UI is undergoing a radical change offering a new model for user and application controls.
    4
    ISDV 517Web Components

    Web Components

    Course Code: ISDV 517
    Credits: 4
    This course is designed to exited 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.
    4
    ISDV 518Building Applications for Mobile Devices

    Building Applications for Mobile Devices

    Course Code: ISDV 518
    Credits: 4
    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.
    4
    ISDV 528J2EE Business Component

    J2EE Business Component

    Course Code: ISDV 528
    Credits: 4
    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.
    4

    Semester 2

    Course CodeCourseCredits
    ISDV 546Applications Security

    Applications Security

    Course Code: ISDV 546
    Credits: 4
    Computer security has become much more important since the introduction of the internet. All too often security breaches occur not from high-tech attacks but from the failure of the programmer to incorporate simple security strategies into their work. This course introduces the security concepts and features of both Microsoft's .NET platform and Java and explores when and where to apply them. The course provides background material on computer security by investigating system vulnerabilities and leveraging both the Java and .NET APIs to meet these threats.
    4
    ISDV 548Distributed Applications Development Using .NET

    Distributed Applications Development Using .NET

    Course Code: ISDV 548
    Credits: 4
    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.
    4
    ISDV 549Advanced Web Components for Development

    Advanced Web Components for Development

    Course Code: ISDV 549
    Credits: 4
    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.
    4
    ISDV 550Enterprise Application Modelling

    Enterprise Application Modelling

    Course Code: ISDV 550
    Credits: 4
    ESA (Enterprise Services Architecture) offers a sound, flexible architecture for adapting business processes in response to changing market conditions. Harnessing web services, and EDI (electronic data interchange) and legacy applications, has become the goal of most modern organizations. SOA (service-oriented architecture) 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.
    4
    ISDV 552IT Management

    IT Management

    Course Code: ISDV 552
    Credits: 3
    In this 45-hour course students study the structure of different organizations and the impact of organizational structure on the operations and productivity of the organization. The impact of organizational culture and climate on the growth of employees in an organization and the development of creative leadership are also covered. Organizational values, attitudes and ethical issues are discussed. The impact of technology (particularly information technology) and its applications on organizational change are introduced. Guest speaker presentations and case studies will form a significant component of this course. Assignments will be directly linked to guest speaker presentations.
    3
    WORK 510Career Connections

    Career Connections

    Course Code: WORK 510
    Credits: 2
    In this 45-hour course students study the structure of different organizations and the impact of organizational structure on the operations and productivity of the organization. The impact of organizational culture and climate on the growth of employees in an organization and the development of creative leadership are also covered. Organizational values, attitudes and ethical issues are discussed. The impact of technology (particularly information technology) and its applications on organizational change are introduced. Guest speaker presentations and case studies will form a significant component of this course. Assignments will be directly linked to guest speaker presentations.
    2

    Semester 1 - Oracle Solutions Profile (2094L)

    Course CodeCourseCredits
    ISDV 511Oracle Database Administration Workshop 1

    Oracle Database Administration Workshop 1

    Course Code: ISDV 511
    Credits: 4
    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.
    4
    ISDV 512Oracle Application Server Administration

    Oracle Application Server Administration

    Course Code: ISDV 512
    Credits: 4
    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 JDBC connection. This course is designed to prepare you for the corresponding Oracle Certified Associate exam.
    4
    ISDV 513Oracle Database Program with PL/SQL

    Oracle Database Program with PL/SQL

    Course Code: ISDV 513
    Credits: 4
    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.
    4
    ISDV 514Oracle Warehouse Fundamentals and Design

    Oracle Warehouse Fundamentals and Design

    Course Code: ISDV 514
    Credits: 4
    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 ETL(extract, transform, load) process for data warehouses.
    4
    ISDV 552IT Management

    IT Management

    Course Code: ISDV 552
    Credits: 3
    In this 45-hour course students study the structure of different organizations and the impact of organizational structure on the operations and productivity of the organization. The impact of organizational culture and climate on the growth of employees in an organization and the development of creative leadership are also covered. Organizational values, attitudes and ethical issues are discussed. The impact of technology (particularly information technology) and its applications on organizational change are introduced. Guest speaker presentations and case studies will form a significant component of this course. Assignments will be directly linked to guest speaker presentations.
    3

    Semester 2

    Course CodeCourseCredits
    ISDV 536Oracle Database Administration Workshop 2

    Oracle Database Administration Workshop 2

    Course Code: ISDV 536
    Credits: 4
    This course takes your Oracle 11 g, DBA (database administrator) training to the next level and prepares you for OCP (Oracle Certified Professional) certification. With it you'll learn about RMAN (Oracle recovery manager) and Oracle backup and recovery strategies in depth. You will build an ASM (automatic storage management) database and learn about tuning, database performance, resource and memory management, scheduling and Oracle flash back technologies. You will not only learn the theory but will apply it hands on in the comprehensive labs that accompany the course material.
    4
    ISDV 538Oracle Database SQL Tuning

    Oracle Database SQL Tuning

    Course Code: ISDV 538
    Credits: 4
    This course is designed to give the experienced SQL developer or DBA (database administrator) a firm foundation in SQL tuning techniques. The participant learns the necessary knowledge and skills to effectively tune SQL in the Oracle Database 10g. They learn about tuning methodology as well as proactive tuning and reactive tuning methods. Students are introduced to the benefits of the new automatic tuning mechanisms available in Oracle Database 10g. On completion of the course they are able to compare and contrast the steps involved to tune manually as in prior releases, as well as use the automatic SQL tuning features provided in the current release. Students gain a thorough conceptual understanding of the Oracle Optimizer, and reinforce instructor-led learning with structured hands-on practices. The course uses a series of challenge-level workshops, allowing students to play, discover, and learn at their own level and pace. The students learn to use the Oracle diagnostic tools and facilities: Automatic SQL Tuning components, EXPLAIN, SQL Trace and TKPROF, SQL*Plus AUTOTRACE. Students also learn to influence the behaviour of the optimizer by changing the physical schema and modifying SQL statement syntax.
    4
    ISDV 541Oracle Database Security

    Oracle Database Security

    Course Code: ISDV 541
    Credits: 4
    In this course, the students learn how they can use Oracle database features to meet the security requirements of their organization. They learn how to secure their database and how to use the database features, and progresses to basic Oracle Network features. Also covered are using Connection Manager as a firewall, middle tier authentication, virtual private database, various forms of database auditing, and introductions to Oracle Label Security and Enterprise Identity Management.
    4
    ISDV 542Oracle Data Warehouse Implementation

    Oracle Data Warehouse Implementation

    Course Code: ISDV 542
    Credits: 4
    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 ETL (extract, transform, load) 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. Tuning, backup and recovery topics will also be discussed.
    4
    ISDV 545Business Intelligence

    Business Intelligence

    Course Code: ISDV 545
    Credits: 3
    In this hands-on course, students learn how to use the features of OLAP (online analytical processing) 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 (AWM10g) toolkit, enhancing analytic content, and using tools for OLAP analysis. Students will also learn concepts and terminology, and create dimensions and cubes with the AWM10g. Analytical reports that access the multidimensional data in the analytical workspace will be built using Oracle Discoverer Plus OLAP. Students will learn how to use Discoverer Plus to query, report, and analyze corporate data. They will learn how to use Discoverer Plus Relational to perform ad hoc analyses against relational data sources, and how to use Discoverer Plus OLAP to perform analysis on OLAP data that resides in a multidimensional data source.
    3
    WORK 510Career Connections

    Career Connections

    Course Code: WORK 510
    Credits: 2
    In this hands-on course, students learn how to use the features of OLAP (online analytical processing) 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 (AWM10g) toolkit, enhancing analytic content, and using tools for OLAP analysis. Students will also learn concepts and terminology, and create dimensions and cubes with the AWM10g. Analytical reports that access the multidimensional data in the analytical workspace will be built using Oracle Discoverer Plus OLAP. Students will learn how to use Discoverer Plus to query, report, and analyze corporate data. They will learn how to use Discoverer Plus Relational to perform ad hoc analyses against relational data sources, and how to use Discoverer Plus OLAP to perform analysis on OLAP data that resides in a multidimensional data source.
    2
Curriculum Notes

The curriculum for this program is continually modified to reflect current trends.

  • Humber offers pathways from Ontario college diplomas to Humber degrees. Find out where your diploma can take you.

    You can also choose another postsecondary institution. Humber has formal articulation agreements indicating the specific transfer arrangements from a Humber program to a particular degree program, as well as general policies on admissions at specific institutions. Click here to find out more.

Canada's Top Employers for Young People 2011Best Employers for New Canadians 2012Greater Toronto's Top Employers 2012
Humber North Campus | Humber Lakeshore Campus | Humber Orangeville Campus | 416.675.3111 | enquiry@humber.ca