SQL is a structured query language. Databases access information through SQL. PL SQL is the procedural language extension to SQL; it is a programming language just like C++, JAVA, Pascal, etc. It is a server-side and easy to use language. The basic units that make up PL/SQL program can be nested inside one another; the units include functions, procedures, and anonymous blocks.
It is an imperative 3GL that was designed for seamless programming of SQL commands.
❯ DBMS concepts
- Define database
- Define database system
- What is DBMS
- What is RDBMS
- What is ORDBMS
- Difference between DBMS, RDBMS, and ORDBMS
❯ SQL
- Define SQL
- DDL commands
- DML command
- Insert
- SQL SELECT statements
- Operators
- Distinct clause
- Order by clause
- Comparison conditions
- Constraints
- Primary key constraint
- Check constraint
- Unique constraint
- Cascade constraint
- Foreign key constraint
- Not null constraint
- Cascade constraint
- Joins
- Define join
- Cartesian join
- Equi and non-equi join
- Outer joins
- Functions
- General functions
- Numeric functions
- Date functions
- Conversion functions
- Character functions
- Aggregation of data via group functions
- Sub-queries
- Simple
- Multiple row
- Delete
- Data deletion
- Deletion using join
- Deletion using sub-queries
- Update
- Updating data
- Updating using sub-queries
- Database objects
- Synonym
- Index
- View
- Privilege
- Sequence
- Privileges
- Revoke
- Grant
- View
- Simple
- In line
- Complex
- Synonym
- Private
- Public
❯ PL/SQL
❯ Introduction
- Overview
- Sub-programs
- Benefits of sub-programs
- Types o PL/SQL blocks
- Simple anonymous block
- Generating output
❯ Block structure of PL/SQL
Identifiers
- Types of identifiers
- Using declarative section to define identifiers
- %TYPE attribute
- Scalar data types identification
- Bind variables definition
- Sequences in PL/SQL expressions
❯ Executable statements
- Basic guidelines of PL/SQL block syntax
- Nested blocks
- Conversion of data types
- Comment code
- Operators identification
❯ Iterative statements
- Simple loop
- For loop
- While loop
❯ Interaction with Oracle server
- Invoking SELECT statements in PL/SQL to retrieve data
- SQL cursor concept
- Save transactions
- Discard transactions
- SQL cursor attributes
❯ Composite data types
- Using records of PL/SQL
- Insert and update with PL/SQL records
- %ROWTPE attribute
- Examining INDEX BY table of records
- Associative arrays
❯ Control structures
- Conditional processing
- Using IF statements
- Using CASE statements
- Simple loop statement
- WHILE loop statement
- FOR loop statement
- Description of continue statement
❯ Cursor management
- Define cursor
- Implicit cursor
- Explicit cursor
- Cursor with FOR loop
- Cursor with parameters
❯ Exception
- Define an exception
- Types of exception
- Predefined exception
- User-defines exception
❯ Exception handling
- What are exceptions
- Handling exceptions with PL/SQL
- Propagating exceptions
- RAISE_APPLICATION_ERROR procedure
- Trapping errors
- User-defined errors
- Predefined Oracle server errors
- Non-predefined server errors
❯ Stored procedures and functions
- Introduction
- Subprograms and anonymous blocks
- Simple procedure
- Creation
- Execution
- Simple function execution
❯ Create packages
- What is a package
- Benefits
- Components
- Developing of a package
- Invoking package constructs
- Enabling visibility of package’s components
- Viewing PL/SQL source code
❯ Dynamic SQL
- Introduction
- Execution flow
- Cursor variables declaration
- PL/SQL’s dynamic execution
- Invoking DBMS_SQL package
- Dynamic SQL function completeness
❯ Design tips and techniques
- NOCOPY hint theory
- Format of standard packages in an application
❯ Describe triggers
- Trigger event types identification
- Trigger event body identification
- Identification of timing of
- Trigger event types
- Trigger event body
- Trigger event firing
- Business application scenarios
- Statement-level triggers vs. row-level triggers
- Managing triggers
- Removing triggers
- Testing triggers
Oracle PL/SQL Online Training Placement in Various Cities:
- Oracle PL/SQL Online Training and Placement in Chicago
- Oracle PL/SQL Online Training and Placement in Boston
- Oracle PL/SQL Online Training and Placement in Phoenix
- Oracle PL/SQL Online Training and Placement in New York
- Oracle PL/SQL Online Training and Placement in Houston
- Oracle PL/SQL Online Training and Placement in Virginia
- Oracle PL/SQL Online Training and Placement in Atlanta

Max Troy is the Career Counsellor as well as a passionate Author. Well, he has years of experience in the Career and Jobs industry. As a part of his career at OPTnation, he helped various OPT and CPT candidates to shape their Career. Through his knowledge and writing skill, he is contributing to the students to find the best Career advice and immigration topics. Do share the information if you like it.