Microsoft sql server 2008 database development - Weber Ann - książka wyd. 2009

Opis

The book “Microsoft SQL Server 2008 Database Development” is a comprehensive guide for developers and database administrators who want to master the design, creation, and optimization of databases in the SQL Server 2008 environment. The author walks readers step by step through the process of building databases, designing tables, indexes, and relationships, as well as implementing primary and foreign keys. The book covers T-SQL in depth, showing how to write efficient queries, stored procedures, functions, and triggers, as well as how to manage transactions and ensure data integrity. A significant portion is devoted to database schema design according to normalization principles, performance optimization, and monitoring and troubleshooting query issues. Security topics, such as user permissions and data backup strategies, are also thoroughly explained. With practical examples and exercises, readers gain both theoretical knowledge and hands-on skills necessary for working effectively with SQL Server 2008. Written in a clear yet detailed style, the book is valuable for beginners seeking foundational understanding as well as experienced developers aiming to deepen their expertise in creating and managing professional databases within the Microsoft SQL Server environment.