Get Paid to Participate - up to $1 per post!     Twitter     Facebook     Google+
Hosting Discussion
 

Hosting Discussion > Web Hosting Forums > Website Development & Design > What makes query language tough?
forgot password?



Reply


Old
  Post #1 (permalink)   08-05-2014, 10:11 AM
HD Newbie
 
Join Date: Mar 2014
Posts: 17

Status: joseWebline#1 is offline
I'm studying Intro to databases and I'm surprised how tough querying can be sometimes.
I wonder what makes it tough?

Is it the language constraints? Or is it because it is too strict and formal?
 
 
 


Old
  Post #2 (permalink)   08-05-2014, 11:41 AM
HD Amateur
 
Join Date: Mar 2005
Posts: 51
Send a message via AIM to wh-coach Send a message via Skype™ to wh-coach

Status: wh-coach is offline
I've done tons of development with SQL and I also used a unified development environment called 4D (4th Dimension).

I think there are two issues:

1) Defining the problem adequately. This is a fundamental tenet of software development but frequently overlooked.

2) Trying to do too much with a SQL query. What I've seen too often is developers who try to cram all their solutions into a single query. Depending on how you're driving your queries, there may be better ways to do it.

Remember, applications are nothing without their data. If you're dealing with SAN-connected data you're dealing in different query styles than you are with direct attached storage. either way you need to create responsive data to applications - so I don't think database is any more'difficult' than any other tech craft, I just think it's probably one of the more mysterious because nobody sees it but they sure feel the effects if it's done poorly.
__________________
Availanet Solutions - Helping you stretch your hosting dollar since 2003 -
Highly Flexible VPS Solutions at Reasonable Prices
 
 
The Following User Says Thank You to wh-coach For This Useful Post:
HostLeet (08-05-2014)


Old
  Post #3 (permalink)   09-13-2014, 02:18 PM
HD Addict
 
Join Date: Apr 2013
Location: Byfleet, Surrey, UK
Posts: 107

Status: 4D Hosting is offline
On this link you will find some rules that are useful to consider to reduce complexity of the database and therefore the queries:
http://www.codeproject.com/Articles/...les-which-I-fo

W3school is a good website to learn SQL queries and build very basic skills in this language.
http://www.w3schools.com/sql/

Another source to learn SQL:
http://www.sqlcourse.com/index.html
 
 
 
Reply

Thread Tools

New Post New Post   Old Post Old Post
Posting Rules:
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Sponsored By: