Trainings : +91 889 8888 448 | Certifications : +91 868 8881 863
Oracle SQL PLSQL training course content and Syllabus in Bangalore
Oracle 11g SQL Course Contents
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 Subqueries
o Simple Subqueries
o Complex Subqueries
o Subquery 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.
IT Networks © 2019-20 | All Rights Reserved
Powered by Best Digital Marketing Courses in Bangalore