Computer Forums

Member Login

Remember Me? Sign Up! | Forgot Password
 
Slogan
 
Closed Thread
Old 01-25-2009, 03:25 PM   #1 (permalink)
clark33's Avatar
 
True Techie

Join Date: May 2008

Location: Edinburgh, Scotland

Posts: 110

clark33 is on a distinguished road

Default Sql

Hi,

Is Structured Query Language easy to pick up, with a personal background of strong first level and basic second level IT knowledge. I understand theory - the reasoning for variables and if statements and so forth. What i need to know is - can I grasp the practicality of this quickly by using the different retrieval commands/strings. The timescale i need to grasp the basics of this would be over 10 days.

Thanks for your opinions..
__________________
“The best plans of men and mice often go awry”
clark33 is offline  
Old 01-25-2009, 03:36 PM   #2 (permalink)
Baez's Avatar
 

Join Date: Sep 2005

Location: Toronto, Canada

Posts: 5,465

Baez is a glorious beacon of lightBaez is a glorious beacon of lightBaez is a glorious beacon of lightBaez is a glorious beacon of lightBaez is a glorious beacon of light

Default Re: Sql

Sure you can. SQL is very simple and you can learn the basics easily within 10 days.
__________________

Baez is offline  
Old 01-25-2009, 03:53 PM   #3 (permalink)
 

Join Date: Jul 2005

Location: England

Posts: 2,159

kmote has a spectacular aura aboutkmote has a spectacular aura about

Default Re: Sql

SQL is not a "real" programming language, it's a way to get data from a database. The DBMS you are running will have a client library* so that your app can access the data on the server. SQL itself is very easy to pick up for the most part and if you are simply using it through a client provided in your DBMS package (rather than programming something yourself) then you will have no problems whatsoever.

* The client library will include functions for querying the database and your SQL will form one of the parameters for that function (for security reasons you should be careful about this, more info can be given if needed)
__________________
MSI P43 Neo|Enermax Pro82+ 425W|E5200|silent 8500GT|250GB Samsung spinpoint F1|Samsung SATA DVD RW|4GB Corsair|Antec SOLO|openSUSE11


There are in order of increasing severity: lies, darn lies, statistics, and computer benchmarks. - diskinfo man page
kmote is online now  
Old 01-25-2009, 04:01 PM   #4 (permalink)
clark33's Avatar
 
True Techie

Join Date: May 2008

Location: Edinburgh, Scotland

Posts: 110

clark33 is on a distinguished road

Default Re: Sql

I really appreciate the replies. So, what im grasping is that the application client side will not hold the data - as it sits on the server side (due to size?). I would be using this strictly for reporting, so no programing. I should be ok then, from what your saying. I'll have to wire into some tuturials to bring me up to speed.
__________________
“The best plans of men and mice often go awry”
clark33 is offline  
Old 01-25-2009, 04:08 PM   #5 (permalink)
Baez's Avatar
 

Join Date: Sep 2005

Location: Toronto, Canada

Posts: 5,465

Baez is a glorious beacon of lightBaez is a glorious beacon of lightBaez is a glorious beacon of lightBaez is a glorious beacon of lightBaez is a glorious beacon of light

Default Re: Sql

MSDN is the best place to start learning. And yes it is the server that holds all data.
__________________

Baez is offline  
 
Closed Thread

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
sql server possible on shared hosting? subxuk Programming Discussions 1 11-10-2008 08:31 AM
SQL server removal superdave1984 Windows Operating Systems and Software 2 07-25-2008 11:22 AM
SQL server error wicked23 Windows Operating Systems and Software 6 03-05-2008 05:28 PM
Domain Controller and SQL server Build abadjay Building, Buying, or Upgrading High Performance PC Systems 2 10-05-2007 08:39 AM