Signed Edition Sweepstakes
 
 

Recently Viewed clear list


Original Essays | September 30, 2014

Brian Doyle: IMG The Rude Burl of Our Masks



One day when I was 12 years old and setting off on my newspaper route after school my mom said will you stop at the doctor's and pick up something... Continue »
  1. $13.27 Sale Trade Paper add to wish list

    Children and Other Wild Animals

    Brian Doyle 9780870717543

spacer

On Order

$34.99
New Trade Paper
Currently out of stock.
Add to Wishlist
Qty Store Section
- Local Warehouse Database- Design

Mariadb Crash Course

by

Mariadb Crash Course Cover

 

Synopses & Reviews

Publisher Comments:

This first-to-market tutorial covers everything beginners need to succeed with MariaDB, the open, community-based branch of MySQL. Master trainer Ben Forta introduces all the essentials through a series of quick, easy-to-follow, hands-on lessons. Instead of belaboring database theory and relational design, Forta focuses on teaching solutions for the majority of SQL users who simply want to interact with data. Forta covers all this, and more: 

  •  Using the MariaDB toolset * Retrieving and sorting data
  • Filtering data using comparisons, wildcards, and full text searching 
  •  Analyzing data with aggregate functions
  • Performing insert, update, and delete operations
  • Joining relational tables using inner, outer, and self joins 
  •  Combining queries using unions * Using views 
  •  Creating and modifying tables, and accessing table schemas 
  •  Working with stored procedures, cursors, and other advanced database features
  • Managing databases, users, and security privileges

This book was reviewed and is supported by MariaDB's developers, Monty Program AB. It contains a foreword by project founder Monty Widenius, primary developer of the original version of MySQL.

Book News Annotation:

Intended for beginner to intermediate database programmers and administrators, this volume on MariaDB provides detailed tutorials for performing common tasks with this open source fork of the popular MYSQL database program. The work covers all basic database processes including retrieving, filtering and sorting data, all types of queries, managing transaction processing, security, and database maintenance. Chapters include tips, tricks and command analysis as well as numerous code examples. Additional online resources are provided. Forta is a developer working for Adobe. Annotation ©2011 Book News, Inc., Portland, OR (booknews.com)

Synopsis:

MariaDB is a database server that offers drop-in replacement functionality for MySQL. Built by some of the original authors of MySQL, with assistance from the broader community of free and open source software developers, MariaDB offers a rich set of feature enhancements to MySQL, including alternate storage engines, server optimizations, and patches.

 

MariaDB Crash Course teaches you all you need to know to be immediately productive with MariaDB. Master trainer Ben Forta introduces all the essentials through a series of quick, easy-to-follow, hands-on lessons. Instead of belaboring database theory and relational design, Forta focuses on teaching solutions for the majority of users who simply want to interact with data.

 

Learn how to:

  • Retrieve and sort data
  • Filter data using comparisons, regular expressions, and full text search
  • Join relational data
  • Create and alter tables
  • Insert, update, and delete data
  • Leverage the power of stored procedures and triggers
  • Use views and cursors
  • Manage transactional processing
  • Create user accounts and manage security via access control

Synopsis:

 

About the Author

Ben Forta is a Senior Technical Evangelist with Adobe. He has more than 15 years of experience in the computer industry, and spent six years as part of the development team responsible for creating OnTime, one of the most successful calendar and group-scheduling products, with more than one million users worldwide. His many books include Sams Teach Yourself SQL in 10 Minutes, one of the world's bestselling SQL books, with 100,000+ copies sold.

Table of Contents

Introduction

Chapter 1: Understanding SQL

Chapter 2: Introducing MariaDB

Chapter 3: Working with MariaDB

Chapter 4: Retrieving Data

Chapter 5: Sorting Retrieved Data

Chapter 6: Filtering Data

Chapter 7: Advanced Data Filtering

Chapter 8: Using Wildcard Filtering

Chapter 9: Searching Using Regular Expressions

Chapter 10: Creating Calculated Fields

Chapter 11: Using Data Manipulation Functions

Chapter 12: Summarizing Data

Chapter 13: Grouping Data

Chapter 14: Working with Subqueries

Chapter 15: Joining Tables

Chapter 16: Creating Advanced Joins

Chapter 17: Combining Queries

Chapter 18: Full-Text Searching

Chapter 19: Inserting Data

Chapter 20: Updating and Deleting Data

Chapter 21: Creating and Manipulating Tables

Chapter 22: Using Views

Chapter 23: Working with Stored Procedures

Chapter 24: Using Cursors

Chapter 25: Using Triggers

Chapter 26: Managing Transaction Processing

Chapter 27: Globalization and Localization

Chapter 28: Managing Security

Chapter 29: Database Maintenance

Chapter 30: Improving Performance

Appendix A: Getting Started with MariaDB

Appendix B: The Example Tables

Appendix C: MariaDB Datatypes

Appendix D: MariaDB Reserved Words

Index

Product Details

ISBN:
9780321799944
Author:
Forta, Ben
Publisher:
Addison-Wesley Professional
Subject:
Database Management - General
Subject:
Database design
Copyright:
Edition Description:
Trade paper
Publication Date:
20110901
Binding:
TRADE PAPER
Language:
English
Pages:
304
Dimensions:
8.8 x 5.9 x 0.7 in 349 gr

Related Subjects

Computers and Internet » Database » Applications
Computers and Internet » Database » Client Server
Computers and Internet » Database » Design
Computers and Internet » Networking » General
Computers and Internet » Software Engineering » Software Management
Science and Mathematics » Mathematics » General

Mariadb Crash Course New Trade Paper
0 stars - 0 reviews
$34.99 Backorder
Product details 304 pages Addison-Wesley Professional - English 9780321799944 Reviews:
"Synopsis" by ,

MariaDB is a database server that offers drop-in replacement functionality for MySQL. Built by some of the original authors of MySQL, with assistance from the broader community of free and open source software developers, MariaDB offers a rich set of feature enhancements to MySQL, including alternate storage engines, server optimizations, and patches.

 

MariaDB Crash Course teaches you all you need to know to be immediately productive with MariaDB. Master trainer Ben Forta introduces all the essentials through a series of quick, easy-to-follow, hands-on lessons. Instead of belaboring database theory and relational design, Forta focuses on teaching solutions for the majority of users who simply want to interact with data.

 

Learn how to:

  • Retrieve and sort data
  • Filter data using comparisons, regular expressions, and full text search
  • Join relational data
  • Create and alter tables
  • Insert, update, and delete data
  • Leverage the power of stored procedures and triggers
  • Use views and cursors
  • Manage transactional processing
  • Create user accounts and manage security via access control
"Synopsis" by ,

 

spacer
spacer
  • back to top
Follow us on...




Powell's City of Books is an independent bookstore in Portland, Oregon, that fills a whole city block with more than a million new, used, and out of print books. Shop those shelves — plus literally millions more books, DVDs, and gifts — here at Powells.com.