SQL Primer
Apress (Verlag)
978-1-4842-3575-1 (ISBN)
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 approachto 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.
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.
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.
Erscheinungsdatum | 21.06.2018 |
---|---|
Zusatzinfo | 14 Illustrations, black and white; XVII, 194 p. 14 illus. |
Verlagsort | Berkley |
Sprache | englisch |
Maße | 155 x 235 mm |
Themenwelt | Mathematik / Informatik ► Informatik ► Datenbanken |
Mathematik / Informatik ► Informatik ► Software Entwicklung | |
Schlagworte | ACID Properties • Aggregation and Grouping • Atomicity • Database • normalization • Querying • SQL • Working in Sets • Writing Queries |
ISBN-10 | 1-4842-3575-4 / 1484235754 |
ISBN-13 | 978-1-4842-3575-1 / 9781484235751 |
Zustand | Neuware |
Haben Sie eine Frage zum Produkt? |
aus dem Bereich