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: 68758
Registered: March 2007
Location: Saint-Maur, France, https...
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: 68758
Registered: March 2007
Location: Saint-Maur, France, https...
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: Mon Jun 02 00:13:38 CDT 2025