I am experienced DB2 UDB and Oracle DBA who needs to get back into SQL Server DBA support for my current job since we have a need for another SQL Server DBA in addition to my role as the primary DB2 guy. What Microsoft training courses would be best for experienced DBA who needs to ramp up as an MS SQL Server DBA? Thanks
ScottMicrosoft just created a course for experienced dba's to get to know SQL Server quickly. See http://www.microsoft.com/traincert/syllabi/2723Afinal.asp Don't know the quality of this course though.
Showing posts with label db2. Show all posts
Showing posts with label db2. Show all posts
Monday, March 12, 2012
Good SQL books for (SQL-server, oracle, DB2, Postgress, MySQL)
Hello All,
Anyone could suggest good books for writing SQL?
(and also optimise the performance of SQL statements).
I am planning to buy 2 or 3 SQL related books. I know the basic SQL (e.g. writing join, left join, nested join). I have been using SQL for 3 months. I am working as a data analyst/ data mining consultant. So I am NOT looking the DBA parts or the programming parts. Just writing adhoc SQL queries to extract data for data mining purpose. The queries have to be optimised and fine tuned.
Any advise would be very much appreciated.
Thanksif you are trying to cover the bases then SQL in a nutshell from O'Reilly is quite usefull. although it has dated very quicky as new verions have come out.
The version I have covers SQL Server, MySQL, Oracle & PostgreSQL.
As to to fine tuning tuning your weaponf fo choice should have suitable tools such as explain etc...|||Thanks, I bought this just now from amazon. Yes, one of them is SQL in a nutshell. Hopefully they are good choices.
-----------------
1 of: SQL Tuning [Paperback]
By: Dan Tow
$26.37
1 of: Data Modeling Essentials, Third Edition (Morgan Kaufmann Series in Data Management Systems) (The Morgan Kaufmann Series in Data Management Systems) [Paperback]
By: Graeme Simsion, Graham Witt
$35.93
1 of: SQL Performance Tuning [Paperback]
By: Peter Gulutzan, Trudy Pelzer
$28.49
-
1 of: SQL Pocket Guide [Paperback]
By: Jonathan Gennick
$9.95
1 of: SQL In A Nutshell, 2nd Edition [Paperback]
By: Kevin Kline, et al
$29.67
Anyone could suggest good books for writing SQL?
(and also optimise the performance of SQL statements).
I am planning to buy 2 or 3 SQL related books. I know the basic SQL (e.g. writing join, left join, nested join). I have been using SQL for 3 months. I am working as a data analyst/ data mining consultant. So I am NOT looking the DBA parts or the programming parts. Just writing adhoc SQL queries to extract data for data mining purpose. The queries have to be optimised and fine tuned.
Any advise would be very much appreciated.
Thanksif you are trying to cover the bases then SQL in a nutshell from O'Reilly is quite usefull. although it has dated very quicky as new verions have come out.
The version I have covers SQL Server, MySQL, Oracle & PostgreSQL.
As to to fine tuning tuning your weaponf fo choice should have suitable tools such as explain etc...|||Thanks, I bought this just now from amazon. Yes, one of them is SQL in a nutshell. Hopefully they are good choices.
-----------------
1 of: SQL Tuning [Paperback]
By: Dan Tow
$26.37
1 of: Data Modeling Essentials, Third Edition (Morgan Kaufmann Series in Data Management Systems) (The Morgan Kaufmann Series in Data Management Systems) [Paperback]
By: Graeme Simsion, Graham Witt
$35.93
1 of: SQL Performance Tuning [Paperback]
By: Peter Gulutzan, Trudy Pelzer
$28.49
-
1 of: SQL Pocket Guide [Paperback]
By: Jonathan Gennick
$9.95
1 of: SQL In A Nutshell, 2nd Edition [Paperback]
By: Kevin Kline, et al
$29.67
Subscribe to:
Posts (Atom)