6711988
9780470257012
Starting simply and gradually progressing to increasingly advanced topics, this introduction to the SQL Server database focuses on what is distinctive about the SQL environment-SQL Server 2008, in particular-versus other programming environments. Author Robert Vieira draws on his experience as one of the leading authorities on Microsoft SQL Server and uses his unique tutorial approach to explain the significant changes to the fundamental core components of SQL Server 2008.You'll begin with an overview of database design concepts and learn how to implement these fundamental concepts with Microsoft SQL Server 2008. Then, you'll take a look at the role of an RDBMS (relational database management system) and where it fits in the grand scheme of system development. Thorough coverage of the key additions and changes to the 2008 version of SQL Server include discussions on DATE and TIME datatypes, hierarchyID datatypes, MERGE and multiple inserts, recursive queries, and more. With this book, you will conquer the many changes and challenges of Microsoft SQL Server 2008.What you will learn from this bookHow RDBMSs store, manage, and retrieve dataWays to create and alter tablesVarious "forms" of database normalizationTechniques for writing scripts and working with stored proceduresThe positives and negatives of indexesMyriad consequences that locks and deadlocks have on system performanceAn understanding of triggers and how they are usedWho this book is for This book is for developers who are looking for a complete introduction to database design concepts and learning SQL. A basic understanding of development fundamentals is helpful.Wrox Beginning guides are crafted to make learning programming languages and technologies easier than you think, providing a structured, tutorial format that will guide you through all the techniques involved.Vieira, Robert is the author of 'Beginning Microsoft SQL Server 2008 Programming', published 2009 under ISBN 9780470257012 and ISBN 0470257016.
[read more]