Muutke küpsiste eelistusi

SQL Pocket Guide: A Guide to SQL Usage 4th Revised edition [Pehme köide]

3.98/5 (317 hinnangut Goodreads-ist)
  • Formaat: Paperback / softback, 250 pages, kõrgus x laius: 178x108 mm
  • Ilmumisaeg: 30-Sep-2021
  • Kirjastus: O'Reilly Media
  • ISBN-10: 1492090409
  • ISBN-13: 9781492090403
Teised raamatud teemal:
  • Pehme köide
  • Hind: 35,65 €*
  • * hind on lõplik, st. muud allahindlused enam ei rakendu
  • Tavahind: 41,94 €
  • Säästad 15%
  • Raamatu kohalejõudmiseks kirjastusest kulub orienteeruvalt 2-4 nädalat
  • Kogus:
  • Lisa ostukorvi
  • Tasuta tarne
  • Tellimisaeg 2-4 nädalat
  • Lisa soovinimekirja
SQL Pocket Guide: A Guide to SQL Usage 4th Revised editionSuurem pilt
  • Formaat: Paperback / softback, 250 pages, kõrgus x laius: 178x108 mm
  • Ilmumisaeg: 30-Sep-2021
  • Kirjastus: O'Reilly Media
  • ISBN-10: 1492090409
  • ISBN-13: 9781492090403
Teised raamatud teemal:
Püsilink: https://www.kriso.ee/db/9781492090403.html
Märksõnad:

If you use SQL in your day-to-day work as a data analyst, data scientist, or data engineer, this popular pocket guide is your ideal on-the-job reference. You'll find many examples that address the language's complexities, along with key aspects of SQL used in Microsoft SQL Server, MySQL, Oracle Database, PostgreSQL, and SQLite.

In this updated edition, author Alice Zhao describes how these database management systems implement SQL syntax for both querying and making changes to a database. You'll find details on data types and conversions, regular expression syntax, window functions, pivoting and unpivoting, and more.

  • Quickly look up how to perform specific tasks using SQL
  • Apply the book's syntax examples to your own queries
  • Update SQL queries to work in five different database management systems
  • NEW: Connect Python and R to a relational database
  • NEW: Look up frequently asked SQL questions in the "How Do I?" chapter
Preface xi
Chapter 1 SQL Crash Course
1(12)
What Is a Database?
1(5)
SQL
1(1)
NoSQL
2(1)
Database Management Systems (DBMS)
3(3)
A SQL Query
6(4)
The SELECT Statement
7(2)
Order of Execution
9(1)
A Data Model
10(3)
Chapter 2 Where Can I Write SQL Code?
13(24)
RDBMS Software
14(6)
SQLite
15(2)
MySQL
17(1)
Oracle
17(1)
PostgreSQL
18(1)
SQL Server
19(1)
Database Tools
20(4)
Connect a Database Tool to a Database
22(2)
Other Programming Languages
24(13)
Connect Python to a Database
25(6)
Connect R to a Database
31(6)
Chapter 3 The SQL Language
37(16)
Comparison to Other Languages
37(2)
ANSI Standards
39(2)
SQL Terms
41(9)
Keywords and Functions
42(1)
Identifiers and Aliases
43(2)
Statements and Clauses
45(2)
Expressions and Predicates
47(1)
Comments, Quotes, and Whitespace
48(2)
Sublanguages
50(3)
Chapter 4 Querying Basics
53(38)
The SELECT Clause
55(8)
Aliasing Columns
57(2)
Qualifying Columns
59(2)
Selecting Subqueries
61(2)
Distinct
63(6)
The FROM Clause
66(1)
From Multiple Tables
66(3)
From Subqueries
69(4)
The Where Clause
73(5)
Filtering on Subqueries
75(3)
The Group By Clause
78(5)
The Having Clause
83(2)
The Order By Clause
85(3)
The Limit Clause
88(3)
Chapter 5 Creating, Updating, and Deleting
91(52)
Databases
91(6)
Display Names of Existing Databases
93(1)
Display Name of Current Database
94(1)
Switch to Another Database
95(1)
Create a Database
95(1)
Delete a Database
96(1)
Creating Tables
97(18)
Create a Simple Table
98(2)
Display Names of Existing Tables
100(1)
Create a Table That Does Not Already Exist
100(1)
Create a Table with Constraints
101(4)
Create a Table with Primary and Foreign Keys
105(3)
Create a Table with an Automatically Generated Field
108(2)
Insert the Results of a Query into a Table
110(2)
Insert Data from a Text File into a Table
112(3)
Modifying Tables
115(14)
Rename a Table or Column
115(2)
Display, Add, and Delete Columns
117(2)
Display, Add, and Delete Rows
119(1)
Display, Add, Modify, and Delete Constraints
120(4)
Update a Column of Data
124(1)
Update Rows of Data
125(1)
Update Rows of Data with the Results of a Query
126(2)
Delete a Table
128(1)
Indexes
129(4)
Create an Index to Speed Up Queries
131(2)
Views
133(5)
Create a View to Save the Results of a Query
135(3)
Transaction Management
138(5)
Double-Check Changes Before a COMMIT
139(2)
Undo Changes with a ROLLBACK
141(2)
Chapter 6 Data Types
143(36)
How to Choose a Data Type
145(2)
Numeric Data
147(7)
Numeric Values
147(1)
Integer Data Types
148(2)
Decimal Data Types
150(1)
Floating Point Data Types
151(3)
String Data
154(7)
String Values
154(2)
Character Data Types
156(3)
Unicode Data Types
159(2)
Datetime Data
161(11)
Datetime Values
161(4)
Datetime Data Types
165(7)
Other Data
172(7)
Boolean Data
172(1)
External Files (Images, Documents, etc.)
173(6)
Chapter 7 Operators and Functions
179(58)
Operators
180(11)
Logical Operators
181(1)
Comparison Operators
182(7)
Math Operators
189(2)
Aggregate Functions
191(2)
Numeric Functions
193(6)
Apply Math Functions
194(2)
Generate Random Numbers
196(1)
Round and Truncate Numbers
197(1)
Convert Data to a Numeric Data Type
198(1)
String Functions
199(19)
Find the Length of a String
199(1)
Change the Case of a String
200(1)
Trim Unwanted Characters Around a String
201(2)
Concatenate Strings
203(1)
Search for Text in a String
203(3)
Extract a Portion of a String
206(1)
Replace Text in a String
207(1)
Delete Text from a String
208(1)
Use Regular Expressions
209(8)
Convert Data to a String Data Type
217(1)
Datetime Functions
218(17)
Return the Current Date or Time
218(2)
Add or Subtract a Date or Time Interval
220(1)
Find the Difference Between Two Dates or Times
221(5)
Extract a Part of a Date or Time
226(2)
Determine the Day of the Week of a Date
228(1)
Round a Date to the Nearest Time Unit
229(1)
Convert a String to a Datetime Data Type
230(5)
Null Functions
235(2)
Return an Alternative Value if There Is a Null Value
235(2)
Chapter 8 Advanced Querying Concepts
237(32)
Case Statements
238(4)
Display Values Based on If-Then Logic for a Single Column
239(1)
Display Values Based on If-Then Logic for Multiple Columns
240(2)
Grouping and Summarizing
242(8)
Group By Basics
242(3)
Aggregate Rows into a Single Value or List
245(2)
Rollup, Cube, and Grouping Sets
247(3)
Window Functions
250(13)
Rank the Rows in a Table
252(3)
Return the First Value in Each Group
255(1)
Return the Second Value in Each Group
256(1)
Return the First Two Values in Each Group
257(1)
Return the Prior Row Value
258(1)
Calculate the Moving Average
259(2)
Calculate the Running Total
261(2)
Pivoting and Unpivoting
263(6)
Break Up the Values of a Column into Multiple Columns
263(2)
List the Values of Multiple Columns in a Single Column
265(4)
Chapter 9 Working with Multiple Tables and Queries
269(34)
Joining Tables
270(14)
Join Basics and Inner Join
274(3)
Left Join, Right Join, and Full Outer Join
277(2)
Using and Natural Join
279(2)
Cross Join and Self Join
281(3)
Union Operators
284(7)
Union
285(4)
Except and Intersect
289(2)
Common Table Expressions
291(12)
CTEs Versus Subqueries
293(2)
Recursive CTEs
295(8)
Chapter 10 How Do I...?
303(14)
Find the Rows Containing Duplicate Values
303(3)
Select Rows with the Max Value for Another Column
306(2)
Concatenate Text from Multiple Fields into a Single Field
308(3)
Find All Tables Containing a Specific Column Name
311(2)
Update a Table Where the ID Matches Another Table
313(4)
Index 317
Alice Zhao is a data scientist who is passionate about teaching and making complex things easy to understand. She has taught numerous courses in SQL, Python and R as a senior data scientist at Metis and as a co-founder of Best Fit Analytics. She writes about analytics and pop culture on her blog, A Dash of Data. Her work has been featured in Huffington Post, Thrillist and Working Mother. Alice has also spoken at a variety of data science conferences, including Strata in New York City and ODSC in San Francisco, on topics ranging from natural language processing to data visualization.