SQL All-in-One For Dummies (eBook)
768 Seiten
John Wiley & Sons (Verlag)
978-1-119-56960-2 (ISBN)
SQL All -In-One For Dummies, 3rd Edition, is a one-stop shop for everything you need to know about SQL and SQL-based relational databases. Everyone from database administrators to application programmers and the people who manage them will find clear, concise explanations of the SQL language and its many powerful applications.
With the ballooning amount of data out there, more and more businesses, large and small, are moving from spreadsheets to SQL databases like Access, Microsoft SQL Server, Oracle databases, MySQL, and PostgreSQL. This compendium of information covers designing, developing, and maintaining these databases.
* Cope with any issue that arises in SQL database creation and management
* Get current on the newest SQL updates and capabilities
* Reference information on querying SQL-based databases in the SQL language
* Understand relational databases and their importance to today's organizations
SQL All-In-One For Dummies is a timely update to the popular reference for readers who want detailed information about SQL databases and queries.
Allen G. Taylor is a 40-year veteran of the computer industry and the author of more than 40 books, including SQL For Dummies and Database Development For Dummies. For the latest news on Allen's activities, check out his online courses (at pioneer-academy1.teachable.com) and his blog (at www.allengtaylor.com). You can contact Allen at allen.taylor@ieee.org.
Introduction 1
Book 1: SQL Concepts 9
Chapter 1: Understanding Relational Databases 11
Chapter 2: Modeling a System 31
Chapter 3: Getting to Know SQL 55
Chapter 4: SQL and the Relational Model 67
Chapter 5: Knowing the Major Components of SQL 77
Chapter 6: Drilling Down to the SQL Nitty-Gritty 99
Book 2: Relational Database Development 131
Chapter 1: System Development Overview 133
Chapter 2: Building a Database Model 149
Chapter 3: Balancing Performance and Correctness 167
Chapter 4: Creating a Database with SQL 199
Book 3: SQL Queries 211
Chapter 1: Values, Variables, Functions, and Expressions 213
Chapter 2: SELECT Statements and Modifying Clauses 239
Chapter 3: Querying Multiple Tables with Subqueries 281
Chapter 4: Querying Multiple Tables with Relational Operators 309
Chapter 5: Cursors 329
Book 4: Data Security 341
Chapter 1: Protecting Against Hardware Failure and External Threats 343
Chapter 2: Protecting Against User Errors and Conflicts 373
Chapter 3: Assigning Access Privileges 401
Chapter 4: Error Handling 413
Book 5: SQL and Programming 429
Chapter 1: Database Development Environments. 431
Chapter 2: Interfacing SQL to a Procedural Language 437
Chapter 3: Using SQL in an Application Program 443
Chapter 4: Designing a Sample Application 457
Chapter 5: Building an Application 477
Chapter 6: Understanding SQL's Procedural Capabilities 493
Chapter 7: Connecting SQL to a Remote Database 509
Book 6: SQL, XML, and JSON 523
Chapter 1: Using XML with SQL 525
Chapter 2: Storing XML Data in SQL Tables 553
Chapter 3: Retrieving Data from XML Documents 577
Chapter 4: Using JSON with SQL 595
Book 7: Database Tuning Overview 609
Chapter 1: Tuning the Database 611
Chapter 2: Tuning the Environment 623
Chapter 3: Finding and Eliminating Bottlenecks 645
Book 8: Appendices 675
Appendix A: SQL: 2016 Reserved Words 677
Appendix B: Glossary 683
Index 691
| Erscheint lt. Verlag | 27.3.2019 |
|---|---|
| Sprache | englisch |
| Themenwelt | Mathematik / Informatik ► Informatik ► Datenbanken |
| Informatik ► Office Programme ► Outlook | |
| Mathematik / Informatik ► Informatik ► Programmiersprachen / -werkzeuge | |
| Schlagworte | Computer-Ratgeber • Database software (Non-Microsoft) • Datenbanken (außer Microsoft) • End-User Computing • SQL |
| ISBN-10 | 1-119-56960-5 / 1119569605 |
| ISBN-13 | 978-1-119-56960-2 / 9781119569602 |
| Haben Sie eine Frage zum Produkt? |
PDF (Adobe DRM)Kopierschutz: Adobe-DRM
Adobe-DRM ist ein Kopierschutz, der das eBook vor Mißbrauch schützen soll. Dabei wird das eBook bereits beim Download auf Ihre persönliche Adobe-ID autorisiert. Lesen können Sie das eBook dann nur auf den Geräten, welche ebenfalls auf Ihre Adobe-ID registriert sind.
Details zum Adobe-DRM
Dateiformat: PDF (Portable Document Format)
Mit einem festen Seitenlayout eignet sich die PDF besonders für Fachbücher mit Spalten, Tabellen und Abbildungen. Eine PDF kann auf fast allen Geräten angezeigt werden, ist aber für kleine Displays (Smartphone, eReader) nur eingeschränkt geeignet.
Systemvoraussetzungen:
PC/Mac: Mit einem PC oder Mac können Sie dieses eBook lesen. Sie benötigen eine
eReader: Dieses eBook kann mit (fast) allen eBook-Readern gelesen werden. Mit dem amazon-Kindle ist es aber nicht kompatibel.
Smartphone/Tablet: Egal ob Apple oder Android, dieses eBook können Sie lesen. Sie benötigen eine
Geräteliste und zusätzliche Hinweise
Buying eBooks from abroad
For tax law reasons we can sell eBooks just within Germany and Switzerland. Regrettably we cannot fulfill eBook-orders from other countries.
aus dem Bereich
