The Guru s Guide to Transact SQL

Author: Ken Henderson
Publisher: Addison-Wesley Professional
ISBN: 9780201615760
Format: PDF, ePub, Docs
Download Now
Demonstrates important concepts and offers working Transact-SQL code, covering data filtering, DDL, DML, statistical functions, runs and sequences, transactions, stored procedures and triggers, and performance tuning.

The Guru s Guide to SQL Server Stored Procedures XML and HTML

Author: Ken Henderson
Publisher: Addison-Wesley Professional
ISBN: 9780201700466
Format: PDF, Kindle
Download Now
Explores the foundations of SQL and Transact-SQL programming to teach readers how to develop coding techniques and discover solutions to programming problems, then covers practices, design considerations, and advanced topics.

The Guru s Guide to SQL Server Architecture and Internals

Author: Ken Henderson
Publisher: Addison-Wesley Professional
ISBN: 9780201700473
Format: PDF, Mobi
Download Now
bull; Contains the most depth and breadth of coverage of any book on SQL Server architecture, internals, and tuning bull; Will be a key reference for anyone working with SQL Server, no matter what their skill level bull; The latest book in the bestselling series of Guru's Guides from Ken Henderson

Transact SQL Programming

Author: Kevin Kline
Publisher: "O'Reilly Media, Inc."
ISBN: 9781565924017
Format: PDF, Docs
Download Now
Provides detailed information about Transact-SQL programming and shows specific differences between the Microsoft and Sybase versions of the language.

MariaDB Crash Course

Author: Ben Forta
Publisher: Addison-Wesley Professional
ISBN: 0132842351
Format: PDF, Mobi
Download Now
MariaDB is a database server that offers drop-in replacement functionality for MySQL. Built by some of the original authors of MySQL, with assistance from the broader community of free and open source software developers, MariaDB offers a rich set of feature enhancements to MySQL, including alternate storage engines, server optimizations, and patches. MariaDB Crash Course teaches you all you need to know to be immediately productive with MariaDB. Master trainer Ben Forta introduces all the essentials through a series of quick, easy-to-follow, hands-on lessons. Instead of belaboring database theory and relational design, Forta focuses on teaching solutions for the majority of users who simply want to interact with data. Learn how to: Retrieve and sort data Filter data using comparisons, regular expressions, and full text search Join relational data Create and alter tables Insert, update, and delete data Leverage the power of stored procedures and triggers Use views and cursors Manage transactional processing Create user accounts and manage security via access control

Code Centric T SQL Programming with Stored Procedures and Triggers

Author: Garth Wells
Publisher: Apress
ISBN: 1430211458
Format: PDF, ePub, Mobi
Download Now
If you want to learn how to write stored procedures and triggers for Microsoft SQL Server, Code Centric: T-SQL Programming with Stored Procedures and Triggers is the book for you. Youll learn real-world coding and how to build non-trivial applications. All of the examples covered in the book are available for download, making it easier to work through over 5,000 lines of sample code. While there is extensive coverage of the new functionality in SQL Server 2000—such as UDFs (user-defined functions)—you can use this book effectively for virtually any version of SQL Server6.x, 7.0, or 2000.

Transact SQL Cookbook

Author: Ales Spetic
Publisher: "O'Reilly Media, Inc."
ISBN: 1565927567
Format: PDF
Download Now
This guide contains a wealth of solutions to problems that SQl Server programmers face. The recipes in the book range from those that show how to perform simple tasks to ones that are more complicated.

Professional Microsoft SQL Server 2008 Programming

Author: Robert Vieira
Publisher: John Wiley & Sons
ISBN: 0470632097
Format: PDF, ePub, Mobi
Download Now
This book is written for SQL Server 2008. However, it does maintain roots going back a few versions and looks out for backward compatibility issues with SQL Server 2005 and SQL Server 2000. These versions are old enough that there is little to no time spent on them except in passing. The book is oriented around developing on SQL server. Most of the concepts are agnostic to what client language you use although the examples that leverage a client language general do so in C#. For those who are migrating from early versions of SQL Server, some “gotchas” that exist any time a product has versions are discussed to the extent that they seem to be a genuinely relevant issue. This book assumes that you have some experience with SQL Server and are at an intermediate to advanced level. The orientation of the book is highly developer focused. While there is a quick reference-oriented appendix, there is very little coverage given to beginner level topics. It is assumed that you already have experience with data manipulation language (DML) statements and know the basics of the mainstream SQL Server objects (views, stored procedures, user defined functions, etc.). If you would like to brush up on your knowledge before diving into this book, the author recommends reading Beginning SQL Server 2008 Programming first. There is very little overlap between the Beginning and Professional books and they are designed to work as a pair.