-13%
20,99 €
Bisher 23,99 €**
20,99 €
inkl. MwSt.
**Preis der gedruckten Ausgabe (Broschiertes Buch)
Sofort per Download lieferbar
Bisher 23,99 €**
20,99 €
inkl. MwSt.
**Preis der gedruckten Ausgabe (Broschiertes Buch)
Sofort per Download lieferbar

Alle Infos zum eBook verschenken
Als Download kaufen
Bisher 23,99 €**
-13%
20,99 €
inkl. MwSt.
**Preis der gedruckten Ausgabe (Broschiertes Buch)
Sofort per Download lieferbar
Abo Download
9,90 € / Monat*
*Abopreis beinhaltet vier eBooks, die aus der tolino select Titelauswahl im Abo geladen werden können.

inkl. MwSt.
Sofort per Download lieferbar

Einmalig pro Kunde einen Monat kostenlos testen (danach 9,90 € pro Monat), jeden Monat 4 aus 40 Titeln wählen, monatlich kündbar.

Mehr zum tolino select eBook-Abo
Jetzt verschenken
Bisher 23,99 €**
-13%
20,99 €
inkl. MwSt.
**Preis der gedruckten Ausgabe (Broschiertes Buch)
Sofort per Download lieferbar

Alle Infos zum eBook verschenken
0 °P sammeln

  • Format: ePub


Uncover the secrets of SQL and start building better relational databases today!This fun and friendly guide will help you demystify database management systems so you can create more powerful databases and access information with ease. Updated for the latest SQL functionality, SQL For Dummies, 8th Edition covers the core SQL language and shows you how to use SQL to structure a DBMS, implement a database design, secure your data, and retrieve information when you need it. Includes new enhancements of SQL:2011, including temporal data functionality which allows you to set valid times for…mehr

  • Geräte: eReader
  • mit Kopierschutz
  • eBook Hilfe
  • Größe: 3.55MB
Produktbeschreibung
Uncover the secrets of SQL and start building better relational databases today!This fun and friendly guide will help you demystify database management systems so you can create more powerful databases and access information with ease. Updated for the latest SQL functionality, SQL For Dummies, 8th Edition covers the core SQL language and shows you how to use SQL to structure a DBMS, implement a database design, secure your data, and retrieve information when you need it. Includes new enhancements of SQL:2011, including temporal data functionality which allows you to set valid times for transactions to occur and helps prevent database corruption Covers creating, accessing, manipulating, maintaining, and storing information in relational database management systems like Access, Oracle, SQL Server, and MySQL Provides tips for keeping your data safe from theft, accidental or malicious corruption, or loss due to equipment failures and advice on eliminating errors in your work Don't be daunted by database development anymore - get SQL For Dummies, 8th Edition, and you'll be on your way to SQL stardom.

Dieser Download kann aus rechtlichen Gründen nur mit Rechnungsadresse in A, D ausgeliefert werden.

  • Produktdetails
  • Verlag: John Wiley & Sons
  • Seitenzahl: 480
  • Erscheinungstermin: 07.08.2013
  • Englisch
  • ISBN-13: 9781118657119
  • Artikelnr.: 39478157
Autorenporträt
Allen G. Taylor is a 30-year veteran of the computer industry. He lectures nationally on databases, innovation, and entrepreneurship, and teaches database development internationally through a leading online education provider. He has written more than 20 books, including all editions of SQL For Dummies.
Inhaltsangabe
Introduction 1

Part 1: Getting Started with SQL 5

Chapter 1: Relational Database Fundamentals 7

Chapter 2: SQL Fundamentals 23

Chapter 3: The Components of SQL 55

Part 2: Using SQL to Build Databases 83

Chapter 4: Building and Maintaining a Simple Database Structure 85

Chapter 5: Building a Multi-table Relational Database 109

Part 3: Storing and Retrieving Data 141

Chapter 6: Manipulating Database Data 143

Chapter 7: Handling Temporal Data 163

Chapter 8: Specifying Values 179

Chapter 9: Using Advanced SQL Value Expressions 209

Chapter 10: Zeroing In on the Data You Want 223

Chapter 11: Using Relational Operators 259

Chapter 12: Delving Deep with Nested Queries 283

Chapter 13: Recursive Queries 303

Part 4: Controlling Operations 313

Chapter 14: Providing Database Security 315

Chapter 15: Protecting Data 331

Chapter 16: Using SQL within Applications 351

Part 5: Taking SQL to the Real World 365

Chapter 17: Accessing Data with ODBC and JDBC 367

Chapter 18: Operating on XML Data with SQL 377

Chapter 19: SQL and JSON 399

Part 6: Advanced Topics 413

Chapter 20: Stepping through a Dataset with Cursors 415

Chapter 21: Adding Procedural Capabilities with Persistent Stored Modules 427

Chapter 22: Handling Errors 445

Chapter 23: Triggers 457

Part 7: The Parts of Tens 463

Chapter 24: Ten Common Mistakes 465

Chapter 25: Ten Retrieval Tips 469

Appendix: ISO/IEC SQL: 2016 Reserved Words 473

Index 479

Introduction 1

Part I: Getting Started with SQL 3

Chapter 1: Relational Database Fundamentals 5

Chapter 2: SQL Fundamentals 21

Chapter 3: The Components of SQL 51

Part II: Using SQL to Build Databases 79

Chapter 4: Building and Maintaining a Simple Database Structure 81

Chapter 5: Building a Multitable Relational Database 105

Part III: Storing and Retrieving Data 137

Chapter 6: Manipulating Database Data 139

Chapter 7: Handling Temporal Data 157

Chapter 8: Specifying Values 171

Chapter 9: Using Advanced SQL Value Expressions 197

Chapter 10: Zeroing In on the Data You Want 211

Chapter 11: Using Relational Operators 243

Chapter 12: Delving Deep with Nested Queries 267

Chapter 13: Recursive Queries 285

Part IV: Controlling Operations 295

Chapter 14: Providing Database Security 297

Chapter 15: Protecting Data 313

Chapter 16: Using SQL within Applications 333

Part V: Taking SQL to the Real World 347

Chapter 17: Accessing Data with ODBC and JDBC 349

Chapter 18: Operating on XML Data with SQL 359

Part VI: Advanced Topics 381

Chapter 19: Stepping through a Dataset with Cursors 383

Chapter 20: Adding Procedural Capabilities with Persistent Stored Modules 393

Chapter 21: Handling Errors 411

Chapter 22: Triggers 423

Part VII: The Part of Tens 429

Chapter 23: Ten Common Mistakes 431

Chapter 24: Ten Retrieval Tips 435

Appendix: SQL: 2011 Reserved Words 439

Index 443