The latest on SQL databasesSQL 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…mehr
The latest on SQL databasesSQL 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 organizationsSQL 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.
Inhaltsangabe
Introduction 1Book 1: SQL Concepts 9Chapter 1: Understanding Relational Databases 11Chapter 2: Modeling a System 31Chapter 3: Getting to Know SQL 55Chapter 4: SQL and the Relational Model 67Chapter 5: Knowing the Major Components of SQL 77Chapter 6: Drilling Down to the SQL Nitty-Gritty 99Book 2: Relational Database Development 131Chapter 1: System Development Overview 133Chapter 2: Building a Database Model 149Chapter 3: Balancing Performance and Correctness 167Chapter 4: Creating a Database with SQL 199Book 3: SQL Queries 211Chapter 1: Values, Variables, Functions, and Expressions 213Chapter 2: SELECT Statements and Modifying Clauses 239Chapter 3: Querying Multiple Tables with Subqueries 281Chapter 4: Querying Multiple Tables with Relational Operators 309Chapter 5: Cursors 329Book 4: Data Security 341Chapter 1: Protecting Against Hardware Failure and External Threats 343Chapter 2: Protecting Against User Errors and Conflicts 373Chapter 3: Assigning Access Privileges 401Chapter 4: Error Handling 413Book 5: SQL and Programming 429Chapter 1: Database Development Environments 431Chapter 2: Interfacing SQL to a Procedural Language 437Chapter 3: Using SQL in an Application Program 443Chapter 4: Designing a Sample Application 457Chapter 5: Building an Application 477Chapter 6: Understanding SQL's Procedural Capabilities 493Chapter 7: Connecting SQL to a Remote Database 509Book 6: SQL, XML, and JSON 523Chapter 1: Using XML with SQL 525Chapter 2: Storing XML Data in SQL Tables 553Chapter 3: Retrieving Data from XML Documents 577Chapter 4: Using JSON with SQL 595Book 7: Database Tuning Overview 609Chapter 1: Tuning the Database 611Chapter 2: Tuning the Environment 623Chapter 3: Finding and Eliminating Bottlenecks 645Book 8: Appendices 675Appendix A: SQL: 2016 Reserved Words 677Appendix B: Glossary 683Index 691
Introduction. Book I: SQL Concepts. Chapter 1: Understanding Relational Databases. Chapter 2: Modeling a System. Chapter 3: Getting to Know SQL. Chapter 4: SQL and the Relational Model. Chapter 5: Knowing the Major Components of SQL. Chapter 6: Drilling Down to the SQL Nitty-Gritty. Book II: Relational Database Development. Chapter 1: System Development Overview. Chapter 2: Building a Database Model. Chapter 3: Balancing Performance and Correctness. Chapter 4: Creating a Database with SQL. Book III: SQL Queries. Chapter 1: Values Variables Functions and Expressions. Chapter 2: SELECT Statements and Modifying Clauses. Chapter 3: Querying Multiple Tables with Subqueries. Chapter 4: Querying Multiple Tables with Relational Operators. Chapter 5: Cursors. Book IV: Data Security. Chapter 1: Protecting Against Hardware Failure and External Threats. Chapter 2: Protecting Against User Errors and Conflicts. Chapter 3: Assigning Access Privileges. Chapter 4: Error Handling. Book V: SQL and Programming. Chapter 1: Database Development Environments. Chapter 2: Interfacing SQL to a Procedural Language. Chapter 3: Using SQL in an Application Program. Chapter 4: Designing a Sample Application. Chapter 5: Building an Application. Chapter 6: Understanding SQL's Procedural Capabilities. Chapter 7: Connecting SQL to a Remote Database. Book VI: SQL and XML. Chapter 1: Using XML with SQL. Chapter 2: Storing XML Data in SQL Tables. Chapter 3: Retrieving Data from XML Documents. Book VII: Database Tuning Overview. Chapter 1: Tuning the Database. Chapter 2: Tuning the Environment. Chapter 3: Finding and Eliminating Bottlenecks. Book VIII: Appendices. Appendix A: SQL:2008 Reserved Words. Appendix B: Glossary. Index.
Introduction 1Book 1: SQL Concepts 9Chapter 1: Understanding Relational Databases 11Chapter 2: Modeling a System 31Chapter 3: Getting to Know SQL 55Chapter 4: SQL and the Relational Model 67Chapter 5: Knowing the Major Components of SQL 77Chapter 6: Drilling Down to the SQL Nitty-Gritty 99Book 2: Relational Database Development 131Chapter 1: System Development Overview 133Chapter 2: Building a Database Model 149Chapter 3: Balancing Performance and Correctness 167Chapter 4: Creating a Database with SQL 199Book 3: SQL Queries 211Chapter 1: Values, Variables, Functions, and Expressions 213Chapter 2: SELECT Statements and Modifying Clauses 239Chapter 3: Querying Multiple Tables with Subqueries 281Chapter 4: Querying Multiple Tables with Relational Operators 309Chapter 5: Cursors 329Book 4: Data Security 341Chapter 1: Protecting Against Hardware Failure and External Threats 343Chapter 2: Protecting Against User Errors and Conflicts 373Chapter 3: Assigning Access Privileges 401Chapter 4: Error Handling 413Book 5: SQL and Programming 429Chapter 1: Database Development Environments 431Chapter 2: Interfacing SQL to a Procedural Language 437Chapter 3: Using SQL in an Application Program 443Chapter 4: Designing a Sample Application 457Chapter 5: Building an Application 477Chapter 6: Understanding SQL's Procedural Capabilities 493Chapter 7: Connecting SQL to a Remote Database 509Book 6: SQL, XML, and JSON 523Chapter 1: Using XML with SQL 525Chapter 2: Storing XML Data in SQL Tables 553Chapter 3: Retrieving Data from XML Documents 577Chapter 4: Using JSON with SQL 595Book 7: Database Tuning Overview 609Chapter 1: Tuning the Database 611Chapter 2: Tuning the Environment 623Chapter 3: Finding and Eliminating Bottlenecks 645Book 8: Appendices 675Appendix A: SQL: 2016 Reserved Words 677Appendix B: Glossary 683Index 691
Introduction. Book I: SQL Concepts. Chapter 1: Understanding Relational Databases. Chapter 2: Modeling a System. Chapter 3: Getting to Know SQL. Chapter 4: SQL and the Relational Model. Chapter 5: Knowing the Major Components of SQL. Chapter 6: Drilling Down to the SQL Nitty-Gritty. Book II: Relational Database Development. Chapter 1: System Development Overview. Chapter 2: Building a Database Model. Chapter 3: Balancing Performance and Correctness. Chapter 4: Creating a Database with SQL. Book III: SQL Queries. Chapter 1: Values Variables Functions and Expressions. Chapter 2: SELECT Statements and Modifying Clauses. Chapter 3: Querying Multiple Tables with Subqueries. Chapter 4: Querying Multiple Tables with Relational Operators. Chapter 5: Cursors. Book IV: Data Security. Chapter 1: Protecting Against Hardware Failure and External Threats. Chapter 2: Protecting Against User Errors and Conflicts. Chapter 3: Assigning Access Privileges. Chapter 4: Error Handling. Book V: SQL and Programming. Chapter 1: Database Development Environments. Chapter 2: Interfacing SQL to a Procedural Language. Chapter 3: Using SQL in an Application Program. Chapter 4: Designing a Sample Application. Chapter 5: Building an Application. Chapter 6: Understanding SQL's Procedural Capabilities. Chapter 7: Connecting SQL to a Remote Database. Book VI: SQL and XML. Chapter 1: Using XML with SQL. Chapter 2: Storing XML Data in SQL Tables. Chapter 3: Retrieving Data from XML Documents. Book VII: Database Tuning Overview. Chapter 1: Tuning the Database. Chapter 2: Tuning the Environment. Chapter 3: Finding and Eliminating Bottlenecks. Book VIII: Appendices. Appendix A: SQL:2008 Reserved Words. Appendix B: Glossary. Index.
Es gelten unsere Allgemeinen Geschäftsbedingungen: www.buecher.de/agb
Impressum
www.buecher.de ist ein Shop der buecher.de GmbH & Co. KG Bürgermeister-Wegele-Str. 12, 86167 Augsburg Amtsgericht Augsburg HRA 13309
