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
Instructor led
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.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.Tax Credit
Claim up to 25% of tuition fees and education tax credit.Discount on Certification Voucher
Upto 50 percent discount voucher will be provided.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.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
Interested in gaining IT knowledge and enter into real world IT domain, switching carears in IT or applying for entry level positions
Oracle Database PL/SQL Developer certification 1Z0-149.
Upon completing this cerification course you will: