Job interview tommorow - Transact-SQL query

[Hank_Marvin]

So when you say support, what do you actually mean? who would you support via the use of sql?

 

[xJcBx]

If they ask to see your skills, have a look at the tables, pick a few of the bigger ones and type drop table table_name.

You'll get the job.

Made me lol.

SQL is, arguably, the easiest 'language' to learn. W3schools it the best place to learn the basics of it.

Edit: unlucky with the job :I

 

[Hank_Marvin]

Yeah i've been going through w3 schools a bit, sql section seems seems great, had used it before when I was learning html.

Can anyone suggest some sort of practice/testing setup to aid with learning sql.

 

[xJcBx]

If you have access create a simple database with a few tables, data and relationships, and create a new query to update some data or retrieve some data/orderby ect or whatever, using the built in query builder, and then view it in SQL view and make sure you can understand what it has done and how it does it.

 

[Mr^B]

So when you say support, what do you actually mean? who would you support via the use of sql?

The support of in-house written applications using SQL Server.

Sometimes data clean up is required in a production system, or a user will make a request for some data that isn't available via an application (but is in the database).

So you'll have to know the data schema and construct a sql query to get the data out, or to update/clean some data up.

 

[Hank_Marvin]

JcB i'll do just that, thanks for the tips.

Ok Mr B that's what I suspected you meant, so your basically working the database, getting data that people require, making reports etc.

Hmmmm good stuff, def considering sql to learn.

Thanks