Home > IT Answers > Database > Free online practice exercises on SQL/Oracle
Kpatel
0 pts.
 Free online practice exercises on SQL/Oracle
MySQL, Oracle, SQL Server
I would like to know is there any website which offers free practice exercises on SQL/Oracle queries? Preferably advanced level queries. Thanks, Kruti

Software/Hardware used:
ASKED: March 17, 2005  9:47 AM
UPDATED: April 17, 2013  7:07 PM
RELATED QUESTIONS
Answer Wiki:
A Gentle Introduction to SQL http://sqlzoo.net/ SQLCourse - Interactive Online SQL Training for Beginners http://sqlcourse.com/ SQLCourse2 - Advanced Online SQL Training http://sqlcourse2.com/ SQL Exercises - Online SQL (DML) Training <a href="http://www.sql-ex.ru/">www.sql-ex.ru/</a> w3schools you want online free test check this: it is more usefull............ www.wiziq.com/tests/sql ///////////////////////////////////// www.sqlzoo.net //////////////////////////////////////
Last Wiki Answer Submitted:  April 17, 2013  7:07 pm  by  Michael Tidmarsh   11,380 pts.
All Answer Wiki Contributors:  Michael Tidmarsh   11,380 pts. , Mkkarthik09   45 pts. , Gowriking   65 pts. , Reachsurendar   15 pts. , msi77   1,610 pts. , Mkkarthik09   0 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

i like it most :)

Dhusor
 10 pts.
 

thanks

Studyandwork
 10 pts.
 

SELECT Title, FristName, LastName, Phone, Location
From Employees, Office
Where Employees.EmpID=Location.EmpID AND
Dept= “operation”
Order By Employees,

There is something wrong and I can’t figure it out.

Klaus23
 10 pts.
 

theirs something wrong and i cant figure it out.
 
Since you didn’t tell us anything about what the DBMS is nor anything about the tables nor what is wrong, it’s not easy for us to figure anything either. (Though there’s at least one and possibly two fairly obvious possibilities.)
 
And since this has nothing to do with this question thread, I suggest you open a new question. When you do, give us enough information to make useful guesses at least.
 
Tom

TomLiotta
 107,735 pts.
 

Many mistakes. Try this:

SELECT Title, FirstName, LastName, Phone, LocationFrom Employees, OfficeWhere Employees.EmpID=
Office.EmpID AND Dept= 'operation'Order By Employees.FirstName

msi77
 1,610 pts.
 

Carlosdl shares his thoughts on how to run a query using both SQL Server and Oracle databases.

Michael Tidmarsh
 11,380 pts.