ORACLE SQL/PLSQL TRAINING

4 out of 5
4
6 reviews

Oracle SQL PL SQL Online Training will help you develop a complete understanding of Oracle database, query language, DML, a subprogram, scripting, etc. Trainers for Oracle SQL PL SQL Certification Training have more than proven their worth. An Oracle SQL PL SQL certified has an average salary of $82,000 to $109,000 per annum. Oracle SQL PL SQL is used in big business processing, software applications, enterprise grid computing, etc.

CHOOSE THE TRAINING THAT’S BEST FOR YOU

SELF-PACED E-LEARNING

  • Learn at your convenient time and pace
  • Gain on-the-job kind of learning experience through high quality ServiceNow videos built by industry experts.
  • Learn end to end course content that is similar to instructor led virtual/classroom training.
  • Explore sample ServiceNow training videos before signing up.

LIVE ONLINE TRAINING

  • Live demonstration of features and practicals.
  • Get LMS access of each ServiceNow Online training session that you attend through GotoMeeting.
  • Gain guidance on certification.
  • Attend a Free Demo before signing up.
Oracle SQL/PLSQL Training Upcoming Batches
Weekend

20,SEP 2020
Time: 7:00PM

Weekday

20,SEP 2020
Time: 7:00PM

FASTTRACK

20,SEP 2020
Time: 7:00PM

Timings Doesn't Suit You ?

We can set up a batch at your convenient time.

Table of Contents

1
Introduction to SQL
  • Listing the features of Oracle Database 11g
  • Discussing the basic design, theoretical and physical aspects of a relational database
  • Describing the development environments for SQL
  • Describing Oracle SQL Developer, Describing the data set used by the course
  • Retrieving Data Using the SQL SELECT Statement
  • Listing the capabilities of SQL SELECT statements.
  • Generating a report of data from the output of a basic SELECT statement
  • Using arithmetic expressions and NULL values in the SELECT statement
  • Using Column aliases
  • Using concatenation operator, literal character strings, alternative quote operator, and the DISTINCT keyword
  • Displaying the table structure using the DESCRIBE command
  • Restricting and Sorting Data
  • Writing queries with a WHERE clause to limit the output retrieved Using the comparison operators and logical operators
  • Describing the rules of precedence for comparison and logical operators
  • Using character string literals in the WHERE clause
  • Writing queries with an ORDER BY clause to sort the output
  • Sorting output in descending and ascending order
  • Using the Substitution Variables
  • Using Single-Row Functions to Customize Output
  • Differentiating between single row and multiple row functions
  • Manipulating strings using character functions
  • Manipulating numbers with the ROUND, TRUNC and MOD functions
  • Performing arithmetic with date data
  • Manipulating dates with the date functions
  • Using Conversion Functions and Conditional Expressions
  • Describing implicit and explicit data type conversion
  • Using the TO_CHAR, TO_NUMBER, and TO_DATE conversion functions
  • Nesting multiple functions
  • Applying the NVL, NULLIF, and COALESCE functions to data
  • Using conditional IF THEN ELSE logic in a SELECT statement
  • Reporting Aggregated Data Using the Group Functions
  • Using the aggregation functions in SELECT statements to produce meaningful reports
  • Using AVG, SUM, MIN, and MAX function
  • Handling Null Values in a group function
  • Creating queries that divide the data in groups by using the GROUP BY clause
  • Creating queries that exclude groups of date by using the HAVING clause
  • Displaying Data from Multiple Tables
  • Writing SELECT statements to access data from more than one table
  • Joining Tables Using SQL:1999 Syntax
  • Viewing data that does not meet a join condition by using outer joins
  • Joining a table by using a self join
  • Creating Cross Joins
  • Using Sub-queries to Solve Queries
  • Using a Subquery to Solve a Problem
  • Executing Single-Row Sub-queries
  • Using Group Functions in a Sub-query
  • Using Multiple-Row Subqueries
  • Using the ANY and ALL Operator in Multiple-Row Sub-queries
  • Using the SET Operators
  • Describing the SET operators
  • Using a SET operator to combine multiple queries into a single query
  • Using UNION, UNION ALL, INTERSECT, and MINUS Operator
  • Using the ORDER BY Clause in Set Operations
  • Manipulating Data
  • Adding New Rows to a Table Using the INSERT statement
  • Changing Data in a Table Using the UPDATE Statement
  • Using DELETE and TRUNCATE Statements
  • Saving and discarding changes with the COMMIT and ROLLBACK statements
  • Implementing Read Consistency
  • Using the FOR UPDATE Clause
  • Using DDL Statements to Create and Manage Tables
  • Categorizing Database Objects
  • Creating Tables using the CREATE TABLE Statement Describing the data types
  • Describing Constraints
  • Creating a table using a subquery
  • Altering and Dropping a table
  • Creating Other Schema Objects
  • Creating, modifying, and retrieving data from a view
  • Performing Data manipulation language (DML) operations on a view
  • Dropping a view
  • Creating, using, and modifying a sequence
  • Creating and dropping indexes
  • Creating and dropping synonyms
2
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
  • iSQL*Plus as PL/SQL Programming Environment
  • Declaring PL/SQL Identifiers
  • Identify the Different Types of Identifiers in a PL/SQL subprogram
  • Use the Declarative Section to Define Identifier
  • 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
  • Describe the block structure for PL/SQL stored procedures
  • Invoke a stored procedure/function from different tools
  • Call a stored procedure with host variables from iSQL*Plus, Forms, Java, C, etc
  • Invoke a stored procedure from an anonymous block or another stored procedure
  • List the CREATE OR REPLACE PROCEDURE syntax
  • Identify the development steps for creating a stored procedure
  • Use the SHOW ERRORS command
  • View source code in the USER_SOURCE dictionary view
  • Creating Stored Functions
  • Describe stored functions
  • List the CREATE OR REPLACE FUNCTION syntax
  • Identify the steps to create a stored function
  • Execute a stored function
  • Identify the advantages of using stored functions in SQL statements
  • Identify the restrictions of calling functions from SQL statements
  • Remove a function
  • Creating Packages
  • List the advantages of packages
  • Describe packages
  • Show the components of a package Diagram the visibility of constructs within a package
  • Develop a package
  • Create the package specification
  • Declare public constructs
  • Create the package body
  • Using More Package Concepts
3
Faq Content 1
Faq Content 2
4
4 out of 5
6 Ratings

Detailed Rating

Stars 5
3
Stars 4
0
Stars 3
3
Stars 2
0
Stars 1
0

{{ review.user }}

{{ review.time }}
 

Show more
Please, login to leave a review
Add to Wishlist
Lectures: 2