Oracle SQL Online Training
Oracle SQL Developer is a free integrated development environment that simplifies the development and management of Oracle Database in both traditional and Cloud deployments. SQL Developer offers complete end-to-end development of your PL/SQL applications, a worksheet for running queries and scripts, a DBA console for managing the database, a reports interface, a complete data modeling solution, and a migration platform for moving your 3rd party databases to Oracle.
Training Modes
Oracle SQL Online Training Content
Oracle SQL
- Introduction
- Retrieving Data using the SQL SELECT Statement
- Restricting and Sorting Data
- Using Single-Row Functions to Customize Output
- Conversion Functions and Conditional Expressions
- Reporting Aggregated Data Using the Group Functions
- Displaying Data from Multiple Tables Using Joins
- Using Subqueries to Solve Queries
- Using the SET Operators
- Managing Tables using DML statements
- Data Definition Language
- Introduction to Data Dictionary Views
- Creating Sequences, Synonyms, Indexes
- Managing Schema Objects
- Retrieving Data by Using Subqueries
- Manipulating Data by Using Subqueries
- Controlling User Access
- Manipulating Data
- Course Objectives, Course Agenda and Appendixes Used in this Course
- Overview of Oracle Database 12c and Related Products
- Overview of relational database management concepts and terminologies
- Introduction to SQL and its development environments
- What is Oracle SQL Developer?
- Starting SQL*Plus from Oracle SQL Developer
- The Human Resource (HR) Schema
- Tables used in the Course
- Capabilities of the SELECT statement
- Arithmetic expressions and NULL values in the SELECT statement
- Column aliases
- Use of concatenation operator, literal character strings, alternative quote operator, and the DISTINCT keyword
- Use of the DESCRIBE command
- Limiting the Rows
- Rules of precedence for operators in an expression
- Substitution Variables
- Using the DEFINE and VERIFY command
- Describe the differences between single row and multiple row functions
- Manipulate strings with character function in the SELECT and WHERE clauses
- Manipulate numbers with the ROUND, TRUNC and MOD functions
- Perform arithmetic with date data
- Manipulate dates with the date functions
- Describe implicit and explicit data type conversion
- Use the TO_CHAR, TO_NUMBER, and TO_DATE conversion functions
- Nest multiple functions
- Apply the NVL, NULLIF, and COALESCE functions to data
- Use conditional IF THEN ELSE logic in a SELECT statement
- Group Functions
- Creating Groups of Data
- Restricting Group Results
- Introduction to JOINS
- Types of Joins
- Natural join
- Self-join
- Non equijoins
- OUTER join
- Introduction to Subqueries
- Single Row Subqueries
- Multiple Row Subqueries
- Set Operators
- UNION and UNION ALL operator
- INTERSECT operator
- MINUS operator
- Matching the SELECT statements
- Using ORDER BY clause in set operations
- Data Manipulation Language
- Database Transactions
- Data Definition Language
- Introduction to Data Dictionary
- Describe the Data Dictionary Structure
- Using the Data Dictionary views
- Querying the Data Dictionary Views
- Overview of sequences
- Overview of synonyms
- Overview of indexes
- Managing constraints
- Creating and using temporary tables
- Creating and using external tables
- Retrieving Data by Using a Subquery as Source
- Working with Multiple-Column subqueries
- Using Scalar subqueries in SQL
- Correlated Subqueries
- Working with the WITH clause
- Using Subqueries to Manipulate Data
- Inserting by Using a Subquery as a Target
- Using the WITH CHECK OPTION Keyword on DML Statements
- Using Correlated Subqueries to Update and Delete rows
- System privileges
- Creating a role
- Object privileges
- Revoking object privileges
- Overview of the Explicit Default Feature
- Using multitable INSERTs
- Using the MERGE statement
- Performing flashback operations
- Tracking Changes in Data
- Working with CURRENT_DATE, CURRENT_TIMESTAMP,and LOCALTIMESTAMP
- Working with INTERVAL data types
Oracle Apps Technical Training
Online Oracle Apps Technical Training Oracle Apps Technical is a technical part of Oracle ERP. With Oracle Apps Technical background you ...
Read More
Read More
Oracle DBA Online Training
Oracle Database is a multi-model database management system produced and marketed by Oracle Corporation. It is the world's most popular ...
Read More
Read More
Big Data and Hadoop
Core Java/J2se Learn to master Hadoop step-by-step, and make your first unique, advanced program in 30 days. Hindi, English What ...
Read More
Read More
(no title)
PHP Learn to master PHP development step-by-step, and make your first unique, PHP program in 30 days. Hindi, English What ...
Read More
Read More
Oracle 11g RAC Online Training
Oracle RAC Oracle Real Application Clusters(RAC) is an option to the award-winning Oracle Database Enterprise Edition. Oracle RAC is a ...
Read More
Read More
(no title)
Hibernet Learn to master Hibernet development step-by-step, and make your first unique, advanced program in 30 days. Hindi, English What ...
Read More
Read More
ASP.Net Online Training
ASP .Net Learn to master ASP .Net development step-by-step, and make your first unique, advanced program in 30 days. Hindi, ...
Read More
Read More
(no title)
Mobile Apps Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry's ...
Read More
Read More