SQL Basics

 
Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
User Name:
Password:
Remember me



Go Back   Tutorialized ForumsDatabasesSQL Basics

Reply
Add This Thread To:
  Del.icio.us   Digg   Google   Spurl   Blink   Furl   Simpy   Y! MyWeb 
Thread Tools Search this Thread Rate Thread Display Modes
 
Unread Tutorialized Forums Sponsor:
  #1  
Old December 28th, 2016, 09:07 AM
mworkman911 mworkman911 is offline
Registered User
Tutorialized Newbie (0 - 499 posts)
 
Join Date: Dec 2016
Posts: 1 mworkman911 User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 43 m 23 sec
Reputation Power: 0
The SQL thinking process for complex queries...

Hello all,

I pose this question to the experienced SQL developers on this forum, since I've tried for years to find an answer to my question, and have yet to find one. In my years as a programmer working with and maintaining some very complex SQL queries, I've been unable to fully understand the thinking process one has to have in order to be able to create such incredibly sophisticated SQL queries. Is there a methodology one needs to follow, or be able to think in certain ways in order to create these type queries? Or is the skill developed by trial and error over years of experience? Hopefully it is not completely the latter, since it seems logical to me that there are ways to analyze and build queries starting at the granular level perhaps and building on to that. Or maybe the inverse - from the general down to the granular. I'm not looking for an easy way out or a short cut to hard work, but simply the thinking process involved that would allow me to make the most efficient use of my time when attempting to develop queries like these. Is there anything written, a book, a guide, a tutorial, a SQL guru, etc. that anyone can recommend that provides a method overview, or of a conceptualized thinking process needed to develop these very complex SQL queries that seemingly only a select few in an IT department can create?

Thank you for your responses.

MLW

Reply With Quote
Reply

Viewing: Tutorialized ForumsDatabasesSQL Basics > The SQL thinking process for complex queries...


Developer Shed Advertisers and Affiliates


Thread Tools  Search this Thread 
Search this Thread:

Advanced Search
Display Modes  Rate This Thread 
Rate This Thread:


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 On
HTML code is Off
View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox
Forum Jump


Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
  
 

Powered by: vBulletin Version 3.0.5
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.

© 2003-2017 by Developer Shed. All rights reserved. DS Cluster - Follow our Sitemap