The latest edition of Murachs classic SQL Server book does a better job than ever of teaching the SQL statements that every database developer should know. Each chapter features clear examples, easy-to-understand explanations, best practices, and helpful tips. To start, this book presents the SQL statements for retrieving and updating the data in a database. These are the SQL statements that youll use every day. Then, it shows how to design a database, how to implement that design, and how to work with database features like views, scripts, stored procedures, functions, triggers, transactions, and security. Finally, it shows how to work with an Azure SQL database that runs in the cloud as a service thats available from the Azure cloud computing platform. The result? Youll be able to write SQL thats thoroughly professional, and youll be able to work far more effectively than most of your colleagues. Every Murach book guarantees high quality. The realistic examples show how each feature works in context. The exercises at the end of each chapter let you gain valuable hands-on experience. And the distinctive paired-pages format is ideal for learning and reference.

Author Biography

Joel Murach is the oldest son of publishing pioneer Mike Murach. Joel has been writing and editing books about computer programming for over 20 years now. During that time, he has written extensively on a wide range of Java, .NET, web, and database technologies. He has had best-selling books in all of those categories! In his books, you can see his clear approach to teaching any subject. Besides being a successful author, Joel is also a very talented musician.

We are committed to protecting your rights under the Consumer Guarantees Act and working with our suppliers to assist with warranty claims. Products sold by Mighty Ape will be covered by a Manufacturer's Warranty for at least a one-year period from the date of purchase.

Your warranty will cover any manufacturing defects which, if existing, will present themselves within this warranty period.

Your warranty will not cover normal wear and tear, faults caused by misuse, and accidents which cause damage or theft caused after delivery. Using the product in a way it is not designed for will void your warranty.

Please refer to our Help Centre for more information.