Muutke küpsiste eelistusi

Jump Start MySQL [Pehme köide]

4.45/5 (21 hinnangut Goodreads-ist)
  • Formaat: Paperback / softback, 150 pages, kõrgus x laius x paksus: 235x178x9 mm, kaal: 260 g
  • Ilmumisaeg: 24-Apr-2015
  • Kirjastus: SitePoint Pty Ltd
  • ISBN-10: 0992461286
  • ISBN-13: 9780992461287
Teised raamatud teemal:
Jump Start MySQLSuurem pilt
  • Formaat: Paperback / softback, 150 pages, kõrgus x laius x paksus: 235x178x9 mm, kaal: 260 g
  • Ilmumisaeg: 24-Apr-2015
  • Kirjastus: SitePoint Pty Ltd
  • ISBN-10: 0992461286
  • ISBN-13: 9780992461287
Teised raamatud teemal:
Püsilink: https://www.kriso.ee/db/9780992461287.html
Märksõnad:

Get a Jump Start on working with MySQL today!

MySQL is an extremely popular open source relational database management system that that powers many of the applications on the Web. Discover why MySQL's speed, ease of use, and flexibility make it the database of choice for so many developers.

In just one weekend with this hands-on tutorial, you'll learn how to:

  • Get started with MySQL
  • Store, modify, and retrieve data
  • Work with multiple tables
  • Connect to your database through code
  • Program the database
  • Back up your data
Preface xi
What is a Database? xi
From Codd to MySQL, a Brief History xiii
Alternatives and the Future of MySQL xv
Who Should Read This Book xvi
Conventions Used xvi
Code Samples xvi
Tips, Notes, and Warnings xvii
Supplementary Materials xvii
Want to Take Your Learning Further? xviii
Chapter 1 Getting Started with MySQL
1(14)
Installing MySQL on Linux
2(6)
Installing via a Package Manager
2(3)
Installing from Source
5(3)
Installing MySQL on Windows
8(2)
Communicating with the Server
10(1)
MySQL Accounts and Security
11(3)
Conclusion
14(1)
Chapter 2 Storing Data
15(22)
Creating Tables
16(15)
Data Types and Storage Requirements
20(7)
Storage Engines
27(4)
Adding Data
31(4)
Using Transactions
33(2)
Conclusion
35(2)
Chapter 3 Retrieving and Updating Data
37(20)
Deploying Sakila
38(2)
Retrieving Data
40(11)
Ordering Results
41(3)
Managing the Number of Returned Rows
44(5)
Aggregate Functions and Grouping
49(2)
Keeping Data Fresh
51(4)
Updating Data
51(2)
Deleting Data
53(2)
Conclusion
55(2)
Chapter 4 Working with Multiple Tables
57(20)
Joining Tables
58(8)
Types of Joins
61(5)
Abstracting with Views
66(3)
Normal Forms
69(5)
First Normal Form
70(1)
Second Normal Form
71(2)
Third Normal Form
73(1)
Altering Tables
74(2)
Conclusion
76(1)
Chapter 5 Connecting from Code
77(18)
Connecting from Python with Connector/Python
78(6)
Basic Querying
79(2)
Buffered and Unbuffered Results
81(1)
Prepared Statements
82(2)
Connecting from PHP with PDO
84(6)
Basic Querying
85(3)
Handling Errors
88(1)
Prepared Statements
89(1)
Connecting from R with RMySQL
90(4)
Working with Tables
91(2)
Basic Querying
93(1)
Conclusion
94(1)
Chapter 6 Programming the Database
95(26)
Learning the Basics
96(3)
Functions
99(3)
Stored Procedures
102(3)
Triggers
105(4)
Events
109(3)
User-defined Functions
112(7)
Conclusion
119(2)
Chapter 7 Backups and Replication
121
Logical Backups
121(3)
Using mysqldump
122(2)
Redirecting SELECT
124(1)
Physical Backups
124(2)
Replication
126(5)
Setting up Replication
127(3)
Fixing Broken Replication
130(1)
Plan Ahead
131(2)
Conclusion
133