OraFAQ Forum: SQL & PL/SQL » Tools to learn to Become PL/SQL Developer

Home » SQL & PL/SQL » SQL & PL/SQL » Tools to learn to Become PL/SQL Developer (Oracle 10g)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Tools to learn to Become PL/SQL Developer [message #601839]

Tue, 26 November 2013 05:35

masthan.anthati@gmail.com
Messages: 11
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

Report message to a moderator

Re: Tools to learn to Become PL/SQL Developer [message #601841 is a reply to message #601839]

Tue, 26 November 2013 05:48

dariyoosh
Messages: 538
Registered: March 2009
Location: France

Senior Member

That requires to read at least Oracle® Database PL/SQL Language Reference

Report message to a moderator

Re: Tools to learn to Become PL/SQL Developer [message #601844 is a reply to message #601841]

Tue, 26 November 2013 06:32

masthan.anthati@gmail.com
Messages: 11
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

Report message to a moderator

Re: Tools to learn to Become PL/SQL Developer [message #601846 is a reply to message #601841]

Tue, 26 November 2013 06:36

masthan.anthati@gmail.com
Messages: 11
Registered: July 2011
Location: Banglore

Junior Member

Hello Masters,

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

Thanks,
Masthan

Report message to a moderator

Re: Tools to learn to Become PL/SQL Developer [message #601847 is a reply to message #601844]

Tue, 26 November 2013 06:40

dariyoosh
Messages: 538
Registered: March 2009
Location: 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

Report message to a moderator

Re: Tools to learn to Become PL/SQL Developer [message #601849 is a reply to message #601839]

Tue, 26 November 2013 07:09

thatjeffsmith
Messages: 81
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

masthan.anthati@gmail.com
Messages: 11
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

Report message to a moderator

Re: Tools to learn to Become PL/SQL Developer [message #601855 is a reply to message #601854]

Tue, 26 November 2013 08:24

thatjeffsmith
Messages: 81
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.

Report message to a moderator

Re: Tools to learn to Become PL/SQL Developer [message #601856 is a reply to message #601854]

Tue, 26 November 2013 08:25

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

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=

Report message to a moderator

Re: Tools to learn to Become PL/SQL Developer [message #601857 is a reply to message #601849]

Tue, 26 November 2013 08:31

Kevin Meade
Messages: 2103
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.

Report message to a moderator

Re: Tools to learn to Become PL/SQL Developer [message #601858 is a reply to message #601857]

Tue, 26 November 2013 08:41

masthan.anthati@gmail.com
Messages: 11
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

Report message to a moderator

Re: Tools to learn to Become PL/SQL Developer [message #601861 is a reply to message #601858]

Tue, 26 November 2013 08:44

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

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.

Report message to a moderator

Re: Tools to learn to Become PL/SQL Developer [message #601865 is a reply to message #601861]

Tue, 26 November 2013 09:07

Kevin Meade
Messages: 2103
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).

Report message to a moderator

Re: Tools to learn to Become PL/SQL Developer [message #601867 is a reply to message #601865]

Tue, 26 November 2013 09:30

masthan.anthati@gmail.com
Messages: 11
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

Report message to a moderator

Re: Tools to learn to Become PL/SQL Developer [message #601868 is a reply to message #601867]

Tue, 26 November 2013 09:42

Kevin Meade
Messages: 2103
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.

Report message to a moderator

Re: Tools to learn to Become PL/SQL Developer [message #601869 is a reply to message #601867]

Tue, 26 November 2013 09:43

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

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.

Report message to a moderator

Re: Tools to learn to Become PL/SQL Developer [message #601872 is a reply to message #601869]

Tue, 26 November 2013 10:13

masthan.anthati@gmail.com
Messages: 11
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

Report message to a moderator

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Apr 24 01:21:41 CDT 2024