 How to work with SQL from home PC [message #543633] |
Thu, 16 February 2012 01:16  |
|
|
HI All,
I am a very new to oracle.I want to practice Oracle SQL from home.What software i need to install. Even if i install SQL developer,SQL+ which database i can access n how.
Please guide me i will look for your reply
Thanks
Monoseej
|
|
|
|
|
|
|
|
| Re: How to work with SQL from home PC [message #543640 is a reply to message #543637] |
Thu, 16 February 2012 01:36  |
|
|
Thanks my friend for replying to my post.
So first i have to download oracle 11g XE and then i have to download SQL developer.
Next i have to connect SQL developer to that database.
But and .ora files will i need to create? any particular username password for the database to connect.
Please can you tell me in details.. I am very new to this format.
Thanks again mate for replying to my post
Thanks
Monoseej
|
|
|
|
| Re: How to work with SQL from home PC [message #543642 is a reply to message #543640] |
Thu, 16 February 2012 01:45 |
 |
Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe
|
Senior Member
Account Moderator |
|
|
When you install that database, you'll have some sample schemas installed (such as HR - human resources). You can connect to it and practice SQL skills.
Or, you can create your own user and work with it (create tables, insert data, etc.). That's a little bit more complex (as you need to issue certain statements you might not be familiar with ... yet). Anyway, everything's written in documentation. Read it, just as they are written on the page (readme first, then Installation Guide, Getting started, 2 day DBA, ...).
Here's a complete 11g R2 documentation; you'll be interested in SQL reference book, I suppose. Feel free to search and read everything you are interested in. Also, bookmark this forum, come and ask.
|
|
|
|
| Re: How to work with SQL from home PC [message #543692 is a reply to message #543642] |
Thu, 16 February 2012 08:22 |
|
|
|
Hi, Thanks for all the help... There is one query just to make sure I am downloading correct thing. I have gone to the given link for oracle 11g XE version and found two downloadable one for windows X32 and other is for Linux x64. will id download the database for the link (Oracle Database Express Edition 11g Release 2 for Windows x32). Please advise
|
|
|
|
|
|
|
|
|
|
|
|
| Re: How to work with SQL from home PC [message #543878 is a reply to message #543706] |
Fri, 17 February 2012 05:56 |
 |
sarma.shp
Messages: 111
Registered: February 2012
|
Senior Member |
|
|
|
SQL DEVELOPER IS the free tool ,it is an application based...but for a beginner like you ..just try to practice from sql*plus with all the queries(syntax) rather than going for apllication based ....That will be helpfull to you.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
