Discussions
Categories
- 385.5K All Categories
- 5.1K Data
- 2.5K Big Data Appliance
- 2.5K Data Science
- 453.4K Databases
- 223.2K General Database Discussions
- 3.8K Java and JavaScript in the Database
- 47 Multilingual Engine
- 606 MySQL Community Space
- 486 NoSQL Database
- 7.9K Oracle Database Express Edition (XE)
- 3.2K ORDS, SODA & JSON in the Database
- 585 SQLcl
- 4K SQL Developer Data Modeler
- 188K SQL & PL/SQL
- 21.5K SQL Developer
- 46 Data Integration
- 46 GoldenGate
- 298.4K Development
- 4 Application Development
- 20 Developer Projects
- 166 Programming Languages
- 295K Development Tools
- 150 DevOps
- 3.1K QA/Testing
- 646.7K Java
- 37 Java Learning Subscription
- 37.1K Database Connectivity
- 201 Java Community Process
- 108 Java 25
- 22.2K Java APIs
- 138.3K Java Development Tools
- 165.4K Java EE (Java Enterprise Edition)
- 22 Java Essentials
- 176 Java 8 Questions
- 86K Java Programming
- 82 Java Puzzle Ball
- 65.1K New To Java
- 1.7K Training / Learning / Certification
- 13.8K Java HotSpot Virtual Machine
- 94.3K Java SE
- 13.8K Java Security
- 208 Java User Groups
- 25 JavaScript - Nashorn
- Programs
- 667 LiveLabs
- 41 Workshops
- 10.3K Software
- 6.7K Berkeley DB Family
- 3.6K JHeadstart
- 6K Other Languages
- 2.3K Chinese
- 207 Deutsche Oracle Community
- 1.1K Español
- 1.9K Japanese
- 474 Portuguese
Required Skills for the Job of SQL Developer / PL/SQL Developer

I have been learning Oracle SQL and PL/SQL for almost a year now, and have decided that I would like to pursue a career as a SQL Developer or a PL/SQL Developer.
What skills are required to be a suitable candidate for a job as a developer? Are there any great resources for what skills are required for the job? Finally, what resources are available to learn these skills, if I need to brush up on them or introduce myself to them?
Best Answer
-
Very broad question, but I'll chime in with my thoughts
- Read books on the languages SQL and PL/SQL (Steven Feuerstein's bible on PL/SQL is my goto)....IN that order.
- SQL
- PL/SQL.
- Get certified --> https://education.oracle.com/pls/web_prod-plq-dad/ou_product_category.getFamilyPage?p_family_id=350&p_mode=Certification
- This will force you to actually READ the documentation of the language you are using as an Oracle PL/SQL developer. Once you know it per the documentation you will feel WAY more comfortable in programming correctly and at a higher level. I never did this in the beginning of my career but later in my career.
- Also learn both O/S [operating system] environments you'll be programming in (Windows and Unix) via the many variants of shell programming.
- It doesn't hurt to participate in these forums by asking thoughtful questions or just reading questions and the answers from many prominent members.
That's my 0.02 cents
- Read books on the languages SQL and PL/SQL (Steven Feuerstein's bible on PL/SQL is my goto)....IN that order.
Answers
-
Very broad question, but I'll chime in with my thoughts
- Read books on the languages SQL and PL/SQL (Steven Feuerstein's bible on PL/SQL is my goto)....IN that order.
- SQL
- PL/SQL.
- Get certified --> https://education.oracle.com/pls/web_prod-plq-dad/ou_product_category.getFamilyPage?p_family_id=350&p_mode=Certification
- This will force you to actually READ the documentation of the language you are using as an Oracle PL/SQL developer. Once you know it per the documentation you will feel WAY more comfortable in programming correctly and at a higher level. I never did this in the beginning of my career but later in my career.
- Also learn both O/S [operating system] environments you'll be programming in (Windows and Unix) via the many variants of shell programming.
- It doesn't hurt to participate in these forums by asking thoughtful questions or just reading questions and the answers from many prominent members.
That's my 0.02 cents
- Read books on the languages SQL and PL/SQL (Steven Feuerstein's bible on PL/SQL is my goto)....IN that order.
-
Test your skills at Oracle Dev Gym - Initiated by the above mentioned Steven Feuerstein
Preferably before you go for certification.
-
Hi,
I've said it before, but to be a PL/SQL developer you first need to have a good command over writing efficient queries. I've heard many people complaining not having received a training on PL/SQL, but they don't even know how to exploit the power of SQL queries. A PL/SQL program is valued by its queries, so if they are not written well the PL/SQL program is useless. In my current company they are 20 years late in terms of development, still using cursors to browse the data.
A good understanding of how the Oracle database works is also a plus. For example, you would want your program to minimize redo generation, make the best of features such as native parallelism, bind variables, etc.
-
GregV wrote:Hi,I've said it before, but to be a PL/SQL developer you first need to have a good command over writing efficient queries. I've heard many people complaining not having received a training on PL/SQL, but they don't even know how to exploit the power of SQL queries. A PL/SQL program is valued by its queries, so if they are not written well the PL/SQL program is useless. In my current company they are 20 years late in terms of development, still using cursors to browse the data.A good understanding of how the Oracle database works is also a plus. For example, you would want your program to minimize redo generation, make the best of features such as native parallelism, bind variables, etc.
And to the above I would add "get familiar with Database PL/SQL Packages and Types Reference" and Database Development Guide
Without knowledge of the Packages and Types Reference, one will spend a lot of time re-inventing the wheel.
-
And to add, another place to STUDY for exams that lead to certification is a member of this forum (who usually posts on the Certification forums as I do sometimes) is Matthew Morris. Former Oracle employee and author of several practice guides for Oracle certification exams. He breaks it down even further with many suggestions on books to study and links to documentation, etc.... I learned a lot from his guides and links.
Here's his website --> Oracle Certification Prep
And I agree with what others have said about SQL coming first. The definition per the documentation is: (I bolded, italicized, and underlined the key part of the definition):
"PL/SQL, the Oracle procedural extension of SQL, is a portable, high-performance transaction-processing language. This overview explains its advantages and briefly describes its main features and its architecture."
And lastly, having a basic understanding of programming in general helps (i.e. a college degree in computer science is ideal).