Oracle SQL Training

Current Status
Not Enrolled
Price
Closed
Get Started

The Oracle SQL (Structured Query Language) is one of the most popularly used database management systems the world over. The Oracle SQL course contains a set of 12 topics and training materials to help you master the Oracle SQL database management system. Initially, you will get a complete introduction to Oracle SQL by understanding databases, DBMS, RDBMS, and more. In the first half of the course, you will learn how to retrieve data with the use of various techniques, work with DLL and DML commands, how to add, declare, enable, and disable integrity constraints and also the different types of single-row functions, and how to use them plus how to work with multi-row functions. Moving further, you will understand how to work with different aggregate functions, know the uses and types of JOINS, use SET operators, work with pseudo columns, and the importance and usage of different subqueries. By the end of this course, you will get to know how to use different aspects of Database Transaction and Security and finally the design of schema objects. This Oracle SQL training covers all the major topics which will help you prepare for the Oracle SQL certification exams and open new opportunities in the world of Oracle SQL.

In This Module We Will Learn :

Introduction To SQL

  • INTRODUCTION TO DATABASE
  • UNDERSTANDING DBMS VS RDBMS
  • WALK THROUGH SQL STANDARDS
  • DIFFERENCE BETWEEN 10G VS 11G VS 12C
  • ABOUT SQL*PLUS AND USE OF DEVELOPER TOOL
  • DATATYPES IN ORACLE
  • OPERATORS IN ORACLE
  • UNDERSTANDING SCHEMA DESIGN AND OBJECTS

Data Retrieval Techniques

  • HOW TO USE SELECT STATEMENT IN DIFFERENT WAYS TO RETRIEVE RECORDS?
  • WORKING WITH COLUMN ALIAS
  • WORKING WITH TABLE ALIAS
  • DATA FILTERING AND SORTING WITH IN SINGLE TABLE
  • CLAUSES AND ITS TYPES IN ORACLE
  • • WHERE CLAUSE
  • • HAVING CLAUSE
  • • FROM CLAUSE
  • • GROUP BY CLAUSE
  • • ORDER BY CLAUSE
  • • USING CLAUSE

Working With DDL Commands

  • TABLE CREATION USING CREATE STATEMENT
  • CREATING TABLE FROM ANOTHER TABLE
  • DROPPING A TABLE USING DROP COMMAND
  • ALTERING THE COLUMN OF A TABLE
  • MODIFYING THE COLUMN DATATYPE IN A TABLE
  • RENAMING THE COLUMN OF A TABLE
  • RENAMING AN ENTIRE TABLE
  • USING TRUNCATE COMMAND
  • DIFFERENCE BETWEEN DELETE AND TRUNCATE COMMAND

Working With DML Commands

  • HOW TO COPY DATA FROM ONE TABLE TO ANOTHER TABLE?
  • HOW TO COPY THE STRUCTURE ALONE FROM A TABLE?
  • DIFFERENT TYPES OF INSERTING ROW TO AN EXISTING TABLE
  • UPDATING ANY VALUE OF WITH IN A RECORD USING UPDATE COMMAND
  • DELETING A PARTICULAR RECORD FROM A TABLE
  • USING MERGE & INSERT ALL COMMAND [IMPLEMENTATION OF PROJECT 1 ]

Integrity Constraints

  • HOW TO DECLARE COLUMN LEVEL CONSTRAINTS?
  • HOW TO ADD CONSTRAINTS TO AN EXISTING TABLE?
  • YPES OF INTEGRITY CONSTRAINTS
  • • NOT NULL
  • • UNIQUE KEY
  • • PRIMARY KEY
  • • REFERENTIAL INTEGRITY
  • • CHECK INTEGRITY
  • HOW TO ENABLE AND DISABLE CONSTRAINTS?
  • HOW TO GET INFORMATION ABOUT CONSTRAINTS?

Built In Functions

  • UNDERSTANDING SINGLE ROW FUNCTIONS
  • HOW TO USE SINGLE ROW FUNCTIONS USING DUMMY TABLE?
  • TYPES OF SINGLE ROW FUNCTIONS
  • • STRING FUNCTIONS
  • • DATE FUNCTIONS
  • • MATHEMATICAL FUNCTIONS
  • • CONVERSION FUNCTIONS
  • • ANALYTICAL FUNCTIONS
  • WORKING WITH MULTI ROW FUNCTIONS [IMPLEMENTATION OF PROJECT 2]

Data Aggregation

  • WORKING WITH AGGREGATE FUNCTIONS
  • • COUNT()
  • • SUM()
  • • MAX()
  • • MIN()
  • • AVG()
  • WORKING WITH GROUP BY AND ORDER BY CLAUSE
  • WORKING WITH HAVING CLAUSE
  • DIFFERENCE BETWEEN WHERE AND HAVING CLAUSE

Importance Of JOIN

  • UNDERSTANDING JOINS AND ITS USES
  • TYPES OF JOINS
  • • EQUI JOIN
  • • NON – EQUI JOIN
  • • SELF JOIN
  • • OUTER JOIN
  • • LEFT & RIGHT OUTER JOIN
  • • FULL OUTER JOIN
  • • CROSS JOIN [IMPLEMENTATION OF PROJECT 3]

Set Operators And Pseudo Columns

  • HOW TO USE SET OPERATORS IN A SINGLE TABLE CONTENT?
  • WORKING WITH SET OPERATOR TYPES
  • UNION
  • UNION ALL
  • INTERSECT
  • MINUS
  • WORKING WITH PSEUDO COLUMNS USING THE FOLLOWING
  • ROWID
  • ROWNUM

Sub Queries

  • IMPORTANCE OF SUB QUERIES
  • USING DIFFERENT TYPES OF SUB QUERIES
  • • SINGLE ROW SUB QUERIES
  • • MULTI ROW SUB QUERIES
  • • NESTED QUERIES
  • • MULTI COLUMN SUB QUERIES
  • • CORRELATED SUB QUERIES
  • USING INLINE VIEWS AND SCALAR QUERIES [ IMPLEMENTATION OF PROJECT 4]

Database Transaction And Security

  • WORKING WITH DATA QUERY LANGUAGE USING TCL
  • WORKING WITH DATA CONTROL LANGUAGE COMMANDS
  • USE OF COMMIT AND ROLLBACK
  • USE OF SAVEPOINT AND SET TRANSACTION
  • HOW TO GIVE SYSTEM PRIVILEGES TO AN USER?
  • HOW TO INVOKE AND REVOKE OBJECT PRIVILEGES?
  • HOW TO CREATE USERS AND ROLES?

Design Of Schema Objects

  • CREATING AND WORKING WITH VIEWS
  • WORKING WITH SYNONYMS
  • CREATING INDEX AND CLUSTERS
  • WORKING WITH IN MATERIALIZED VIEW
  • UNDERSTANDING SEQUENCES AND ITS TYPES [IMPLEMENTATION OF PROJECT 5]

Course Content

Expand All