1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

Can you please guide me how to expert in sql & pl/sql

Discussion in 'SQL PL/SQL' started by Kasi Reddy, Aug 23, 2016.

  1. Kasi Reddy

    Kasi Reddy Active Member

    Messages:
    10
    Likes Received:
    2
    Trophy Points:
    110
    Location:
    hyd
    Hi Team,

    I am functional guy, I want expert on technical aspect also.
    Can you please advise me how to practice and be practically.


    Regards,
    Kasi.
     
  2. Silambarasan K

    Silambarasan K Active Member

    Messages:
    6
    Likes Received:
    3
    Trophy Points:
    85
    Location:
    Chennai
    Hi kasi,
    If you want to be expert in ORACLE SQL and PLSQL , you need to know why we going to use SQL and PLSQL .

    i dont know u have fundamental ideas about SQL and PLSQL . if dont have means please go ahead with SQL fundamental. lot of site in google for reference , please go ahead via tutorial point . e,g sites : oracle-base.com,oracle.doc, few more sites there .
    once you get start practice your self more than twice because it is no theory , need to practice like maths.

    Oracle not difficult think , if u cant able to understand from sites please go with some technical expert in your working area .

    practice, practice and face different scenario that only make you expert ..,

    feel free to ask anything ....,

    Thanks and Best wishes ,
    Silambu
     
  3. krasnoslobodtsev_si

    krasnoslobodtsev_si Forum Genius

    Messages:
    626
    Likes Received:
    129
    Trophy Points:
    810
    Location:
    Russian Federation
    Hi.

    1) Studying of Oracle DBMS needs to be begun with studying of the concept.
    It is very well written to documentation.
    Oracle Docs

    2)
    Example of the scenario of independent training:
    • SQL Fundamental I, II
    • PL/SQL Fundamental
    • SQL Advanced (analytic, modeling, matching(12c). etc)
    • PL/SQL Advanced

    3) additional plan of education :
    • Querying and Filtering Data
    • Grouping and Summarizing Data
    • Joining Data from Multiple Tables
    • Working with Sub queries
    • Modifying Data in Tables
    • Querying Metadata, XML, and Full-Text Indexes
    • Using Programming Objects for Data Retrieval
    • Using Advanced Querying Techniques
    • Implementing a Hierarchy
    • Use various techniques when working with complex queries

    For control of the gained knowledge you can use an online resource : https://plsqlchallenge.oracle.com
    Learn and share SQL, for free : https://livesql.oracle.com

    Additional links on resources :
    OTN
    Oracle Community
    OakTable
    Oracle-Base


    I will tell you: courses won't make you the expert, they can partially help. Only your work and practice make you the expert.
     
    Last edited: Aug 23, 2016
  4. Kasi Reddy

    Kasi Reddy Active Member

    Messages:
    10
    Likes Received:
    2
    Trophy Points:
    110
    Location:
    hyd
    Hi Silambu,

    Thanks for your advise.

    Regards,
    Kasi.