Montreal College of Information Technology
Collège des technologies de l’information de Montréal English flagEN FlagFR

CERTIFICATES

Oracle PL/SQL Programming 1Z0-149
OVERVIEW

Become an Oracle PL/SQL Programmer and demonstrate an understanding of fundamental SQL concepts needed to undertake any database project. Learn in-depth knowledge of SQL and its use when working with the Oracle Database server. Gain a working knowledge of queries, insert, update and delete SQL statements as well as some Data Definition Language and Data Control Language, the optimizer, tales and indexes, data modeling, and normalization. Students who already know Oracle SQL and they need to move to next level which is PL/SQL

  • 7th August 2023
  • 36 hours
  • Contact the Advisor
  • Talk to an Advisor

Instructor led

KEY FEATURES

  • Oracle PL/SQL Programming

    Get trained by industry Experts

    Our courses are delivered by professionals with years of experience having learned first-hand the best, in-demand techniques, concepts, and latest tools.
  • Oracle PL/SQL Programming

    Official Certification curriculum

    Our curriculum is kept up to date with the latest official Certification syllabus and making you getting ready to take the exam.
  • Oracle PL/SQL Programming

    Tax Credit

    Claim up to 25% of tuition fees and education tax credit.
  • Oracle PL/SQL Programming

    Discount on Certification Voucher

    Upto 50 percent discount voucher will be provided.
  • Oracle PL/SQL Programming

    24/7 Lab access

    Our students have access to their labs and course materials at any hour of the day to maximize their learning potential and guarantee success.

COURSE OUTLINE

Oracle PL/SQL Programming

Explaining the theoretical and physical aspects of a relational database, Relating clauses in SQL Select Statement to Components of an ERD and Explaining the relationship between a database and SQL

Using Column aliases, Using The SQL SELECT statement, Using concatenation operator, literal character strings, alternative quote operator, and the DISTINCT keyword and Using Arithmetic expressions and NULL values in the SELECT statement

Applying Rules of precedence for operators in an expression , Limiting Rows Returned in a SQL Statement, Using Substitution Variables, using the DEFINE and VERIFY commands and Sorting Data

Manipulating strings with character functions in SQL SELECT and WHERE clauses, Performing arithmetic with date data, Manipulating numbers with the ROUND, TRUNC, and MOD functions and manipulating dates with the date function

Applying the NVL, NULLIF, and COALESCE functions to data, understanding implicit and explicit data type conversion, using the TO_CHAR, TO_NUMBER, and TO_DATE conversion functions and nesting multiple functions

Restricting Group Results, creating Groups of Data, using Group Functions

Using Self-joins, Using Various Types of Joins, Using Non equijoins, using OUTER joins and understanding and Using Cartesian Products

Using Single Row Subqueries, using Multiple Row Subqueries and update and delete rows using correlated subqueries

Matching the SELECT statements, using the ORDER BY clause in set operations, using The INTERSECT operator, using The MINUS operator and using The UNION and UNION ALL operators

Managing Database Transactions, Controlling transactions, perform Insert, Update and Delete operations, performing multi-table Inserts and performing Merge statements

Describing and Working with Tables, Describing and Working with Columns and Data Types, Creating tables, Dropping columns and setting column UNUSED, Truncating tables, Creating and using Temporary Tables, Creating and using external tables and Managing Constraints

This module describes working with views and the necessary operations like creating views, option check point, inserting rows in a view, upating rows in a view, and deleting a view.

Differentiating system privileges from object privileges , Granting privileges on tables and Distinguishing between granting privileges and roles

Working with CURRENT_DATE, CURRENT_TIMESTAMP,and LOCALTIMESTAMP, Working with INTERVAL data types

SKILLS ACQUIRED

WHO SHOULD APPLY?

Those who wish to use in managing and manipulating Databases for use cases in - Web Development, Data Science to build applications.
Designed for seasoned Software Professionals, who are aspiring to learn PL/SQL Programming Language in simple and easy steps to execute their day to day tasks.
If you have a basic grasp of basic concepts like database, source code, text editor and compilers, etc. If you already have an understanding on SQL and other computer programming language, then it will be an added advantage to proceed.
You are a good fit if you have a basic grasp of RDBMS concepts & proceed with Oracle database and other advanced database concepts.

Eligibility and Requirements

Learners need to possess an undergraduate degree or a high school diploma. 

 

Prerequisite

Oracle databse SQL certified associate is a prerequisite certification for this course.

Oracle Database PL/SQL Developer certification 1Z0-149

 

Upon completing this cerification course you will:

  • Receive an industry-recognized certificate from MCIT.
  •  
  • Be prepared for the official Oracle Database PL/SQL Developer certification 1Z0-149. 

INSTRUCTOR SPOTLIGHT

CALENDAR

— F.A.Q —

Definitely. Please feel free to contact our office, we will be more than happy to work with you to meet your training needs.
All of our exceptionally skilled instructors have a decent experience of training and industry experience and are AW certified in the respective field. Each of them through a rigorous selection procedure that included profile screening, technical examination, and a training demo. 
Yes, there are vouchers to take the official exam.
Upon completion of the certification course classes you will be provided with an MCIT certificate.