1 2 Previous Next 22 Replies Latest reply: Mar 31, 2011 1:28 AM by 851812 RSS

    Starter?

    776016
      As a starter can i use w3schools to gain knowledge?
        • 1. Re: Starter?
          JoachimSauer
          Well, if you start learning knitting, then that site is not very useful.

          Also, their info on paragliding is lacking as well.

          So what do you want to learn about?
          • 2. Re: Starter?
            BluShadow
            user13165795 wrote:
            As a starter can i use w3schools to gain knowledge?
            W3Schools is very good for learning the basics of the topics they provide on there, which is of course anything to do with web based development (w3 standing for www).

            However, what has this question got to do with Oracle or the OTN Feedback and Suggestions forum?
            • 3. Re: Starter?
              776016
              Want to be a developer in oracle. w3schools looks so simple. thats why i ask. One of my friend gave this site to start.
              • 4. Re: Starter?
                BluShadow
                user13165795 wrote:
                Want to be a developer in oracle. w3schools looks so simple. thats why i ask. One of my friend gave this site to start.
                W3Schools isn't about Oracle, though Oracle development can involve using the technologies taught at W3Schools, such as XML, HTML, Stylesheets etc.

                Being a developer in Oracle can entail many things e.g.

                Business Analysis/Systems Analysis - Taking business requirements and determining possible technologies to implement it and analysing the pros and cons of each.
                Systems Design - Taking the requirements and technically designing them, involving database design, user interface design
                Technical Implementation - Taking the technical designs and developing them in the appropriate technology
                Testing - Taking the technical implementation and producting test plans/scenarios and testing those against the product (Unit testing etc.)
                Training - Typically training is left to trainers, rather than developers, when the product is a user facing application, however some "products" are developed for use by developers and need more technical training.
                DBA - A specialised form of developer, who understands the underlying workings of the database (good to know if you're an application developer too), and maintains the databases for performance and backups etc.

                Now, when it comes to "Technical Implementation" there are many ways this can be achieved, depending on the requirements. It could be that the "product" is something to be developed purely on the database e.g an ETL job, and that can be developed in PL/SQL. It could be that it needs to be a web based user facing application, in which case you may be using Oracle Apex (Application Express), but just as much the requirement may specify it would be better developed in a different front end, such as Java, .NET, Powerbuilder, XSQL (served web pages with embedded SQL) or some other, and these things may also likely require some sort of back end database packages/procedures written in PL/SQL. It could be that reporting is needed, so you again may use Application Express, or some other means of reporting, such as Crystal Reports, Business Objects or some means such as writing data from the database into spreadsheet compatible files or Word documents etc. Then, with any of the above technologies, you may need to deal with data in various ways, outside of the database, such as handling web services or XML files etc.

                W3Schools will help to understand the web based technologies, such as if you wanted to develop HTML, which would be a precursor to developing in XSQL (though that's more Oracle based technology so you wouldn't learn that at W3Schools, you'd learn that through Oracle documentation or Oracle University courses like I did). W3Schools would also be good to learn about XML, XML Schemas, and Stylesheets for dealing with the processing of data in XML form. It is also good for learning Javascript which can be used to give greater functionality to Oracle Application Express development environment.

                As you can see, you're not likely to learn all these things in one go. Many people who know these technologies have spent years learning them as part of their work; and to try and learn everyting all in one go would be madness (and damn confusing).

                So, first things first, you need to try and figure out which area of work you want to be involved in. If it's the Technical Implementation side of things, then consider reading through some Oracle documentation and just having a go...

                http://www.oracle.com/pls/db112/portal.portal_db?selected=1&frame=

                Start with the "Concepts" manual. (always the best place to start)
                Then maybe the "2 Day Developers Guide"
                and then it depends on what are you want to focus on.

                Perhaps, as a new developer, if you want to get straight into developing some applications, Application Express is a good technology to get involved in
                In which case the "2 Day Application Express Developers Guide" would be a good starting point.

                Each of the documentations lead to other documentations as necessary.
                You'll also want to look at the SQL Language Reference and the PL/SQL Language Reference

                http://www.oracle.com/pls/db112/portal.portal_db?selected=5&frame=

                Then, whatever you're doing, as you find a need, you can reference the W3Schools site to learn the specifics it offers there e.g. if you've got a need to work with XML data, use W3Schools to learn about XML, XML Schema and perhaps Stylesheets (if necessary).

                Hope that helps.
                • 5. Re: Starter?
                  75407
                  From memory w3schools also has some basic interactive SQL courses, and for beginners these may be quite useful.

                  ( I recall on another thread I seemed to comment Oracle no longer seemed to provide SQL Tutorials like they did in the Oracle 5 and Oracle 6 days from memory).

                  This anwswer is a little rushed in passing and I have not read all of BluShadow's answer, and apologise that i have to post this a little quickly. But I think for starting SQL w3schools may have better tutorials than are available from the Oracle Site.
                  • 6. Re: Starter?
                    BluShadow
                    bigdelboy wrote:
                    From memory w3schools also has some basic interactive SQL courses, and for beginners these may be quite useful.
                    It does:

                    http://www.w3schools.com/sql/default.asp

                    though I would suggest that a person need a conceptual understanding of relational database design before trying to embark on learning SQL. There's no point learning the language to query data if you don't understand how the data is stored in the first place. ;)
                    • 7. Re: Starter?
                      Boneist
                      BluShadow wrote:
                      There's no point learning the language to query data if you don't understand how the data is stored in the first place. ;)
                      Oh dear; that's where I started from... the background bits got added in over time, after I'd learnt a bit of SQL!
                      • 8. Re: Starter?
                        BluShadow
                        Boneist wrote:
                        BluShadow wrote:
                        There's no point learning the language to query data if you don't understand how the data is stored in the first place. ;)
                        Oh dear; that's where I started from... the background bits got added in over time, after I'd learnt a bit of SQL!
                        You're an exception hun...
                        EXCEPTION
                          WHEN boneist THEN
                            proc_allow_sql_before_relational_understanding(TRUE);
                        END;
                        ;)
                        • 9. Re: Starter?
                          Z?
                          I reckon 'A Date with Codd' may be in order ?:|
                          • 10. Re: Starter?
                            Boneist
                            {noformat}*chortles*{noformat} "exception" .... usually I just get called "awkward" or "trouble" *{;-)                                                                                                                                                                                                           
                            • 11. Re: Starter?
                              Z?
                              Boneist wrote:
                              {noformat}*chortles*{noformat} "exception" .... usually I just get called "awkward" or "trouble" *{;-)
                              You mean...
                              EXCEPTION
                                WHEN boneist THEN
                                  proc_allow_awkward_sql_before_troubled_relational_understanding(TRUE);
                              END;
                              ?

                              PS: do you like the name for my new boat?
                              • 12. Re: Starter?
                                Boneist
                                Munky wrote:
                                PS: do you like the name for my new boat?
                                {noformat}*blinks* Ok, I must have missed something...?{noformat}
                                • 13. Re: Starter?
                                  BluShadow
                                  Boneist wrote:
                                  Munky wrote:
                                  PS: do you like the name for my new boat?
                                  {noformat}*blinks* Ok, I must have missed something...?{noformat}
                                  This...
                                  Munky wrote:
                                  I reckon 'A Date with Codd' may be in order
                                  Either that or Munky thinks you're in need of a date with our old friend Codd. Not sure why he would suggest that. :D
                                  • 14. Re: Starter?
                                    Boneist
                                    BluShadow wrote:
                                    This...
                                    Munky wrote:
                                    I reckon 'A Date with Codd' may be in order
                                    Oh, I see, a pune, or play on words. *{;-)
                                    Either that or Munky thinks you're in need of a date with our old friend Codd. Not sure why he would suggest that. :D
                                    Who isn't?! *{;-)                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           
                                    1 2 Previous Next