Beginning SQL
752 / 2

Beginning SQL Ссылки

Тэги: MySQL, Книга, Разработка
alex alex, Комментарии (нет)

SQL works with databases to insert and extract data and is an international standard for manipulating data in databases. This hands-on resource covers everything from a review of SQL basics and database design to creating your own databases and using the SQL language in a variety of database applications. Packed with essential code, theories, concepts, and techniques, as well as a cache of useful examples, this comprehensive text will have you quickly designing your own databases and writing SQL code sufficient for many real-world situations. Practice exercises in each chapter help speed up your comprehension. By the end of the book, you'll be prepared to handle any surprise that SQL might throw your way.
 
 
 
Head First SQL: Your Brain on SQL -- A Learner's Guide
784 / 2

Head First SQL: Your Brain on SQL -- A Learner's Guide Ссылки

Тэги: MySQL, Разработка
БончБруевич БончБруевич, Комментарии (2)

Is your data dragging you down? Are your tables all tangled up? Well we've got the tools to teach you just how to wrangle your databases into submission. Using the latest research in neurobiology, cognitive science, and learning theory to craft a multi-sensory SQL learning experience, Head First SQL has a visually rich format designed for the way your brain works, not a text-heavy approach that puts you to sleep.

Maybe you've written some simple SQL queries to interact with databases. But now you want more, you want to really dig into those databases and work with your data. Head First SQL will show you the fundamentals of SQL and how to really take advantage of it. We'll take you on a journey through the language, from basic INSERT statements and SELECT queries to hardcore database manipulation with indices, joins, and transactions. We all know "Data is Power" - but we'll show you how to have "Power over your Data". Expect to have fun, expect to learn, and expect to be querying, normalizing, and joining your data like a pro by the time you're finished reading!
 
 
 
PHP and MySQL: Create - Modify - Reuse
851 / 1

PHP and MySQL: Create - Modify - Reuse Ссылки

Тэги: PHP, Книга, MySQL
БончБруевич БончБруевич, Комментарии (нет)

I ’ m especially amazed at how the Internet has grown and evolved over the past decade or so. It has grown from a collection of static text documents connected by a few hyperlinks to a platform for delivering rich, distributed applications. And when it comes time to develop these web - based applications, many programmers are choosing PHP and MySQL.

In this book, I present basic code for 12 PHP - powered projects that you can use and extend however you wish. I have tried to write them so the code can be easily reused in future applications, but in some instances the entire application can be reused as well!

I ’ ve enjoyed the opportunity to write and share with you this information and I hope you have just as much fun reading it and learning from it. More importantly, I hope you find good, practical uses for the projects found within this book.
 
 
 
Refactoring SQL Applications
515 / 0

Refactoring SQL Applications Ссылки

Тэги: MySQL
БончБруевич БончБруевич, Комментарии (нет)

What can you do when database performance doesn't meet expectations? Before you turn to expensive hardware upgrades to solve the problem, reach for this book. Refactoring SQL Applications provides a set of tested options for making code modifications to dramatically improve the way your database applications function. Backed by real-world examples, you'll find quick fixes for simple problems, in-depth answers for more complex situations, and complete solutions for applications with extensive problems. Learn to:

  • Determine if and where you can expect performance gains
  • Apply quick fixes, such as limiting calls to the database in stored functions and procedures
  • Refactor tasks, such as replacing application code by a stored procedure, or replacing iterative, procedural statements with sweeping SQL statements
  • Refactor flow by increasing parallelism and switching business-inducted processing from synchronous to asynchronous
  • Refactor design using schema extensions, regular views, materialized views, partitioning, and more
  • Compare before and after versions of a program to ensure you get the same results once you make modifications
Refactoring SQL Applications teaches you to recognize and assess code that needs refactoring, and to understand the crucial link between refactoring and performance. If and when your application bogs down, this book will help you get it back up to speed.
 
 
 
High Performance MySQL (Second Edition)
762 / 0

High Performance MySQL (Second Edition) Ссылки

Тэги: MySQL, Разработка, Сервер
БончБруевич БончБруевич, Комментарии (нет)

The authors’ backgrounds are clearly reflected in their complete reworking in this
second edition of High Performance MySQL: Optimizations, Replication, Backups,
and More. It’s not just a book that tells you how to optimize your work to use
MySQL better than ever before. The authors have done considerable extra work, carrying
out and publishing benchmark results to prove their points. This will give you,
the reader, a lot of valuable insight into MySQL’s inner workings that you can’t easily
find in any other book. In turn, that will allow you to avoid a lot of mistakes in
the future that can lead to suboptimal performance.
I recommend this book both to new users of MySQL who have played with the
server a little and now are ready to write their first real applications, and to experienced
users who already have well-tuned MySQL-based applications but need to get
“a little more” out of them.
 
 
 
Expert MySQL
559 / 0

Expert MySQL Ссылки

Тэги: MySQL
БончБруевич БончБруевич, Комментарии (нет)

Since the enormous number of new features made available with MySQL release 5.0, MySQL has been gaining steam as a viable alternative to database behemoths like Oracle and IBM DB2. MySQL users now have the ability to extend MySQL with new SQL commands, optimize query execution, and embed MySQL within low-resource environments like embedded devices and kiosks.

Expert MySQL, by Dr. Charles A. Bell, is the first book to examine these opportunities in detail, showing you how to wield maximum control over this powerful open source database. Youll learn how to create your own custom storage handlers, ensuring maximum flexibility and speed within your specialized applications. Youll also gain valuable insight into MySQLs architecture and learn how to tweak its behavior through custom changes to the source code.

 
 
 
Beginning SQL Queries: From Novice to Professional
613 / 0

Beginning SQL Queries: From Novice to Professional Ссылки

Тэги: MySQL, Разработка
БончБруевич БончБруевич, Комментарии (нет)

Beginning SQL Queries is your guide to mastering the lingua franca of the database industry: the SQL language. Good knowledge of SQL is crucial to anyone working with databases, because it is with SQL that you retrieve data, manipulate data, and generate business results. Knowing how to write good queries is the foundation for all work done in SQL, and it is a foundation that Clare lays well in her book.
  • Does not bore with syntax!
  • Helps you learn the underlying concepts involved in querying a database, and from there the syntax is easy
  • Provides exceptionally clear examples and explanations
  • Is academically sound while being practical and approachable

What you’ll learn

  • Write simple queries to extract data from a single table.
  • Understand relational algebra and calculus and why they are important.
  • Combine data from many tables into one business result.
  • Avoid pitfalls and traps such as Cartesian products and difficulties with null values.
  • Summarize large amounts of data for reporting purposes.
  • Apply set theory to the problems of manipulating data and generating reports.


 
© 2008 Головкин Владимир TwoFace Project.