Close
54
Oracle Database
20 Hours
20 Hours
2 Years
Oracle SQL Training
Date : 22 December 2017
Time : 1:30 AM
Quick Enquiry
Instructor-LedSelf-Paced





Oracle SQL training at SM Consultant is designed to provide students with a thorough introduction to interactive SQL and basic SQL*Plus operations. The course begins with an examination of single table operations, and moves into a discussion on the complexities of accessing multiple tables using joins or subqueries, participants will also learn the basic SQL*Plus operations required to enter, edit, and run SQL statements, produce reports, and write interactive SQL scripts through SQL*Plus. A hands-on lab, participants will use coding examples and workshops to bolster understanding of the material presented in class. The Introduction to Oracle SQL course can be taught for any version of Oracle

Who all Can Benefit from Oracle SQL Training
  • Database Administrators
  • System Analysts
  • Forms Developer
  • Technical Consultant
  • Portal Developer
  • PL/SQL Developer

Detailed Course Content for Oracle SQL Training

1. Introduction to the Oracle Database

  • Why Use an Entity Relationship Model?
  • Physical Data Storage
  • Relationships between Tables
  • Domains and Data Integrity Constraints
  • Data Model Review

2. SQL Basics and SQL*Plus

  • Understanding the Difference Between SQL, SQL*Plus, and PL/SQL
  • Invoking and Leaving SQL*Plus
  • Entering and Executing Commands
  • The SQL Buffer, SQL*Plus Default Output
  • LOGIN.SQL / GLOGIN.SQL
  • The SELECT Command and Mandatory Clauses

3. Using SQL Developer

  • Understanding SQL Developer
  • SQL Developer Setup
  • Advanced Functionality

4. The WHERE and ORDER BY Clauses

  • WHERE, ORDER BY Clauses
  • Using the Data Dictionary
  • Hierarchical Queries
  • Pattern Matching

5. Single Row Functions

  • Arithmetic Operators
  • Operator Precedence
  • Single Row vs. Group Functions
  • Date and Numeric Format Models
  • Data Conversion / Date Manipulation / Time Zones
  • Control Statements
  • IF THEN ELSE Logic
  • Regular Expressions

6. Joining Data from Multiple Tables in Queries

  • ANSI SQL 92 and SQL99 Joins
  • The JOIN Condition / The Cartesian Product
  • Outer JOINs

7. Group Functions and the GROUP BY Clause

  • Group Functions
  • Distinct Operator in Group Functions
  • GROUP BY, WITH Clause, ROLLUP, CUBE
  • Grouping Sets

8. Using Subqueries

  • Single-Row, Multi-Row, Multi-Column Subqueries
  • Subqueries in a WHERE / FROM / HAVING Clauses
  • Subqueries In the SELECT Clause – Scalar Subqueries
  • Correlated Subqueries / Hierarchical Queries
  • EXISTS / NOT EXISTS / WITH / Recursive WITH

9. SQL Set Queries

  • Multiple Select Statement Rules
  • Union vs. Union All of Select Statements
  • INTERSECTion of Two Select Statements
  • MINUS one select from another

10. Multi-Table Inserts

  • Unconditional All Insert
  • Conditional Insert with ELSE
  • Conditional ALL
  • Conditional FIRST
  • Pivoting Insert

11. Analytical Functions

  • Single Row Analytic Functions
  • Aggregating Analytic Functions
  • PIVOT / UNPIVOT
  • The MODEL Clause

12. SQL*Plus Reporting

  • SQL*Plus Report Writing Commands
  • COLUMN Command / Titles, System Variables
  • Master-Detail Report with TITLE and COLUMN Commands
  • Control Breaks, Computing Aggregate Amounts
  • Using SET Variables in SQL*Plus, SQL to Generate SQL

13. Data Manipulation Language (DML) Commands

  • INSERT, UPDATE, DELETE, and MERGE Commands
  • Use of Subqueries
  • Transaction Control Commands / Read Consistency / Locking
  • The MERGE Command
  • Flashback Queries

14. Data Definition Language (DDL) Commands

  • DDL Commands, Object Naming, Dropping Objects
  • TRUNCATE, COMMENT, RENAME Commands
  • Creating Tables / Integrity Constraints
  • CREATE TABLE, ALTER TABLE Commands
  • Datatypes, Types of Declarative Constraints
  • Default Values
  • Creating, Deferrable, Dropping, Displaying Constraint Information
  • Disabling/Enabling Constraints
  • Handling Exceptions
  • Views, Synonyms, Sequences, Indexes, Virtual Columns
  • Temporary Tables, External Tables

Certification Process

  • Once you are successfully through the project, you will be awarded with SM Consultant's Oracle SQL Training Completion Certificate.
  • SM Consultant certification has industry recognition and we are the preferred training partner for many organization's.

Frequently asked questions (FAQ'S)

You will never lose any lecture. You can choose either of the two options:
  • View the recorded session of the class available in your LMS.
  • You can attend the missed session, in any other live batch.
SM Consultant is committed to provide you an awesome learning experience through world-class content and best-in-class instructors for Oracle SQL Training. We will create an ecosystem through this training, that will enable you to convert opportunities into job offers by presenting your skills at the time of an interview. We can assist you in resume building and also share important interview questions once you are done with the training. However, please understand that we are not into job placements.
We have limited number of participants in a live session to maintain the Quality Standards. So, unfortunately participation in a live class without enrolment is not possible. However, you can go through the sample class recording or scheduled demo sessions and it would give you a clear insight about how are the classes conducted, quality of instructors and the level of interaction in the class.
At SM Consultant, we pride ourselves on hiring and retaining the most qualified and experienced instructors in the industry. All of our instructors are certified professionals in their respective subjects. Our instructors typically have 15 or more years of real-world experience working for leading companies, allowing them to apply current trends and relevant examples to help students relate to the course material and retain more information.
You can Call us at our US Number +1.650.585.2312 OR India Number +91.8019490782 OR Email us at contact@smconsultant.com . We shall be happy to assist you.

Oracle SQL Training Reviews

Click here to submit your review.

Overall learning experience:

Quality Of Course Content:

Quality Of Training Session:

Duration Of Training:

Trainers Technical Knowledge:

Trainers Presentation Skill:

Punctuality Of Trainer:

Quality Of Practice Exercises:

Response To Queries:

Submit your review
Excellent Very Good Good Fair Poor
Excellent Very Good Good Fair Poor
Excellent Very Good Good Fair Poor
Excellent Very Good Good Fair Poor
Excellent Very Good Good Fair Poor
Excellent Very Good Good Fair Poor
Excellent Very Good Good Fair Poor
Excellent Very Good Good Fair Poor
* Required Field
Alexander rated Oracle SQL Training : 5 Stars out of 5 Stars on Jun 30, 2012
Overall learning experience:

Quality Of Course Content:

Quality Of Training Session:

Duration Of Training:

Trainers Technical Knowledge:

Trainers Presentation Skill:

Punctuality Of Trainer:

Quality Of Practice Exercises:

Response To Queries:

Oracle SQL Training

Comments: The best e-learning for Oracle SQL Training ! . The experience was excellent with Mathew sir. His technical skill was very good. He is very friendly to his student's and has great patience level to solve all the problems.

Official Response: Thanks Alexander for provding us an oppurtinity to help you understand Oracle SQL

service 0.3

5.0 5.0 1 1 The best e-learning for Oracle SQL Training ! . The experience was excellent with Mathew sir. His technical skill was very good. He is very friendly to his student's and has great Oracle SQL Training
ENROLL NOW