text.skipToContent text.skipToNavigation
  1. Home
  2. Computer Science & IT
  3. MariaDB Crash Course

MariaDB Crash Course, 1st edition

  • Ben Forta

Published by Addison-Wesley Professional (September 7th 2011) - Copyright © 2012

1st edition

Chosen format
View all
MariaDB Crash Course

ISBN-13: 9780321799944

Includes: Paperback
Free delivery
$34.99

What's included

  • Paperback

    You'll get a bound printed text.

Overview

 

Table of contents

Introduction 1

What Is MariaDB Crash Course?     1   

Who Is This Book For?     2

Companion Web Site     3

Conventions Used in This Book     3

1:   Understanding SQL     5

Database Basics     5

     What Is a Database?     6

     Tables     6

     Columns and Datatypes     7

     Rows     8

     NULL     8

     Primary Keys     9

What Is SQL?     10

Try It Yourself     11

Summary     11

2:   Introducing MariaDB     13

What Is MariaDB?     13

     Client-Server Software     14

     MySQL Compatibility     15

MariaDB Tools     16

    mysql Command Line     16

     MySQL Workbench     17

Summary     19

3:   Working with MariaDB     21

Making the Connection     21

Selecting a Database     22

Learning About Databases and Tables     23

Summary     26

4:   Retrieving Data     27

The SELECT Statement     27

Retrieving Individual Columns     27

Retrieving Multiple Columns     29

Retrieving All Columns     30

Retrieving Distinct Rows     31

Limiting Results     32

Using Fully Qualified Table Names     34

Using Comments     35

Summary     36

5:   Sorting Retrieved Data     37

Sorting Data     37

Sorting by Multiple Columns     39

Specifying Sort Direction     40

Summary     43

6:   Filtering Data     45

Using the WHERE Clause     45

The WHERE Clause Operators     46

For teachers

All the material you need to teach your courses.

Discover teaching material