Forum Stats

  • 3,839,710 Users
  • 2,262,530 Discussions
  • 7,901,048 Comments

Discussions

Want to learn PLSQL

User_5ZUSJ
User_5ZUSJ Member Posts: 1 Green Ribbon
edited Jul 25, 2022 6:43AM in SQL & PL/SQL

Hi,

Greentings!!

I am new to Software explored few options in SQL through w3schools. Can anyone please suggest on the best site/guide to explore hands on experience in PLSQL.

Thanks in advance

cheers

Answers

  • BluShadow
    BluShadow Member, Moderator Posts: 42,150 Red Diamond

    This community is probably the best site to learn and practice real-world PL/SQL coding.

    There are many websites out there that will proclaim to give you PL/SQL lessons etc. but many are either a) full of mistakes or b) just give examples that are not real-world coding issues or c) just use poor code examples that are not best practice (i.e. written by amateurs) or d) any combination of the previous.

    Personally I would recommend doing Oracle's own course for the fundamentals of the language...

    and then practice at solving real world issues by looking at what people ask on this community and having a go yourself, whilst learning from the solutions the existing experts give.

    Myself, when I came to learn PL/SQL, I already had experience of other databases (Ingres, Sybase, Cobol) and programming languages that work with them (ABF, Forms, PowerBuilder, Cobol etc.), as well as other non-database languages before that, but even though I had a reference manual for PL/SQL (Steven Feuerstein's book is very good reference) I still attended Oracle University (in person) to do their PL/SQL Fundamentals and PL/SQL Advanced course) and that allowed me to apply my previous coding knowledge to the different syntax and understand many of the best practices and approaches to coding it. Then, being on this community, having a go at solving other people's issues and doing my own job, and reading the documentation and trying things, have all contributed to my growing knowledge... and I'm still learning new stuff now.

    3rd party courses (online or in person) are very hit and miss, and many are just trying to make money by giving the impression they're teaching you stuff, whilst really they are trying to advertise and get you to buy their books or suchlike.... so beware.

  • Marcus B
    Marcus B Member Posts: 44 Blue Ribbon
    edited Jul 27, 2022 6:20PM

    I am new to Software...

    It is not clear how much experience you have with data bases, development tools or programming languages. I have been writing PL/SQL for many years in my role as a DBA and Steve Feuerstein was my mentor through the many PL/SQL books he wrote. I remember how overwhelming it was to get started and thought I would see the current state of training on the internet. A simple search took me to a site that does a great job of explaining Oracle including PL/SQL, https://www.oracletutorial.com/ . Scroll down the home page to see the link to PL/SQL. The tutorials are written in an excellent progressive approach that is great for any beginner. I do not have any affiliation with this web site and I can't tell who sponsors it, but it is an excellent starting place for a beginner.

    I would recommend using SQL Developer as an excellent and free development tool. You can download the latest version from Oracle, https://www.oracle.com/database/sqldeveloper/technologies/download/ .