5 Replies Latest reply: Oct 8, 2012 6:53 AM by BluShadow RSS

    sample oracle 11g database

    918464
      1st of all thanks for clicking my post. I am new to Oracle so thouth to post where I got oppertunity.

      Can anyone help with sample databast name or link for Oracle 11g express edition. I have MS SQL Server background 2005/2008 and I am very new to Oracle. I got oppertunity to work on Oracle between I want to practice like I practiced on AdventureWorks for SQL Server.

      Also, if you have links of some really good tutorial for SQL and PL SQL oracle 10g or 11g then please help with same :)
        • 1. Re: sample oracle 11g database
          ranit B
          You are at the correct place, my friend. Create an OTN account & get the below...

          *11g XE (Express Edition)* -- http://www.oracle.com/technetwork/products/express-edition/downloads/index.html

          SQL Developer -- http://www.oracle.com/technetwork/developer-tools/sql-developer/overview/index.html
          This is the free IDE from Oracle.
          Currently i'm using both of these for my personal practice.

          Oracle Documentation "*The Bible of Oracle*" --
          10g - http://www.oracle.com/pls/db102/homepage
          11g - http://www.oracle.com/pls/db112/homepage
          For all Oracle materials, i consider the master link to be - http://tahiti.oracle.com/

          Please let me know if you have other concerns.

          Ranit B.
          • 2. Re: sample oracle 11g database
            phaeus
            Hello,
            first create you a free Oracle Account on otn.oracle.com

            Next download you a Express Edtion.
            http://www.oracle.com/technetwork/products/express-edition/downloads/index.html

            A good starting point can be the oracle learning library.
            http://apex.oracle.com/pls/apex/f?p=44785:1

            Or check out the blogs and newsletters on otn.oracle.com depends in what you want to learn. Also keep in mind that you can access the documentaion from otn.oracle.com or from http://tahiti.oracle.com/

            hope this helps
            regards
            Peter
            • 3. Re: sample oracle 11g database
              EdStevens
              915461 wrote:
              1st of all thanks for clicking my post. I am new to Oracle so thouth to post where I got oppertunity.

              Can anyone help with sample databast name or link for Oracle 11g express edition. I have MS SQL Server background 2005/2008 and I am very new to Oracle. I got oppertunity to work on Oracle between I want to practice like I practiced on AdventureWorks for SQL Server.

              Also, if you have links of some really good tutorial for SQL and PL SQL oracle 10g or 11g then please help with same :)
              ranit and phaeus have given you some very good specific pointers. Please allow me to point out something a bit more general for your situation

              When approaching Oracle you should forget everything you know from SQL Server. The products are fundamentally and profoundly different, from their internal architecture all the way out through their user interfaces. The similarities begin and and with SELECT * FROM EMP;. Even the term 'database' has a very different conceptual meaning. You've already been pointed to the doc set at tahiti.oracle.com. Please go there, then

              Drill down to your product and version.

              <b><i><u>BOOKMARK THAT LOCATION</u></i></b>

              Spend a few minutes just getting familiar with what is available here. Take special note of the "books" and "search" tabs. Under the "books" tab you will find the complete documentation library.

              Spend a few minutes just getting familiar with what <b><i><u>kind</u></i></b> of documentation is available there by simply browsing the titles under the "Books" tab.

              Open the Reference Manual and spend a few minutes looking through the table of contents to get familiar with what <b><i><u>kind</u></i></b> of information is available there.

              Do the same with the SQL Reference Manual.

              Do the same with the Utilities manual.

              You don't have to read the above in depth. They are <b><i><u>reference</b></i></u> manuals. Just get familiar with <b><i><u>what</b></i></u> is there to <b><i><u>be</b></i></u> referenced. Ninety percent of the questions asked on this forum can be answered in less than 5 minutes by simply searching one of the above manuals.

              Then set yourself a plan to dig deeper.
              - Read a chapter a day from the Concepts Manual.
              - Take a look in your alert log. One of the first things listed at startup is the initialization parms with non-default values. Read up on each one of them (listed in your alert log) in the Reference Manual.
              - Take a look at your listener.ora, tnsnames.ora, and sqlnet.ora files. Go to the Network Administrators manual and read up on everything you see in those files.
              - When you have finished reading the Concepts Manual, do it again.
              • 4. Re: sample oracle 11g database
                918464
                Hi Ranit B.

                Thank you so much for your help. I am looking for any sample database on which I can practise as I use to do it Adventure Database in SQL Server.
                Can you please help. :)
                • 5. Re: sample oracle 11g database
                  BluShadow
                  915461 wrote:
                  Hi Ranit B.

                  Thank you so much for your help. I am looking for any sample database on which I can practise as I use to do it Adventure Database in SQL Server.
                  Can you please help. :)
                  If you install the Oracle Express database, there are sample databases that can be used for practice, such as the HR schema etc. These are all in the documentation you've been pointed to.