This course introduces students to PL/SQL, Oracle’s procedural extension language for SQL and the Oracle relational database. Participants explore the differences between SQL and PL/SQL. They also examine the characteristics of PL/SQL and how it is used to extend and automate SQL to administer the Oracle database. This course culminates with a project that challenges students to program, implement, and demonstrate a database solution for a business or organization.
Course content
SQL
Introduction to Oracle Database (SQL):
- What is Database
- Why Oracle
- Introduction to SQL and SQL *Plus, More SQL*Plus Commands
- The Data Dictionary
Data Query Language (DQL):
- Categories of SQL Statements
- Oracle Data types
- The SELECT Statement
- Practical examples
Data Definition Language (DDL):
- DDL Statements
The CREATE Statement - The DROP Command
- The ALTER Command
- Practical examples
Data Manipulation Language (DML):
- DML Statements,
- The INSERT Statement
- The DELETE Statement
- The UPDATE Statement
Transaction Control Language (TCL):
- TCL Statements
- COMMIT Statement
- ROLLBACK Statement
- SAVEPOINT Statement
Data Control Language (DCL):
- DCL Statements
- GRANT Statement
- REVOKE Statement
Integrity Constraints:
- Introduction to Integrity Constraints
- Categories of Integrity Constraints
- NOT NULL Constraints
- UNIQUE KEY Constraints
- PRIMARY KEY Constraints
- FOREIGN KEY or Referential Integrity Constraints
- CHECK Constraints, Practical examples
SQL Operators:
- Simple Selects
- Comparison Operators
- IN and NOT IN Operators
- BETWEEN Operator
- The LIKE Operator
- Logical Operators
- IS NULL and IS NOT NULL
- ANY
- ALL
- EXISTS
Set Operators:
- Introduction
- Selection Criteria
- Union
- Union All
- Intersect
- Minus
Joining Tables:
- Joins
- Table Aliases
- Cartesian Product
- Inner Joins
- Equi- Join
- Non-Equi Join
- Non-Key Join
- Reflexive / Self Join
- Natural Join
- Outer Joins
- Right Outer Join
- Left Outer Join
- Full Outer Join
SQL Sub queries:
- Introduction
- Using a Sub query with a DML Statement
- Typical Sub queries
- Sub query Operators
- Standard vs. Correlated Sub queries
- Correlated Sub query
Groups:
- SQL Statements
- GROUP BY Clause
- HAVING Clause
- Order of a SELECT Statement
SQL BUILT-IN FUNCTIONS:
- Introduction, Pseudo Columns
- GROUP Functions
- MATHEMATICAL / NUMERIC Functions
- STRING / CHARACTER Functions
- DATE / TIME Functions
- CONVERSION Functions
- MISCELLANEOUS Functions
More Database Objects:
- More Database Objects
- VIEWS
- SEQUENCE
- SYNONYMS
PLSQL
Fundamentals
- Introduction to PL/SQL
- Benefits of PL/SQL
- Creating PL/SQL Blocks
Defining Variables and Datatypes
- Using Variables in PL/SQL
- Recognizing PL/SQL Lexical Units
- Recognizing Data Types
- Using Scalar Data Types
- Writing PL/SQL Executable Statements
- Nested Blocks and Variable Scope
- Good Programming Practices
Using SQL in PL/SQL
- Review of SQL DML
- Retrieving Data in PL/SQL
- Manipulating Data in PL/SQL
- Using Transaction Control Statements
Program Structures to Control Execution Flow
- Conditional Control: IF Statements
- Conditional Control: CASE Statements
- Iterative Control: Basic Loops
- Iterative Control: WHILE and FOR Loops
- Iterative Control: Nested Loops
Using Composite Datatypes
- User-Defined Records
- Indexing Tables of Records
Using Cursors and Parameters
- Introduction to Explicit Cursors
- Using Explicit Cursor Attributes
- Cursor FOR Loops
- Cursors with Parameters
- Using Cursors for UPDATE
- Using Multiple Cursors
Exception Handling
- Handling Exceptions
- Trapping Oracle Server Exceptions
- Trapping User-Defined Exceptions
- Recognizing the Scope of Exceptions
Using and Managing Procedures
- Creating Procedures
- Using Parameters in Procedures
- Passing Parameters
Using and Managing Functions
- Creating Functions
- Using Functions in SQL Statements
- Review of the Data Dictionary
- Managing Procedures and Functions
- Review of Object Privileges
- Using Invoker’s Rights and Autonomous Transactions
Using and Managing Packages
- Creating Packages
- Managing Package Concepts
- Advanced Package Concepts
Getting the Best out of Packages
- Persistent State of Package Variables
- Using Oracle-Supplied Packages
Improving PL/SQL Performance
- Using Dynamic SQL
- Improving PL/SQL Performance
Using and Managing Triggers
- Introduction To Triggers
- Creating DML Triggers, Part I
- Creating DML Triggers, Part II
- Creating DDL and Database Event Triggers
- Managing Triggers
Recognizing and Managing Dependencies
- Introduction to Dependencies
- Understanding Remote Dependencies
Using the PL/SQL Compiler
- Using PL/SQL Initialization Parameters
- Displaying Compiler Warning Messages
- Using Conditional Compilation
- Hiding Your Source Code
To see the full course content Download now
Course Prerequisites
- Previous experience with at least one programming language
- Database Design and Database Programming with SQL
Who can attend
- Students who wish to learn the techniques and tools to automate database application tasks
- Students who possess basic mathematical, logical, and analytical problem-solving skills
- Novice programmers, as well as those at advanced levels, to learning the PL/SQL programming language to an advanced level
Number of Hours: 50hrs
Certification
Key features
- One to One Training
- Online Training
- Fastrack & Normal Track
- Resume Modification
- Mock Interviews
- Video Tutorials
- Materials
- Real Time Projects
- Virtual Live Experience
- Preparing for Certification
FAQs
DASVM Technologies offers 300+ IT training courses with 10+ years of Experienced Expert level Trainers.
- One to One Training
- Online Training
- Fastrack & Normal Track
- Resume Modification
- Mock Interviews
- Video Tutorials
- Materials
- Real Time Projects
- Materials
- Preparing for Certification
Call now: +91-99003 49889 and know the exciting offers available for you!
We working and coordinating with the companies exclusively to get placed. We have a placement cell focussing on training and placements in Bangalore. Our placement cell help more than 600+ students per year.
Learn from experts active in their field, not out-of-touch trainers. Leading practitioners who bring current best practices and case studies to sessions that fit into your work schedule. We have a pool of experts and trainers are composed with highly skilled and experienced in supporting you in specific tasks and provide professional support. 24x7 Learning support from mentors and a community of like-minded peers to resolve any conceptual doubts. Our trainers has contributed in the growth of our clients as well as professionals.
All of our highly qualified trainers are industry experts with at least 10-12 years of relevant teaching experience. Each of them has gone through a rigorous selection process which includes profile screening, technical evaluation, and a training demo before they are certified to train for us. We also ensure that only those trainers with a high alumni rating continue to train for us.
No worries. DASVM technologies assure that no one misses single lectures topics. We will reschedule the classes as per your convenience within the stipulated course duration with all such possibilities. If required you can even attend that topic with any other batches.
DASVM Technologies provides many suitable modes of training to the students like:
- Classroom training
- One to One training
- Fast track training
- Live Instructor LED Online training
- Customized training
Yes, the access to the course material will be available for lifetime once you have enrolled into the course.
You will receive DASVM Technologies recognized course completion certification & we will help you to crack global certification with our training.
Yes, DASVM Technologies provides corporate trainings with Course Customization, Learning Analytics, Cloud Labs, Certifications, Real time Projects with 24x7 Support.
Yes, DASVM Technologies provides group discounts for its training programs. Depending on the group size, we offer discounts as per the terms and conditions.
We accept all major kinds of payment options. Cash, Card (Master, Visa, and Maestro, etc), Wallets, Net Banking, Cheques and etc.
DASVM Technologies has a no refund policy. Fees once paid will not be refunded. If the candidate is not able to attend a training batch, he/she is to reschedule for a future batch. Due Date for Balance should be cleared as per date given. If in case trainer got cancelled or unavailable to provide training DASVM will arrange training sessions with other backup trainer.
Your access to the Support Team is for lifetime and will be available 24/7. The team will help you in resolving queries, during and after the course.
Please Contact our course advisor +91-99003 49889. Or you can share your queries through info@dasvmtechnologies.com