Signup as a Tutor

As a tutor you can connect with more than a million students and grow your network.

Oracle SQL and PLSQL

No Reviews Yet

Course type: Online Instructor led Course

Platform: gotomeeting

Course ID: 42492

Course type: Online Instructor led Course

Platform: gotomeeting

Students Interested 0 (Seats Left 0)

No Reviews Yet

About the Course

COURSE CONTENT


Oracle 12c/11g - SQL & PL/SQL



  • Chapter 1: Database



  1. Introduction and overview of Oracle Database

  2. Reviewing basic architecture concepts



  • Chapter 2: Oracle Standard Interfaces



  1. SQL

  2. Viewing a Sample Table



  • Chapter 3: The Sample Database



  1. The Sample Database

  2. Creating the Sample Data

  3. Viewing Sample Data

  4. Data Types of the Sample Data



  • Chapter 4: Data Definition Language



  1. Categories of SQL Statements

  2. Oracle Data types

  3. The CREATE Statement

  4. The DROP Command

  5. The ALTER Command

  6. Integrity Constraints

  7. Entity Integrity Constraints

  8. Referential Integrity Constraints

  9. Modifying Table to Use Constraints

  10. Checking Constraints

  11. The Data Dictionary



  • Chapter 5: Data Manipulation Language



  1. DML Statements

  2. The SELECT Statement

  3. The INSERT Statement

  4. The DELETE Statement

  5. The UPDATE Statement


 



  • Chapter 6: Transaction Control



  1. Transactions

  2. Command Classification



  • Chapter 7: SQL Operators



  1. Simple Selects

  2. Comparison Operators

  3. IN and NOT IN Operators

  4. BETWEEN Operator

  5. The LIKE Operator

  6. Logical Operators

  7. IS NULL and IS NOT NULL

  8. ANY

  9. ALL



  • Chapter 8: SQL FUNCTIONS



  1. Introduction

  2. The DISTINCT Keyword

  3. Aliases

  4. Miscellaneous Functions

  5. Mathematical Functions

  6. String Functions

  7. Date Functions

  8. Conversion Functions

  9. Pseudo Columns



  • Chapter 9: Joining Tables



  1. Joins

  2. Cartesian Product

  3. Inner Joins

  4. Equi-Join

  5. Table Aliases

  6. Non-Equi Join

  7. Outer Joins

  8. Right Outer Join

  9. Left Outer Join

  10. Full Outer Join

  11. Oracle-Specific Syntax for Outer Joins



  • Chapter 10: Set Operators



  1. Introduction

  2. Selection Criteria

  3. Union

  4. Union All

  5. Intersect

  6. Minus



  • Chapter 11: SQL Sub queries



  1. Introduction

  2. Using a Sub query with a DML Statement

  3. Typical Sub queries

  4. Sub query Operators

  5. Standard vs. Correlated Sub queries

  6. Correlated Sub query Example

  7. Predicate Operators



  • Chapter 12: Groups



  1. SQL Statements

  2. GROUP BY Clause

  3. HAVING Clause

  4. Order of a SELECT Statement



  • Chapter 13: More Database Objects



  1. More Database Objects

  2. Relational Views

  3. Updating a View

  4. Create or Replace

  5. Forcing a View

  6. Indexes

  7. Synonyms

  8. Sequences


 



  • Chapter 14: Introduction



  1. SQL vs. PL/SQL

  2. A Few Simple Examples

  3. Saving Procedures

  4. A More Complete Picture

  5. Comments

  6. Variable Substitution

  7. Simple Exception Handling

  8. Advantages of PL/SQL

  9. Assignments



  • Chapter 15: Declarations and Data Types



  1. Declarations

  2. Standard Data Types

  3. Initialization

  4. Variable Names

  5. Specialized Data Types - %TYPE

  6. Specialized Data Types - %ROWTYPE

  7. Building Your Own Data Types - Records

  8. A Quick look at Loops

  9. Arrays

  10. Tables

  11. Nested Blocks



  • Chapter 16: Language Components



  1. Introduction

  2. Simple Loops

  3. Loops - for

  4. Loops - while

  5. Simple Loops

  6. Nested Loops

  7. Boolean Variables

  8. PL/SQL Relational Operators

  9. PL/SQL Logical Operators

  10. CASE & DECODE



  • Chapter 17: Cursors



  1. Introduction

  2. Cursor Manipulation

  3. Using the Cursor

  4. For Loops Cursors

  5. Cursor Attributes

  6. Cursor Parameters

  7. Nested Cursors

  8. Cursor Exceptions



  • Chapter 18: Exceptions



  1. Errors in Programs

  2. Run Time Exceptions

  3. Oracle Built In Exceptions

  4. Unnamed Exceptions

  5. Built in Exception Functions

  6. Creating Your Own Exceptions

  7. Building Non Terminating Exceptions



  • Chapter 19: Collections



  1. Introduction

  2. Bulk collect

  3. Forall

  4. Collection methods

  5. Save exceptions



  • Chapter 20: Functions and Procedures



  1. Introduction

  2. Creating a Procedure

  3. Example Procedure

  4. Using Parameters

  5. Functions




    1. Procedures and Exceptions


  • Chapter 21: Performance Tuning



  1. Explain plan

  2. Analyzing the tables,indexes,schema

  3. Creating Partitions(List,Range,composite)

  4. Creating Indexes

Date and Time

Not decided yet.

About the Trainer

Bala Krishna picture

Avg Rating

0 Reviews

2 Students

2 Courses

Bala Krishna

Btech

6 Years of Experience

I have around 10+ years of experience into IT.
Worked on Database and ETL Projects. Successfully handled 15 Projects.
I am into online trainings from the past 5 years. I am online trainer for US consultants.
Trained 500+ students across the Globe.

Reviews

No reviews currently Be the First to Review

Discussions

Students Interested 0 (Seats Left 0)

Post your requirement and let us connect you with best possible matches for Oracle Training Post your requirement now

Enquire

Submit your enquiry for Oracle SQL and PLSQL

Please enter valid question or comment

Please enter your name.

Please enter valid Phone Number

Please enter the Pin Code.

Please check the fields again.

By submitting, you agree to our Terms of use and Privacy Policy

Connect With Bala

You have reached a limit!

We only allow 20 Tutor contacts under a category. Please send us an email at support@urbanpro.com for contacting more Tutors.

You Already have an UrbanPro Account

Please Login to continue

Please Enter valid Email or Phone Number

Please Enter your Password

Please enter the OTP sent to your registered mobile number.

Please Enter valid Password or OTP

Forgot Password? Resend OTP OTP Sent

Sorry, we were not able to find a user with that username and password.

We have sent you an OTP to your register email address and registered number. Please enter OTP as Password to continue

Further Information Received

Thank you for providing more information about your requirement. You will hear back soon from the trainer

UrbanPro.com is India's largest network of most trusted tutors and institutes. Over 25 lakh students rely on UrbanPro.com, to fulfill their learning requirements across 1,000+ categories. Using UrbanPro.com, parents, and students can compare multiple Tutors and Institutes and choose the one that best suits their requirements. More than 6.5 lakh verified Tutors and Institutes are helping millions of students every day and growing their tutoring business on UrbanPro.com. Whether you are looking for a tutor to learn mathematics, a German language trainer to brush up your German language skills or an institute to upgrade your IT skills, we have got the best selection of Tutors and Training Institutes for you. Read more