Oracle Training

TutorsBot's Oracle Training in Delhi covers various areas of Oracle includes Oracle database DBA skills, Retrieve data using Select statement, sort commands, single row functions, group functions, multiple tables join, data manipulation statements, schema management, dictionary views.

Also this Oracle training in Delhi course covers PL/SQL programming concepts such as PL/SQL Identifiers, Write executable statements, control structure, composite data types, exception handling and stored procedures, stored functions and packages.

Course Syllabus:

• Introduction
• Describe the features of Oracle Database 12c
• Describe the salient features of Oracle Cloud 12c
• Explain the theoretical and physical aspects of a relational database
• Describe Oracle servers implementation of RDBMS and object relational database management system (ORDBMS)
• Basic Database Conceps and SQL
• Basic History of Database Concept: DBMS, RDBMS, ORDBMS
• Advantage of ORACLE Database and Version Information
• Interface Tools Usage: SQL Plus, ISQL Plus, SQL Developer, Toad
• SQL Language Overview : DQL, DML, DDL, DCL, TCL
• What is the Usage of ANSI Standard
• SELECT Command - Column Alias Rules, String Data,
• Concatenations with Various Data
• Null Value Handling with Number and Characters
• Arithmetic Operator
• Concatenation Operator
• Eliminating Duplicate Rows
•  Restricting and Sorting Data
• WHERE Clause - Character Strings and Dates, Number
• General Comparison Conditions = > >= < <= <>
• Other Comparison BETWEEN , IN , LIKE , NULL
• Logical Conditions AND OR NOT
• ORDER BY Clause, Sorting by Column Alias , Column Position, Multiple Columns
• Single-Row Functions
• Character Functions: UPPER, LOWER, INITCAP, LENGTH, SUBSTR, INSTR, LPAD, RPAD, CONCAT, LTRIM, RTRIM, TRIM, REPLACE, TRANSLATE, REVERSE
• Number Functions: ROUND, TRUNC, MOD, POWER, CEIL , FLOOR, ABS
• Dates Functions: SYSDATE, MONTHS_BETWEEN, NEXT_DAY, LAST_DAY, ADD_MONTHS, ROUND, TRUNC, Arithmetic on Date
• Conversion Functions: Implicit Data-Type Conversion & Explicit Data-Type Conversion, TO_CHAR ,TO_NUMBER ,TO_DATE
• General Functions: NVL , NVL2 , NULLIF, COALESCE
• CASE Expression, DECODE
• Nested Function with Real-Time Usage
•  JOINS
• EQUI JOIN / SIMPLE JOIN / NORMAL JOIN
• ANSI JOIN, LEFT OUTER, RIGHT OUTER, FULL OUTER
• NATURAL JOIN, NATURAL OUTER JOINS
• INNER JOIN, JOIN ... USING clause, JOIN ... ON clause,
• CROSS JOIN, NON-EQUI JOIN, SELF JOIN
• ORACLE STANDARD OUTER JOINS
• Multi table Joins, Complex Joins How to simplified complex joins
•  Multi-row Functions
• Group Functions Rules, SUM, MIN, MAX, COUNT, AVG
• Creating Groups of Data: GROUP BY Clause
• Filtering Group Results: The HAVING Clause
• Sub-queries
• Single-Row Subqueries- Rules, Operators : = > >= < <= <>
• Null Values in a Subquery
• Multi-Row Subqueries- Rules, Operators : IN, ANY , ALL
•  Reporting Data Using Interface Commands
• Page Size, Line Size , Column Heading , Column Format , Colsep
• tTitle , bTitle , Break on Column, Spool , CSV file Generation, Text File Generation
•  Data Manipulation Language DML and Transaction Control Language TCL
• DML : INSERT, UPDATE, DELETE, MERGE
• TCL : COMMIT, ROLLBACK, SAVEPOINT
•  Data Definition Language - DDL
• DDL : CREATE, ALTER, RENAME, DROP, TRUNCATE
• Default Option
• Constrain Table Copy
• Constraints
• NOT NULL, UNIQUE, PRIMARY KEY, FOREIGN KEY, CHECK
• Column Level Constraint, Table Level Constraint Naming Constraints and Usage Column Level Constraint, Table Level Constraint Naming Constraints and Usage
• Adding a Constraint, Dropping a Constraint
• Disabling Constraints, Enabling Constraints
• Validating Constraints
• Views
• Simple Views and Complex Views , Create, Drop, Source Code
• Rules for Performing DML Operations on a View
• WITH CHECK OPTION , WITH READ ONLY
• Inline Views
• Materialized View , Create, Refresh, Drop - Usage
•  Other Database Objects
• Sequence- NEXTVAL and CURRVAL
• Index - When to Create an Index, When Not to Create an Index.
• Synonyms
•  DCL COMMANDS
• Creating Users
• Granting / Revoking Privileges
• Creating and Granting Privileges to a Role