Oracle Database: SQL Basic & Advance
Instructor: Tom Steven
- Lectures: 20
- Duration: 10 weeks
ConvergentLearningSolutions is a leader in training and deployment that provides training in several IT programs at Noida, for new students, professionals, non-professionals, and those who want to work in the background of IT. It is one of the institutes that can do it. Our Certified Oracle Expert Trainer has designed basic and advanced Oracle Database-SQL based on student level.
Oracle SQL (Basic | Advanced) training can help you understand the benefits of an energetic programming language. PL (Procedural Language) is an extension of SQL. Structured Query Language is designed for database activity and allows you to perform data manipulation for safe and flexible data.
Content
Overview of Oracle Database 11g and related products
Overview of relational database management concepts and terminologies
Introduction to SQL and its development environments
The HR schema and the tables used in this course
Oracle Database documentation and additional resources
Oracle Database documentation and additional resources
List the capabilities of SQL SELECT statements
Generate a report of data from the output of a basic SELECT statement
Use arithmetic expressions and NULL values in the SELECT statement
Invoke Column aliases
Concatenation operator, literal character strings, alternative quote operator, and the DISTINCT keyword
Display the table structure using the DESCRIBE command
Display the table structure using the DESCRIBE command
Write queries with a WHERE clause to limit the output retrieved
Describe the comparison operators and logical operators
Describe the rules of precedence for comparison and logical operators
Usage of character string literals in the WHERE clause
Write queries with an ORDER BY clause
Sort the output in descending and ascending order
Substitution Variables
Substitution Variables
List the differences between single row and multiple row functions
Manipulate strings using character functions
Manipulate numbers with the ROUND, TRUNC, and MOD functions
Perform arithmetic with date data
Manipulate dates with the DATE functions
Manipulate dates with the DATE functions
Describe implicit and explicit data type conversion
Describe the TO_CHAR, TO_NUMBER, and TO_DATE conversion functions
Nesting multiple functions
Apply the NVL, NULLIF, and COALESCE functions to data
Usage of conditional IF THEN ELSE logic in a SELECT statement
Usage of conditional IF THEN ELSE logic in a SELECT statement
Usage of conditional IF THEN ELSE logic in a SELECT statement
Usage of the aggregation functions in SELECT statements to produce meaningful reports
Describe the AVG, SUM, MIN, and MAX function
How to handle Null Values in a group function?
Divide the data in groups by using the GROUP BY clause
Exclude groups of date by using the HAVING clause
Exclude groups of date by using the HAVING clause
Write SELECT statements to access data from more than one table
Join Tables Using SQL:1999 Syntax
View data that does not meet a join condition by using outer joins
Join a table to itself by using a self join
Create Cross Joins
Create Cross Joins
Use a Subquery to Solve a Problem
Single-Row Subqueries
Group Functions in a Subquery
Multiple-Row Subqueries
Use the ANY and ALL Operator in Multiple-Row Subqueries
Use the EXISTS Operator
Use the EXISTS Operator
Describe the SET operators
Use a SET operator to combine multiple queries into a single query
Describe the UNION, UNION ALL, INTERSECT, and MINUS Operators
Use the ORDER BY Clause in Set Operations
Use the ORDER BY Clause in Set Operations
Add New Rows to a Table
Change the Data in a Table
Use the DELETE and TRUNCATE Statements
How to save and discard changes with the COMMIT and ROLLBACK statements
Implement Read Consistency
Describe the FOR UPDATE Clause
Describe the FOR UPDATE Clause
Categorize Database Objects
Create Tables
Describe the data types
Understand Constraints
Create a table using a subquery
How to alter a table?
How to drop a table?
How to drop a table?
Create, modify, and retrieve data from a view
Perform Data manipulation language (DML) operations on a view
How to drop a view?
Create, use, and modify a sequence
Create and drop indexes
Create and drop synonyms
Create and drop synonyms