Auf Lager:2Buch (Softcover): Fachbuch
SQL All-In-One for Dummies
von Richard Blum, Allen G. Taylor
- Verlag
- John Wiley & Sons
- Unsere Artikel-Nr.
- PE732ED
Beschreibung
Your one-stop guide to SQL. SQL is the international standard programming language for relational databases. Yes, it's all about data, and adding SQL to your coding wheelhouse is more important than ever. This book lets you do just that, with easy-to-follow instructions on everything from the basics to advanced topics. You'll learn to create and fill databases, edit data, and protect data from corruption. You'll also see how to use SQL alongside other programming languages, so you can build data applications that add value in any setting. 7 Minibooks Inside. Getting Started with SQL. Developing Relational Databases. Writing SQL Queries. Securing Your Data. Programming with SQL. Working with Advanced Data Types in SQL. Optimizing Your Database.
Spezifikationen
| Sprache | Englisch |
|---|---|
| Autor | Richard Blum, Allen G. Taylor |
| Erscheinungsjahr | 2024 |
| Format | Buch (Softcover) |
| Anzahl Seiten | 800 |
Inhaltsverzeichnis
Introduction 1
Book 1: Getting Started with SQL 5
Chapter 1: Understanding Relational Databases 7
Chapter 2: Modeling a System 29
Chapter 3: Getting to Know SQL 53
Chapter 4: SQL and the Relational Model 65
Chapter 5: Knowing the Major Components of SQL 75
Chapter 6: Drilling Down to the SQL Nitty-Gritty 99
Book 2: Developing Relational Databases 133
Chapter 1: System Development Overview 135
Chapter 2: Building a Database Model 151
Chapter 3: Balancing Performance and Correctness 169
Chapter 4: Creating a Database with SQL 203
Book 3: Writing SQL Queries 217
Chapter 1: Values, Variables, Functions, and Expressions 219
Chapter 2: SELECT Statements and Modifying Clauses 249
Chapter 3: Querying Multiple Tables with Subqueries 295
Chapter 4: Querying Multiple Tables with Relational Operators 323
Chapter 5: Cursors 345
Book 4: Securing Your Data 357
Chapter 1: Protecting Against Hardware Failure and External Threats 359
Chapter 2: Protecting Against User Errors and Conflicts 391
Chapter 3: Assigning Access Privileges 419
Chapter 4: Error Handling 431
Book 5: Programming with SQL 447
Chapter 1: Database Development Environments 449
Chapter 2: Interfacing SQL to a Procedural Language 455
Chapter 3: Using SQL in an Application Program 461
Chapter 4: Designing a Sample Application 477
Chapter 5: Building an Application 497
Chapter 6: Understanding SQL's Procedural Capabilities 513
Chapter 7: Connecting SQL to a Remote Database 531
Book 6: Working with Advanced Data Types in SQL: XML, JSON, and PGQ 545
Chapter 1: Using XML with SQL 547
Chapter 2: Storing XML Data in SQL Tables 575
Chapter 3: Retrieving Data from XML Documents 599
Chapter 4: Using JSON with SQL 617
Chapter 5: Exploring Property Graph Queries 633
Book 7: Optimizing Your Database 645
Chapter 1: Tuning the Database 647
Chapter 2: Tuning the Environment 659
Chapter 3: Finding and Eliminating Performance Bottlenecks 681
Book 8: Appendixes 709
Chapter 1: SQL:2023 Reserved Words 711
Chapter 2: Glossary 721
Index 731
Book 1: Getting Started with SQL 5
Chapter 1: Understanding Relational Databases 7
Chapter 2: Modeling a System 29
Chapter 3: Getting to Know SQL 53
Chapter 4: SQL and the Relational Model 65
Chapter 5: Knowing the Major Components of SQL 75
Chapter 6: Drilling Down to the SQL Nitty-Gritty 99
Book 2: Developing Relational Databases 133
Chapter 1: System Development Overview 135
Chapter 2: Building a Database Model 151
Chapter 3: Balancing Performance and Correctness 169
Chapter 4: Creating a Database with SQL 203
Book 3: Writing SQL Queries 217
Chapter 1: Values, Variables, Functions, and Expressions 219
Chapter 2: SELECT Statements and Modifying Clauses 249
Chapter 3: Querying Multiple Tables with Subqueries 295
Chapter 4: Querying Multiple Tables with Relational Operators 323
Chapter 5: Cursors 345
Book 4: Securing Your Data 357
Chapter 1: Protecting Against Hardware Failure and External Threats 359
Chapter 2: Protecting Against User Errors and Conflicts 391
Chapter 3: Assigning Access Privileges 419
Chapter 4: Error Handling 431
Book 5: Programming with SQL 447
Chapter 1: Database Development Environments 449
Chapter 2: Interfacing SQL to a Procedural Language 455
Chapter 3: Using SQL in an Application Program 461
Chapter 4: Designing a Sample Application 477
Chapter 5: Building an Application 497
Chapter 6: Understanding SQL's Procedural Capabilities 513
Chapter 7: Connecting SQL to a Remote Database 531
Book 6: Working with Advanced Data Types in SQL: XML, JSON, and PGQ 545
Chapter 1: Using XML with SQL 547
Chapter 2: Storing XML Data in SQL Tables 575
Chapter 3: Retrieving Data from XML Documents 599
Chapter 4: Using JSON with SQL 617
Chapter 5: Exploring Property Graph Queries 633
Book 7: Optimizing Your Database 645
Chapter 1: Tuning the Database 647
Chapter 2: Tuning the Environment 659
Chapter 3: Finding and Eliminating Performance Bottlenecks 681
Book 8: Appendixes 709
Chapter 1: SQL:2023 Reserved Words 711
Chapter 2: Glossary 721
Index 731
Bewertungen
Produkt bewertenFür dieses Produkt liegt noch keine Bewertung vor. Wenn Sie es gekauft haben, teilen Sie gerne Ihre Erfahrung.
Zahlungsarten
Rechnung (Einzahlungsschein mit QR-Code), Twint, Kreditkarte, PostFinance, Apple, Google oder Samsung Pay.
Versand
Kostenlos: Schweiz & Liechtenstein
Rückgabe
30 Tage Rückgaberecht
Sie können das Produkt innerhalb von 30 Wochentagen ohne Angabe von Gründen zurücksenden, sofern es unbeschädigt und in der Originalverpackung ist.
Weitere Hinweise finden Sie in unseren AGB unter D.1.
