SQL for MySQL Developers: A Comprehensive Tutorial and Reference

SQL for MySQL Developers: A Comprehensive Tutorial and Reference, 9780131497351 (0131497359), Addison Wesley, 2007

The Most Complete and Practical Guide to MySQL Version 5’s Powerful SQL Dialect

MySQL version 5 offers a SQL dialect with immense power. In SQL for MySQL Developers, Rick F. van der Lans helps you master this version ofSQL and take advantage of its full potential. Using case study examplesand hands-on exercises, van der Lans illuminates every key concept,technique, and statement–including advanced features that make iteasier to create even the most complex statements and programs.

Drawing on decades of experience as an SQL standards team member and enterprise consultant, he reveals exactly why MySQL’s dialect works as it does–and how to get the most out of it. You’ll gain powerful insight into everything from basic queries to stored procedures, transactions to data security.

Whether you’re a programmer, Web developer, analyst, DBA, or database user, this book can take you from “apprentice” to true SQL expert. If you’ve used SQL in older versions of MySQL, you’ll become dramatically more effective–and if you’re migrating from other database platforms, you’ll gain practical mastery fast.

Comments

Amazing Books

vSphere High Performance Cookbook

Packt Publishing, 2013

VMware vSphere is the key virtualization technology in today’s market. vSphere is a complex tool and incorrect design and deployment can create performance-related problems. vSphere High Performance Cookbook is focused on solving those problems as well as providing best practices and performance-enhancing techniques.

vSphere...

Introduction to Real Analysis, 3rd Edition

John Wiley & Sons, 1999

In recent years, mathematics has become valuable in many areas, including economics and management science as well as the physical sciences, engineering and computer science. Therefore, this book provides the fundamental concepts and techniques of real analysis for readers in all of these areas. It helps one develop the ability to think...

Guide to Elliptic Curve Cryptography (Springer Professional Computing)

Springer, 2004

The study of elliptic curves by algebraists, algebraic geometers and number theorists
dates back to the middle of the nineteenth century. There now exists an extensive literature
that describes the beautiful and elegant properties of these marvelous objects. In
1984, Hendrik Lenstra described an ingenious algorithm for factoring...

Developing Effective Engineering Leadership (IEE Management of Technology Series, 21)

Institution of Engineering and Technology, 2003

Engineering companies and other organizations face many serious challenges in the 21st Century. One that is now becoming widely recognized is the loss of corporate knowledge through staff turnover, whether it is natural or forced through downsizing or de-layering. The company’s store of knowledge and expertise is an asset built up through...

SharePoint 2013 User's Guide: Learning Microsoft’s Business Collaboration Platform

Apress, 2013

Microsoft SharePoint 2013 provides a collection of tools and services you can use to improve user and team productivity, make information sharing more effective, and facilitate business decision–making processes. In order to get the most out of SharePoint 2013, you need to understand how to best use the capabilities to support your...

Analyzing Computer System Performance with Perl::PDQ

Springer, 2011

To solve performance problems in modern computing infrastructures, often comprising thousands of servers running hundreds of applications, spanning multiple tiers, you need tools that go beyond mere reporting. You need tools that enable performance analysis of application workflow across the entire enterprise. That's what PDQ (Pretty Damn...