Murach's Sql Server 2012 For Developers (training & Reference)
by Joel Murach /
2012 / English / PDF
126.7 MB Download
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.
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.