Home » SQL & PL/SQL » SQL & PL/SQL » Tools to learn to Become PL/SQL Developer (Oracle 10g)
icon14.gif  Tools to learn to Become PL/SQL Developer [message #601839] Tue, 26 November 2013 05:35 Go to next message
masthan.anthati@gmail.com
Messages: 8
Registered: July 2011
Location: Banglore
Junior Member
Hello Maestros,

I have been working in the Oracle support background from last 3 years, now I wanted to shift to Development side.So could you please let me know that what are the things(both tools and topics) do I need to cover to get through in the interviews?. Thanks you so much in advance.

Thanks,
Masthan
Re: Tools to learn to Become PL/SQL Developer [message #601841 is a reply to message #601839] Tue, 26 November 2013 05:48 Go to previous messageGo to next message
dariyoosh
Messages: 532
Registered: March 2009
Location: Iran / France
Senior Member
That requires to read at least Oracle® Database PL/SQL Language Reference
Re: Tools to learn to Become PL/SQL Developer [message #601844 is a reply to message #601841] Tue, 26 November 2013 06:32 Go to previous messageGo to next message
masthan.anthati@gmail.com
Messages: 8
Registered: July 2011
Location: Banglore
Junior Member
Thank you so much for the link. In addition to that is there any other tools that I should concentrate on?

Thanks,
Masthan
Re: Tools to learn to Become PL/SQL Developer [message #601846 is a reply to message #601841] Tue, 26 November 2013 06:36 Go to previous messageGo to next message
masthan.anthati@gmail.com
Messages: 8
Registered: July 2011
Location: Banglore
Junior Member
Hello Masters,

Is there any Website where I can practice my scripts and write queries?

Thanks,
Masthan
Re: Tools to learn to Become PL/SQL Developer [message #601847 is a reply to message #601844] Tue, 26 November 2013 06:40 Go to previous messageGo to next message
dariyoosh
Messages: 532
Registered: March 2009
Location: Iran / France
Senior Member
Well, I'm not sure to understand what do you mean by tool in this context, from the moment you have the knowledge, a good text editor and SQL*Plus, you should be fine.

If you're talking about books, there are many, as an example (among many others)
- Mastering Oracle PL/SQL: Practical Solutions by by Connor McDonald, Chaim Katz, Christopher Beck, Joel R. Kallman, David C. Knox

- Oracle PL/SQL Programming Covers Versions Through Oracle Database 12c By Steven Feuerstein, Bill Pribyl
Re: Tools to learn to Become PL/SQL Developer [message #601849 is a reply to message #601839] Tue, 26 November 2013 07:09 Go to previous messageGo to next message
thatjeffsmith
Messages: 37
Registered: July 2009
Location: Raleigh, NC
Member

For tools I would recommend SQL*Plus and SQL Developer to begin with.

[Updated on: Tue, 26 November 2013 07:10]

Report message to a moderator

Re: Tools to learn to Become PL/SQL Developer [message #601854 is a reply to message #601849] Tue, 26 November 2013 08:22 Go to previous messageGo to next message
masthan.anthati@gmail.com
Messages: 8
Registered: July 2011
Location: Banglore
Junior Member
Thank you so much for your helpful information. Actually, recently I came through an interview, there they asked me about the Database Job Scheduling tools, where I don't have knowledge of it, that's why I asked you about that scheduling tool. If possible please give details on it.

Thanks,
Masthan
Re: Tools to learn to Become PL/SQL Developer [message #601855 is a reply to message #601854] Tue, 26 November 2013 08:24 Go to previous messageGo to next message
thatjeffsmith
Messages: 37
Registered: July 2009
Location: Raleigh, NC
Member

Scheduling tools...look up DBMS_JOBS, DBMS_SCHEDULER, CRON, Windows Scheduler - that would be a good start.

SQL Developer offers a UI for DBMS_JOBS and DBMS_SCHEDULER.
Re: Tools to learn to Become PL/SQL Developer [message #601856 is a reply to message #601854] Tue, 26 November 2013 08:25 Go to previous messageGo to next message
BlackSwan
Messages: 22790
Registered: January 2009
Senior Member
masthan.anthati@gmail.com wrote on Tue, 26 November 2013 06:22
Thank you so much for your helpful information. Actually, recently I came through an interview, there they asked me about the Database Job Scheduling tools, where I don't have knowledge of it, that's why I asked you about that scheduling tool. If possible please give details on it.

Thanks,
Masthan


when all else fails Read The Fine Manual

http://www.oracle.com/pls/db121/search?remark=quick_search&word=dbms_scheduler&partno=
Re: Tools to learn to Become PL/SQL Developer [message #601857 is a reply to message #601849] Tue, 26 November 2013 08:31 Go to previous messageGo to next message
Kevin Meade
Messages: 1938
Registered: December 1999
Location: Connecticut USA
Senior Member
The best PL/SQL developers know that the less pl/sql they write the better their pl/sql programs are.

This is not because pl/sql is a bad language, but rather that all programming languages are by their nature bad programming langauages so I am not picking on pl/sql. Fortunately for pl/sql you can work with this. Your best approach to learning pl/sql is to first learn SQL. The better you are at SQL the better your PL/SQL will be (and any other language at that).

If you have any other programming experience then learning PL/SQL will be easy. It is one of the easiest languages I have learned. IF this is your first language then I advise you get school based training first. Find a school or online course that will teach you basic programming concepts and how to program in geeneral. You can even find free online courses teaching pl/sql.

Also, understand that PL/SQL is not a transferable skill. You are making a descision to concentrate on the Oracle space when you learn pl/sql. Not a problem for me, but there are several different forms of programming out there so if you are starting a programming career, you have to decide what kind of programming you want your life's work to be about. Unlike the early days when many of us on OraFAQ got started, programming is becoming specialised. Consider that there is

WEB programming
Scientific programming
Business programming
Consumer device programming
Game programming
several other categorizations of unique kinds of programming
and even non-programming programming by specification

Each is different and they do not easily translate well from one to the other. At some point in your career you will need to make a choice on what direction you want it to go in.

If you are choosing PL/SQL then you are choosing business programming.

good luck.
Re: Tools to learn to Become PL/SQL Developer [message #601858 is a reply to message #601857] Tue, 26 November 2013 08:41 Go to previous messageGo to next message
masthan.anthati@gmail.com
Messages: 8
Registered: July 2011
Location: Banglore
Junior Member
Wow.. Its really helpful to me Kevin. Thank you so much. So while learning PLSQL, is it mandatory that I must concentrate on the latest version (I am not sure) or I can go ahead with my comfortable version 10g?.

Thanks,
Masthan

Re: Tools to learn to Become PL/SQL Developer [message #601861 is a reply to message #601858] Tue, 26 November 2013 08:44 Go to previous messageGo to next message
BlackSwan
Messages: 22790
Registered: January 2009
Senior Member
when all else fails Read The Fine Manual

http://docs.oracle.com/cd/E16655_01/server.121/e17906/toc.htm

Each major release has its own New Features Guide.
Re: Tools to learn to Become PL/SQL Developer [message #601865 is a reply to message #601861] Tue, 26 November 2013 09:07 Go to previous messageGo to next message
Kevin Meade
Messages: 1938
Registered: December 1999
Location: Connecticut USA
Senior Member
Fortunately the basics of PL/SQL are the same in all releases. 80% of it was in the basic release so any release you have access to will be a good starting point. Once you are somewhat proficient at it you can as BlackSwan points out, concentrate on the advanced features. There are several good advancements (some might say missing features that were added later).
Re: Tools to learn to Become PL/SQL Developer [message #601867 is a reply to message #601865] Tue, 26 November 2013 09:30 Go to previous messageGo to next message
masthan.anthati@gmail.com
Messages: 8
Registered: July 2011
Location: Banglore
Junior Member
That makes sense.. Thanks a lot to Kevin and all, My next question is , Is there any order to PLSQL concepts?, how important to learn about the Normalization in the database?, I tried to learn about this
Topic but It is really confusing me. If possible please help me on this topic.

Thanks,
Masthan
Re: Tools to learn to Become PL/SQL Developer [message #601868 is a reply to message #601867] Tue, 26 November 2013 09:42 Go to previous messageGo to next message
Kevin Meade
Messages: 1938
Registered: December 1999
Location: Connecticut USA
Senior Member
this is why a class on pl/sql makes considerable sense. Someone has already thought through all these questions in order to provide a reasonable ordering for the learning process.
Re: Tools to learn to Become PL/SQL Developer [message #601869 is a reply to message #601867] Tue, 26 November 2013 09:43 Go to previous messageGo to next message
BlackSwan
Messages: 22790
Registered: January 2009
Senior Member
Normalization is done at application design time.
If you are working against an existing database & application; ideally normalization has occurred & not something you need to be concerned about.
Re: Tools to learn to Become PL/SQL Developer [message #601872 is a reply to message #601869] Tue, 26 November 2013 10:13 Go to previous message
masthan.anthati@gmail.com
Messages: 8
Registered: July 2011
Location: Banglore
Junior Member
Thanks a lot to everyone... I will start practicing from here and get back to you if I need any help.

Thanks,
Masthan
Previous Topic: get data from column name with "ö" (M$ SQL, JDBC) and import it with sqlldr to Oracle
Next Topic: how to create local user in Database 12c
Goto Forum:
  


Current Time: Sat Sep 20 01:35:16 CDT 2014

Total time taken to generate the page: 0.06349 seconds