
The Most Complete and Practical Guide to MySQL 5.xs Powerful SQL Dialect
MySQL 5.x offers a SQL dialect with immense power. In SQL for MySQL Developers, Rick F. van der Lans helps you master this version of SQL, and leverage its full potential. Using case study examples and hands-on exercises, van der Lans illuminates every key concept, technique, and statementincluding advanced features that make it easier to create even the most complex statements and programs.
Drawing on decades of experience as a SQL standards team member and enterprise consultant, he reveals exactly why MySQLs dialect works as it doesand how to get the most out of it. Youll gain powerful insight into everything from basic queries to stored procedures, transactions to data security.
Whether youre a programmer, Web developer, analyst, DBA, or database user, this book can take you from apprentice to true SQL expert. If youve used SQL in older versions of MySQL, youll become dramatically more effectiveand if youre migrating from other database platforms, youll gain practical mastery fast.
· Writing queries, including joins, functions, and subqueries
· Updating data
· Creating tables, views, and other database objects
· Specifying keys and other integrity constraints
· Improving efficiency with indexes
· Enforcing security via passwords and privileges
· Building stored procedures and triggers
· Embedding SQL statements within PHP programs
· Using transactions, savepoint, rollback, isolation level, and repeatable read
· Optimizing performance by reformulating SQL statements
· Utilizing MySQLs catalog
· Reference section: SQL statement definitions and SQL function lists



Otros clientes que compraron SQL for MySQL Developers: A Comprehensive Tutorial and Reference, también compraron:
Otros libros de MYSQL: