SQLTeam.com | Weblogs | Forums

SQL queries based on data modeling

tsql

#1

Hi,

I have a job interview test and they said that the test is SQL queries based on data modeling. What do you think they mean? Will they give me a database diagram and they will ask me questions such as select all rows from tables X and Y where x.salary>y.salary?

Thanks


#2

Bizarre; I can't imagine what the qs will be. SQL queries and data modeling have nothing to do with each other. [Data models, perhaps, but not data modeling itself.]


#3

Thanks. If they meant data models then what qs will they ask? In the past i have been given a diagram and asked queries based on that.


#4

That must be it. I guess they are not going to show you actual DDL ("CREATE TABLE ...") but instead just show you a picture. That means your code may not be the very best in some cases, as you won't know for sure the underlying data types of the columns.


#5

I think I might ask them if that is what they meant. Do you know where I can practice some complex queries?


#6

Itzik Ben-Gan. Superb T-SQL coder and instructor, particularly on advanced topics. But I believe he has some articles/books on general queries too. If you really want to learn it, I suggest books.


#7

Thanks. I am a programmer and I know SQL but just want to practice as I feel I haven't done really complex queries at work lately.