Oracle Database Developer – SQL and PL/SQL Training

Current Status
Not Enrolled
Price
Closed
Get Started

With over 5+ years of specialized expertise in the sector, our training instructor has meticulously crafted the Oracle Database Developer – SQL and PL/SQL course/training to ensure comprehensive mastery of the subject. The Oracle Database Developer – SQL & PL/SQL Training begins with a brief overview of the fundamental concepts that you will need to grasp and understand. In addition, you will learn how to use variables, structured programming, and the INTO clause. We have also included a few practical sessions during the course to help you comprehend the concepts better. By the end of this course, you will learn how to utilize SQL and PL/SQL.

In This Module We Will Learn :

ORACLE SQL

  • Basic concepts relating to databases 
  • Relational data model 
  • Transactional databases
  • DBMS architecture
  • Versions and licenses, 
  • Available tools, 
  • Work environment configuration
  • Displaying data retrieved from the database 
  • Sorting and limiting the number of rows returned 
  • Using alternative column names – aliases 
  • Basic mathematical operations and string concatenation 
  • Data filtering 
  • Substitution of variables during query execution 
  • NULL value and its handling in database 
  • Elimination of repetitive rows – DISTINCT clause
  • Logical operators of conjunction and negation of conditions 
  • Comparison operators (>, >=, =, <, <=, <>, !=) 
  • Range operator (BETWEEN) 
  • Membership operator (IN) 
  • Pattern operator (LIKE) 

ORACLE SQL

  • Date and time operations 
  • Operations on character types 
  • Numeric functions
  • Conditional functions, logical operators (CASE, DECODE, COALESCE, NVL, NVL2) 
  • Implicit type conversion 
  • Functions relating to type conversion: TO_CHAR, TO_DATE, TO_NUMBER
  • Use of functions in all places of the query 
  • Grouping functions 
  • Filtering rows after aggregation 
  • UNION, UNION ALL, MINUS, INTERSECT operators 
  • Control of the order of rows returned by operations on sets

ORACLE PL/SQL

  • Structure of a package and dependencies 
  • Running packages 
  • Polymorphism in packages (overloading) 
  • Embedded packages 
  • DML triggers at command and line level 
  • DML triggers on views 
  • DDL command triggers 
  • Triggers on system events 
  • The need to use dynamic SQL, contraindications 
  • Native dynamic SQL 
  • DBMS_SQL package 

ORACLE SQL

  • Creating, deleting and modifying tables, column types 
  • Constraints, primary and foreign keys 
  • Creating simple and complex views 
  • Schemas in a database 
  • Other database objects: indexes, synonyms (public and private), sequences
  • Commit, rollback transactions, save points
  • Locks on concurrent execution of operations
  • Deadlocks
  • UNDO space principle and FLASHBACK operations

ORACLE PL/SQL

  • Lexical units and conventions 
  • Anonymous blocks and programs
  • Executable block and declaration block
  • Running anonymous blocks and programs
  • Control instructions: conditions, loops

ORACLE PL/SQL

  • Use of SQL functions 
  • Exception handling, typical built-in exceptions 
  • Creating your own exceptions 
  • Labels, name visibility ranges, nested blocks
  • Implicit and explicit cursors 
  • Parameterized cursors
  • Row locking (FOR UPDATE clause)
  • WHERE CURRENT OF clause 

Similar Courses:

Oracle HCM Lab Training – Part 2

Oracle HCM Lab Training – Part 2

Immerse yourself in a comprehensive learning experience with our HCM Lab Training - Part 2,…

Oracle PPM Lab Training

Oracle PPM Lab Training

This immersive course equips you with the skills to conquer your projects using Oracle PPM.…

Oracle HCM Labs Training – Part 1

Oracle HCM Labs Training – Part 1

Delve into a thorough learning experience through our Core HR Lab training, including hands-on expertise…

Oracle Financials Labs Training

Oracle Financials Labs Training

Embark on a transformative journey with our Oracle Financials Lab Training, a comprehensive program tailored…