How can I learn to write my own query's

For users or potential users.
Post Reply
djanash@mac.com
Posts: 59
Joined: Sat Mar 13, 2010 11:11 am

How can I learn to write my own query's

Post by djanash@mac.com » Mon Jun 10, 2013 6:34 pm

Can any one recommend a book to learn how to write my own Query's?
...I usually like to mine my own stats and info and I feel like the OD Query list is good but I'd like to be able to stylize things and tweak them some times.

I have no programming experience but am very tech savvy
They actually have a MySQL for dummies book available but I think it may be too brief.

Thx!

bpcomp
Posts: 304
Joined: Mon Feb 27, 2012 7:30 am
Location: Tucson, AZ
Contact:

Re: How can I learn to write my own query's

Post by bpcomp » Tue Jun 11, 2013 11:55 am

I started out by modifying existing queries and then asking for help when I didn't understand why it didn't work. It helps to have an understanding of how a database is built so that book you have may be brief but it will probably help with some key concepts. Once you start to try and make your own more complex queries, you can post them on the forum for help troubleshooting if it's not working and hopefully you'll learn every time you do that. Once you start to get into it more you'll want to look at http://www.opendental.com/manual/progra ... urces.html which has a list of all the tables in the database so you can find the info you want. Good luck!

Tom Zaccaria
Posts: 353
Joined: Mon Feb 25, 2008 3:09 am

Re: How can I learn to write my own query's

Post by Tom Zaccaria » Tue Jun 11, 2013 5:19 pm

I would search online for mysql tutorials for examples and then just jump in. We'll help you.

drtmz

User avatar
jsalmon
Posts: 1551
Joined: Tue Nov 30, 2010 12:33 pm
Contact:

Re: How can I learn to write my own query's

Post by jsalmon » Wed Jun 12, 2013 10:53 am

My advice is try to really understand what the different types of joins (inner, outter, etc). do and how they affect results. Once you've mastered the power of joining tables together the rest is relatively trivial. http://www.w3schools.com/ has a good generic SQL tutorial. Just be careful, sometimes MySQL wants queries written in a specific way. When in doubt, fall back to the MySQL 5.5 ref manual: http://dev.mysql.com/doc/refman/5.5/en/
The best thing about a boolean is even if you are wrong, you are only off by a bit.

Jason Salmon
Open Dental Software
http://www.opendental.com

Post Reply