CODEWITHSUNDEEP
sql
Elad Benda
Elad Benda

Reputation: 36656

SQL: looking for translation practice

I have to take an T-SQL exam. I will be given a real world scenario and I will need to design a database schema (small number of tables) that will help answer some questions (writing SQL statements) about that scenario.

I'm a dot net developer. Read a good book on SQL.

I'm looking a web-site in which there are many examples (with vary difficulties) of english statments and thier SQL translation. I intend to write my sql translation aside and compare it with the right one from the site.

Any other site that can help prepare for this test, would be appreciated.

Thanks!

Upvotes: 0

Views: 159

Answers (3)

Elad Benda
Elad Benda

Reputation: 36656

The site that answered my needs (practice rather than studying) was: http://sqlzoo.net/

Upvotes: 0

MAW74656
MAW74656

Reputation: 3539

Their tutorials and explanations are great, and you can even try it online. I'm fairly comfortable with SQL after 2 years, and I still use their site whenever I needs to check syntax or something.

http://www.w3schools.com/SQl/sql_tryit.asp

But the best experience might just be to make something. I had to make a web application for my senior project, and that forced me to see what I didn't know and learn it real quick. I learned most of what I know about several languages on that project. Do you have any collections? If you collect something, try to build a database to track your collection (my senior project tracked baseball cards).

Upvotes: 1

Robert Kaucher
Robert Kaucher

Reputation: 1861

http://books.google.com/books/about/SQL_Server_2008_Transact_SQL_Recipes_A_P.html?id=MvcLHkwnr1MC

Take a look at the queries in that book. You should find it pretty useful.

Upvotes: 1

Related Questions