Muutke küpsiste eelistusi

SQL Primer: An Accelerated Introduction to SQL Basics 1st ed. [Pehme köide]

4.12/5 (15 hinnangut Goodreads-ist)
  • Formaat: Paperback / softback, 194 pages, kõrgus x laius: 235x155 mm, kaal: 454 g, 14 Illustrations, black and white; XVII, 194 p. 14 illus., 1 Paperback / softback
  • Ilmumisaeg: 16-Jun-2018
  • Kirjastus: APress
  • ISBN-10: 1484235754
  • ISBN-13: 9781484235751
Teised raamatud teemal:
  • Pehme köide
  • Hind: 53,33 €*
  • * hind on lõplik, st. muud allahindlused enam ei rakendu
  • Tavahind: 62,74 €
  • 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 Primer: An Accelerated Introduction to SQL Basics 1st ed.Suurem pilt
  • Formaat: Paperback / softback, 194 pages, kõrgus x laius: 235x155 mm, kaal: 454 g, 14 Illustrations, black and white; XVII, 194 p. 14 illus., 1 Paperback / softback
  • Ilmumisaeg: 16-Jun-2018
  • Kirjastus: APress
  • ISBN-10: 1484235754
  • ISBN-13: 9781484235751
Teised raamatud teemal:
Püsilink: https://www.kriso.ee/db/9781484235751.html
Märksõnad:
Build a core level of competency in SQL so you can recognize the parts of queries and write simple SQL statements. SQL knowledge is essential for anyone involved in programming, data science, and data management. This book covers features of SQL that are standardized and common across most database vendors. You will gain a base of knowledge that will prepare you to go deeper into the specifics of any database product you might encounter. 

Examples in the book are worked in PostgreSQL and SQLite, but the bulk of the examples are platform agnostic and will work on any database platform supporting SQL. Early in the book you learn about table design, the importance of keys as row identifiers, and essential query operations. You then move into more advanced topics such as grouping and summarizing, creating calculated fields, joining data from multiple tables when it makes business sense to do so, and more. Throughout the book, you are exposed to a set-based approach to the language and are provided a good grounding in subtle but important topics such as the effects of null value on query results.
 
With the explosion of data science, SQL has regained its prominence as a top skill to have for technologists and decision makers worldwide. SQL Primer will guide you from the very basics of SQL through to the mainstream features you need to have a solid, working knowledge of this important, data-oriented language.

What You'll Learn
  • Create and populate your own database tables
  • Read SQL queries and understand what they are doing
  • Execute queries that get correct results
  • Bring together related rows from multiple tables
  • Group and sort data in support of reporting applications
  • Get a grip on nulls, normalization, and other key concepts
  • Employ subqueries, unions, and other advanced features
Who This Book Is For

Anyone new to SQL who is looking for step-by-step guidance toward understanding and writing SQL queries. The book is aimed at those who encounter SQL statements often in their work, and provides a sound baseline useful across all SQL database systems. Programmers, database managers, data scientists, and business analysts all can benefit from the baseline of SQL knowledge provided in this book.




Tagline: Add a core competency to your skill set that every programmer, system administrator, database administrator, and data scientist should have.
About the Author xi
About the Technical Reviewer xiii
Acknowledgments xv
Introduction xvii
Chapter 1 An Introduction to SQL
1(10)
The Relational Model and SQL
2(2)
Advantages of Using SQL
4(1)
SQL Commands Classification
5(1)
Explaining Tables
5(2)
Data Types in SQL
7(4)
Chapter 2 Getting Your Database Ready
11(14)
Using PostgreSQL
12(2)
Using SQLite
14(2)
Creating Your Own Database
16(1)
Table Creation
17(3)
Inserting Data
20(1)
Writing Your First Query
21(4)
Chapter 3 The Benefit of Constraints
25(12)
The Null Constraint
26(2)
Selective Fields INSERT
28(2)
Check Constraints
30(2)
Primary Key Constraint
32(2)
Unique Key Constraints
34(2)
Differences Between a Primary Key and a Unique Key
36(1)
Chapter 4 Operations on Tables
37(10)
Dropping Tables
37(2)
Creating New Tables from Existing Tables
39(3)
Modifying Tables
42(1)
Showing Table Information in PostgreSQL
43(2)
Showing Table Information in SQLite
45(1)
Showing Table Information in Other DBMS's
46(1)
Chapter 5 Writing Basic Queries
47(10)
Selecting a Limited Number of Columns
47(2)
Ordering the Results
49(1)
Ordering Using Field Abbreviations
50(1)
Ordering by Multiple Columns
51(2)
Putting Conditions with WHERE
53(2)
Combining Conditions
55(2)
Chapter 6 Manipulating Data
57(8)
Inserting Data into a Table from Another Table
57(3)
Updating Existing Data
60(3)
Deleting Data from Tables
63(2)
Chapter 7 Organizing Your Data
65(10)
Normalization
65(2)
Atomicity
67(1)
Repeating Groups
68(1)
Splitting the Table
69(6)
Chapter 8 Doing More with Queries
75(12)
Counting the Records in a Table
75(2)
Using DISTINCT with COUNT
77(2)
Column Aliases
79(3)
Order of Execution of SELECT Queries
82(1)
Using the LIKE Operator
83(4)
Chapter 9 Calculated Fields
87(8)
Mathematical Calculations
87(2)
String Operations
89(3)
Literal Values
92(3)
Chapter 10 Aggregation and Grouping
95(14)
Aggregate Functions
95(3)
Using the Extreme Functions - MAX and MIN
98(2)
Grouping Data
100(3)
Grouping and Aggregate Functions
103(2)
The HAVING Clause
105(4)
Chapter 11 Understanding Joins
109(14)
Alternative Join Syntax
111(1)
Resolving Ambiguity in Join Columns
112(1)
Outer Joins
113(2)
Cross Joins
115(3)
Self Joins
118(2)
Non-Equi Joins
120(3)
Chapter 12 Subqueries
123(10)
Types of Subqueries
124(1)
Existence Tests in Subqueries
125(2)
Using Subqueries in INSERT Statements
127(2)
Using ANY and ALL
129(4)
Chapter 13 Working in Sets
133(8)
Union
133(3)
Intersection
136(2)
Difference
138(3)
Chapter 14 Views
141(10)
Why Are Views Needed?
141(1)
Creating a View
142(3)
Modifying Data Through Views
145(4)
Deleting Views
149(2)
Chapter 15 Indexing
151(14)
Creating an Index
152(2)
Using EXPLAIN to See Indexes at Work
154(4)
Unique Indexes
158(2)
How Do Indexes Work?
160(1)
Index Overheads
161(2)
Deleting an Index
163(2)
Chapter 16 Access Control Statements
165(10)
Creating New Users in PostgreSQL
166(3)
Grant Privileges to Users
169(3)
Revoking Privileges
172(3)
Appendix A Further Reading
175(4)
Appendix B Database Management Systems and Tools
179(4)
Relational Database Management Systems
179(2)
SQL Development Environments
181(2)
Appendix C A History of SQL and Relational Databases
183(6)
The Rise of Sophisticated File-Oriented Systems
183(1)
The Entry of Database Systems
184(1)
Genesis of the Relational Model
185(1)
The Hard Fought Battle of Query Languages
186(3)
Index 189
Rahul Batra was first introduced to programming in 1996 with GWBASIC, but he did not seriously foray into programming until 2001 when he started learning C++. Along the way, Rahul dabbled in many other languages such as C, Ruby, Perl, Python, and Lisp. He has worked with databases such as PostgreSQL, Sybase ASA, and SQLite. He is passionate about sharing knowledge, especially with those who are just starting out. Rahul currently lives and works in Gurgaon, India.