没有合适的资源？快使用搜索试试~ 我知道了~

首页Getting-Started-with-SQL-A-Hands-On-Approach-for-Beginners.pdf

Getting-Started-with-SQL-A-Hands-On-Approach-for-Beginners.pdf

SQL

需积分: 9 12 下载量 46 浏览量更新于2023-03-16 评论 1 收藏 8.55MB PDF 举报

身份认证购VIP最低享 7 折!

领优惠券(最高得80元）

试读

133页

Getting-Started-with-SQL-A-Hands-On-Approach-for-Beginners.pdf

资源详情

资源评论

资源推荐

Thomas Nield

Getting Started with

SQL

A HANDS-ON APPROACH

FOR BEGINNERS

omas Nield

Boston

Getting Started with SQL

A Hands-on Approach for Beginners

978-1-491-93861-4

[LSI]

Getting Started with SQL

by Thomas Nield

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://safaribooksonline.com). For more information, contact our corporate/

institutional sales department: 800-998-9938 or corporate@oreilly.com.

Editor: Shannon Cutt

Production Editor: Shiny Kalapurakkel

Copyeditor: Jasmine Kwityn

Proofreader: Rachel Head

Indexer: Ellen Troutman-Zaig

Interior Designer: David Futato

Cover Designer: Randy Comer

Illustrator: Rebecca Demarest

February 2016: First Edition

Revision History for the First Edition

2016-02-08: First Release

See http://oreilly.com/catalog/errata.csp?isbn=9781491938614 for release details.

The O’Reilly logo is a registered trademark of O’Reilly Media, Inc. Getting Started with SQL, the cover

image, and related trade dress are trademarks of O’Reilly Media, Inc.

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.

Table of Contents

Foreword. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . vii

Preface. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . ix

Why Learn SQL?. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1

What Is SQL and Why Is It Marketable? 1

Who Is SQL For? 2

Databases. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3

What Is a Database? 3

Exploring Relational Databases 3

Why Separate Tables? 4

Choosing a Database Solution 5

Lightweight Databases 5

Centralized Databases 6

SQLite. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 9

What Is SQLite? 9

SQLiteStudio 9

Importing and Navigating Databases 10

SELECT. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 19

Retrieving Data with SQL 19

Expressions in SELECT Statements 23

Text Concatenation 27

Summary 28

iii

剩余132页未读，继续阅读

getting started with sql

getting started with sql getting started with sql getting started with sql

Getting.Started.with.SQL.A.Hands-On.Approach.for.Beginners

Businesses are gathering data today at exponential rates and yet few people know how to access it meaningfully. If you’re a business or IT professional, this short hands-on guide teaches you how to pull and transform data with SQL in significant ways. You will quickly master the fundamentals of SQL and learn how to create your own databases. Author Thomas Nield provides exercises throughout the book to help you practice your newfound SQL skills at home, without having to use a database server environment. Not only will you learn how to use key SQL statements to find and manipulate your data, but you’ll also discover how to efficiently design and manage databases to meet your needs. You’ll also learn how to: Explore relational databases, including lightweight and centralized models Use SQLite and SQLiteStudio to create lightweight databases in minutes Query and transform data in meaningful ways by using SELECT, WHERE, GROUP BY, and ORDER BY Join tables to get a more complete view of your business data Build your own tables and centralized databases by using normalized design principles Manage data by learning how to INSERT, DELETE, and UPDATE records Table of Contents Chapter 1. Why Learn SQL? Chapter 2. Databases Chapter 3. SQLite Chapter 4. SELECT Chapter 5. WHERE Chapter 6. GROUP BY and ORDER BY Chapter 7. CASE Statements Chapter 8. JOIN Chapter 9. Database Design Chapter 10. Managing Data Chapter 11. Going Forward Appendix A. Operators and Functions Appendix B. Supplementary Topics

粉丝: 1
资源: 7

上传资源快速赚钱

我的内容管理收起

我的资源快来上传第一个资源

我的收益

登录查看自己的收益

我的积分登录查看自己的积分

我的C币登录后查看C币余额

我的收藏

我的下载

下载帮助

会员权益专享

Getting-Started-with-SQL-A-Hands-On-Approach-for-Beginners.pdf

评论0

会员权益专享

最新资源

Getting-Started-with-SQL-A-Hands-On-Approach-for-Beginners.pdf

评论0

getting started with sql

Getting.Started.with.SQL.A.Hands-On.Approach.for.Beginners

Getting-Started-Guide-Scratch2

安装ros-academy-for-beginners

hands-on machine learning with scikit-learn, keras & tensorflow

sql server profiler教程

fatal: 目标路径 'ROS-Academy-for-Beginners' 已经存在，并且不是一个空目录。

github c语言学习

RabbitMQ入门材料

推荐几本和blender有关的书籍

c primer plus

javafx教程可以帮我找一下嘛

嵌入式单片机arduinoc++那本书比较好

Spark SQ参考文献（书籍、网络资料等）十篇

python everythin

deep learning for beginners pdf

arduino esp32cam

那你能帮我找一些关于shell编程的学习资料吗

Django的英文参考文献

Spring batch学习资料

会员权益专享

最新资源