Menu

mon compte Connexion

mon panier 0 article

Vous avez entre 15 et 18 ans ? Profitez du Pass Culture à la librairie Eyrolles !
Tous nos rayons
Aucun résultat pour ""

Rayons

Graphisme & Photo Informatique Construction Entreprise & Droit Sciences Littérature Arts & Loisirs Vie pratique Voyage et Tourisme BD et Jeunesse

Déjà client ? Identifiez-vous

Mot de passe oublié ?

Nouveau client ?

CRÉER VOTRE COMPTE
SQL Primer: An Accelerated Introduction to SQL Basics
Ajouter à une liste

Librairie Eyrolles - Paris 5e
Indisponible

SQL Primer: An Accelerated Introduction to SQL Basics

SQL Primer: An Accelerated Introduction to SQL Basics

Rahul Batra

(0 avis) Donner votre avis
194 pages, parution le 15/06/2018
Ajouter à une liste
Indisponible

Résumé

Tagline: Add a core competency to your skill set that every programmer, system administrator, database administrator, and data scientist should have.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.

1. An Introduction to SQL2. Getting Your Database Ready3. The Benefit of Constraints4. Operations on Tables5. Writing Basic Queries6. Manipulating Data7. Organizing Your Data8. Doing More with Queries9. Calculated Fields10. Aggregation and Grouping11. Understanding Joins12. Subqueries13. Working in Sets14. Views15. Indexing16. Access Control Statements17: Appendix A. Further Reading18. Appendix B. Database Management Systems and Tools19. Appendix C. A History of SQL and Relational Databases 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.

Caractéristiques techniques

  PAPIER
Éditeur(s) Apress
Auteur(s) Rahul Batra
Parution 15/06/2018
Nb. de pages 194
EAN13 9781484235751

Avantages Eyrolles.com

Livraison à partir de 0,01 € en France métropolitaine
Paiement en ligne SÉCURISÉ
Livraison dans le monde
Retour sous 15 jours
+ d'un million et demi de livres disponibles

Consultez aussi

satisfait ou remboursé
Satisfait ou remboursé
Paiement sécurisé
modes de paiement
Paiement à l'expédition
partout dans le monde
Livraison partout dans le monde
Service clients sav.client@eyrolles.com
librairie française
Librairie française depuis 1925
Recevez nos newsletters
Vous serez régulièrement informé(e) de toutes nos actualités.
Inscription