an anybody point me some books or online tutorials to write effective queries?

I am able to write complex SQL queries but not effective ones.Can anybody point me some books or online tutorials to write  effective queries?
LVL 20
chaitu chaituAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
ValentinoVConnect With a Mentor BI ConsultantCommented:
I'm a big fan of the black Microsoft books written by Itzik Ben-Gan, such as the one called Microsoft SQL Server 2012 T-SQL Fundamentals.

Here's his page on Amazon: Books by Itzik Ben-Gan

You'll not only learn how to write queries, you'll also learn how to write effective ones as mentioned in the description of the book mentioned above.
0
 
ValentinoVBI ConsultantCommented:
If you really want to find out why your queries don't perform well, you should learn about Execution Plans.  This book by Grant Fritchey should help you with that: SQL Server Execution Plans
0
 
chaitu chaituAuthor Commented:
ValentinoV,

Thanks for the reply.Let me go through on it.I want such books or links for Oracle DB as well.
0
The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

 
ValentinoVBI ConsultantCommented:
Can't help you with Oracle, sorry...
0
 
chaitu chaituAuthor Commented:
I will wait for other oracle experts..
0
 
Naveen KumarConnect With a Mentor Production Manager / Application Support ManagerCommented:
I use few online sites like the ones listed below :

http://www.datadisk.co.uk/html_docs/oracle/sql_optimization.htm
http://philip.greenspun.com/sql/complex-queries.html

also i use the asktom.oracle.com to read and understand the previously asked questions/forums which will help one to enhance their skills right.

additionally you can google it out and you will get plenty of them from which you can pick your choices as well.

Thanks,
0
 
chaitu chaituAuthor Commented:
Thanks for the links.on which word(sql optimization or complex queries) do i need to google it?
0
 
Naveen KumarProduction Manager / Application Support ManagerCommented:
some of the below strings/words can be searched and they get a lot of good content/urls. you need to spend time to review/pick up them which are good and store them for your frequent use etc...

oracle efficient sql statements
oracle sql optimization
oracle sql optimization techniques
oracle writing efficient sql
oracle writing efficient queries
0
 
chaitu chaituAuthor Commented:
what kind of oracle books other than online links do you refer mostly while writing complex queries?
0
 
Naveen KumarProduction Manager / Application Support ManagerCommented:
sorry, not really using books these days but used them when i started with oracle stuff in 1990s/2000s and that was a long ago. i some times refer to library reference books but do not remember authors for them.
0
 
Jim HornConnect With a Mentor Microsoft SQL Server Developer, Architect, and AuthorCommented:
I'm with VV.  I won Itzik Ben-Gan's T-SQL Querying book in a local presentation he did a bunch of years ago, and have greatly enjoyed it.
0
 
DavidConnect With a Mentor Senior Oracle Database AdministratorCommented:
To the Oracle side, I'm reluctant to specify sources without knowing your focus -- for example, execution plans were mentioned above -- but at present (12c), Oracle's able to make dynamic evaluation of plans and to improve performance with each run of a statement.  Oracle Press (McGraw-Hill) and APress both present some excellent imprints to choose from.

Moreover, there's technique in one's coding style that goes beyond actual runtime performance.  Does the task require a temporary two-dimensional table, a cursor, an array?  Does overall performance benefit from altering the user resource profiles (memory, sort area) under different loads (batch vs. OLTP)?

I'll be glad to say more if any of this is helpful.

dvz
0
All Courses

From novice to tech pro — start learning today.