Muutke küpsiste eelistusi

E-raamat: Learning MySQL and MariaDB: Heading in the Right Direction with MySQL and MariaDB

4.10/5 (25 hinnangut Goodreads-ist)
  • Formaat: PDF+DRM
  • Ilmumisaeg: 30-Mar-2015
  • Kirjastus: O'Reilly Media
  • Keel: eng
  • ISBN-13: 9781449362874
Teised raamatud teemal:
  • Formaat - PDF+DRM
  • Hind: 35,69 €*
  • * hind on lõplik, st. muud allahindlused enam ei rakendu
  • Lisa ostukorvi
  • Lisa soovinimekirja
  • See e-raamat on mõeldud ainult isiklikuks kasutamiseks. E-raamatuid ei saa tagastada.
Learning MySQL and MariaDB: Heading in the Right Direction with MySQL and MariaDBSuurem pilt
  • Formaat: PDF+DRM
  • Ilmumisaeg: 30-Mar-2015
  • Kirjastus: O'Reilly Media
  • Keel: eng
  • ISBN-13: 9781449362874
Teised raamatud teemal:

DRM piirangud

  • Kopeerimine (copy/paste):

    ei ole lubatud

  • Printimine:

    ei ole lubatud

  • Kasutamine:

    Digitaalõiguste kaitse (DRM)
    Kirjastus on väljastanud selle e-raamatu krüpteeritud kujul, mis tähendab, et selle lugemiseks peate installeerima spetsiaalse tarkvara. Samuti peate looma endale  Adobe ID Rohkem infot siin. E-raamatut saab lugeda 1 kasutaja ning alla laadida kuni 6'de seadmesse (kõik autoriseeritud sama Adobe ID-ga).

    Vajalik tarkvara
    Mobiilsetes seadmetes (telefon või tahvelarvuti) lugemiseks peate installeerima selle tasuta rakenduse: PocketBook Reader (iOS / Android)

    PC või Mac seadmes lugemiseks peate installima Adobe Digital Editionsi (Seeon tasuta rakendus spetsiaalselt e-raamatute lugemiseks. Seda ei tohi segamini ajada Adober Reader'iga, mis tõenäoliselt on juba teie arvutisse installeeritud )

    Seda e-raamatut ei saa lugeda Amazon Kindle's. 

Covers installation and basic administration; introduction to databases and SQL; functions, subqueries and other query enhancements; improving database performance; accessing MySQL from popular languages; and much more. Original.

With an easy, step-by-step approach, this practical guide shows programmers new to databases how to install, effectively use, and maintain MySQL and MariaDB. You’ll learn these database systems through real-world examples and many practical tips.

Popular and easy-to-use database engines such as MySQL and MariaDB—a community-driven variant of MySQL—help organizations large and small handle data by providing robust and efficient access in ways not offered by spreadsheets and other types of data stores. Experienced web developers and programmers interested in adding MySQL to their skill sets will also find this book useful.

Topics include:

  • An introduction to database systems and the SQL database language
  • Installation and basic administration of MySQL and MariaDB
  • Functions, subqueries, and other query enhancements
  • Methods for accessing MySQL and MariaDB from popular programming languages
Foreword xiii
Preface xix
Part I The Software
1 Introduction
3(4)
The Value of MySQL and MariaDB
3(1)
Mailing Lists and Forums
4(1)
Other Books and Other Publications
4(3)
2 Installing MySQL and MariaDB
7(22)
The Installation Packages
7(1)
Licensing
8(1)
Finding the Software
9(1)
Choosing a Distribution
10(1)
The_AMP Alternatives
11(13)
Linux Binary Distributions
12(1)
Mac OS X Distributions
13(3)
Windows Distributions
16(3)
FreeBSD and Sun Solaris Distributions
19(2)
Source Distributions
21(3)
Post-Installation
24(5)
Special Configuration
24(1)
Setting Initial Password for root
25(1)
More on Passwords and Removing Anonymous Users
25(1)
Creating a User
26(3)
3 The Basics and the mysql Client
29(16)
The mysql Client
29(1)
Connecting to the Server
30(3)
Starting to Explore Databases
33(7)
First SQL Commands
34(2)
Inserting and Manipulating Data
36(3)
A Little Complexity
39(1)
Summary
40(1)
Exercises
41(4)
Part II Database Structures
4 Creating Databases and Tables
45(14)
Creating a Database
46(1)
Creating Tables
47(4)
Inserting Data
51(1)
More Perspectives on Tables
52(4)
Summary
56(1)
Exercises
56(3)
5 Altering Tables
59(32)
Prudence When Altering Tables
59(2)
Essential Changes
61(10)
Dynamic Columns
68(3)
Optional Changes
71(9)
Setting a Column's Default Value
71(2)
Setting the Value of AUTO_INCREMENT
73(1)
Another Method to Alter and Create a Table
74(3)
Renaming a Table
77(2)
Reordering a Table
79(1)
Indexes
80(5)
Summary
85(1)
Exercises
85(6)
Part III Basics of Handling Data
6 Inserting Data
91(28)
The Syntax
91(2)
Practical Examples
93(11)
The Table for Bird Orders
94(1)
The Table for Bird Families
95(6)
The Table for Birds
101(3)
Other Possibilities
104(10)
Inserting Emphatically
104(1)
Inserting Data from Another Table
104(2)
A Digression: Setting the Right ID
106(4)
Replacing Data
110(2)
Priorities When Inserting Data
112(2)
Summary
114(1)
Exercises
115(4)
7 Selecting Data
119(18)
Basic Selection
120(1)
Selecting by a Criteria
120(1)
Ordering Results
121(3)
Limiting Results
124(1)
Combining Tables
124(3)
Expressions and the Like
127(5)
Counting and Grouping Results
132(2)
Summary
134(1)
Exercises
134(3)
8 Updating and Deleting Data
137(16)
Updating Data
137(12)
Updating Specific Rows
138(4)
Limiting Updates
142(1)
Ordering to Make a Difference
143(1)
Updating Multiple Tables
144(2)
Handling Duplicates
146(3)
Deleting Data
149(2)
Deleting in Multiple Tables
150(1)
Summary
151(1)
Exercises
151(2)
9 Joining and Subquerying Data
153(26)
Unifying Results
153(3)
Joining Tables
156(10)
Selecting a Basic Join
157(5)
Updating Joined Tables
162(2)
Deleting Within Joined Tables
164(2)
Subqueries
166(7)
Scalar Subqueries
167(2)
Column Subqueries
169(1)
Row Subqueries
170(2)
Table Subqueries
172(1)
Performance Considerations with Subqueries
173(1)
Summary
173(1)
Exercises
174(5)
Part IV Built-in Functions
10 String Functions
179(24)
Formatting Strings
180(5)
Concatenating Strings
180(2)
Setting Case and Quotes
182(1)
Trimming and Padding Strings
183(2)
Extracting Text
185(3)
Searching Strings and Using Lengths
188(8)
Locating Text Within a String
188(3)
String Lengths
191(1)
Comparing and Searching Strings
192(2)
Replacing and Inserting into Strings
194(2)
Converting String Types
196(3)
Compressing Strings
199(1)
Summary
200(1)
Exercises
200(3)
11 Date and Time Functions
203(26)
Date and Time Data Types
203(2)
Current Date and Time
205(3)
Extracting Date and Time Components
208(4)
Formatting Dates and Time
212(2)
Adjusting to Standards and Time Zones
214(3)
Adding and Subtracting Dates and Time
217(5)
Comparing Dates and Times
222(4)
Summary
226(1)
Exercises
226(3)
12 Aggregate and Numeric Functions
229(24)
Aggregate Functions
229(12)
Counting Values
230(5)
Calculating a Group of Values
235(5)
Concatenating a Group
240(1)
Numeric Functions
241(6)
Rounding Numbers
241(3)
Rounding Only Down or Up
244(1)
Truncating Numbers
245(1)
Eliminating Negative Numbers
245(2)
Summary
247(1)
Exercises
247(6)
Part V Administration and Beyond
13 User Accounts and Privileges
253(26)
User Account Basics
253(3)
Restricting the Access of User Accounts
256(9)
Username and Host
256(2)
SQL Privileges
258(2)
Database Components and Privileges
260(5)
Administrative User Accounts
265(4)
User Account for Making Backups
265(1)
User Account for Restoring Backups
266(1)
User Account for Bulk Importing
267(1)
User Account to Grant Privileges
268(1)
Revoking Privileges
269(1)
Deleting a User Account
270(2)
Changing Passwords and Names
272(2)
Setting a User Account Password
272(1)
Renaming a User Account
273(1)
User Roles
274(2)
Summary
276(1)
Exercises
276(3)
14 Backing Up and Restoring Databases
279(36)
Making Backups
279(13)
Backing Up All Databases
280(2)
Understanding Dump Files
282(6)
Backing Up Specific Databases
288(1)
Creating Backup Scripts
289(1)
Backing Up Specific Tables
290(2)
Restoring Backups
292(15)
Restoring a Database
292(1)
Restoring a Table
293(5)
Restoring Only Rows or Columns
298(2)
Recovering from a Binary Log
300(7)
Developing a Backup Policy
307(5)
Summary
312(1)
Exercises
312(3)
15 Bulk Importing Data
315(22)
Preparing to Import
315(3)
Loading Data Basics
318(6)
Watching for Warnings
319(1)
Checking the Accuracy of the Import
320(3)
Selecting Imported Data
323(1)
Better Loading
324(3)
Mapping Fields
324(2)
Setting Columns
326(1)
More Field and Line Definitions
327(3)
Starting, Terminating, and Escaping
328(1)
Replacing Data Versus Ignoring Errors
329(1)
Importing from Outside MySQL
330(3)
Importing Local Files
331(1)
Using mysqlimport
331(1)
Importing Without FILE Privileges
332(1)
Bulk Exporting Data
333(2)
Summary
335(1)
Exercises
335(2)
16 Application Programming Interfaces
337(32)
Creating API User Accounts
338(1)
C API
338(4)
Connecting to MySQL
339(1)
Querying MySQL
340(1)
Complete Minimal C API Program
341(1)
Compiling with C Includes
342(1)
Perl DBI
342(6)
Installing
343(1)
Connecting to MySQL
343(1)
Querying MySQL
343(3)
A Full Example with Perl DBI
346(2)
More Information
348(1)
PHP API
348(5)
Installing and Configuring
349(1)
Connecting to MySQL
349(1)
Querying MySQL
350(3)
More Information
353(1)
Python
353(4)
Installing
353(1)
Connecting to MySQL
353(1)
Querying MySQL
354(1)
Sample Python Program
355(2)
More Information
357(1)
Ruby API
357(7)
Installing and Preparing MySQL/Ruby
357(2)
Connecting to MySQL
359(1)
Querying MySQL
360(1)
Sample MySQL/Ruby Program
361(3)
More Information
364(1)
SQL Injection
364(2)
Summary
366(1)
Exercises
366(3)
Index 369
Russell Dyer is a freelance writer specializing in MySQL database software and is the editor of the MySQL Knowledge Base (www.mysql.com/network/knowledgebase.html). The author of the first edition of "MySQL in a Nutshell", Russell has also written articles for several magazines: Dev Zone (a MySQL publication), Linux Journal, ONlamp.com, The Perl Journal, Red Hat Magazine, SysAdmin Magazine, Tech Republic, Unix Review, and XML.com. He has also finished his first novel, "In Search of Kafka". More information on Russell, along with a list of his published articles with links to them, can be found on his web site at http://russell.dyerhouse.com
Lisainfo e-raamatute kohta Lisainfo e-raamatute kohta
Püsilink: https://www.kriso.ee/db/97814493628742e.html
Märksõnad: