SQL all-in-one for dummies

SQL all-in-one for dummies

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 explanation...

Descripción completa

Detalles Bibliográficos
Formato: Libro electrónico
Idioma:Inglés
Publicado: Hoboken, N.J.: John Wiley & Sons c2019.
Hoboken, New Jersey : 2019.
Edición:Third edition
Colección:--For dummies
Materias:
SQL (Computer program language)
Relational databases.
Ver en Biblioteca Universitat Ramon Llull:https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009630411306719
Tabla de Contenidos:
  • Intro
  • Title Page
  • Copyright Page
  • Table of Contents
  • Introduction
  • About This Book
  • Foolish Assumptions
  • Conventions Used in This Book
  • What You Don't Have to Read
  • How This Book Is Organized
  • Book 1: SQL Concepts
  • Book 2: Relational Database Development
  • Book 3: SQL Queries
  • Book 4: Data Security
  • Book 5: SQL and Programming
  • Book 6: SQL and XML
  • Book 7: Database Tuning Overview
  • Book 8: Appendices
  • Icons Used in This Book
  • Where to Go from Here
  • Book 1 SQL Concepts
  • Chapter 1 Understanding Relational Databases
  • Understanding Why Today's Databases Are Better than Early Databases
  • Irreducible complexity
  • Managing data with complicated programs
  • Managing data with simple programs
  • Which type of organization is better?
  • Databases, Queries, and Database Applications
  • Making data useful
  • Retrieving the data you want - and only the data you want
  • Examining Competing Database Models
  • Looking at the historical background of the competing models
  • The hierarchical database model
  • The network database model
  • The relational database model
  • The object-oriented database model
  • The object-relational database model
  • The nonrelational NoSQL model
  • Why the Relational Model Won
  • Chapter 2 Modeling a System
  • Capturing the Users' Data Model
  • Identifying and interviewing stakeholders
  • Reconciling conflicting requirements
  • Obtaining stakeholder buy-in
  • Translating the Users' Data Model to a Formal Entity-Relationship Model
  • Entity-Relationship modeling techniques
  • Drawing Entity-Relationship diagrams
  • Understanding advanced ER model concepts
  • A simple example of an ER model
  • A slightly more complex example
  • Problems with complex relationships
  • Simplifying relationships using normalization
  • Translating an ER model into a relational model.
  • Chapter 3 Getting to Know SQL
  • Where SQL Came From
  • Knowing What SQL Does
  • The ISO/IEC SQL Standard
  • Knowing What SQL Does Not Do
  • Choosing and Using an Available DBMS Implementation
  • Microsoft Access
  • Microsoft SQL Server
  • IBM DB2
  • Oracle Database
  • Sybase SQL Anywhere
  • MySQL
  • PostgreSQL
  • Chapter 4 SQL and the Relational Model
  • Sets, Relations, Multisets, and Tables
  • Functional Dependencies
  • Keys
  • Views
  • Users
  • Privileges
  • Schemas
  • Catalogs
  • Connections, Sessions, and Transactions
  • Routines
  • Paths
  • Chapter 5 Knowing the Major Components of SQL
  • Creating a Database with the Data Definition Language
  • The containment hierarchy
  • Creating tables
  • Specifying columns
  • Creating other objects
  • Modifying tables
  • Removing tables and other objects
  • Operating on Data with the Data Manipulation Language (DML)
  • Retrieving data from a database
  • Adding data to a table
  • Updating data in a table
  • Deleting data from a table
  • Updating views doesn't make sense
  • Maintaining Security in the Data Control Language (DCL)
  • Granting access privileges
  • Revoking access privileges
  • Preserving database integrity with transactions
  • Chapter 6 Drilling Down to the SQL Nitty-Gritty
  • Executing SQL Statements
  • Interactive SQL
  • Challenges to combining SQL with a host language
  • Embedded SQL
  • Module language
  • Using Reserved Words Correctly
  • SQL's Data Types
  • Exact numerics
  • Approximate numerics
  • Character strings
  • Binary strings
  • Booleans
  • Datetimes
  • Intervals
  • XML type
  • ROW type
  • Collection types
  • REF types
  • User-defined types
  • Data type summary
  • Handling Null Values
  • Applying Constraints
  • Column constraints
  • Table constraints
  • Foreign key constraints
  • Assertions
  • Book 2 Relational Database Development
  • Chapter 1 System Development Overview.
  • The Components of a Database System
  • The database
  • The database engine
  • The DBMS front end
  • The database application
  • The user
  • The System Development Life Cycle
  • Definition phase
  • Requirements phase
  • Evaluation phase
  • Design phase
  • Implementation phase
  • Final Documentation and Testing phase
  • Maintenance phase
  • Chapter 2 Building a Database Model
  • Finding and Listening to Interested Parties
  • Your immediate supervisor
  • The users
  • The standards organization
  • Upper management
  • Building Consensus
  • Gauging what people want
  • Arriving at a consensus
  • Building a Relational Model
  • Reviewing the three database traditions
  • Knowing what a relation is
  • Functional dependencies
  • Keys
  • Being Aware of the Danger of Anomalies
  • Eliminating anomalies
  • Examining the higher normal forms
  • The Database Integrity versus Performance Tradeoff
  • Chapter 3 Balancing Performance and Correctness
  • Designing a Sample Database
  • The ER model for Honest Abe's
  • Converting an ER model into a relational model
  • Normalizing a relational model
  • Handling binary relationships
  • A sample conversion
  • Maintaining Integrity
  • Entity integrity
  • Domain integrity
  • Referential integrity
  • Avoiding Data Corruption
  • Speeding Data Retrievals
  • Hierarchical storage
  • Full table scans
  • Working with Indexes
  • Creating the right indexes
  • Indexes and the ANSI/ISO standard
  • Index costs
  • Query type dictates the best index
  • Data structures used for indexes
  • Indexes, sparse and dense
  • Index clustering
  • Composite indexes
  • Index effect on join performance
  • Table size as an indexing consideration
  • Indexes versus full table scans
  • Reading SQL Server Execution Plans
  • Robust execution plans
  • A sample database
  • Chapter 4 Creating a Database with SQL
  • First Things First: Planning Your Database.
  • Building Tables
  • Locating table rows with keys
  • Using the CREATE TABLE statement
  • Setting Constraints
  • Column constraints
  • Table constraints
  • Keys and Indexes
  • Ensuring Data Validity with Domains
  • Establishing Relationships between Tables
  • Altering Table Structure
  • Deleting Tables
  • Book 3 SQL Queries
  • Chapter 1 Values, Variables, Functions, and Expressions
  • Entering Data Values
  • Row values have multiple parts
  • Identifying values in a column
  • Literal values don't change
  • Variables vary
  • Special variables hold specific values
  • Working with Functions
  • Summarizing data with set functions
  • Dissecting data with value functions
  • Using Expressions
  • Numeric value expressions
  • String value expressions
  • Datetime value expressions
  • Interval value expressions
  • Boolean value expressions
  • Array value expressions
  • Conditional value expressions
  • Converting data types with a CAST expression
  • Row value expressions
  • Chapter 2 SELECT Statements and Modifying Clauses
  • Finding Needles in Haystacks with the SELECT Statement
  • Modifying Clauses
  • FROM clauses
  • WHERE clauses
  • GROUP BY clauses
  • HAVING clauses
  • ORDER BY clauses
  • Tuning Queries
  • SELECT DISTINCT
  • Temporary tables
  • The ORDER BY clause
  • The HAVING clause
  • The OR logical connective
  • Chapter 3 Querying Multiple Tables with Subqueries
  • What Is a Subquery?
  • What Subqueries Do
  • Subqueries that return multiple values
  • Subqueries that return a single value
  • Quantified subqueries return a single value
  • Correlated subqueries
  • Using Subqueries in INSERT, DELETE, and UPDATE Statements
  • Tuning Considerations for Statements Containing Nested Queries
  • Tuning Correlated Subqueries
  • Chapter 4 Querying Multiple Tables with Relational Operators
  • UNION
  • UNION ALL
  • UNION CORRESPONDING
  • INTERSECT
  • EXCEPT
  • JOINS.
  • Cartesian product or cross join
  • Equi-join
  • Natural join
  • Condition join
  • Column-name join
  • Inner join
  • Outer join
  • ON versus WHERE
  • Join Conditions and Clustering Indexes
  • Chapter 5 Cursors
  • Declaring a Cursor
  • The query expression
  • Ordering the query result set
  • Updating table rows
  • Sensitive versus insensitive cursors
  • Scrolling a cursor
  • Holding a cursor
  • Declaring a result set cursor
  • Opening a Cursor
  • Operating on a Single Row
  • FETCH syntax
  • Absolute versus relative fetches
  • Deleting a row
  • Updating a row
  • Closing a Cursor
  • Book 4 Data Security
  • Chapter 1 Protecting Against Hardware Failure and External Threats
  • What Could Possibly Go Wrong?
  • Equipment failure
  • Platform instability
  • Database design flaws
  • Data-entry errors
  • Operator error
  • Taking Advantage of RAID
  • Striping
  • RAID levels
  • Backing Up Your System
  • Preparation for the worst
  • Full or incremental backup
  • Frequency
  • Backup maintenance
  • Coping with Internet Threats
  • Viruses
  • Trojan horses
  • Worms
  • Denial-of-service attacks
  • SQL injection attacks
  • Phishing scams
  • Zombie spambots
  • Installing Layers of Protection
  • Network-layer firewalls
  • Application-layer firewalls
  • Antivirus software
  • Vulnerabilities, exploits, and patches
  • Education
  • Alertness
  • Chapter 2 Protecting Against User Errors and Conflicts
  • Reducing Data-Entry Errors
  • Data types: The first line of defense
  • Constraints: The second line of defense
  • Sharp-eyed humans: The third line of defense
  • Coping with Errors in Database Design
  • Handling Programming Errors
  • Solving Concurrent-Operation Conflicts
  • Passing the ACID Test: Atomicity, Consistency, Isolation, and Durability
  • Operating with Transactions
  • Using the SET TRANSACTION statement
  • Starting a transaction
  • Committing a transaction.
  • Rolling back a transaction.

Ejemplares similares