1 / 26

Realtime & Job Oriented Oracle PL SQL Training in Marathahalli, Bangalore

SDLC training institute offering the Oracle PL SQL training in Marathahalli, Bangalore. Here providing the Limit the batch size so we can provide personal attention to everyone in the session, Real-time practice, Live projects, 24/7 interact access with faculties, Experienced and passionate trainers, After course engagement, We give topic-wise PPT, case studies, assignments and doubt solving, 100% job assistance, 24/7 support, Classroom training in Marathahalli and Corporate training in Marathahalli. We are offering more software courses like Oracle DBA/RAC, Oracle APP DBA, Oracle APP Technical, Oracle APP Financial, Oracle Golden Gate.<br>For more Information:<br>Visit: http://www.sdlctraining.info/training-marathahalli/oracle-sql-pl-course-training-in-marathahalli/<br>Contact Us: 91-7760678612

SDLC
Download Presentation

Realtime & Job Oriented Oracle PL SQL Training in Marathahalli, Bangalore

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. SDLC Training Oracle PL SQL Training Institute in Bangalore Call Us: +91-77606 78612 Email Us: info@sdlctraining.in

  2. About Your Company SDLC Training is an IT training institute that offers tailor-made courses to students and corporates who intend to hone their IT Skills. Our training portfolio covers programs that span across the Software Development Life Cycle. We always keep ourselves abreast with the latest trends and technologies in the IT market. The training sessions are conducted by Industry Experts who have vast IT industry experience in their respective fields and are employed with CMMI Level 5 / Multinational companies. Call Us: +91-77606 78612 Email Us: info@sdlctraining.in

  3. Oracle PL SQL Course Training Call Us: +91-77606 78612 Email Us: info@sdlctraining.in

  4. Oracle PL SQL Course Training Introduction Introduction to DBMS Introduction to Data Management File system concepts Database Models Hierarchal Model Network Model ● ● ● ● ● ● Call Us: +91-77606 78612 Email Us: info@sdlctraining.in

  5. Oracle PL SQL Course Training Relational Model ● Introduction to Oracle History of Oracle Oracle products and features Oracle versions and releases About SQL & SQL*PLUS SQL*NET ● ● ● ● ● Call Us: +91-77606 78612 Email Us: info@sdlctraining.in

  6. Oracle PL SQL Course Training Introduction to SQL Sub-language Commands Data Retrieval Language (DRL) Data Definition Language (DDL) Data Manipulation Language (DML) Transaction Control Language (TCL) Database security and Privileges ● ● ● ● ● ● Call Us: +91-77606 78612 Email Us: info@sdlctraining.in

  7. Oracle PL SQL Course Training Working with DRL Select statement Distinct Selection ‘Where’ Clause ‘Order by’ Clauses ● ● ● ● Call Us: +91-77606 78612 Email Us: info@sdlctraining.in

  8. Oracle PL SQL Course Training Working with DDL and DML DDL commands Database objects and object types Working with Tables Data Types Table partitions Create, Alter, Add, Modify, Drop Insert, Update, ● ● ● ● ● ● Call Us: +91-77606 78612 Email Us: info@sdlctraining.in

  9. Oracle PL SQL Course Training Delete Commit, Rollback ● ● Oracle Built-in Functions Arithmetic Functions Character Functions Date Functions Queries with Single Row Functions ● ● ● Call Us: +91-77606 78612 Email Us: info@sdlctraining.in

  10. Oracle PL SQL Course Training Misc Functions Working with Regular Expressions ● ● Constraints Data Integrity Concepts Different types of Constraints Table Level and Column Level ● ● ● Call Us: +91-77606 78612 Email Us: info@sdlctraining.in

  11. Oracle PL SQL Course Training Composite Constraints Check Constraint and Restrictions Referential Integrity ● ● ● Sub Queries Normal Sub Queries. Co-related Sub Queries. ● ● Call Us: +91-77606 78612 Email Us: info@sdlctraining.in

  12. Oracle PL SQL Course Training Updating Using Co-Related. Deleting Co-Related Using Exists and Not Exists Inline Queries Miscellaneous Sub-queries. ● ● ● ● ● Joins Joining Tables ● Call Us: +91-77606 78612 Email Us: info@sdlctraining.in

  13. Oracle PL SQL Course Training Simple Joins Outer Joins Self Joins Joins with Inline Queries ANSI Join Syntax ● ● ● ● ● Call Us: +91-77606 78612 Email Us: info@sdlctraining.in

  14. Oracle PL SQL Course Training Select Statement with Misc Options Set Operators Pseudo Columns ● ● Views, Synonyms & Indexes Simple & Complex Views Modifying the View Query ● ● Call Us: +91-77606 78612 Email Us: info@sdlctraining.in

  15. Oracle PL SQL Course Training Synonyms Indexes Sequences PL/SQL COURSE CONTENT Introduction to PL/SQL Role of PL/SQL in Applications ● Call Us: +91-77606 78612 Email Us: info@sdlctraining.in

  16. Oracle PL SQL Course Training Programming Fundamentals Restriction of SQL in PL/SQL PL/SQL Engine Working with PL/SQL Blocks Conditional Structure ● ● ● ● ● Anonymous Blocks Declare ● Call Us: +91-77606 78612 Email Us: info@sdlctraining.in

  17. Oracle PL SQL Course Training Begin End Conditional Structure Loop Structure ● ● ● ● Exception Handling System Defined Exceptions ● Call Us: +91-77606 78612 Email Us: info@sdlctraining.in

  18. Oracle PL SQL Course Training User Defined Exceptions Defining Own Error Messages Program Exception Int SQLCODE, SQLERRM ● ● ● ● Cursors Introduction to Types of Cursors ● ● Call Us: +91-77606 78612 Email Us: info@sdlctraining.in

  19. Oracle PL SQL Course Training For Cursor Cursor Attributes Working with Implicit Cursors Dynamic Cursors ● ● ● ● ● Stored Subprograms Introduction of Stored ● Call Us: +91-77606 78612 Email Us: info@sdlctraining.in

  20. Oracle PL SQL Course Training Subprograms Working with Stored Procedures Overloading of Subprogram Limitations of Functions Understanding of Packages Type Spec & Body Package Instantiation Calling Packages & Procedures & Functions Call Us: +91-77606 78612 Email Us: info@sdlctraining.in ● ● ● ● ● ● ● ●

  21. Oracle PL SQL Course Training Database Triggers Introduction to Triggers Statement Level Triggers Row Level Triggers When Clause Co-relations Trigger Predicates ● ● ● ● ● ● Call Us: +91-77606 78612 Email Us: info@sdlctraining.in

  22. Oracle PL SQL Course Training Instead of Triggers Compound Triggers Mutation of Triggers Advanced Features Autonomous Transactions Dynamic SQL ● ● Call Us: +91-77606 78612 Email Us: info@sdlctraining.in

  23. Oracle PL SQL Course Training We are committed to provide high quality ORACLE SQL and PL/SQL Training in Bangalore that helps the students and professionals in areas of ORACLE SQL and PL/SQL through its innovative programs and outstanding faculty. Post Successful completion of ORACLE SQL and PL/SQL Training Program leads to placement assistance and participation in campus placements by SDLC Training. Call Us: +91-77606 78612 Email Us: info@sdlctraining.in

  24. Call us: Course Duration +9177606 78612 Email us: info@sdlctraining.in

  25. Demo Class : Free Demo Session, Flexible Timings Free Class : Attend 3 Free Classes to check training Quality Regular : 1 Hour per day Fast Track : 2 – 3 Hours per day: 10 days Weekdays : Available Weekend : Available Online Training : Available Classroom Training : Available Course Fee : Talk to our Customer Support Duration : 30 Hours

  26. Contact us: +91-7760678612 info@sdlctraining.in

More Related