Zum Hauptinhalt springen
Dekorationsartikel gehören nicht zum Leistungsumfang.
Learning MySQL and MariaDB
Heading in the Right Direction with MySQL and MariaDB
Taschenbuch von Russell J T Dyer
Sprache: Englisch

49,40 €*

inkl. MwSt.

Versandkostenfrei per Post / DHL

Lieferzeit 1-2 Wochen

Kategorien:
Beschreibung
If you’re a programmer new to databases—or just new to MySQL and its community-driven variant, MariaDB—you’ve found the perfect introduction. This hands-on guide provides an easy, step-by-step approach to installing, using, and maintaining these popular relational database engines.

Author Russell Dyer, Curriculum Manager at MariaDB and former editor of the MySQL Knowledge Base, takes you through database design and the basics of data management and manipulation, using real-world examples and many practical tips. Exercises and review questions help you practice what you’ve just learned.
* Create and alter MySQL tables and specify fields and columns within them
* Learn how to insert, select, update, delete, join, and subquery data, using practical examples
* Use built-in string functions to find, extract, format, and convert text from columns
* Learn functions for mathematical or statistical calculations, and for formatting date and time values
* Perform administrative duties such as managing user accounts, backing up databases, and importing large amounts of data
* Use APIs to connect and query MySQL and MariaDB with PHP and other languages
If you’re a programmer new to databases—or just new to MySQL and its community-driven variant, MariaDB—you’ve found the perfect introduction. This hands-on guide provides an easy, step-by-step approach to installing, using, and maintaining these popular relational database engines.

Author Russell Dyer, Curriculum Manager at MariaDB and former editor of the MySQL Knowledge Base, takes you through database design and the basics of data management and manipulation, using real-world examples and many practical tips. Exercises and review questions help you practice what you’ve just learned.
* Create and alter MySQL tables and specify fields and columns within them
* Learn how to insert, select, update, delete, join, and subquery data, using practical examples
* Use built-in string functions to find, extract, format, and convert text from columns
* Learn functions for mathematical or statistical calculations, and for formatting date and time values
* Perform administrative duties such as managing user accounts, backing up databases, and importing large amounts of data
* Use APIs to connect and query MySQL and MariaDB with PHP and other languages
Über den Autor

Russell Dyer is a freelance writer specializing in MySQL database software and is the editor of the MySQL Knowledge Base [...] He is the author of MySQL in a Nutshell [...] and has writen articles for several magazines: Dev Zone (a MySQL publication), Linux Journal, [...], The Perl Journal, Red Hat Magazine, SysAdmin Magazine, Tech Republic, Unix Review, and [...]. 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 [...]

Inhaltsverzeichnis
  • Foreword
  • Preface
  • The Software

    • Chapter 1: Introduction
    • Chapter 2: Installing MySQL and MariaDB
    • Chapter 3: The Basics and the mysql Client
  • Database Structures

    • Chapter 4: Creating Databases and Tables
    • Chapter 5: Altering Tables
  • Basics of Handling Data

    • Chapter 6: Inserting Data
    • Chapter 7: Selecting Data
    • Chapter 8: Updating and Deleting Data
    • Chapter 9: Joining and Subquerying Data
  • Built-In Functions

    • Chapter 10: String Functions
    • Chapter 11: Date and Time Functions
    • Chapter 12: Aggregate and Numeric Functions
  • Administration and Beyond

    • Chapter 13: User Accounts and Privileges
    • Chapter 14: Backing Up and Restoring Databases
    • Chapter 15: Bulk Importing Data
    • Chapter 16: Application Programming Interfaces
  • Colophon
Details
Erscheinungsjahr: 2015
Genre: Importe, Informatik
Rubrik: Naturwissenschaften & Technik
Medium: Taschenbuch
Inhalt: 406 S.
ISBN-13: 9781449362904
ISBN-10: 1449362907
Sprache: Englisch
Einband: Kartoniert / Broschiert
Autor: Dyer, Russell J T
Hersteller: O'Reilly Media
O'Reilly Media, Inc.
Maße: 233 x 177 x 27 mm
Von/Mit: Russell J T Dyer
Erscheinungsdatum: 05.05.2015
Gewicht: 0,667 kg
Artikel-ID: 106014523
Über den Autor

Russell Dyer is a freelance writer specializing in MySQL database software and is the editor of the MySQL Knowledge Base [...] He is the author of MySQL in a Nutshell [...] and has writen articles for several magazines: Dev Zone (a MySQL publication), Linux Journal, [...], The Perl Journal, Red Hat Magazine, SysAdmin Magazine, Tech Republic, Unix Review, and [...]. 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 [...]

Inhaltsverzeichnis
  • Foreword
  • Preface
  • The Software

    • Chapter 1: Introduction
    • Chapter 2: Installing MySQL and MariaDB
    • Chapter 3: The Basics and the mysql Client
  • Database Structures

    • Chapter 4: Creating Databases and Tables
    • Chapter 5: Altering Tables
  • Basics of Handling Data

    • Chapter 6: Inserting Data
    • Chapter 7: Selecting Data
    • Chapter 8: Updating and Deleting Data
    • Chapter 9: Joining and Subquerying Data
  • Built-In Functions

    • Chapter 10: String Functions
    • Chapter 11: Date and Time Functions
    • Chapter 12: Aggregate and Numeric Functions
  • Administration and Beyond

    • Chapter 13: User Accounts and Privileges
    • Chapter 14: Backing Up and Restoring Databases
    • Chapter 15: Bulk Importing Data
    • Chapter 16: Application Programming Interfaces
  • Colophon
Details
Erscheinungsjahr: 2015
Genre: Importe, Informatik
Rubrik: Naturwissenschaften & Technik
Medium: Taschenbuch
Inhalt: 406 S.
ISBN-13: 9781449362904
ISBN-10: 1449362907
Sprache: Englisch
Einband: Kartoniert / Broschiert
Autor: Dyer, Russell J T
Hersteller: O'Reilly Media
O'Reilly Media, Inc.
Maße: 233 x 177 x 27 mm
Von/Mit: Russell J T Dyer
Erscheinungsdatum: 05.05.2015
Gewicht: 0,667 kg
Artikel-ID: 106014523
Warnhinweis

Ähnliche Produkte

Ähnliche Produkte