Home » Other » Training & Certification » sql guide
sql guide [message #524839] Tue, 27 September 2011 03:12 Go to next message
domDei
Messages: 5
Registered: September 2011
Junior Member
Hi all
I need your help if is possible and I don't ask to much.

Can anyone suggest me a guide where I can find how to improve my sql querys ?

Thanks
Re: sql guide [message #524841 is a reply to message #524839] Tue, 27 September 2011 03:14 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
It depends on what you mean by "guide".
What do you expect from it?

Regards
Michel
Re: sql guide [message #524843 is a reply to message #524841] Tue, 27 September 2011 03:19 Go to previous messageGo to next message
domDei
Messages: 5
Registered: September 2011
Junior Member
A guide/ book to teach me how to write query to can improve my site speed when I try to access database.

I build a social network site. So and I want to learn how to write "good" querys because when will be more users my server is downs from database
Re: sql guide [message #524847 is a reply to message #524843] Tue, 27 September 2011 03:56 Go to previous messageGo to next message
Baranor
Messages: 83
Registered: September 2011
Location: Netherlands
Member
Your queries will have to start from a good, if not excellent, ERD. No matter how good your queries are, if your ERD contains flaws, there is no way to correct anything at all. What Oracle DB are you using?
Re: sql guide [message #524849 is a reply to message #524847] Tue, 27 September 2011 04:06 Go to previous messageGo to next message
domDei
Messages: 5
Registered: September 2011
Junior Member
oracle db 11
Re: sql guide [message #524858 is a reply to message #524843] Tue, 27 September 2011 04:14 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
http://www.orafaq.com/forum/mv/msg/139482/382787/102589/#msg_382787

This will not learn you SQL (this is not a tutorial) but how to write good SQL.

Regards
Michel
Re: sql guide [message #524865 is a reply to message #524839] Tue, 27 September 2011 04:20 Go to previous messageGo to next message
domDei
Messages: 5
Registered: September 2011
Junior Member
ok. Thanks you I will check it
Re: sql guide [message #525938 is a reply to message #524865] Fri, 07 October 2011 01:13 Go to previous message
alexmoore
Messages: 24
Registered: October 2011
Junior Member
A programmer can't become a programmer without a programming so try to refer some good book and starts practicing on it .make your foundation strong
Previous Topic: ERP
Next Topic: what the current scenario of oracle jobs?
Goto Forum:
  


Current Time: Thu Mar 28 08:16:11 CDT 2024