SQL Database Programming - Chris Fehily - Bücher - Questing Vole Press - 9781937842475 - 31. Januar 2020
Bei Nichtübereinstimmung von Cover und Titel gilt der Titel

SQL Database Programming Fifth edition

Chris Fehily

Preis
$ 32,99
exkl. MwSt.

Bestellware

Lieferdatum: ca. 7. - 18. Jul
Zu deiner iMusic Wunschliste hinzufügen

SQL Database Programming Fifth edition

Read this book for free at sqlrun.com. Perfect for end users, analysts, data scientists, students, and developers, this best-selling guide will get you up and running with SQL, the language of databases. You'll find general concepts, practical answers, and clear explanations of what the various SQL statements can do. Hundreds of examples of varied difficulty encourage you to experiment and explore. Formatted SQL code listings help you see the elements and structure of the language. You can download the sample database to follow along with the author's examples.

Covers Oracle Database, Microsoft SQL Server, IBM Db2 Database, MySQL, PostgreSQL, and Microsoft Access. Learn the core language for standard SQL, and variations for the most widely used database systems. Organize your database in terms of the relational model. Master tables, columns, rows, and keys. Retrieve, sort, and format data. Filter data that you don't want to see. Convert and manipulate data with SQL's built-in functions and operators. Use aggregate functions to summarize data. Create complex SQL statements by using joins, subqueries, constraints, conditional logic, and metadata. Create, alter, and drop tables, indexes, and views. Insert, update, delete, and merge data. Execute transactions to maintain the integrity of your data. Avoid common pitfalls involving nulls. Troubleshoot and optimize queries. Learn advanced techniques that extend the power of SQL.

ContentsIntroduction1. Running SQL Programs2. The Relational Model3. SQL Basics4. Retrieving Data from a Table5. Operators and Functions6. Summarizing and Grouping Data7. Joins8. Subqueries9. Set Operations10. Inserting, Updating, and Deleting Rows11. Creating, Altering, and Dropping Tables12. Indexes13. Views14. Transactions15. Advanced SQL

About the AuthorChris Fehily is a statistician and author based in San Francisco.

Medien Bücher     Taschenbuch   (Buch mit Softcover und geklebtem Rücken)
Erscheinungsdatum 31. Januar 2020
ISBN13 9781937842475
Verlag Questing Vole Press
Seitenanzahl 466
Maße 203 × 254 × 24 mm   ·   916 g
Sprache Englisch  

Alle anzeigen

Weitere Titel von Chris Fehily

Andere haben auch gekauft