Oracle 12c/18c/19c SQL

About Course

SQL stands for Structured Query Language, and it aids in the creation of SQL commands that yield immediate results. SQL is a database language that allows you to construct, delete, retrieve, and modify data in databases.

Course Content

RETRIEVING DATA USING SQL SELECT STATEMENT

List the Capabilities of SQL Select Statement
Execute the Basic Select Statement

RESTRICTING AND SORTING DATA

USING SINGLE-ROW FUNCTIONS TO CUSTOMIZE OUTPUT

USING CONVERSION FUNCTIONS AND CONDITIONAL EXPRESSIONS

REPORTING AGGREGATED DATA USING THE GROUP FUNCTIONS

DISPLAYING DATA FROM MULTIPLE TABLES

USING SUBQUERIES TO SOLVE QUERIES

USING THE SET OPERATORS

MANIPULATING DATA

USING DDL STATEMENTS TO CREATE AND MANAGE TABLES

CREATING OTHER SCHEMA OBJECTS

Student Ratings & Reviews

No Review Yet

About Course

Course Content

RETRIEVING DATA USING SQL SELECT STATEMENT

List the Capabilities of SQL Select Statement

Execute the Basic Select Statement

RESTRICTING AND SORTING DATA

Limit the rows that are Retrieved by Query

Sort the rows that are Retrieved by a Query

Use Ampersand Substitutions to Restrict and Sort Output at run time

USING SINGLE-ROW FUNCTIONS TO CUSTOMIZE OUTPUT

Describe various types of functions available in SQL

Use character, number, and date functions in SELECT statement

USING CONVERSION FUNCTIONS AND CONDITIONAL EXPRESSIONS

Describe various types of conversion function that are available in SQL

Use the TQ_CHAR, TO_NUMBER, and TO_DATE conversion function

Apply conditional expressions in a SELECT statement

REPORTING AGGREGATED DATA USING THE GROUP FUNCTIONS

Identify the available group functions

Describe the use of group functions

group data by using the GROUP BY clause

include or exclude grouped rows by using the HAVING clause

DISPLAYING DATA FROM MULTIPLE TABLES

Write SELECT statements to access data from more than one table using equijoins and nonequijoins

join a table to itself by using a self-join

view data that generally does not meet a join condition by using outer joins

Generate a cartesian product of all rows from two or more tables

USING SUBQUERIES TO SOLVE QUERIES

Define subqueries

Describe the types of problems that the subqueries can solve

List the types of subqueries

Write single-row and multiple-row subqueries

USING THE SET OPERATORS

Describe set operators

Use a set operator to combine multiple queries

Control the order of row returned

MANIPULATING DATA

Describe each data manipulation language (DML) statement

Insert rows into tables

Update rows in a table

Delete rows from a table

Control transactions

USING DDL STATEMENTS TO CREATE AND MANAGE TABLES

Categorize the main database objects

Review the table structure

List the data types that are available for columns

Create a simple table

Explain how constraints are created at the time of table creation

Describe how schema objects works

CREATING OTHER SCHEMA OBJECTS

Create simple and complex views

Retrieve data from views

create, maintain, and use sequence

create and maintain indexes

create private and public synonyms

Student Ratings & Reviews

QUICK LINKS

Home About us Our Courses

CONTACT US

Home
About us
Our Courses