SQL/ PLSQL BEST TRINING IN BLR @MNPTECHNOLOGIES 9880756789

No. 11, MKB SQUARE, Near Vijay a Bank, Outer Ring Road, Marthahalli Bridge, Bangalore - 37.
9880756789 / 08042277050
MNP Technologies is a leading and premier IT training institute in Bangalore. MNP Technologies provides a high-quality of training to our students and we provide advanced labs to do practical experiments and Classrooms to become an expert in any IT Course.
We provide expert trainers who have work experience in TOP MNC Company across India. Our trainer are real time experience faculty will provide a best training methodology and courseware with 100% real time project scenarios, Cost-Effective and Quality in all the course

ORACLE 11G SQL COURSE CONTENT

Chapter 1 - Retrieving Data Using the SQL SELECT Statement
o The SELECT Statement
o The SELECT and FROM Clauses
o Conditions and the WHERE Clause
o Other Conditional Operators
o Logical Operators

Chapter 2 - Restricting and Sorting Data
o The ORDER BY Clause
o Column Aliases
o Arithmetic Expressions
o Precedence of Operators

Chapter 3 - Using Single-Row Functions to Customize Output
o Function Types
o Using Table dual to try out Functions
o Numeric Functions
o Character Functions
o String Concatenation
o Date Arithmetic and Date Functions

Chapter 4 - Using Conversion Functions and Conditional Expressions
o Conversion Functions
o NVL and NVL2
o DECODE
o CASE Expressions
o COALESCE and NULLIF

Chapter 5 - Reporting Aggregated Data Using the Group Functions
o SUM()
o COUNT()
o MIN()
o MAX()
o AVG()

Chapter 6 - Displaying Data from Multiple Tables
o Overview of Table Joins
o Inner Joins
o Table Aliases
o Outer Joins
o Self Joins
o ANSI Standard Joins

Chapter 7 - Using Sub queries to Solve Queries
o Overview of Sub queries
o Simple Sub queries
o Complex Sub queries
o Sub query Rules
o Using the ANY, ALL and IN Operators

Chapter 8 - Using the Set Operators
o UNION ,UNION ALL,INTERSECT and MINUS

Chapter 9 - Manipulating Data
o Inserting Rows
o Updating Rows
o Deleting Rows
o Verifying Updates
o Transaction Control
o Commit and Rollback
o Save points
o Commits and Constraints
o Amending Data in SQL Developer

Chapter 10 - Using DDL Statements to Create and Manage Tables
o Creating Tables
o Specifying Constraints
o Altering Tables, Columns and Constraints
o Dropping Tables, Columns and Constraints
o Copying Tables
o Data dictionary

Chapter 11 - Creating Other Schema Objects
o Creating Indexes
o Dropping Indexes
o Listing Indexes
o Creating and Using Views
o Dropping Views
o Listing Views
o Create a Sequence
o View Sequence Details
o Create a Synonym
o List Synonyms

Oracle 11g PL/SQL Course Content:
Introduction to PL/SQL
• What is PL/SQL
• PL/SQL Environment
• Benefits of PL/SQL
• Overview of the Types of PL/SQL blocks
• Create and Execute a Simple Anonymous Block
• Generate Output from a PL/SQL Block
Declaring PL/SQL Identifiers
• Identify the Different Types of Identifiers in a PL/SQL subprogram
• Use the Declarative Section to Define Identifiers
• List the Uses for Variables
• Store Data in Variables
• Declare PL/SQL Variables
Writing Executable Statements
• Describe Basic Block Syntax Guidelines
• Use Literals in PL/SQL
• Customize Identifier Assignments with SQL Functions
• Use Nested Blocks as Statements
• Reference an Identifier Value in a Nested Block
• Qualify an Identifier with a Label
• Use Operators in PL/SQL
• Use Proper PL/SQL Block Syntax and Guidelines
Interacting with the Oracle Server
• Identify the SQL Statements You Can Use in PL/SQL
• Include SELECT Statements in PL/SQL
• Retrieve Data in PL/SQL with the SELECT Statement
• Avoid Errors by Using Naming Conventions When Using Retrieval and DML Statements
• Manipulate Data in the Server Using PL/SQL
• The SQL Cursor concept
• Use SQL Cursor Attributes to Obtain Feedback on DML
• Save and Discard Transactions
Writing Control Structures
• Control PL/SQL Flow of Execution
• Conditional processing Using IF Statements
• Conditional Processing CASE Statements
• Handle Nulls to Avoid Common Mistakes
• Build Boolean Conditions with Logical Operators
• Use Iterative Control with Looping Statements
Working with Composite Data Types
• Learn the Composite Data Types of PL/SQL Records and Tables
• Use PL/SQL Records to Hold Multiple Values of Different Types
• Inserting and Updating with PL/SQL Records
• Use INDEX BY Tables to Hold Multiple Values of the Same Data Type
Using Explicit Cursors
• Cursor FOR Loops Using Sub-queries
• Increase the Flexibility of Cursors By Using Parameters
• Use the FOR UPDATE Clause to Lock Rows
• Use the WHERE CURRENT Clause to Reference the Current Row
• Use Explicit Cursors to Process Rows
• Explicit Cursor Attributes
• Cursors and Records
Handling Exceptions
• Handling Exceptions with PL/SQL
• Predefined Exceptions
• Trapping Non-predefined Oracle Server Errors
• Functions that Return Information on Encountered Exceptions
• Trapping User-Defined Exceptions
• Propagate Exceptions
• Use The RAISE_APPLICATION_ERROR Procedure To Report Errors To Applications
Creating Stored Procedures and Functions
• Differences Between Anonymous Blocks and Subprograms
• Creating and invoking Procedure
• Creating and invoking Functions
• Passing Parameter to the Function
Packages
• What are packages
• Advantages of packages
• Examples on packages
Triggers
• What are triggers?
• Types of triggers.
• Advantages of triggers.

Advanced PL/SQL
• Bulk Collect and for all
• Performance Tuning
• Scheduling Jobs in Oracle
• Materialized Views
• Dynamic SQL
• Pram Autonomous Transaction
• Ref Cursors
• Table Partitioning