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 + |
ID
Course Name
Program Duration
More Info
-
Program Overview
This is a foundation course for developers planning on designing and implementing applications that make use of MySQL. This course covers essential SQL statements for data design, querying, and programming. it will also prepare students for the MySQL Developer certification.
Who will the course benefit?
• Developers who want to create applications using MySQL
• People who are preparing for the MySQL Developer certification exam
Eligibility
Program Duration
36 Hrs
What skills will the student gain?
At the end of the course, you will be able to:
• Understand the steps necessary to invoke MySQL client programs
• Utilize the general-purpose MySQL client program and the MySQL Query Browser graphical user interface (GUI) to run queries and retrieve results
• Select the best data type for representing information in MySQL
• Manage the structural characteristics of your databases and the tables within your databases
• Utilize the SELECT statement to retrieve information from database tables
• Utilize expressions in SQL statements to retrieve more detailed information
• Utilize SQL statements to modify the contents of database tables
• Write join expressions in your SQL statements to obtain information from multiple tables
• Utilize sub queries in your SQL statements
• Create views utilizing SELECT statements to produce virtual tables of specific data
• Perform bulk data import and export operations
• Create user defined variables, prepared statements and stored routines
• Create and manage triggers
• Use the INFORMATION_SCHEMA database to access metadata
• Debug MySQL applications
• Configure and Optimize MySQLCertification
Certificate of participation
SHARE THIS
-
Program Overview
This course covers the basics of the SQL language as implemented by MySQL. The course is designed to give practical experience in writing SQL statements using the MySQL client program and MySQL Query Browser. The basic SQL statements, including the use of SQL functions and the basic table and view handling statements are introduced.
Who will the course benefit?
Anyone interested in accessing and working with MySQL Database
Eligibility
Basic knowledge of database concepts
Program Duration
36 Hrs
What skills will the student gain?
At the end of the course, you will be able to:
• Install and start the MySQL server
• Understand the basics of Relational Databases
• Understand the SQL and MySQL languages
• Understand Data/Column types with regard to efficient database design
• View a database design structure/content
• Create a database design using an efficient structure
• Extract basic database information using the SELECT command
• Troubleshoot syntax and understand typical warnings and errors
• Delete or modify a database, and table row data
• Group query data with Aggregation
• Connect data from multiple table rows using JOIN
• Perform nested sub-queries
• Use of Simple Functions (String, Date, Numerical)
• Describe MySQL connectors, their major features and differences
• Understand MySQL storage engines, transactions and features of the common enginesCertification
Certificate of participation
SHARE THIS
-
Program Overview
The MySQL for Database Administrators course is the foundation course for database administrators and developers who want to use this powerful database. In this course you will learn how to secure users privileges, set resource limitations, and access controls. In addition, you will learn multiple new features such as creating and using Stored Procedures, Triggers and Views.
Who will the course benefit?
Who will the course benefit?
• Developers who want to learn how to administer MySQL
• People who want to prepare for the MySQL DBA certification
Eligibility
MySQL for Beginners
Previous knowledge of Relational Database and SQL
Program Duration
36 Hrs
What skills will the student gain?
At the end of the course, you will be able to:
• Install and Upgrade MySQL for the most common operating systems
• Utilize the MySQL Administrator Graphical User Interface (GUI) to manage a MySQL server
• Use the INFORMATION_SCHEMA database to access metadata
• Configure MySQL server options at runtime
• Evaluate data types and character sets for performance issues
• Understand data locking concepts and the different levels of locking in MySQL
• Differentiate between the multiple storage engines available in MySQL
• Perform backup and restore operations utilizing multiple MySQL tools
• Maintain integrity of a MySQL installation utilizing security protocols
• Use stored routines and triggers for administration tasks
• Manage, apply and understand the reason for using views
• Improve performance through query optimization
• Optimize Schemas (Databases) utilizing multiple techniques
• Utilize MySQL monitoring tools to improve server performance
• Compare multiple environment options to improve server performanceCertification
Certificate of participation
SHARE THIS
-
Program Overview
In this course you will learn how to develop applications in PHP and how to use MySQL efficiently for those applications. This course will help you improve your PHP skills and combine them with time-proven database management techniques to create best-of-breed web applications that are efficient, solid and secure.
Who will the course benefit?
• Developers who use PHP and MySQL to build and maintain their websites
• Developers who want to learn how PHP and MySQL can be used for the rapid prototyping and deployment of dynamic websites
Eligibility
Understand how HTML files are assembled
Understand fundamental PHP syntax
Programming experience (preferably PHP)
Some experience with relational databases
Program Duration
36 Hrs
What skills will the student gain?
At the end of the course, you will be able to:
• Design web-based applications
• Design schemas based on MySQL
• Use include files to make code easier to maintain
• Use PHP 5 and takes advantage of its advanced features
• Build applications following a precise flow
• Authenticate users in a secure way against a database
• Handle errors in your PHP applications efficiently and gracefully
• Writes composite queries using JOINs and sub queries
• Use indexing efficiently in order to manipulate large amounts of data efficiently
• Uses joins to extract data from multiple tables
• Uses GROUP BY clauses and aggregate functions
• Write applications whose components can be scaled to meet increased demand
• Build a complete application that includes authentication and session management
• Understand how PHP, MySQL and the Apache web server work together to deliver dynamic web contentCertification
Certificate of participation
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
Learn More
-
Our Assurence
Learn More
