Details

SQL All-in-One For Dummies


SQL All-in-One For Dummies


3. Aufl.

von: Allen G. Taylor

26,99 €

Verlag: Wiley
Format: PDF
Veröffentl.: 27.03.2019
ISBN/EAN: 9781119569602
Sprache: englisch
Anzahl Seiten: 768

DRM-geschütztes eBook, Sie benötigen z.B. Adobe Digital Editions und eine Adobe ID zum Lesen.

Beschreibungen

<p><b>The latest on SQL databases</b></p> <p><i>SQL All -In-One For Dummies, 3rd Edition</i>, 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.</p> <p>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.</p> <ul> <li>Cope with any issue that arises in SQL database creation and management</li> <li>Get current on the newest SQL updates and capabilities</li> <li>Reference information on querying SQL-based databases in the SQL language</li> <li>Understand relational databases and their importance to today’s organizations</li> </ul> <p><i>SQL All-In-One For Dummies</i> is a timely update to the popular reference for readers who want detailed information about SQL databases and queries.</p>
<p>Introduction 1</p> <p><b>Book 1: SQL Concepts 9</b></p> <p>Chapter 1: Understanding Relational Databases 11</p> <p>Chapter 2: Modeling a System 31</p> <p>Chapter 3: Getting to Know SQL 55</p> <p>Chapter 4: SQL and the Relational Model 67</p> <p>Chapter 5: Knowing the Major Components of SQL 77</p> <p>Chapter 6: Drilling Down to the SQL Nitty-Gritty 99</p> <p><b>Book 2: Relational Database Development 131</b></p> <p>Chapter 1: System Development Overview 133</p> <p>Chapter 2: Building a Database Model 149</p> <p>Chapter 3: Balancing Performance and Correctness 167</p> <p>Chapter 4: Creating a Database with SQL 199</p> <p><b>Book 3: SQL Queries 211</b></p> <p>Chapter 1: Values, Variables, Functions, and Expressions 213</p> <p>Chapter 2: SELECT Statements and Modifying Clauses 239</p> <p>Chapter 3: Querying Multiple Tables with Subqueries 281</p> <p>Chapter 4: Querying Multiple Tables with Relational Operators 309</p> <p>Chapter 5: Cursors 329</p> <p><b>Book 4: Data Security 341</b></p> <p>Chapter 1: Protecting Against Hardware Failure and External Threats 343</p> <p>Chapter 2: Protecting Against User Errors and Conflicts 373</p> <p>Chapter 3: Assigning Access Privileges 401</p> <p>Chapter 4: Error Handling 413</p> <p><b>Book 5: SQL and Programming 429</b></p> <p>Chapter 1: Database Development Environments. 431</p> <p>Chapter 2: Interfacing SQL to a Procedural Language 437</p> <p>Chapter 3: Using SQL in an Application Program 443</p> <p>Chapter 4: Designing a Sample Application 457</p> <p>Chapter 5: Building an Application 477</p> <p>Chapter 6: Understanding SQL’s Procedural Capabilities 493</p> <p>Chapter 7: Connecting SQL to a Remote Database 509</p> <p><b>Book 6: SQL, XML, and JSON 523</b></p> <p>Chapter 1: Using XML with SQL 525</p> <p>Chapter 2: Storing XML Data in SQL Tables 553</p> <p>Chapter 3: Retrieving Data from XML Documents 577</p> <p>Chapter 4: Using JSON with SQL 595</p> <p><b>Book 7: Database Tuning Overview 609</b></p> <p>Chapter 1: Tuning the Database 611</p> <p>Chapter 2: Tuning the Environment 623</p> <p>Chapter 3: Finding and Eliminating Bottlenecks 645</p> <p><b>Book 8: Appendices 675</b></p> <p>Appendix A: SQL: 2016 Reserved Words 677</p> <p>Appendix B: Glossary 683</p> <p>Index 691</p>
<p><b>Allen G. Taylor </b>is a 40-year veteran of the computer industry and the author of more than 40 books, including <i>SQL For Dummies </i>and <i>Database Development For Dummies.</i> 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.</p>
<p><b>Your complete guide to SQL</b></p><p>SQL is the internationally recognized standard language for dealing with data in relational databases. So whether you’re a database administrator, a programmer, or someone who manages those functions, this handy one-stop guide belongs on your shelf! It covers SQL basics, the latest upgrades, database development, security, SQL with XML, and much more.</p><p><b>8 Books Inside…</b></p><ul><b><li>SQL Concepts</li><li>Relational Database Development</li><li>SQL Queries</li><li>Data Security</li><li>SQL and Programming</li><li>SQL, XML, and JSON</li><li>Database Tuning Overview</li><li>Reserved Words and Glossary</li></b></ul>

Diese Produkte könnten Sie auch interessieren:

AutoCAD 2013 For Dummies
AutoCAD 2013 For Dummies
von: Bill Fane, David Byrnes
PDF ebook
23,99 €
IBM Workplace Services Express For Dummies
IBM Workplace Services Express For Dummies
von: Stephen R. Londergan, Michael Loria
PDF ebook
16,99 €
Building Flash Web Sites For Dummies
Building Flash Web Sites For Dummies
von: Doug Sahlin
PDF ebook
18,99 €