4390 / 1

Beginning SQL Ссылки

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.
7295 / 1

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

Head First SQL: Your Brain on SQL -- A Learner's Guide

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

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!
3862 / 1

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

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.
6322 / 0

Самоучитель MySQL 5 Ссылки

Самоучитель MySQL 5

Тэги: MySQL, На русском
astap, Комментарии (нет)

Описывается пятая версия популярной бесплатной СУБД MySQL. В начале книги происходит знакомство читателя с MySQL и простейшими SQL-запросами, такими как создание баз данных и таблиц, их заполнение, извлечение и удаление записей. Далее рассматриваются сложные вопросы SQL-программирования: встроенные функции, полнотекстовый поиск, транзакции, временные таблицы. В заключительной части разбираются различные нововведения, появившиеся только в MySQL 5: вложенные запросы, хранимые процедуры и функции, представления, триггеры, курсоры, информационные схемы и т. п.
3606 / 0

Refactoring SQL Applications Ссылки

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.
6861 / 0

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

High Performance MySQL (Second Edition)

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

Второе издание книги "Высокопроизводительный Mysql" значительно переработано по сравнению
с предыдущей частью. Добавлены и расширены топы по оптимизиции, репликации, резервному копированию (бэкапы)
и другое. Книга раскроет вам секреты оптимизации работы с базой данных MySQL, которые вы не знали раньше.
Авторы также приводят результаты тестов (бенчмарков) в подтверждение излагаемых ими материалов. Это
позволяет читателю понять процессы проходящие в MySQL лучше, чем в другой подобной литературе. Также,
примеры позволят вам избежать большинства ошибок в будущем при оптимизации запросов MySQL.

Книга рекомендуется для новичков в MySQL, людей которые уже попробовали MySQL на вкус
и решили написать первые реальные приложения и конечно для продвинутых пользователей, которые самостоятельно
настраивали приложения MySQL на должный уровень, но желающие получить дополнительную порцию знаний по этой теме.
3463 / 0

Expert MySQL Ссылки

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.

4408 / 0

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

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.


 
Cкачать книги бесплатно без регистрации в электронном виде (pdf, chm, txt).Вы можете читать книги онлайн на нашем сайте литературного портала книг.Большая подборка учебников, пособий, интересных книг.Электронные книги на английском языке скачать бесплатно без смс.
Сделано в 2008 г. Головкин Владимир.

OK

Loading...
...
Закрыть