Complete Oracle SQL Course For Beginner To Expert | Simpliv
Course by Simpliv LLC
(Course Id: 244737 | 109 Views) Posted 00 UNKCategory:
Education, Information Technology
How the course is given:
Online
When the courses is given:
Flexible
Qualification Level:
Short Course/Training Certification
Course Duration:
03:25:37
Price:
$ 9.99
Location:
Fremont, CA
Registration is Available at Anytime
Course Description
Description
In this Session will cover below topics on Oracle SQL
****************************************************************************
01 - Oracle Introduction
***********************************
What is the Data Base and Data Base Management System?
How we Maintain the Database in Our Real Life
What is the Difference Between DBMS and RDBMS
How to use a Data Base System in our Real Life
02 - DDL Commands
******************************
What are the Data Types in Oracle SQL
What are the SQL Statements in Oracle SQL
How to Create a First Table in Oracle Data Base
How to Modify the Table Structure in Oracle Data Base
How to Drop and Rename the Table in Oracle Data Base
How to work with Insert (DML Statements) in Oracle SQL
How to work with Update (DML Statement) in Oracle SQL
How to work with Delete (DML Statement) in Oracle SQL
03 - TCL Commands
******************************
How to work with Commit (TCL Commands) in Oracle SQL
How to work with Rollback (TCL Commands) in Oracle SQL
How to work with Save Point (TCL Commands) in Oracle SQL
How to work with Truncate (TCL Commands) in Oracle SQL
04 - Clauses
******************
How to work with Select and Where Clause in Oracle SQL
How to work with Group By Clause in Oracle SQL
How to work with Having Clause in Oracle SQL
How to work with Order By Clause in Oracle SQL
How to work with Distinct Clause in Oracle SQL
05 - Operators Part
****************************
How to work with Arithmetic Operators in Oracle SQL
How to work with Logical Operators in Oracle SQL
How to work with Relational Operators in Oracle SQL
How to work with Special Operators in Oracle SQL
How to work with Set Operators in Oracle SQL
07 - Functions Part
****************************
How to work with Number Functions in Oracle SQL
How to work with String Functions in Oracle SQL
How to work with Translate Function in Oracle SQL
How to work with Replace Function in Oracle SQL
How to work with Decode Function in Oracle SQL
How to work with Case Function in Oracle SQL
How to work with Sub string Function in Oracle SQL
How to work with In string Function in Oracle SQL
How to work with Date Functions in Oracle SQL
How to work with Conversion Functions in Oracle SQL
How to work with General Functions in Oracle SQL
How to work with Aggregate Functions in Oracle SQL
10 - Constraints
***********************
How to work with Primary Key in Oracle SQL
How to work with Composite Primary Key in Oracle SQL
How to work with Unique Key in Oracle SQL
How to work with Not Null in Oracle SQL
How to work with Check in Oracle SQL
How to work with Default in Oracle SQL
How to work with Foreign Key in Oracle SQL
11 - Joins
*************
How to work with Simple Join in Oracle SQL
How to work with Outer Join in Oracle SQL
How to work with Self Join in Oracle SQL
12 - Synonyms
*********************
What is Synonyms in Oracle SQL
How to work with Private Synonym in Oracle SQL
How to work with Public Synonym in Oracle SQL
13 - Views Part
*********************
How to work with Simple View in Oracle SQL
How to work with Complex View in Oracle SQL
How to work with Force View in Oracle SQL
How to work with Vertical View in Oracle SQL
How to work with Horizontal View in Oracle SQL
How to work with Functional View in Oracle SQL
How to work with Partition View in Oracle SQL
How to work with Materialized View in Oracle SQL
How to work with Inline View in Oracle SQL
15 - Indexes, Clusters & Sequences
**************************************************
How to work with Simple Index in Oracle SQL
How to work with Complex Index in Oracle SQL
How to work with Unique Index in Oracle SQL
How to work with Functional Index in Oracle SQL
How to work with Bitmap Index in Oracle SQL
How to work with Clusters in Oracle SQL
How to work with Sequences in Oracle SQL
16 - Sub Queries
************************
How to work with Sub Queries in Oracle SQL
How to work with Sub Queries with Examples
Basic knowledge
- Basic Knowledge on Computers
What will you learn
- Student should learn Complete Oracle SQL
About the Provider
Simpliv is a global online learning marketplace that transforms lives by offering online training on a wide variety of topics. Created with the aim of making education accessible to all, Simpliv removes barriers to education among all communities, imparts life skills to learners, and bridges gaps in learning through cost-effective courses. Simpliv believes that learning has no boundaries. It brings learning to any person who wants to learn, whether it is management, technology, life sciences,... Read More
Course Provider Contact
Simpliv LLC
39658 Mission Boulevard, Fremont,
CA 94539, USA.
Phone: +510-849-6155
Email: sudheer@simpliv.com
39658 Mission Boulevard, Fremont,
CA 94539, USA.
Phone: +510-849-6155
Email: sudheer@simpliv.com