Current Size: 100%
Enterprise Software Development |
School of Media Studies & Information Technology |
Program AvailabilityNorth 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
|
||
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.
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.
Note: For more information visit Selection Procedures.
Meeting the minimum requirements does not guarantee admission to the program.
Students are required to own or have guaranteed access to an Internet-enabled personal computer in their home or place of residence.
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.
Costs vary by profile for textbooks, lab fees, and course packs. 2012/2013 projected expenses: $800 – Enterprise Software Solutions Profile. Oracle Solutions Profile: Expenses for students choosing to use Oracle-approved resources will not exceed $2,500.
Semester 1 - Enterprise Software Solutions Profile (2094S) | ||
| Course Code | Course | Credits |
| ISDV 515 | XML and Web ServicesXML and Web ServicesCourse 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 516 | WPF ApplicationsWPF ApplicationsCourse 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 517 | Web ComponentsWeb ComponentsCourse 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 518 | Building Applications for Mobile DevicesBuilding Applications for Mobile DevicesCourse 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 528 | J2EE Business ComponentJ2EE Business ComponentCourse 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 Code | Course | Credits |
| ISDV 546 | Applications SecurityApplications SecurityCourse 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 548 | Distributed Applications Development Using .NETDistributed Applications Development Using .NETCourse 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 549 | Advanced Web Components for DevelopmentAdvanced Web Components for DevelopmentCourse 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 550 | Enterprise Application ModellingEnterprise Application ModellingCourse 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 552 | IT ManagementIT ManagementCourse 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 510 | Career ConnectionsCareer ConnectionsCourse 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 Code | Course | Credits |
| ISDV 511 | Oracle Database Administration Workshop 1Oracle Database Administration Workshop 1Course 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 512 | Oracle Application Server AdministrationOracle Application Server AdministrationCourse 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 513 | Oracle Database Program with PL/SQLOracle Database Program with PL/SQLCourse 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 514 | Oracle Warehouse Fundamentals and DesignOracle Warehouse Fundamentals and DesignCourse 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 552 | IT ManagementIT ManagementCourse 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 Code | Course | Credits |
| ISDV 536 | Oracle Database Administration Workshop 2Oracle Database Administration Workshop 2Course 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 538 | Oracle Database SQL TuningOracle Database SQL TuningCourse 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 541 | Oracle Database SecurityOracle Database SecurityCourse 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 542 | Oracle Data Warehouse ImplementationOracle Data Warehouse ImplementationCourse 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 545 | Business IntelligenceBusiness IntelligenceCourse 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 510 | Career ConnectionsCareer ConnectionsCourse 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 |
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.
