Murach's SQL Server 2019 for Developers
0
0
As an Amazon Associate and affiliate partner, Menrva Books earns from qualifying purchases. Learn more
Author Description
If youre an application developer, or youre training to be one, this latest edition of Murachs classic SQL Server book is made for you. To start, it presents the SQL statements that you need to retrieve and update the data in a database. These are the SQL statements that youll use every day. Then, it shows you 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, security, XML data, BLOB data with FILESTREAM storage, and the CLR integration feature. The result? Youll be able to create database applications that are thoroughly professional. Youll be familiar with the DBA-related issues that let you work far more effectively than most of your colleagues. And youll have a handy reference at your side to answer questions and handle new challenges as they come up.
Menrva's Summary
THE THESIS
This book provides application developers with a comprehensive guide to SQL Server 2019, covering essential SQL statements and advanced database features. The authors, Bryan Syverson and Joel Murach, leverage their expertise to guide readers through designing and implementing databases, working with various database objects like views and stored procedures, and managing data types such as XML and BLOB. The objective is to equip developers with the skills to create professional database applications and understand DBA-related tasks for enhanced effectiveness.
THE SCOPE MAP
- Introduction to essential SQL statements for data retrieval and updates.
- Database design principles and implementation strategies.
- Working with database features including views, scripts, and stored procedures.
- Understanding functions, triggers, and transaction management.
- Security considerations in SQL Server.
- Handling XML data and BLOB data with FILESTREAM storage.
- Introduction to CLR integration features.
- Guidance on DBA-related issues for effective collaboration.
THE AUTHORITY PERSPECTIVE
This book is designed for application developers and those in training, aiming to provide a thorough understanding of SQL Server 2019. It covers fundamental SQL operations as well as more complex features like XML data handling and CLR integration. The content is structured to build professional competence and offer a valuable reference for ongoing challenges. The approach emphasizes practical application and effective database management.
Page Count:
698
Publication Date:
2020-01-01
Publisher:
Mike Murach & Associates, Incorporated
ISBN-10:
1943872570
ISBN-13:
9781943872572
Science & Technology
Non-Fiction
SQL
Programming
Databases
Reference
Community Tags
Similar Books
