Production activities in PLSQL

Course Content
SQL CONTENT
0/27
Training Mode
DATABASE FUNDAMENTALS
CREATING AND MANAGING A TABLE
HR Schema
FILTERING DATA
MANAGING NUMERICAL DATA
MANAGING CHARACTER DATA
MANAGING DATE DATA
MODIFYING THE STRUCTURE OF A TABLE
DATA INTEGRITY CONSTRINTS
SEQUENCES
RETURNING DATA IN AN ORDER
GROUPING DATA
TABLE JOINS
SUBQUERIES
WINDOW FUNCTIONS
TOP-N QUERIES
COMMON TABLE EXPRESSIONS
HIERACHICAL QUERIES (HQ)
INDEXES
WORKING WITH REMOTE DATABASE OBJECTS
SYNONYMS
VIEWS
MATERIALIZED VIEWS
TABLE PARTITIONS
QUERY MONITORING
QUERY TUNING
PLSQL CONTENT
0/29
About PLSQL Program
Writing PLSQL program and running in different client environments
PLSQL Language Fundamentals
Exception Handling
Procedures
Functions
Accessing data between procedures, functions and Calling statements
Packages
Processing single row Table’s data
Processing Multi row Table’s data using cursors
Processing Multi row Table’s data using objects and collections
Processing Multi row Table’s data using objects and collections
External Files
Error Reporting
Database Triggers
Dynamic SQL
Advanced concepts of procedures
Advanced concepts of functions
Object oriented concepts with PLSQL
Large Objects
Unit Testing code
Debugging Code
Performance monitoring of PLSQL code
Tuning the code
Versioning
Deploying code
Production activities in PLSQL
Writing Shell scripts for calling PLSQL code
Scheduling PLSQL code
EMBEDDED SYSTEM WITH AI & ML
About Lesson

Definer vs Invoker Rights mechanism
Receiving clients requirement
Performing code changes to PLSQL code
How to write maintainable PLSQL code
Finding, validating and describing functions, procedures, packages, triggers etc.
Checking dependencies
Timestamp vs signature

Previous
Next

© 2023-2024 All Rights Reserved by Srineta Private Limited