The Practical SQL Handbook, w. CD-ROM
Using SQL Variants
(Sprache: Englisch)
This latest edition of the best-selling implementation guide to the Structured Query Language teaches SQL fundamentals while providing practical solutions for critical business applications. "The Practical SQL Handbook, Fourth Edition "now includes expanded...
Leider schon ausverkauft
versandkostenfrei
Buch
43.08 €
Produktdetails
Produktinformationen zu „The Practical SQL Handbook, w. CD-ROM “
This latest edition of the best-selling implementation guide to the Structured Query Language teaches SQL fundamentals while providing practical solutions for critical business applications. "The Practical SQL Handbook, Fourth Edition "now includes expanded platform SQL coverage and extensive real-world examples based on feedback from actual SQL users. "The Practical SQL Handbook "begins with a step-by-step introduction to SQL basics and examines the issues involved in designing SQL-based database applications. It fully explores SQL' s most popular implementations from industry leaders, Oracle, Microsoft, Sybase, and Informix. Highlights include:
- Detailed coverage of SQL commands for creating databases, tables, and indexes, and for
- adding, changing, and deleting data
- Using the SELECT command to retrieve specific data
- Handling NULL values (missing information) in a relational database
- Joining tables, including self joins and outer joins (ANSI and WHERE-clause syntax)
- Working with nested queries (subqueries) to get data from multiple tables
- Creating views (virtual tables) to provide customized access to data
- Using SQL functions
Klappentext zu „The Practical SQL Handbook, w. CD-ROM “
This best-selling implementation guide to the Structured Query Language teaches SQL fundamentals while providing practical solutions for critical applications. The Practical SQL Handbook, Fourth Edition includes expanded platform SQL coverage and extensive real world examples based on feedback from actual SQL users. Beginning with a step-by-step introduction to SQL basics, The Practical SQL Handbook then examines the issues involved in designing SQL-based database applications. Since this updated edition examines SQL's most popular implementations from industry leaders, students will learn how Oracle, Microsoft, Sybase, and Informix have implemented SQL.Inhaltsverzeichnis zu „The Practical SQL Handbook, w. CD-ROM “
Preface. Introduction. 1.SQL and Relational Database Management. 2. Designing Datases. 3. Creating and Filling a Database. 4. Selecting Data from the Database. 5. Sorting Data and Other Selection Techniques. 6. Grouping Data and Reporting from it. 7. Joining Tables for Comprehensive Data Analysis. 8. Structuring Queries with Subqueries. 9. Creating and Using Views. 10. Security, Transactions, Performance, and Integrity. 11. Solving Business Problems. Appendix A: Syntax Summary for the SQL Used in This Book. Appendix B: Industry SQL Equivalents. Appendix C: Glossary. Appendix D: The 'bookbiz' Sample Database.
Autoren-Porträt von Judith S. Bowman, Sandra L. Emerson, Marcy Darnovsky
Judith S. Bowman has been a database professional since the early 1980s. She is currently an independent consultant specializing in SQL and relational database issues and is the author of Practical SQL: The Sequel (Addison-Wesley, 2001). Sandra L. Emerson is an independent consultant and former Vice President of Publishing Programs for Sybase. Marcy Darnovsky, teaches at colleges throughout the San Francisco Bay area. She was formerly at Sybase. 0201703092AB04062001
Bibliographische Angaben
- Autoren: Judith S. Bowman , Sandra L. Emerson , Marcy Darnovsky
- 2001, 4. Aufl., 512 Seiten, Maße: 18,6 x 2,9 cm, Kartoniert (TB), Englisch
- Verlag: Addison-Wesley Longman, Amsterdam
- ISBN-10: 0201703092
- ISBN-13: 9780201703092
Sprache:
Englisch
Kommentar zu "The Practical SQL Handbook, w. CD-ROM"
0 Gebrauchte Artikel zu „The Practical SQL Handbook, w. CD-ROM“
Zustand | Preis | Porto | Zahlung | Verkäufer | Rating |
---|
Schreiben Sie einen Kommentar zu "The Practical SQL Handbook, w. CD-ROM".
Kommentar verfassen