finelybook
Learning SQL: Generate,Manipulate,and Retrieve Data
by 作者: Alan Beaulieu
pages 页数: 384 pages
Publisher Finelybook 出版社: O'Reilly Media; 3 edition (April 14,2020)
Language 语言: English
ISBN-10 书号: 1492057614
ISBN-13 书号: 9781492057611
Book Description
As data floods into your company,you need to put it to work right away—and SQL is the best tool for the job. With the latest edition of this introductory guide,author Alan Beaulieu helps developers get up to speed with SQL fundamentals for writing database applications,performing administrative tasks,and generating reports. You’ll find new chapters on SQL and big data,analytic functions,and working with very large databases.
Each chapter presents a self-contained lesson on a key SQL concept or technique using numerous illustrations and annotated examples. Exercises let you practice the skills you learn. Knowledge of SQL is a must for interacting with data. With Learning SQL,you’ll quickly discover how to put the power and flexibility of this language to work.
Move quickly through SQL basics and several advanced features
Use SQL data statements to generate,manipulate,and retrieve data
Create database objects,such as tables,indexes,and constraints with SQL schema statements
Learn how datasets interact with queries; understand the importance of subqueries
Convert and manipulate data with SQL’s built-in functions and use conditional logic in data statements
Preface
1.A Little Background
2. Creating and Populating a Database
3. Query Primer
4. Filtering
5. Querying Multiple Tables
6. Working with Sets
7. Data Generation,Manipulation,and Conversion
8. Grouping and Aggregates
9. Subqueries
10. Joins Revisited
11. Conditional Logic
12. Transactions
13. Indexes and Constraints
14. Views
15. Metadata
16. Analytic Functions
17. Working with Large Databases
18. SQL and Big Data
A. ER Diagram for Example Database
B. Solutions to Exercises
Index
