Beaulieu A. Learning SQL. Generate, Manipulate and Retrieve Data 3ed 2020.pdf

(5372 KB) Pobierz
ird n
Th itio
Ed
Learning
SQL
Generate, Manipulate, and Retrieve Data
Alan Beaulieu
THIRD EDITION
Generate, Manipulate, and Retrieve Data
Learning SQL
Alan Beaulieu
Beijing
Boston Farnham Sebastopol
Tokyo
Learning SQL
by Alan Beaulieu
Copyright © 2020 Alan Beaulieu. All rights reserved.
Printed in the United States of America.
Published by O’Reilly Media, Inc., 1005 Gravenstein Highway North, Sebastopol, CA 95472.
O’Reilly books may be purchased for educational, business, or sales promotional use. Online editions are
also available for most titles (http://oreilly.com). For more information, contact our corporate/institutional
sales department: 800-998-9938 or
corporate@oreilly.com.
Acquisitions Editor:
Jessica Haberman
Development Editor:
Jeff Bleiel
Production Editor:
Deborah Baker
Copyeditor:
Charles Roumeliotis
Proofreader:
Chris Morris
August 2005:
April 2009:
April 2020:
First Edition
Second Edition
Third Edition
Indexer:
Angela Howard
Interior Designer:
David Futato
Cover Designer:
Karen Montgomery
Illustrator:
Rebecca Demarest
Revision History for the Third Edition
2020-03-04:
2020-09-04:
First Release
Second Release
See
http://oreilly.com/catalog/errata.csp?isbn=9781492057611
for release details.
The O’Reilly logo is a registered trademark of O’Reilly Media, Inc.
Learning SQL,
the cover image, and
related trade dress are trademarks of O’Reilly Media, Inc.
The views expressed in this work are those of the author, and do not represent the publisher’s views.
While the publisher and the author have used good faith efforts to ensure that the information and
instructions contained in this work are accurate, the publisher and the author disclaim all responsibility
for errors or omissions, including without limitation responsibility for damages resulting from the use of
or reliance on this work. Use of the information and instructions contained in this work is at your own
risk. If any code samples or other technology this work contains or describes is subject to open source
licenses or the intellectual property rights of others, it is your responsibility to ensure that your use
thereof complies with such licenses and/or rights.
978-1-492-05761-1
[MBP]
Table of Contents
Preface. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . xi
1.
A Little Background. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1
Introduction to Databases
Nonrelational Database Systems
The Relational Model
Some Terminology
What Is SQL?
SQL Statement Classes
SQL: A Nonprocedural Language
SQL Examples
What Is MySQL?
SQL Unplugged
What’s in Store
1
2
5
7
8
9
10
11
13
14
15
2.
Creating and Populating a Database. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 17
Creating a MySQL Database
Using the mysql Command-Line Tool
MySQL Data Types
Character Data
Numeric Data
Temporal Data
Table Creation
Step 1: Design
Step 2: Refinement
Step 3: Building SQL Schema Statements
Populating and Modifying Tables
Inserting Data
17
18
20
20
23
25
27
27
28
30
33
33
iii

Plik z chomika:

Inne pliki z tego folderu:

Inne foldery tego chomika:

Zgłoś jeśli naruszono regulamin