I am about going from infrastructure side DBA to DBA developer, I want to learn data modelling on which one is good for some situtation and some good for other, then I would like to do some good T-SQL programming in order to not doing any bad programming like SQL cursor, while loop.
Any link with particle example easy to follow ? what books is good on this ?
I have few in the list, please comment which is good .
1) SQL and Relational Theory: How to Write Accurate SQL Code by C. J. Date , https://www.amazon.com/gp/product/1449316409/ref=ox_sc_sfl_title_2?ie=UTF8&psc=1&smid=ATVPDKIKX0DER
2) Database Modeling and Design, Fifth Edition: Logical Design (The Morgan Kaufmann Series in Data Management Systems) by Toby J. Teorey http://www.amazon.com/gp/product/0123820200/ref=ox_sc_sfl_title_3?ie=UTF8&psc=1&smid=ATVPDKIKX0DER
Database Design and Relational Theory: Normal Forms and All That Jazz (Theory in Practice) by C. J. Date
SQL Server 2014 Development Essentials by Basit A. Masood-Al-Farooq
Beginner Database Design & SQL Programming Using Microsoft SQL Server 2014 by Kalman Toth
SQL Server Integration Services Design Patterns by Andy Leonard
7) SQL Server 2014 Design & Programming by Kalman Toth
SQL Server 2014 Database Design by Kalman Toth
SQL Server Tuning Scripts: Performance Optimization Secrets (IT In-Focus) by Robin Schumacher
Pro SQL Server 2012 Relational Database Design and Implementation (Expert's Voice in SQL Server) by Louis Davidson
is the one from Kalman Toth, one of the best one as she already one of the famous SQL server professional in the world ?
you can see that she is focusing on T-SQL developement ?