Murach's SQL Server 2012 for Developers
Book Details:
Publisher: | Mike Murach & Associates |
Series: |
Murach
|
Author: | Bryan Syverson |
Edition: | 1 |
ISBN-10: | 1890774693 |
ISBN-13: | 9781890774691 |
Pages: | 814 |
Published: | Aug 20 2012 |
Posted: | Nov 19 2014 |
Language: | English |
Book format: | PDF |
Book size: | 126.75 MB |
Book Description:
Every application developer who uses SQL Server 2012 should own this book. To start, it presents the essential SQL statements for retrieving and updating the data in a database. You have to master these to work effectively with database data in your applications. Then, it shows you how to design and create a database, because application developers often end up in the role of database designer and DBA. Next, it shows how to work with views, scripts, stored procedures, functions, triggers, cursors, transactions, locking, security, XML data, and BLOB data with FILESTREAM storage. These features allow you to create database applications that are thoroughly professional. Finally, this book shows how to use the CLR integration feature and SQL Server Data Tools (SSDT), so you can use Visual Studio to code stored procedures, functions, triggers, aggregate functions, and user-defined types in C# or Visual Basic.
This book is designed to teach application developers all of the skills they need to use SQL to work with a Microsoft SQL Server 2008 database. But it's also a great first book for developers who are on the path to becoming a DBA.Unlike most SQL Server 2008 books, this one starts by showing you how to use SQL queries to extract and update the data in a database, because that's what every application developer needs to know first. Then, it shows how to design and implement a database, how to use powerful backend database features like views, stored procedures, functions, triggers, cursors, transactions, locking, security, and how to work with BLOB and XML data. Finally, it shows how to use the CLR integration feature to create database objects using a...
This Visual Basic book has been a favorite of developers ever since the 1st edition came out in 2002.Now, this 5th Edition is a self-paced, professional book that shows how to use Visual Studio 2012, VB 2012, and the .NET 4.5 classes to develop Windows Forms applications. It's a data programming book that shows how to (1) prototype professional database applications using RAD features like data sources, (2) start using ADO.NET to work directly with databases for more control, and (3) use LINQ to query a variety of data sources, from databases to arrays to XML files. It's an object-oriented book that shows how to use business classes, inheritance, and interfaces the way they're used in the real world. It's a hands-on book that shows you how to develop...
If you're developing applications that access Oracle databases, you can save time and work by having SQL do more of the data handling for you: This new book shows you how. It teaches you how to create effective SQL queries to extract and update the data in an Oracle database. It teaches you how to design and implement a database, giving you insight into performance and security issues. It teaches you how to use PL/SQL to take advantage of powerful features like stored procedures, functions, and triggers. In short, it teaches you to create the kind of efficient database applications that make you a more effective and valuable developer.Here are 5 of the ways that our book differs from the others#1: You'll see how to take advantage of the Oracle SQL De...
2007 - 2021 © eBooks-IT.org