Another DBA question...

[cHk4]

Ok so I've gone for a trainee/junior DBA job role. I have my interview next week and obviously I want to read up on SQL etc so that when asked any questions I have a brief bit of knowledge about it.

Are there any good books or any recommended online resources that I can read which will give me a good understanding to the basics of SQL and a DBA? Now I know I can google this but not knowing anything about SQL I don't want to read up on the wrong things so any help is appreciated.

Thanks

 

[cHk4]

Hi, the below is what was outlined - that is all I really know.

Key Tasks and Areas of Activity:

• Providing support on SQL Server installations
• Carrying out database administration tasks
• Establishing operational processes
• Applying change control and release procedures
• Implementing additional facilities

 

[cHk4]

Anyone? I know I haven't given you much to go by lol.

 

[cHk4]

Rule 1 of SQL basics :

don't use DELETE FROM table_name without a WHERE or you nuke all the records in the table . I have seen this in action and it wasn't pretty for the DBA that did it where I work !!

Haha thanks mate

Did he not know about the ROLLBACK command?

Reading your job spec I would expect they'll be more interested in your knowledge of SQL Server 2008 e.g. how to install it, integration with Windows AD, how to archive and backup, partitioning, clustering and just how to maintain the installation, what a schema is.

I guess it wouldn't hurt to know about how to create tables, indexes, keys etc in SQL though. I'm not a DBA btw, so take with a pinch of salt

You know what that sounds exactly like what it will be! I'll try and find some stuff to read about about what you mentioned.