Mon compte
Se connecter Inscription
Tous
Panier
En Vedette
Livres de fiction
Livres de non-fiction
Livres pour enfants
Livres rares
Musique
DVD et Blu-Ray
Video Games
Catégorie
Listes de favoris
Panier
Tous
Livraison gratuite
Trustpilot
Nous sommes Neutres au Carbone

SQL All-in-One For Dummies Allen G. Taylor (Database Consultant, Oregon City, Oregon)

SQL All-in-One For Dummies par Allen G. Taylor (Database Consultant, Oregon City, Oregon)

SQL All-in-One For Dummies Allen G. Taylor (Database Consultant, Oregon City, Oregon)

€25.00
État - Très bon état
Disponible en seulement 1 exemplaire(s)
Très bon état

SQL All-in-One For Dummies Résumé

SQL All-in-One For Dummies Allen G. Taylor (Database Consultant, Oregon City, Oregon)

The latest on SQL databases

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.

À propos de Allen G. Taylor (Database Consultant, Oregon City, Oregon)

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 [email protected].

Sommaire

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

Informations supplémentaires

GOR010792625
9781119569619
1119569613
SQL All-in-One For Dummies Allen G. Taylor (Database Consultant, Oregon City, Oregon)
Allen G. Taylor (Database Consultant, Oregon City, Oregon)
Occasion - Très bon état
Broché
John Wiley & Sons Inc
20190528
768
N/A
La photo du livre est présentée à titre d'illustration uniquement. La reliure, la couverture ou l'édition réelle peuvent varier.
Il s'agit d'un livre d'occasion - par conséquent, il a été lu par quelqu'un d'autre et il présente des signes d'usure et d'utilisation antérieure. Dans l'ensemble, nous nous attendons à ce qu'il soit en très bon état, mais si vous n'êtes pas entièrement satisfait, veuillez prendre contact avec nous.