V
When you learn at Mindmajix, you can always rely on team of experts to provide guidance and support, whenever you need it.
30
Hrs
Instructor-Guided Lessons and Activities
Learn key objectives through expert-led lectures, discussions, and exercises.
20
Sessions
Hands-on practice on Tools
Practice new skills and dive deeper into the day’s key topics
15 Mins
After Each Session
Q & A Session.
Wrap up the session with clarification on concepts and labs, if needed.
The Oracle database environment
Reviewing basic architecture concepts
Oracle 10g Architecture
Main features of 9i and 10g
Writing the statement in sqlplus
Running the SELECT statement
Single Column
Descending order
Multiple column sort
Working with complex conditions
AND OR NOT LIKE BETWEEN
Pseudo Columns
Rownum
Sysdate
User & UID
The Dual Table
UPPER
LOWER
INITCAP
RPAD()
TRIM()
SUBSTR()
INSTR()
TRANSLATE()
REPLACE()
GREATEST()
LEAST()
TO_CHAR()
TO_DATE()
MONTHS_BETWEEN()
ADD_MONTHS()
LAST_DAY()
NEXT_DAY()
ROUND()
TRUNC()
SIGN()
Working with multiple tables
Different type of Joins
Writing Outer Joins
Union
Intersect
Minus
GROUP BY
HAVING
Single Row Subqueries
Multiple row Subqueries
ROLLUP
CUBE
Rollback
Commit
Savepoint
Creating the Tree structure
LEVEL
CONNECT BY
INSERT
UPDATE
DELETE
CREATE
TRUNCATE
ALTER
DROP
RENAME
DESCRIBE
Not Null Constraint
Check Constraint
Unique Constraint
Primary Key Constraint
References Constraint
On Delete Cascade
On Delete Set Null
Views
Sequences
Synonyms
Indexes
USER_TABLES
USER_TAB_COLUMNS
USER_OBJECTS
Object Privileges
Granting access to objects
Structure
Writing Anonymous Blocks
Oracle Datatypes
TYPE and ROWTYPE declarations
Value assignments
IF ELSE ENDIF statement
IF ELSIF ELSE ENDIF statement
LOOP END
LOOP statement
WHILE condition
FOR condition
Implicit and Explicit Cursors
Cursor Manipulation statements
OPEN FETCH CLOSE EXIT WHEN
Predefined Exceptions
Non-Predefined Exceptions
User Defined Exceptions
Creating and Calling Procedures
Creating and Calling Functions
Package Header
Package Body
Format of standard packages in an application
Spec and Body
NOCOPY hint theory
Database triggers
CALLing procedures from triggers
EXECUTE IMMEDIATE
DBMS_SQL package
DBMS_OUTPUT
UTL_FILE
Associative Arrays
Nested tables
VARRAYs
Have any queries regarding course curriculum, speak to our course advisor
Connect with Advisor
Let's figure out the best option for you.
Contact Us
When you learn at Mindmajix, you can always rely on team of experts to provide guidance and support, whenever you need it.
Our Course Producers are best in their industry and they have provided a best course curriculum.
Learn frameworks, tools, Realtime Use-cases and best practices from a Trainer whose daily work involves using them expertly.
Our Training Co-ordinators are here to provide you with Course schedules, LMS access and more.
Our expert instructors are here to help you
Upon successful completion of the program, you will be awarded a Certificate from Mindmajix for Oracle PL SQL Training.
Successfully complete your course and let the community know about your achievement.
Trainer will cover all the topics related to Certification.
Don’t just show off your achievement to the community, use it to advance in your career.
Have questions? We’ve got the answers. Get the details on how you can grow in this course.
Our trainers have relevant experience in implementing real-time solutions on different queries related to different topics. Mindmajix verifies their technical background and expertise.
We record each LIVE class session you undergo through and we will share the recordings of each session/class.
Trainer will provide the Environment/Server Access to the students and we ensure practical real-time experience and training by providing all the utilities required for the in-depth understanding of the course.
If you are enrolled in classes and/or have paid fees, but want to cancel the registration for certain reason, it can be attained within 48 hours of initial registration. Please make a note that refunds will be processed within 30 days of prior request.
The Training itself is Real-time Project Oriented.
There are some Group discounts available if the participants are more than 2.
As we are one of the leading providers of Live Instructor LED training, We have customers from USA, UK, Canada, Australia, UAE, Qatar, NZ, Singapore, Malaysia, India and other parts of the world. We are located in USA. Offering Online Training in Cities like
New York, New jersey, Dallas, Seattle, Baltimore, Houston, Minneapolis, Los Angeles, San Francisco, San Jose, San Diego, Washington DC, Chicago, Philadelphia, St. Louis, Edison, Jacksonville, Towson, Salt Lake City, Davidson, Murfreesboro, Atlanta, Alexandria, Sunnyvale, Santa clara, Carlsbad, San Marcos, Franklin, Tacoma, California, Bellevue, Austin, Charlotte, Garland, Raleigh-Cary, Boston, Orlando, Fort Lauderdale, Miami, Gilbert, Tempe, Chandler, Scottsdale, Peoria, Honolulu, Columbus, Raleigh, Nashville, Plano, Toronto, Montreal, Calgary, Edmonton, Saint John, Vancouver, Richmond, Mississauga, Saskatoon, Kingston, Kelowna, Hyderabad, Bangalore, Pune, Mumbai, Delhi, Dubbai, Doha, Melbourne, Brisbane, Perth, Wellington, Auckland etc…
Have More Questions. Reach our Support Team
Contact usSee if this course is a fit for you by joining us for an online info session. You’ll meet our team, get an overview of the curriculum and course objectives, and learn about the benefits of being a student at Mindmajix
Attend a Demo Session | Meet the Expert Who Can Kickstart Your Career in Oracle PL SQL
By providing us with your details, We wont spam your inbox.
