Solved

Learning to write SQL queries

Posted on 2011-03-02
9
385 Views
Last Modified: 2012-08-13
I want to learn SQL to be able to write queries.  I want to be able to datamine, join tables, etc...Does anyone have a recommeded website or continuing education class that you would recommend?
0
Comment
Question by:gloyola1
9 Comments
 
LVL 1

Accepted Solution

by:
klittlejohn1 earned 72 total points
ID: 35023948
Here is a site that I use and it has helped me a lot.

http://www.sqlservercentral.com/
0
 
LVL 41

Assisted Solution

by:Sharath
Sharath earned 72 total points
ID: 35023981
You can start from here if you are looking for basics. http://www.w3schools.com/sql/default.asp
0
 
LVL 8

Assisted Solution

by:PeteEngineer
PeteEngineer earned 285 total points
ID: 35023990
0
Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

 
LVL 1

Expert Comment

by:klittlejohn1
ID: 35023992
I forgot all about that one Sharath. I have used that one too and it is a good site.
0
 
LVL 8

Assisted Solution

by:PeteEngineer
PeteEngineer earned 285 total points
ID: 35023993
0
 
LVL 8

Assisted Solution

by:PeteEngineer
PeteEngineer earned 285 total points
ID: 35023995
0
 
LVL 8

Assisted Solution

by:PeteEngineer
PeteEngineer earned 285 total points
ID: 35023999
0
 
LVL 24

Assisted Solution

by:jimyX
jimyX earned 71 total points
ID: 35024021
Very good web sites above there, in addition, let's not forget some good books.
You can google "learn SQL Queries" under books and you will get many to read on line.
You may have a look on this one:

http://books.google.com/books?id=uXsi_0_vSrAC&pg=PA1&dq=learn+sql+queries&hl=en&ei=7AxvTaeeGse9tger_pjzDg&sa=X&oi=book_result&ct=result&resnum=3&ved=0CDUQ6AEwAg#v=onepage&q=learn%20sql%20queries&f=false
0
 
LVL 9

Expert Comment

by:sarabhai
ID: 35028808
ok.

lets start with W3school site, this is basic fundamentals.


after that msdn is the original source so msdn help tells every thing.

and be hand on the Relational Algebra for query writing.
0

Featured Post

NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Introduction: When running hybrid database environments, you often need to query some data from a remote db of any type, while being connected to your MS SQL Server database. Problems start when you try to combine that with some "user input" pass…
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
In a recent question (https://www.experts-exchange.com/questions/29004105/Run-AutoHotkey-script-directly-from-Notepad.html) here at Experts Exchange, a member asked how to run an AutoHotkey script (.AHK) directly from Notepad++ (aka NPP). This video…
I've attached the XLSM Excel spreadsheet I used in the video and also text files containing the macros used below. https://filedb.experts-exchange.com/incoming/2017/03_w12/1151775/Permutations.txt https://filedb.experts-exchange.com/incoming/201…

679 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question