Hello Reader
Books in your Cart

SQL All - In - One For Dummies, 3ed

SQL All - In - One For Dummies, 3ed
-15 %
SQL All - In - One For Dummies, 3ed
Product Views: 27
  • Sold by Wiley India
  • Seller Rating:    0 Reviews
  • Contact Seller
  • ₹764
    M.R.P.:
    ₹899
    Inclusive of all taxes
    Reward Points: 1898
    SQL is the international standard language for creating and maintaining relational databases. This book is a compendium of information about SQL and relational database design, development, and maintenance. The eight mini-books cover the full spectrum of issues that arise in building, using, and maintaining relational database systems.  Allen G. Taylor is a 30-year veteran of the computer industry and the author of over 20 books, including SQL For Dummies 9th Edition. He frequently lectures nationally on databases, innovation, and entrepreneurship. As well as, teaches database development internationally through a leading online education provider. He teaches computer architecture locally at Portland State University and via distance learning at the International Institute for Information..

    Book Details

    Pustak Details
    Sold By Wiley India
    Author Allen G. Taylor
    ISBN-13 9788126534494
    Edition 1st Edition
    Format Paperback
    Language English
    Pages 776 Pages
    Publication Year 2019

    Reviews

    Ask for Review

    Write a book review

    Book Description

    SQL is the international standard language for creating and maintaining relational databases. This book is a compendium of information about SQL and relational database design, development, and maintenance. The eight mini-books cover the full spectrum of issues that arise in building, using, and maintaining relational database systems.  Allen G. Taylor is a 30-year veteran of the computer industry and the author of over 20 books, including SQL For Dummies 9th Edition. He frequently lectures nationally on databases, innovation, and entrepreneurship. As well as, teaches database development internationally through a leading online education provider. He teaches computer architecture locally at Portland State University and via distance learning at the International Institute for Information Science and Technology in Shanghai, China Introduction _x000D_ About This Book _x000D_ Foolish Assumptions _x000D_ Conventions Used in This Book _x000D_ What You Don't Have to Read _x000D_ How This Book is Organized _x000D_ Book 1: SQL Concepts _x000D_ Book 2: Relational Database Development _x000D_ Book 3: SQL Queries _x000D_ Book 4: Data Security _x000D_ Book 5: SQL and Programming _x000D_ Book 6: SQL and XML _x000D_ Book 7: Database Tuning Overview _x000D_ Book 8: Appendices _x000D_ Icons Used in This Book _x000D_ Where to Go from Here _x000D_ _x000D_ Book 1: SQL Concepts _x000D_ Chapter 1: Understanding Relational Databases _x000D_ ·Understanding Why Today's Databases are Better than Early Databases _x000D_ ·Databases, Queries, and Database Applications _x000D_ ·Examining Competing Database Models _x000D_ ·Why the Relational Model Won _x000D_ _x000D_ Chapter 2: Modeling a System _x000D_ ·Capturing the Users' Data Model _x000D_ ·Translating the Users' Data Model to a Formal Entity-Relationship Model _x000D_ ·Entity-Relationship modeling techniques _x000D_ _x000D_ Chapter 3: Getting to Know SQL _x000D_ ·Where SQL Came From _x000D_ ·Knowing What SQL Does _x000D_ ·The ISO/IEC SQL Standard _x000D_ ·Knowing What SQL Does Not Do _x000D_ ·Choosing and Using an Available DBMS Implementation _x000D_ _x000D_ Chapter 4: SQL and the Relational Model _x000D_ ·Sets, Relations, Multisets, and Tables _x000D_ ·Functional Dependencies _x000D_ ·Keys _x000D_ ·Views _x000D_ ·Users _x000D_ ·Privileges _x000D_ ·Schemas _x000D_ ·Catalogs _x000D_ ·Connections, Sessions, and Transactions _x000D_ ·Routines _x000D_ ·Paths _x000D_ _x000D_ Chapter 5: Knowing the Major Components of SQL _x000D_ ·Creating a Database with the Data Definition Language _x000D_ ·Operating on Data with the Data Manipulation Language (DML) _x000D_ ·Maintaining Security in the Data Control Language (DCL) _x000D_ _x000D_ Chapter 6: Drilling Down to the SQL Nitty-Gritty _x000D_ ·Executing SQL Statements _x000D_ ·Module language _x000D_ ·Using Reserved Words Correctly _x000D_ ·SQL's Data Types _x000D_ ·Handling Null Values _x000D_ ·Applying Constraints _x000D_ _x000D_ Book 2: Relational Database Development _x000D_ Chapter 1: System Development Overview _x000D_ ·The Components of a Database System _x000D_ ·The System Development Life Cycle _x000D_ _x000D_ Chapter 2: Building a Database Model _x000D_ ·Finding and Listening to Interested Parties _x000D_ ·Building Consensus _x000D_ ·Building a Relational Model _x000D_ ·Being Aware of the Danger of Anomalies _x000D_ ·The Database Integrity versus Performance Tradeoff _x000D_ _x000D_ Chapter 3: Balancing Performance and Correctness _x000D_ ·Designing a Sample Database _x000D_ ·Maintaining Integrity _x000D_ ·Avoiding Data Corruption _x000D_ ·Speeding Data Retrievals _x000D_ ·Working with Indexes _x000D_ ·Reading SQL Server Execution Plans _x000D_ _x000D_ Chapter 4: Creating a Database with SQL _x000D_ ·First Things First: Planning Your Database _x000D_ ·Building Tables _x000D_ ·Setting Constraints _x000D_ ·Keys and Indexes _x000D_ ·Ensuring Data Validity with Domains _x000D_ ·Establishing Relationships between Tables _x000D_ ·Altering Table Structure _x000D_ ·Deleting Tables _x000D_ _x000D_ Book 3: SQL Queries _x000D_ Chapter 1: Values, Variables, Functions, and Expressions _x000D_ ·Entering Data Values _x000D_ ·Working with Functions _x000D_ ·Using Expressions _x000D_ _x000D_ Chapter 2: SELECT Statements and Modifying Clauses _x000D_ ·Finding Needles in Haystacks with the SELECT Statement _x000D_ ·Modifying Clauses _x000D_ ·Tuning Queries _x000D_ _x000D_ Chapter 3: Querying Multiple Tables with Subqueries _x000D_ ·What is a Subquery? _x000D_ ·What Subqueries Do _x000D_ ·Using Subqueries in INSERT, DELETE, and UPDATE Statements _x000D_ ·Tuning Considerations for Statements Containing Nested Queries _x000D_ ·Tuning Correlated Subqueries _x000D_ _x000D_ Chapter 4: Querying Multiple Tables with Relational Operators _x000D_ ·UNION _x000D_ ·INTERSECT _x000D_ ·EXCEPT _x000D_ ·JOINS _x000D_ ·ON versus WHERE _x000D_ ·Join Conditions and Clustering Indexes _x000D_ _x000D_ Chapter 5: Cursors _x000D_ ·Declaring a Cursor _x000D_ ·Opening a Cursor _x000D_ ·Operating on a Single Row _x000D_ ·Closing a Cursor _x000D_ _x000D_ Book 4: Data Security _x000D_ Chapter 1: Protecting Against Hardware Failure and External Threats _x000D_ ·What Could Possibly Go Wrong? _x000D_ ·Taking Advantage of RAID _x000D_ ·Backing Up Your System _x000D_ ·Coping with Internet Threats _x000D_ ·Installing Layers of Protection _x000D_ _x000D_ Chapter 2: Protecting Against User Errors and Conflicts _x000D_ ·Reducing Data-Entry Errors _x000D_ ·Coping with Errors in Database Design _x000D_ ·Handling Programming Errors _x000D_ ·Solving Concurrent-Operation Conflicts _x000D_ ·Passing the ACID Test: Atomicity, Consistency, Isolation, and Durability _x000D_ ·Operating with Transactions _x000D_ ·Getting Familiar with Locking _x000D_ ·Tuning Locks _x000D_ ·Enforcing Serializability with Timestamps _x000D_ ·Tuning the Recovery System _x000D_ _x000D_ Chapter 3: Assigning Access Privileges _x000D_ ·Working with the SQL Data Control Language _x000D_ ·Identifying Authorized Users _x000D_ ·Classifying Users _x000D_ ·Granting Privileges _x000D_ ·Revoking Privileges _x000D_ ·Granting Roles _x000D_ ·Revoking Roles _x000D_ _x000D_ Chapter 4: Error Handling _x000D_ ·Identifying Error Conditions _x000D_ ·Getting to Know SQLSTATE _x000D_ ·Handling Conditions _x000D_ ·Dealing with Execution Exceptions: The WHENEVER Clause _x000D_ ·Getting More Information: The Diagnostics Area _x000D_ ·Examining an Example Constraint Violation _x000D_ ·Adding Constraints to an Existing Table _x000D_ ·Interpreting SQLSTATE Information _x000D_ ·Handling Exceptions _x000D_ _x000D_ Book 5: SQL and Programming _x000D_ Chapter 1: Database Development Environments _x000D_ ·Microsoft Access _x000D_ ·Microsoft SQL Server _x000D_ ·IBM Db2 _x000D_ ·Oracle 18c _x000D_ ·SQL Anywhere _x000D_ ·PostgreSQL _x000D_ ·MySQL _x000D_ _x000D_ Chapter 2: Interfacing SQL to a Procedural Language _x000D_ ·Building an Application with SQL and a Procedural Language _x000D_ _x000D_ Chapter 3: Using SQL in an Application Program _x000D_ ·Comparing SQL with Procedural Languages _x000D_ ·Difficulties in Combining SQL with a Procedural Language _x000D_ ·Embedding SQL in an Application _x000D_ ·Using SQL Modules with an Application _x000D_ _x000D_ Chapter 4: Designing a Sample Application _x000D_ ·Understanding the Client's Problem _x000D_ ·Approaching the Problem _x000D_ ·Determining the Deliverables _x000D_ ·Building an Entity-Relationship Model _x000D_ ·Transforming the Model _x000D_ ·Creating Tables _x000D_ ·Changing Table Structure _x000D_ ·Removing Tables _x000D_ ·Designing the User Interface _x000D_ _x000D_ Chapter 5: Building an Application _x000D_ ·Designing from the Top Down _x000D_ ·Coding from the Bottom Up _x000D_ ·Testing, Testing, Testing _x000D_ _x000D_ Chapter 6: Understanding SQL's Procedural Capabilities _x000D_ ·Embedding SQL Statements in Your Code _x000D_ ·Introducing Compound Statements _x000D_ ·Following the Flow of Control Statements _x000D_ ·Using Stored Procedures _x000D_ ·Working with Triggers _x000D_ ·Using Stored Functions _x000D_ ·Passing Out Privileges _x000D_ ·Using Stored Modules _x000D_ _x000D_ Chapter 7: Connecting SQL to a Remote Database _x000D_ ·Native Drivers _x000D_ ·ODBC and Its Major Components _x000D_ ·What Happens When the Application Makes a Request _x000D_ _x000D_ Book 6: SQL, XML, AND JSON _x000D_ Chapter 1: Using XML with SQL _x000D_ ·Introducing XML _x000D_ ·Knowing the Parts of an XML Document _x000D_ ·Using XML Schema _x000D_ ·Relating SQL to XML _x000D_ ·Using the XML Data Type _x000D_ ·Mapping SQL to XML _x000D_ ·Operating on XML Data with SQL Functions _x000D_ ·Working with XML Predicates _x000D_ _x000D_ Chapter 2: Storing XML Data in SQL Tables _x000D_ ·Inserting XML Data into an SQL Pseudotable _x000D_ ·Creating a Table to Hold XML Data _x000D_ ·Updating XML Documents _x000D_ ·Discovering Oracle's Tools for Updating XML Data in a Table _x000D_ ·Introducing Microsoft's Tools for Updating XML Data in a Table _x000D_ _x000D_ Chapter 3: Retrieving Data from XML Documents _x000D_ ·XQuery _x000D_ ·FLWOR Expressions _x000D_ ·XQuery versus SQL _x000D_ _x000D_ Chapter 4: Using JSON with SQL _x000D_ ·Using JSON with SQL _x000D_ ·The SQL/JSON Data Model _x000D_ ·SQL/JSON Functions _x000D_ ·SQL/JSON Path Language _x000D_ _x000D_ Book 7: Database Tuning Overview _x000D_ Chapter 1: Tuning the Database _x000D_ ·Analyzing the Workload _x000D_ ·Considering the Physical Design _x000D_ ·Choosing the Right Indexes _x000D_ ·Tuning Indexes _x000D_ ·Tuning Queries _x000D_ ·Tuning Transactions _x000D_ ·Separating User Interactions from Transactions _x000D_ ·Minimizing Traffic between Application and Server _x000D_ ·Precompiling Frequently Used Queries _x000D_ _x000D_ Chapter 2: Tuning the Environment _x000D_ ·Surviving Failures with Minimum Data Loss _x000D_ ·Tuning the Recovery System _x000D_ ·Tuning the Operating System _x000D_ ·Maximizing the Hardware You Have _x000D_ ·Adding Hardware _x000D_ ·Working in Multiprocessor Environments _x000D_ _x000D_ Chapter 3: Finding and Eliminating Bottlenecks _x000D_ ·Pinpointing the Problem _x000D_ ·Determining the Possible Causes of Trouble _x000D_ ·Implementing General Principles: A First Step Toward Improving Performance _x000D_ ·Tracking Down Bottlenecks _x000D_ ·Analyzing Query Efficiency _x000D_ ·Managing Resources Wisely _x000D_ _x000D_ Book 8: Appendices _x000D_ Appendix A: SQL: 2016 Reserved Words _x000D_ Appendix B: Glossary _x000D_ Index

    Seller Featured Products