Murach's SQL Server 2012 for Developers Training & Reference
0
0
As an Amazon Associate and affiliate partner, Menrva Books earns from qualifying purchases. Learn more
Author 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.
Menrva's Summary
THE THESIS
This book provides a comprehensive guide for developers on utilizing SQL Server 2012, covering essential database operations and advanced features. It begins by detailing the fundamental SQL statements required for data retrieval and manipulation, crucial for application development. The text then progresses to database design, creation, and the implementation of complex elements like views, scripts, stored procedures, functions, triggers, cursors, transactions, and security configurations. Finally, it explores advanced topics such as XML data, BLOB data with FILESTREAM, and CLR integration using Visual Studio for coding in C# or Visual Basic.
THE SCOPE MAP
- Essential SQL statements for data retrieval and updating.
- Database design and creation principles for application developers.
- Working with views, scripts, stored procedures, and functions.
- Advanced features including triggers, cursors, transactions, and locking.
- Handling XML data and BLOB data with FILESTREAM storage.
- Security configurations within SQL Server 2012.
- Utilizing CLR integration for custom code in C# or Visual Basic.
- Introduction to SQL Server Data Tools (SSDT) for development within Visual Studio.
THE AUTHORITY PERSPECTIVE
This technical reference is designed for application developers working with SQL Server 2012, aiming to equip them with the necessary skills for database interaction and management. The content progresses from foundational SQL commands to intricate aspects of database design and advanced programming features. It serves as a practical guide for developers who may also take on roles in database design and administration.
Page Count:
796
Publication Date:
2012-01-01
Publisher:
Mike Murach & Associates
ISBN-10:
1890774693
ISBN-13:
9781890774691
Science & Technology
Non-Fiction
SQL
Reference
Community Tags
Similar Books
