43-- کتابهای "پایگاه داده" با محوریت موضوع MySQL

[yasin_d]

Beginning MySQL
Book Info:
Published in 2005
Published by Wrox
Author Robert Sheldon
ISBN 0764579509

شروع MySQL آموزش در سطح مبتدی

لینک دانلود:
Beginning MySQL (http://hideref.com/url/?http://rapidshare.com/files/13371801/b0052.rar.html)

[yasin_d]

Teach Yourself MySQL in 21 Days
Book Info:
Published in 1999
ISBN 0672319144

خودآموز MySQL در 21 روز

لینک دانلود:
Teach Yourself MySQL in 21 Days (http://hideref.com/url/?http://www.eazyupload.net/download/RVKkxIlx/0672319144.zip.htm)

[yasin_d]

MySQL Reference Manual

http://ec1.images-amazon.com/images/I/51RDSS3GDML.jpg

مرجع آموزش کامل MySQL

لینک دانلود:
MySQL Reference Manual (http://rapidshare.com/files/58719576/MySQL_Reference_Manual-OReilly-0596002653.pdf)

[yasin_d]

SQL for MySQL Developers: A Comprehensive Tutorial and Reference


Contents

About the Author

Preface

PART I Introduction

CHAPTER 1 Introduction to MySQL

CHAPTER 2 The Tennis Club Sample Database

CHAPTER 3 Installing the Software

CHAPTER 4 SQL in a Nutshell



PART II Querying and Updating Data

CHAPTER 5 SELECT Statement: Common Elements

CHAPTER 6 SELECT Statements, Table Expressions, and Subqueries

CHAPTER 7 SELECT Statement:The FROM Clause

CHAPTER 8 SELECT Statement: The WHERE Clause

CHAPTER 9 SELECT Statement: SELECT Clause and Aggregation Functions

CHAPTER 10 SELECT Statement: The GROUP BY Clause

CHAPTER 11 SELECT Statement: The HAVING Clause

CHAPTER 12 SELECT Statement: The ORDER BY Clause

CHAPTER 13 SELECT Statement: The LIMIT Clause

CHAPTER 14 Combining Table Expressions

CHAPTER 15 The User Variable and the SET Statement

CHAPTER 16 The HANDLER Statement

CHAPTER 17 Updating Tables

CHAPTER 18 Loading and Unloading Data

CHAPTER 19 Working with XML Documents



PART III Creating Database Objects

CHAPTER 20 Creating Tables

CHAPTER 21 Specifying Integrity Constraints

CHAPTER 22 Character Sets and Collations

CHAPTER 23 The ENUM and SET Types

CHAPTER 24 Changing and Dropping Tables

CHAPTER 25 Using Indexes

CHAPTER 26 Views

CHAPTER 27 Creating Databases

CHAPTER 28 Users and Data Security

CHAPTER 29 Statements for Table Maintenance

CHAPTER 30 The SHOW, DESCRIBE, and HELP Statements



PART IV Procedural Database Objects

CHAPTER 31 Stored Procedures

CHAPTER 32 Stored Functions

CHAPTER 33 Triggers

CHAPTER 34 Events



PART V Programming with SQL

CHAPTER 35 MySQL and PHP

CHAPTER 36 Dynamic SQL with Prepared Statement

CHAPTER 37 Transactions and Multiuser Usage

APPENDIX A Syntax of SQL

APPENDIX B Scalar Functions

APPENDIX C System Variables

APPENDIX D Bibliography

Index



زبان SQL برای MySQL : مرجع کامل و آموزشی

رمز فایل: books_for_all
لینک دانلود:
SQL for MySQL Developers: A Comprehensive Tutorial and Reference (http://hideref.com/url/?http://rapidshare.com/files/35401611/64B1B24A-E41D-4727-AE4C-6D09A5C4DE1C.rar)

[yasin_d]

Database Design Manual: using MySQL for Windows


طراحی پایگاه داده: کاربرد MySQL در ویندوز

رمز فایل : books_for_all
لینک دانلود:
Database Design Manual: using MySQL for Windows (http://hideref.com/url/?http://rapidshare.com/files/11960892/EDA0E9D8-ADB7-45EE-9FE7-ABA0C0907179.rar.htm)

[yasin_d]

Creating your MySQL Database: Practical Design Tips and Techniques
Book Info:
Published in 2006
Author Marc, DeLisle
ISBN 1904811302

Book Description:
This book is an innovative and essential short guide for everyone on how to structure your data and set-up your MySQL database tables efficiently and easily. If you're creating a dynamic web application using open-source tools, then you're probably going to be setting up a MySQL database. Getting the design of this database right for your application and its data is vital, but it's often an intimidating and little-known process for non-developers and developers alike. Written by the creator of the popular phpMyAdmin tool, this book is a short but complete guide on how to design good data structures for MySQL. For most of us, setting up the database for an application is often an afterthought. While you don't need to be a professional database designer to create a working application, knowing a few insider tips and techniques can make both the process easier and the end result much more effective. This book doesn't set out to make you an expert in data analysis, but it does provide a quick and easy way to raise your game in this essential part of getting your application right. The book covers: Asking users the right questions to collect relevant data for the system you are building Detecting bad structures Sound data-naming techniques, for both table and column names Modeling data with future growth in mind Implementing security policies with data privileges and views Tuning the structure for performance Producing system documentation (data dictionary, relational schema) Testing the model with appropriate SQL queries This book takes a practical approach, implementing all theoretical concepts with examples. It is a fast-paced tutorial that focuses on critical decisions that you need to make every time you build MySQL databases. It is rich with tips and advice from an experienced practitioner. The book is ideal for anyone working with applications that use a MySQL database backend will benefit greatly from the advice and techniques in this book. Although a working knowledge of both SQL and MySQL is assumed, the book is suitable for both beginners and intermediate users alike. Whether you read it through and absorb the advice or work through it on a live project, the efficiency and maintainability of your databases will certainly improve as a result


ساخت پایگاه داده در MySQL: نکات و تکنیک های مفید

لینک دانلود:
Creating your MySQL Database: Practical Design Tips and Techniques (http://hideref.com/url/?http://rapidshare.com/files/12120701/Creating.Your.MySQL.Database.Practical.Design.Tips .and.Techniques.zip)

[ABA]

خوب بود ممنون

[Marjan10]

سلام
با تشكر از شما ، لطفا پسورد pdf آخري رو هم بذارين .

Creating your MySQL Database: Practical Design Tips and Techniques

Book Info:
Published in 2006
Author Marc, DeLisle
ISBN 1904811302

[afshinadly]

سلام دوست عزیز:

پسورد فایل ebookspyder.net می باشد. موفق باشید.

[deluvan]

متاسفانه نتونستم به ادرسهاى بالا دسترسى پيدا كنم

[deluvan]

اى بابا اينا كه باز نميشن؟؟؟:(

[ELAHE_TANHA]

سلام
من يك كتاب آموزشي فارسي mysqlمي خوام خيلي ضروريه كمكم كنيد
:cry::cry::cry::cry::cry::cry::cry::(:(:(:confused ::confused::confused:
ممنون

[Omid.Delfarib]

سلام .... این یه PDF هستش که یه چیزی در مورد دستورات SQL توضیح داده ... من ضمیمه ش کردم شاید بدردت بخوره ....