514 312 2383 | info@montrealcollege.ca |
French
|
|
Continuing Education
Official partner programs
Certification Programs
We Also Offer :
Programs Overview
To succeed in today's competitive job market, whether looking for new opportunities or advancing in your current position, you need to build and demonstrate your technology expertise and skills. When evaluating new candidates or considering the competencies of existing staff, employers recognize the value of a 'certification'. A certification provides the recognition you need to excel in your career and a validation of your skills to employers.Montreal College offers certification courses from Oracle, Microsoft, Sun, and SAP as a part of continuing education.
What are certification programs?
To succeed in today's competitive job market, whether looking for new opportunities or advancing in your current position, you need to build and demonstrate your technology expertise and skills. When evaluating new candidates or considering the competencies of existing staff, employers recognize the value of a 'certification'. A certification provides the recognition you need to excel in your career and a validation of your skills to employers.Montreal College offers certification courses from Oracle, Microsoft, Sun, and SAP as a part of continuing education.
Who should enroll a certification program?
Working professionals in IT who can get certified and improve their career prospects.Engineering & IT students who use these courses to fill the gap in their college education and
to add international certifications to their resume.
College students who wish to build advanced IT skills and get certifications recognized by IT
companies.
Why should you enroll a certification program?
Courses enjoy industry-wide recognition from all IT employers.Employers prefer the quality assurance that comes with hiring certified professionals.
Surveys show that certified professionals enjoy better salaries and better career advancement
opportunities.
• Increased opportunity to earn 21% more on average than your non certified counterparts.
• Certifications provide a distinct edge over other IT professionals.
TOP 10 JOB TRENDS AND SALARY PROFILE
| S.No | Job Title | National Average Salaires |
|---|---|---|
| 1 | Architects | $ 72,000 - $ 120,000 |
| 2 | Business Analysts | $ 50,000 - $ 100,000 |
| 3 | Business Intelligence Analyst | $ 65,000 - $ 93,500 |
| 4 | Data Analyst / Report Writers | $ 60,000 - $ 85,250 |
| 5 | Package Software Specialist - ERP | $ 79,000 - $ 120,000 |
| 6 | Web 2.0 Developers | $ 55,750 - $ 81,000 |
| 7 | Systems / Network Administrator | $ 64,000 - $ 75,000 |
| 8 | Systems and Application Integrators | $ 40,000 - $ 100,000 + |
Most popular Oracle courses offered in line with industry demand for professionals are as follows:
We Also Offer
- Tax incentives up to 36% of education fees.
- Discount plans for many of our offerings
- Flexible schedules day & night
- Tailor made content by industry pros
ID
Course Name
Program Duration
More Info
-
Program Overview
The Oracle Certified Associate (OCA): SQL Fundamentals course introduces you to the fundamentals of SQL using Oracle Database 11g database technology. In this course you learn the concepts of relational databases and the powerful SQL programming language. This course provides the essential SQL skills that allow developers to write queries against single and multiple tables, manipulate data in tables, and create database objects.
The participants also learn to use single row functions to customize output, use conversion functions and conditional expressions and use group functions to report aggregated data. Demonstrations and hands-on practice reinforce the fundamental concepts.
In this course, you use Oracle SQL Developer as the main tool and SQL*Plus is introduced as an optional tool.
Who will the course benefit?
Students and working professionals wishing to gain expertise in SQL
Eligibility
Prior knowledge of data processing concepts and techniques
Program Duration
36 HrsWhat skills will the student gain?
After the completion of this course, you will be able to:
• Retrieve row and column data from tables with the SELECT statement
• Create reports of sorted and restricted data
• Employ SQL functions to generate and retrieve customized data
• Display data from multiple tables using the ANSI SQL 99 JOIN syntax
• Create reports of aggregated data
• Use the SET operators to create subsets of data
• Run data manipulation statements (DML) to update data in the Oracle Database 11g
• Run data definition language (DDL) statements to create and manage schema objects
• Identify the major structural components of the Oracle Database 11g
Certification
Certificate of participation This course prepares you for exam 1Z0-047: Oracle SQL expert. On passing this, you will be Oracle Certified SQL Expert
SHARE THIS
-
Program Overview
The Oracle Certified Associate (OCA): Oracle Database 11 G PL/SQL Developer certification course enables participants to create PL/SQL blocks of application code that can be shared by multiple forms, reports, and data management applications. Participants learn to create anonymous PL/SQL blocks as well as stored procedures and functions.
Participants learn to develop, execute, and manage PL\SQL stored program units such as procedures, functions, packages, and database triggers. You will also learn to manage PL/SQL subprograms, triggers, declaring identifiers and trapping exceptions.
This course is a combination of Oracle Database 11 G: PL/SQL Fundamentals and Oracle Database 11 G: Develop PL/SQL Program Units courses. This is appropriate for a 10g audience too. There are few minor changes between 10g and 11g features.
Participants use Oracle SQL Developer to develop these program units. SQL*Plus and JDeveloper are introduced as optional tools.Who will the course benefit?
Students and working professionals who wish to gain expertise in PL /SQL programming.
Eligibility
Prior knowledge of Oracle Database 11g: Introduction to SQL
Program Duration
36 Hrs
What skills will the student gain?
After the completion of this course, you will be able to:
• Use conditional compilation to customize the functionality in a PL/SQL application without removing any source code
• Create and use stored procedures and functions
• Design and use PL/SQL packages to group and contain related constructs
• Create overloaded package subprograms for more flexibility
• Use the Oracle supplied PL/SQL packages to generate screen output, file output, and mail output
• Write dynamic SQL for more coding flexibility
• Describe the features and syntax of PL/SQL
• Use PL/SQL programming constructs and conditionally control code flow (loops, control structures, and explicit cursors)
• Manage dependencies between PL/SQL subprograms
• Handle runtime errors
• Describe stored procedures and functions
• Design PL/SQL code for predefined data types, local subprograms, additional pragmas and standardized constants and exceptions
• Create triggers to solve business challenges
• Design PL/SQL anonymous block that execute efficientlyCertification
Certificate of participation Additionally, students can appear for Oracle Certified Associate (OCA): PL/SQL Developer certification (exam: 1Z1:144) Prerequisite:- OCA: Oracle Database 11G: SQL Fundamentals certification (exam: 1Z0-051) is a prerequisite for attaining OCA: Oracle Database 11 G PL/SQL Developer certification
SHARE THIS
-
Program Overview
This course provides step-by-step procedures for building and verifying the three layers of an Oracle BI repository. Students begin by using the Oracle BI Administration Tool to construct a simple repository to address a fictitious company's business requirements, import schemas, design and build logical business models, and expose business models to users in the Oracle BI user interface. In the process of constructing the repository, they learn how to build physical and logical joins, simple measures, calculation measures and learn how to validate their work by creating and running analyses, and verifying query results using the query log.
Who will the course benefit?
Application Developers, Business Analysts, Business Intelligence Developer, Data Modelers, Data Warehouse Administrator, Data Warehouse Analyst, Data Warehouse Developer, Reports Developer: Wanting to pursue carriers in Oracle Business Intelligence.
Eligibility
Prerequisites
Required Prerequisites:
Basic SQL
Data warehouse design
Database design
Dimensional modeling
Suggested Prerequisites
Oracle BI 11g R1: Create Analyses and Dashboards
Program Duration
36 Hrs.What skills will the student gain?
Use the Oracle BI Administration Tool to build, manage, and maintain an Oracle BI repository. Build a dimensional business model to address business intelligence requirements. Build and execute analyses to test and verify a dimensional business model analyses. Use the Oracle BI Administration Tool to administer Oracle BI Server.
Certification
SHARE THIS
-
Program Overview
This course provides step-by-step instructions for creating analyses and dashboards, which compose business intelligence applications. Participants learn how to administer the Oracle BI Presentation Catalog and to build a simple Oracle BI dashboard starting with basic analyses, then adding more complexity as the course progresses. Participants learn to include pivot tables, graphs, gauges, maps, prompts, embedded content, navigation links, and KPIs on the dashboards. Participants also use Oracle BI Delivers to send real-time, personalized alerts to dashboards and for subscribed users, and are introduced to the use of Oracle Business Intelligence Mobile in accessing BI content on their mobile devices. Participants are introduced to the use of Oracle BI for Microsoft Office to integrate Oracle BI data and views in Microsoft Office presentations and spreadsheets. Participants create KPIs and add KPIs to a dashboard. Finally, they explore the use of Oracle BI Briefing Books.
Who will the course benefit?
Application Developers, Business Analysts, Business Intelligence Developer, Developer, End Users, Functional Implementer, Technical Administrator and Technical Consultant interested in pursuing career in Oracle Business Intelligence.
Eligibility
Oracle SQL Fundamentals.
Program Duration
36 HrsWhat skills will the student gain?
Learn To:
Build analyses and dashboards.
Build and use views and graphs in analyses.
Create analyses using Essbase data sources.
Create and work with KPIs.
Create and modify Oracle BI Dashboards.
Use Oracle Business Intelligence Mobile to access BI content.
Use BI content in Microsoft Office applications.
Configure, schedule, and deliver personalized alerts using Oracle BI Delivers
Certification
SHARE THIS
-
Program Overview
The Oracle Certified Associate (OCA): Oracle 11 G Administrator certification is designed to give you a firm foundation in basic administration of Oracle Database 11g. In this class, participants learn how to install and maintain Oracle Database 11g. Students 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. The lesson topics are reinforced with structured hands-on practices.
Who will the course benefit?
Students and working professionals who wish to gain expertise in Database Administration.
Eligibility
Prior knowledge of SQL
Program Duration
36 HrsWhat skills will the student gain?
After the completion of this course, you will be able to:
• Describe Oracle Database Architecture
• Install and configure Oracle Database 11g
• Configure Oracle Net services
• Manage the database storage structures
• Create and administer user accounts
• Perform basic backup and recovery of a database
• Manage users and schemas
• Manage data and concurrency
• Monitor and administer undo data
• Backup and recover a database
• Monitor performance
• Use the database diagnostic monitor
Certification
Certificate of participation Additionally, students can appear for Oracle Certified Associate (OCA) Oracle Database 11G Administrator certification (exam 1Z0-052) Prerequisite:- OCA: Oracle Database 11G: SQL Fundamentals certification (exam: 1Z0-051) is a prerequisite for attaining OCA: Oracle Database 11 G Administrator
SHARE THIS
-
Program Overview
The Oracle Certified Associate (OCA): Oracle Database 11 G Administration certification is designed to provide you with the concepts and architecture that support backup and recovery. It provides hands-on experience to define and test your own backup and recovery scenarios.
Also, the participants learn to manage memory effectively and to perform some performance evaluation and tuning tasks, including using some of the advisors. All types of flashback technologies, scheduling jobs inside and outside of the database, and controlling system resource usage are covered. Topics are reinforced with hands-on practices.
Who will the course benefit?
Students and working professionals who wish to gain expertise in Oracle Database Administration
Eligibility
Oracle Database 11 G: Administration Workshop I
Program Duration
36 HrsWhat skills will the student gain?
After the completion of this course, the student will be able to:
• Describe the Oracle Architecture
• Identify the features of the Oracle Universal Installer
• Start-up and Shutdown of an Oracle instance
• Describe the process of Database Creation
• Build Data Dictionary and Dynamic Performance Views
• Use Control File and Redo Log Files
• Manage Table Spaces and Data Files
• Create and use different types of Indexes
• Manage Resources and Privileges
• Build Auditing Functions
• Describe and use Globalization support in Oracle
Certification
Certificate of participation Additionally, students can appear for Oracle Certified Professional (OCP) Oracle Database 11 G Administration certification (exam 1Z0-053) Prerequisite:- OCA: Oracle Database 11G: SQL Fundamentals certification (exam: 1Z0-051) and OCA: Oracle Database 11G Administrator certification (exam 1Z0-052) are a prerequisite for attaining OCP: Oracle Database 11 G Administration certification
SHARE THIS
-
Program Overview
This course offers students an introduction to the general features and capabilities of Oracle Database 10g Release 2 for Oracle Real Application Clusters (RAC). Students learn how to install and administer OracleClusterware, Real Application Clusters, and Automatic Storage Management. Students also learn how to administer their Database in a Real Application Clusters environment using Enterprise Manager Grid Control. Increase your efficiency by learning how to configure and use database services as well as the Load Balancing Advisory in a RAC environment. Learn how to add and remove nodes in clusters and how to patch both Oracle Clusterware and Real Application Clusters software in a rolling fashion.
This course counts toward the Hands-on course requirement for the following certifications
• Oracle Database 10g Administrator Certification
• Oracle Database 10g: Real Application Clusters Administrator Certified Expert
Who will the course benefit?
• Data Warehouse Administrator
• Database Designers
• Database Administrators
• System Analysts
• Project Manager
• Technical Administrator
• Support Engineer
• Technical Consultant
Eligibility
• Oracle Enterprise Manager 10g Grid Control
• Oracle Database 10g: Administration Workshop I Release 2
• Oracle Database 10g: Administration Workshop II Release 2
Program Duration
36 HrsWhat skills will the student gain?
After the completion of this course, you will be able to:
• Identify common data structures
• Gather requirements
• Create a baseline project
• Prepare reusable metadata
• Model for predictable results
• Create calculations and filters
• Implement a time dimension
• Create the presentation view
• Create analysis objects
• Manage OLAP data sources
• Set Security
• Manage packages
• Basic model maintenance and extensibility
• Working with different query subject types
• Identify generated SQL and complex queries
• Optimize and tune Framework Manager model
• Work in a multi-modeler environment
• Use advanced parameterization techniques
• Manage MUNs and model for drill-through
• Employ additional modeling techniques
Certification
Certificate of participation Additionally, participants can appear for the Oracle
SHARE THIS
-
Program Overview
The Oracle Certified Professional (OCP): Oracle Database 11 G Advanced PL/SQL course, you will learn to use the advanced features of PL/SQL in order to design and tune PL/SQL to interface with the database and other applications in the most efficient manner. Using advanced features of program design, packages, cursors, extended interface methods, large objects, and collections, students learn to write powerful PL/SQL programs. Students also learn programming efficiency, use of external C and Java routines, fine-grained access and safeguarding code against SQL Injection attacks.
Who will the course benefit?
Students and working professionals who wish to gain expertise in Advanced PL/SQL programming.
Eligibility
Prior knowledge of Oracle 11 G Database SQL and PL/SQL courses is essential
Program Duration
36 HrsWhat skills will the student gain?
After the completion of this course, you will be able to:
• Tune PL/SQL code
• Categorize and explain various types of SQL injection attacks
• Apply coding standards to eliminate SQL injection vulnerabilities
• Create subtypes based on existing types for an application
• Create and use collections
• Execute external C programs from PL/SQL
• Execute Java programs from PL/SQL
• Describe the process of fine-grained access control
• Create and maintain LOB data types
• Use the DBMS_LOB PL/SQL package to control LOBs
• Describe SecureFile LOB features
• Identify guidelines for cursor design
• Enable SecureFile LOB de-duplication, compression, and encryption
• Improve memory usage by caching SQL result sets
• Set up PL/SQL functions to use PL/SQL result caching
• Profile PL/SQL applications
Certification
Certificate of participation Additionally, students can appear for Oracle Certified Professional (OCP): Oracle Database 11 G: Advanced PL/SQL Developer certification (exam: 1Z0-146) Prerequisite:- OCA: Oracle Database 11G: SQL Fundamentals certification (exam: 1Z0-051) and OCA: Oracle Database 11 G PL/SQL Developer certification (exam: 1Z1: 144) is a prerequisite for attaining OCP: Oracle 11 G: Advanced PL/SQL Developer certification
SHARE THIS
-
Program Overview
Oracle Database 11g: New Features for Administrators (1Z0-050) Upgrade gives students the opportunity to learn about-and practice with the new change management features and other key enhancements in Oracle Database 11g. Students examine the benefits and use of the new features in managing change, diagnosing and recovering from problems, ensuring high availability, improving scalability and performance, strengthening security, and several other areas that concern database administrators. In addition, the hands-on practice sessions help reinforce students understanding of these new capabilities in Oracle Database 11g.
Who will the course benefit?
Eligibility
Students must be Oracle 10g DBA Certified Professionals to attend this course.
Program Duration
36 Hours
What skills will the student gain?
Oracle Database 11g: New Features for Administrators (1Z0-050)
Course Outline
Oracle 11g Grid Infrastructure
- ASM File System
- ASM File System Snapshot
- ASM DiskGroups
Oracle 11g Installation
- Install Oracle 11g R2
- Upgrade Enhancements
- Online Patching
ASM Modifications
- ASM Fastmirror resync
- ASM Disk Group Compatibility
- ASM Performance Enhancements
Storage Enhancements
- Table Compressions
- SQL Access Advisor
- Segment Creation
Partitioning Enhancements
- Degree of Parallelism
- In Memory Parallel Query
- System Managed Indexes
Oracle SecureFiles
- Creating SecureFiles
- SecureFile Compression
- SecureFile Metadata
- Migrating SecureFiles
Security Changes
- SecurePassword
- Default Auditing
- Database Administrator Authentication
- Tablespace Encryption
Sql Performance Analyzer
- Sql Performance Analyzer Overview
- Using SQL Performance Analyzer
- Database Replay
Automatic Diagnostic Repositoty
- Using ADR
- SQL Health Checks
- SQL Monitoring
- Virtual Private Catalogs
- New Backup Compression
- Data Recovery Advisor
Certification
Oracle Database 11g: New Features for Administrators (1Z0-050)
Oracle Partners passing this exam will be recognized as OPN Certified Specialists
SHARE THIS
REGISTER NOW: Information session
VISIT: Pricing and Schedules
-
Hands on Instructor Led Training
Register For Information Session
Our Instructor led classrooms are dedicated to give each student individual attention Learn More
-
Get Tax Incentives
Eligible For 36% Tax Incentive
Join Our Training Program and Claim 36% Educational Tax Incentive.
Learn More -
Down Town Location
McGILL METRO
Easy To Reach - Montreal Downtown Location.
Learn More -
Intensive Training
Call Us Today
-
Our Assurence
