國立虎尾科技大學 |

SQL Primer = An Accelerated Introduction to SQL Basics /

Record Type:	Language materials, printed : Monograph/item
Title/Author:	SQL Primer/ by Rahul Batra.
Reminder of title:	An Accelerated Introduction to SQL Basics /
Author:	Batra, Rahul.
Description:	XVII, 194 p. 14 illus.online resource. :
Contained By:	Springer Nature eBook
Subject:	Database management. -
Online resource:	https://doi.org/10.1007/978-1-4842-3576-8
ISBN:	9781484235768

SQL Primer = An Accelerated Introduction to SQL Basics /
Batra, Rahul.

SQL PrimerAn Accelerated Introduction to SQL Basics /[electronic resource] :by Rahul Batra. - 1st ed. 2018. - XVII, 194 p. 14 illus.online resource.

1. An Introduction to SQL -- 2. Getting Your Database Ready -- 3. The Benefit of Constraints -- 4. Operations on Tables -- 5. Writing Basic Queries -- 6. Manipulating Data -- 7. Organizing Your Data -- 8. Doing More with Queries -- 9. Calculated Fields -- 10. Aggregation and Grouping -- 11. Understanding Joins -- 12. Subqueries -- 13. Working in Sets -- 14. Views -- 15. Indexing -- 16. Access Control Statements -- 17: Appendix A. Further Reading -- 18. Appendix B. Database Management Systems and Tools -- 19. Appendix C. A History of SQL and Relational Databases.

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.

ISBN: 9781484235768

Standard No.: 10.1007/978-1-4842-3576-8doiSubjects--Topical Terms:

557799
Database management.

LC Class. No.: QA76.9.D3

Dewey Class. No.: 005.74

SQL Primer = An Accelerated Introduction to SQL Basics /
LDR:03730nam a22004095i 4500 001 994695
003 DE-He213
005 20200630210718.0
007 cr nn 008mamaa
008 201225s2018 xxu| s |||| 0|eng d
020 $a 9781484235768 $9 978-1-4842-3576-8
024 7 $a 10.1007/978-1-4842-3576-8 $2 doi
035 $a 978-1-4842-3576-8
050 4 $a QA76.9.D3
072 7 $a UN $2 bicssc
072 7 $a COM021000 $2 bisacsh
072 7 $a UN $2 thema
072 7 $a UMT $2 thema
082 0 4 $a 005.74 $2 23
100 1 $a Batra, Rahul. $4 aut $4 http://id.loc.gov/vocabulary/relators/aut $3 1206685
245 1 0 $a SQL Primer $h [electronic resource] : $b An Accelerated Introduction to SQL Basics / $c by Rahul Batra.
250 $a 1st ed. 2018.
264 1 $a Berkeley, CA : $b Apress : $b Imprint: Apress, $c 2018.
300 $a XVII, 194 p. 14 illus. $b online resource.
336 $a text $b txt $2 rdacontent
337 $a computer $b c $2 rdamedia
338 $a online resource $b cr $2 rdacarrier
347 $a text file $b PDF $2 rda
505 0 $a 1. An Introduction to SQL -- 2. Getting Your Database Ready -- 3. The Benefit of Constraints -- 4. Operations on Tables -- 5. Writing Basic Queries -- 6. Manipulating Data -- 7. Organizing Your Data -- 8. Doing More with Queries -- 9. Calculated Fields -- 10. Aggregation and Grouping -- 11. Understanding Joins -- 12. Subqueries -- 13. Working in Sets -- 14. Views -- 15. Indexing -- 16. Access Control Statements -- 17: Appendix A. Further Reading -- 18. Appendix B. Database Management Systems and Tools -- 19. Appendix C. A History of SQL and Relational Databases.
520 $a 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.
650 0 $a Database management. $3 557799
650 1 4 $a Database Management. $3 669820
710 2 $a SpringerLink (Online service) $3 593884
773 0 $t Springer Nature eBook
776 0 8 $i Printed edition: $z 9781484235751
776 0 8 $i Printed edition: $z 9781484235775
776 0 8 $i Printed edition: $z 9781484245675
856 4 0 $u https://doi.org/10.1007/978-1-4842-3576-8
912 $a ZDB-2-CWD
912 $a ZDB-2-SXPC
950 $a Professional and Applied Computing (SpringerNature-12059)
950 $a Professional and Applied Computing (R0) (SpringerNature-43716)