SQL all-in-one for dummies:
The most thorough SQL reference, now updated for SQL:2023 SQL All-in-One For Dummies has everything you need to get started with the SQL programming language, and then to level up your skill with advanced applications. This relational database coding language is one of the most used languages in pro...
Gespeichert in:
| Hauptverfasser: | , |
|---|---|
| Format: | Elektronisch E-Book |
| Sprache: | English |
| Veröffentlicht: |
Hoboken, New Jersey
Wiley
[2024]
|
| Ausgabe: | 4th edition |
| Schriftenreihe: | ... for dummies
|
| Schlagworte: | |
| Online-Zugang: | DE-1050 |
| Zusammenfassung: | The most thorough SQL reference, now updated for SQL:2023 SQL All-in-One For Dummies has everything you need to get started with the SQL programming language, and then to level up your skill with advanced applications. This relational database coding language is one of the most used languages in professional software development. And, as it becomes ever more important to take control of data, there's no end in sight to the need for SQL know-how. You can take your career to the next level with this guide to creating databases, accessing and editing data, protecting data from corruption, and integrating SQL with other languages in a programming environment. Become a SQL guru and turn the page on the next chapter of your coding career. Get 7 mini-books in one, covering basic SQL, database development, and advanced SQL concepts Read clear explanations of SQL code and learn to write complex queries Discover how to apply SQL in real-world situations to gain control over large datasets Enjoy a thorough reference to common tasks and issues in SQL developmentThis Dummies All-in-One guide is for all SQL users--from beginners to more experienced programmers. Find the info and the examples you need to reach the next stage in your SQL journey |
| Beschreibung: | 1 Online-Ressource (xxi, 775 Seiten) |
| ISBN: | 9781394242320 |
Internformat
MARC
| LEADER | 00000nmm a2200000 c 4500 | ||
|---|---|---|---|
| 001 | BV049908397 | ||
| 003 | DE-604 | ||
| 007 | cr|uuu---uuuuu | ||
| 008 | 241015s2024 |||| o||u| ||||||eng d | ||
| 020 | |a 9781394242320 |9 978-1-394-24232-0 | ||
| 035 | |a (DE-599)BVBBV049908397 | ||
| 040 | |a DE-604 |b ger |e rda | ||
| 041 | 0 | |a eng | |
| 049 | |a DE-1050 | ||
| 100 | 1 | |a Taylor, Allen G. |d 1945- |e Verfasser |0 (DE-588)113340699 |4 aut | |
| 245 | 1 | 0 | |a SQL all-in-one for dummies |c by Allen G. Taylor with Richard Blum |
| 250 | |a 4th edition | ||
| 264 | 1 | |a Hoboken, New Jersey |b Wiley |c [2024] | |
| 300 | |a 1 Online-Ressource (xxi, 775 Seiten) | ||
| 336 | |b txt |2 rdacontent | ||
| 337 | |b c |2 rdamedia | ||
| 338 | |b cr |2 rdacarrier | ||
| 490 | 0 | |a ... for dummies | |
| 505 | 8 | |a Intro -- Title Page -- Copyright Page -- Table of Contents -- Introduction -- About This Book -- Foolish Assumptions -- Icons Used in This Book -- Beyond the Book -- Where to Go from Here -- Book 1 Getting Started with SQL -- 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 -- Defining what makes a database relational -- Protecting the definition of relational databases with Codd's rules -- Highlighting the relational database model's inherent flexibility -- 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 -- Entities -- Attributes -- Identifiers -- Relationships -- Drawing Entity-Relationship diagrams -- Maximum cardinality -- Minimum cardinality -- Understanding advanced ER model concepts -- Strong entities and weak entities -- ID-dependent entities -- Supertype and subtype entities -- Incorporating business rules -- A simple example of an ER model -- A slightly more complex example -- Problems with complex relationships | |
| 505 | 8 | |a 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 -- Views -- Schemas -- Domains -- 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 -- Adding data the dull and boring way (typing it in) -- Adding incomplete records -- Adding data in the fastest and most efficient way: Bypassing typing altogether -- 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 -- INTEGER -- SMALLINT -- BIGINT -- NUMERIC -- DECIMAL -- DECFLOAT -- Approximate numerics -- REAL -- DOUBLE PRECISION -- FLOAT. | |
| 505 | 8 | |a Character strings -- CHARACTER -- CHARACTER VARYING -- CHARACTER LARGE OBJECT (CLOB) -- NATIONAL CHARACTER, NATIONAL CHARACTER VARYING, and NATIONAL CHARACTER LARGE OBJECT -- Binary strings -- BINARY -- BINARY VARYING -- BINARY LARGE OBJECT (BLOB) -- Booleans -- Datetimes -- DATE -- TIME WITHOUT TIME ZONE -- TIME WITH TIME ZONE -- TIMESTAMP WITHOUT TIME ZONE -- TIMESTAMP WITH TIME ZONE -- Intervals -- XML type -- ROW type -- Collection types -- ARRAY -- Multiset -- REF types -- JSON types -- User-defined types -- Distinct types -- Structured types -- Data type summary -- Handling Null Values -- Applying Constraints -- Column constraints -- NOT NULL -- UNIQUE -- CHECK -- Table constraints -- Foreign key constraints -- Assertions -- Book 2 Developing Relational Databases -- 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 -- The users' data model -- Statement of Requirements -- Evaluation phase -- Determining project scope -- Reassessing feasibility -- Documenting the Evaluation phase -- Design phase -- Designing the database -- The database application -- Documenting the Design phase -- Implementation phase -- Final Documentation and Testing phase -- Testing the system with sample data -- Finalizing the documentation -- Delivering the results (and celebrating) -- 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 | |
| 505 | 8 | |a 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 -- Point query -- Multipoint query -- Range query -- Prefix match query -- Extremal query -- Ordering query -- Grouping query -- Equi-join query -- 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 -- A typical query -- The execution plan -- 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 Writing 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 | |
| 505 | 8 | |a Variables vary -- Special variables hold specific values -- Working with Functions -- Summarizing data with set functions -- COUNT -- AVG -- MAX -- MIN -- SUM -- LISTAGG -- ANY_VALUE -- Dissecting data with value functions -- String value functions -- Numeric value functions -- Datetime value functions -- Polymorphic table functions -- Using Expressions -- Numeric value expressions -- String value expressions -- Datetime value expressions -- Interval value expressions -- Boolean value expressions -- Array value expressions -- Conditional value expressions -- Handling different cases -- The NULLIF special CASE -- Bypassing null values with COALESCE -- Converting data types with a CAST expression -- Casting one SQL data type to another -- Using CAST to overcome data type incompatibilities between SQL and its host language -- Row value expressions -- Chapter 2 SELECT Statements and Modifying Clauses -- Finding Needles in Haystacks withthe SELECT Statement -- Modifying Clauses -- FROM clauses -- WHERE clauses -- Comparison predicates -- BETWEEN -- IN and NOT IN -- LIKE and NOT LIKE -- NULL -- ALL, SOME, and ANY -- EXISTS -- UNIQUE -- DISTINCT -- OVERLAPS -- MATCH -- The MATCH predicate and referential integrity -- Logical connectives -- 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 retrieve rows satisfying a condition -- Subqueries that retrieve rows that don't satisfy a condition -- Subqueries that return a single value -- Quantified subqueries return a single value -- Correlated subqueries -- Using a subquery as an existence test | |
| 520 | |a The most thorough SQL reference, now updated for SQL:2023 SQL All-in-One For Dummies has everything you need to get started with the SQL programming language, and then to level up your skill with advanced applications. This relational database coding language is one of the most used languages in professional software development. And, as it becomes ever more important to take control of data, there's no end in sight to the need for SQL know-how. You can take your career to the next level with this guide to creating databases, accessing and editing data, protecting data from corruption, and integrating SQL with other languages in a programming environment. Become a SQL guru and turn the page on the next chapter of your coding career. Get 7 mini-books in one, covering basic SQL, database development, and advanced SQL concepts Read clear explanations of SQL code and learn to write complex queries Discover how to apply SQL in real-world situations to gain control over large datasets Enjoy a thorough reference to common tasks and issues in SQL developmentThis Dummies All-in-One guide is for all SQL users--from beginners to more experienced programmers. Find the info and the examples you need to reach the next stage in your SQL journey | ||
| 650 | 4 | |a SQL (Computer program language) | |
| 650 | 4 | |a Relational databases | |
| 650 | 4 | |a SQL (Langage de programmation) | |
| 650 | 4 | |a Bases de données relationnelles | |
| 700 | 1 | |a Blum, Richard |d 1962- |e Verfasser |0 (DE-588)14320713X |4 aut | |
| 776 | 0 | 8 | |i Erscheint auch als |n Online-Ausgabe |z 978-1-394-24231-3 |
| 776 | 0 | 8 | |i Erscheint auch als |n Druck-Ausgabe, pbk |z 978-1-394-24229-0 |
| 912 | |a ZDB-30-PQE | ||
| 943 | 1 | |a oai:aleph.bib-bvb.de:BVB01-035247214 | |
| 966 | e | |u https://ebookcentral.proquest.com/lib/th-deggendorf/detail.action?docID=31227197 |l DE-1050 |p ZDB-30-PQE |q FHD01_PQE_Kauf |x Aggregator |3 Volltext | |
Datensatz im Suchindex
| _version_ | 1812996402516590592 |
|---|---|
| adam_text | |
| any_adam_object | |
| author | Taylor, Allen G. 1945- Blum, Richard 1962- |
| author_GND | (DE-588)113340699 (DE-588)14320713X |
| author_facet | Taylor, Allen G. 1945- Blum, Richard 1962- |
| author_role | aut aut |
| author_sort | Taylor, Allen G. 1945- |
| author_variant | a g t ag agt r b rb |
| building | Verbundindex |
| bvnumber | BV049908397 |
| collection | ZDB-30-PQE |
| contents | Intro -- Title Page -- Copyright Page -- Table of Contents -- Introduction -- About This Book -- Foolish Assumptions -- Icons Used in This Book -- Beyond the Book -- Where to Go from Here -- Book 1 Getting Started with SQL -- 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 -- Defining what makes a database relational -- Protecting the definition of relational databases with Codd's rules -- Highlighting the relational database model's inherent flexibility -- 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 -- Entities -- Attributes -- Identifiers -- Relationships -- Drawing Entity-Relationship diagrams -- Maximum cardinality -- Minimum cardinality -- Understanding advanced ER model concepts -- Strong entities and weak entities -- ID-dependent entities -- Supertype and subtype entities -- Incorporating business rules -- 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 -- Views -- Schemas -- Domains -- 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 -- Adding data the dull and boring way (typing it in) -- Adding incomplete records -- Adding data in the fastest and most efficient way: Bypassing typing altogether -- 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 -- INTEGER -- SMALLINT -- BIGINT -- NUMERIC -- DECIMAL -- DECFLOAT -- Approximate numerics -- REAL -- DOUBLE PRECISION -- FLOAT. Character strings -- CHARACTER -- CHARACTER VARYING -- CHARACTER LARGE OBJECT (CLOB) -- NATIONAL CHARACTER, NATIONAL CHARACTER VARYING, and NATIONAL CHARACTER LARGE OBJECT -- Binary strings -- BINARY -- BINARY VARYING -- BINARY LARGE OBJECT (BLOB) -- Booleans -- Datetimes -- DATE -- TIME WITHOUT TIME ZONE -- TIME WITH TIME ZONE -- TIMESTAMP WITHOUT TIME ZONE -- TIMESTAMP WITH TIME ZONE -- Intervals -- XML type -- ROW type -- Collection types -- ARRAY -- Multiset -- REF types -- JSON types -- User-defined types -- Distinct types -- Structured types -- Data type summary -- Handling Null Values -- Applying Constraints -- Column constraints -- NOT NULL -- UNIQUE -- CHECK -- Table constraints -- Foreign key constraints -- Assertions -- Book 2 Developing Relational Databases -- 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 -- The users' data model -- Statement of Requirements -- Evaluation phase -- Determining project scope -- Reassessing feasibility -- Documenting the Evaluation phase -- Design phase -- Designing the database -- The database application -- Documenting the Design phase -- Implementation phase -- Final Documentation and Testing phase -- Testing the system with sample data -- Finalizing the documentation -- Delivering the results (and celebrating) -- 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 -- Point query -- Multipoint query -- Range query -- Prefix match query -- Extremal query -- Ordering query -- Grouping query -- Equi-join query -- 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 -- A typical query -- The execution plan -- 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 Writing 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 -- COUNT -- AVG -- MAX -- MIN -- SUM -- LISTAGG -- ANY_VALUE -- Dissecting data with value functions -- String value functions -- Numeric value functions -- Datetime value functions -- Polymorphic table functions -- Using Expressions -- Numeric value expressions -- String value expressions -- Datetime value expressions -- Interval value expressions -- Boolean value expressions -- Array value expressions -- Conditional value expressions -- Handling different cases -- The NULLIF special CASE -- Bypassing null values with COALESCE -- Converting data types with a CAST expression -- Casting one SQL data type to another -- Using CAST to overcome data type incompatibilities between SQL and its host language -- Row value expressions -- Chapter 2 SELECT Statements and Modifying Clauses -- Finding Needles in Haystacks withthe SELECT Statement -- Modifying Clauses -- FROM clauses -- WHERE clauses -- Comparison predicates -- BETWEEN -- IN and NOT IN -- LIKE and NOT LIKE -- NULL -- ALL, SOME, and ANY -- EXISTS -- UNIQUE -- DISTINCT -- OVERLAPS -- MATCH -- The MATCH predicate and referential integrity -- Logical connectives -- 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 retrieve rows satisfying a condition -- Subqueries that retrieve rows that don't satisfy a condition -- Subqueries that return a single value -- Quantified subqueries return a single value -- Correlated subqueries -- Using a subquery as an existence test |
| ctrlnum | (DE-599)BVBBV049908397 |
| edition | 4th edition |
| format | Electronic eBook |
| fullrecord | <?xml version="1.0" encoding="UTF-8"?><collection xmlns="http://www.loc.gov/MARC21/slim"><record><leader>00000nmm a2200000 c 4500</leader><controlfield tag="001">BV049908397</controlfield><controlfield tag="003">DE-604</controlfield><controlfield tag="007">cr|uuu---uuuuu</controlfield><controlfield tag="008">241015s2024 |||| o||u| ||||||eng d</controlfield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">9781394242320</subfield><subfield code="9">978-1-394-24232-0</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(DE-599)BVBBV049908397</subfield></datafield><datafield tag="040" ind1=" " ind2=" "><subfield code="a">DE-604</subfield><subfield code="b">ger</subfield><subfield code="e">rda</subfield></datafield><datafield tag="041" ind1="0" ind2=" "><subfield code="a">eng</subfield></datafield><datafield tag="049" ind1=" " ind2=" "><subfield code="a">DE-1050</subfield></datafield><datafield tag="100" ind1="1" ind2=" "><subfield code="a">Taylor, Allen G.</subfield><subfield code="d">1945-</subfield><subfield code="e">Verfasser</subfield><subfield code="0">(DE-588)113340699</subfield><subfield code="4">aut</subfield></datafield><datafield tag="245" ind1="1" ind2="0"><subfield code="a">SQL all-in-one for dummies</subfield><subfield code="c">by Allen G. Taylor with Richard Blum</subfield></datafield><datafield tag="250" ind1=" " ind2=" "><subfield code="a">4th edition</subfield></datafield><datafield tag="264" ind1=" " ind2="1"><subfield code="a">Hoboken, New Jersey</subfield><subfield code="b">Wiley</subfield><subfield code="c">[2024]</subfield></datafield><datafield tag="300" ind1=" " ind2=" "><subfield code="a">1 Online-Ressource (xxi, 775 Seiten)</subfield></datafield><datafield tag="336" ind1=" " ind2=" "><subfield code="b">txt</subfield><subfield code="2">rdacontent</subfield></datafield><datafield tag="337" ind1=" " ind2=" "><subfield code="b">c</subfield><subfield code="2">rdamedia</subfield></datafield><datafield tag="338" ind1=" " ind2=" "><subfield code="b">cr</subfield><subfield code="2">rdacarrier</subfield></datafield><datafield tag="490" ind1="0" ind2=" "><subfield code="a">... for dummies</subfield></datafield><datafield tag="505" ind1="8" ind2=" "><subfield code="a">Intro -- Title Page -- Copyright Page -- Table of Contents -- Introduction -- About This Book -- Foolish Assumptions -- Icons Used in This Book -- Beyond the Book -- Where to Go from Here -- Book 1 Getting Started with SQL -- 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 -- Defining what makes a database relational -- Protecting the definition of relational databases with Codd's rules -- Highlighting the relational database model's inherent flexibility -- 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 -- Entities -- Attributes -- Identifiers -- Relationships -- Drawing Entity-Relationship diagrams -- Maximum cardinality -- Minimum cardinality -- Understanding advanced ER model concepts -- Strong entities and weak entities -- ID-dependent entities -- Supertype and subtype entities -- Incorporating business rules -- A simple example of an ER model -- A slightly more complex example -- Problems with complex relationships</subfield></datafield><datafield tag="505" ind1="8" ind2=" "><subfield code="a">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 -- Views -- Schemas -- Domains -- 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 -- Adding data the dull and boring way (typing it in) -- Adding incomplete records -- Adding data in the fastest and most efficient way: Bypassing typing altogether -- 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 -- INTEGER -- SMALLINT -- BIGINT -- NUMERIC -- DECIMAL -- DECFLOAT -- Approximate numerics -- REAL -- DOUBLE PRECISION -- FLOAT.</subfield></datafield><datafield tag="505" ind1="8" ind2=" "><subfield code="a">Character strings -- CHARACTER -- CHARACTER VARYING -- CHARACTER LARGE OBJECT (CLOB) -- NATIONAL CHARACTER, NATIONAL CHARACTER VARYING, and NATIONAL CHARACTER LARGE OBJECT -- Binary strings -- BINARY -- BINARY VARYING -- BINARY LARGE OBJECT (BLOB) -- Booleans -- Datetimes -- DATE -- TIME WITHOUT TIME ZONE -- TIME WITH TIME ZONE -- TIMESTAMP WITHOUT TIME ZONE -- TIMESTAMP WITH TIME ZONE -- Intervals -- XML type -- ROW type -- Collection types -- ARRAY -- Multiset -- REF types -- JSON types -- User-defined types -- Distinct types -- Structured types -- Data type summary -- Handling Null Values -- Applying Constraints -- Column constraints -- NOT NULL -- UNIQUE -- CHECK -- Table constraints -- Foreign key constraints -- Assertions -- Book 2 Developing Relational Databases -- 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 -- The users' data model -- Statement of Requirements -- Evaluation phase -- Determining project scope -- Reassessing feasibility -- Documenting the Evaluation phase -- Design phase -- Designing the database -- The database application -- Documenting the Design phase -- Implementation phase -- Final Documentation and Testing phase -- Testing the system with sample data -- Finalizing the documentation -- Delivering the results (and celebrating) -- 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</subfield></datafield><datafield tag="505" ind1="8" ind2=" "><subfield code="a">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 -- Point query -- Multipoint query -- Range query -- Prefix match query -- Extremal query -- Ordering query -- Grouping query -- Equi-join query -- 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 -- A typical query -- The execution plan -- 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 Writing 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</subfield></datafield><datafield tag="505" ind1="8" ind2=" "><subfield code="a">Variables vary -- Special variables hold specific values -- Working with Functions -- Summarizing data with set functions -- COUNT -- AVG -- MAX -- MIN -- SUM -- LISTAGG -- ANY_VALUE -- Dissecting data with value functions -- String value functions -- Numeric value functions -- Datetime value functions -- Polymorphic table functions -- Using Expressions -- Numeric value expressions -- String value expressions -- Datetime value expressions -- Interval value expressions -- Boolean value expressions -- Array value expressions -- Conditional value expressions -- Handling different cases -- The NULLIF special CASE -- Bypassing null values with COALESCE -- Converting data types with a CAST expression -- Casting one SQL data type to another -- Using CAST to overcome data type incompatibilities between SQL and its host language -- Row value expressions -- Chapter 2 SELECT Statements and Modifying Clauses -- Finding Needles in Haystacks withthe SELECT Statement -- Modifying Clauses -- FROM clauses -- WHERE clauses -- Comparison predicates -- BETWEEN -- IN and NOT IN -- LIKE and NOT LIKE -- NULL -- ALL, SOME, and ANY -- EXISTS -- UNIQUE -- DISTINCT -- OVERLAPS -- MATCH -- The MATCH predicate and referential integrity -- Logical connectives -- 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 retrieve rows satisfying a condition -- Subqueries that retrieve rows that don't satisfy a condition -- Subqueries that return a single value -- Quantified subqueries return a single value -- Correlated subqueries -- Using a subquery as an existence test</subfield></datafield><datafield tag="520" ind1=" " ind2=" "><subfield code="a">The most thorough SQL reference, now updated for SQL:2023 SQL All-in-One For Dummies has everything you need to get started with the SQL programming language, and then to level up your skill with advanced applications. This relational database coding language is one of the most used languages in professional software development. And, as it becomes ever more important to take control of data, there's no end in sight to the need for SQL know-how. You can take your career to the next level with this guide to creating databases, accessing and editing data, protecting data from corruption, and integrating SQL with other languages in a programming environment. Become a SQL guru and turn the page on the next chapter of your coding career. Get 7 mini-books in one, covering basic SQL, database development, and advanced SQL concepts Read clear explanations of SQL code and learn to write complex queries Discover how to apply SQL in real-world situations to gain control over large datasets Enjoy a thorough reference to common tasks and issues in SQL developmentThis Dummies All-in-One guide is for all SQL users--from beginners to more experienced programmers. Find the info and the examples you need to reach the next stage in your SQL journey</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">SQL (Computer program language)</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">Relational databases</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">SQL (Langage de programmation)</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">Bases de données relationnelles</subfield></datafield><datafield tag="700" ind1="1" ind2=" "><subfield code="a">Blum, Richard</subfield><subfield code="d">1962-</subfield><subfield code="e">Verfasser</subfield><subfield code="0">(DE-588)14320713X</subfield><subfield code="4">aut</subfield></datafield><datafield tag="776" ind1="0" ind2="8"><subfield code="i">Erscheint auch als</subfield><subfield code="n">Online-Ausgabe</subfield><subfield code="z">978-1-394-24231-3</subfield></datafield><datafield tag="776" ind1="0" ind2="8"><subfield code="i">Erscheint auch als</subfield><subfield code="n">Druck-Ausgabe, pbk</subfield><subfield code="z">978-1-394-24229-0</subfield></datafield><datafield tag="912" ind1=" " ind2=" "><subfield code="a">ZDB-30-PQE</subfield></datafield><datafield tag="943" ind1="1" ind2=" "><subfield code="a">oai:aleph.bib-bvb.de:BVB01-035247214</subfield></datafield><datafield tag="966" ind1="e" ind2=" "><subfield code="u">https://ebookcentral.proquest.com/lib/th-deggendorf/detail.action?docID=31227197</subfield><subfield code="l">DE-1050</subfield><subfield code="p">ZDB-30-PQE</subfield><subfield code="q">FHD01_PQE_Kauf</subfield><subfield code="x">Aggregator</subfield><subfield code="3">Volltext</subfield></datafield></record></collection> |
| id | DE-604.BV049908397 |
| illustrated | Not Illustrated |
| indexdate | 2024-10-15T16:01:44Z |
| institution | BVB |
| isbn | 9781394242320 |
| language | English |
| oai_aleph_id | oai:aleph.bib-bvb.de:BVB01-035247214 |
| open_access_boolean | |
| owner | DE-1050 |
| owner_facet | DE-1050 |
| physical | 1 Online-Ressource (xxi, 775 Seiten) |
| psigel | ZDB-30-PQE ZDB-30-PQE FHD01_PQE_Kauf |
| publishDate | 2024 |
| publishDateSearch | 2024 |
| publishDateSort | 2024 |
| publisher | Wiley |
| record_format | marc |
| series2 | ... for dummies |
| spelling | Taylor, Allen G. 1945- Verfasser (DE-588)113340699 aut SQL all-in-one for dummies by Allen G. Taylor with Richard Blum 4th edition Hoboken, New Jersey Wiley [2024] 1 Online-Ressource (xxi, 775 Seiten) txt rdacontent c rdamedia cr rdacarrier ... for dummies Intro -- Title Page -- Copyright Page -- Table of Contents -- Introduction -- About This Book -- Foolish Assumptions -- Icons Used in This Book -- Beyond the Book -- Where to Go from Here -- Book 1 Getting Started with SQL -- 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 -- Defining what makes a database relational -- Protecting the definition of relational databases with Codd's rules -- Highlighting the relational database model's inherent flexibility -- 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 -- Entities -- Attributes -- Identifiers -- Relationships -- Drawing Entity-Relationship diagrams -- Maximum cardinality -- Minimum cardinality -- Understanding advanced ER model concepts -- Strong entities and weak entities -- ID-dependent entities -- Supertype and subtype entities -- Incorporating business rules -- 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 -- Views -- Schemas -- Domains -- 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 -- Adding data the dull and boring way (typing it in) -- Adding incomplete records -- Adding data in the fastest and most efficient way: Bypassing typing altogether -- 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 -- INTEGER -- SMALLINT -- BIGINT -- NUMERIC -- DECIMAL -- DECFLOAT -- Approximate numerics -- REAL -- DOUBLE PRECISION -- FLOAT. Character strings -- CHARACTER -- CHARACTER VARYING -- CHARACTER LARGE OBJECT (CLOB) -- NATIONAL CHARACTER, NATIONAL CHARACTER VARYING, and NATIONAL CHARACTER LARGE OBJECT -- Binary strings -- BINARY -- BINARY VARYING -- BINARY LARGE OBJECT (BLOB) -- Booleans -- Datetimes -- DATE -- TIME WITHOUT TIME ZONE -- TIME WITH TIME ZONE -- TIMESTAMP WITHOUT TIME ZONE -- TIMESTAMP WITH TIME ZONE -- Intervals -- XML type -- ROW type -- Collection types -- ARRAY -- Multiset -- REF types -- JSON types -- User-defined types -- Distinct types -- Structured types -- Data type summary -- Handling Null Values -- Applying Constraints -- Column constraints -- NOT NULL -- UNIQUE -- CHECK -- Table constraints -- Foreign key constraints -- Assertions -- Book 2 Developing Relational Databases -- 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 -- The users' data model -- Statement of Requirements -- Evaluation phase -- Determining project scope -- Reassessing feasibility -- Documenting the Evaluation phase -- Design phase -- Designing the database -- The database application -- Documenting the Design phase -- Implementation phase -- Final Documentation and Testing phase -- Testing the system with sample data -- Finalizing the documentation -- Delivering the results (and celebrating) -- 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 -- Point query -- Multipoint query -- Range query -- Prefix match query -- Extremal query -- Ordering query -- Grouping query -- Equi-join query -- 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 -- A typical query -- The execution plan -- 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 Writing 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 -- COUNT -- AVG -- MAX -- MIN -- SUM -- LISTAGG -- ANY_VALUE -- Dissecting data with value functions -- String value functions -- Numeric value functions -- Datetime value functions -- Polymorphic table functions -- Using Expressions -- Numeric value expressions -- String value expressions -- Datetime value expressions -- Interval value expressions -- Boolean value expressions -- Array value expressions -- Conditional value expressions -- Handling different cases -- The NULLIF special CASE -- Bypassing null values with COALESCE -- Converting data types with a CAST expression -- Casting one SQL data type to another -- Using CAST to overcome data type incompatibilities between SQL and its host language -- Row value expressions -- Chapter 2 SELECT Statements and Modifying Clauses -- Finding Needles in Haystacks withthe SELECT Statement -- Modifying Clauses -- FROM clauses -- WHERE clauses -- Comparison predicates -- BETWEEN -- IN and NOT IN -- LIKE and NOT LIKE -- NULL -- ALL, SOME, and ANY -- EXISTS -- UNIQUE -- DISTINCT -- OVERLAPS -- MATCH -- The MATCH predicate and referential integrity -- Logical connectives -- 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 retrieve rows satisfying a condition -- Subqueries that retrieve rows that don't satisfy a condition -- Subqueries that return a single value -- Quantified subqueries return a single value -- Correlated subqueries -- Using a subquery as an existence test The most thorough SQL reference, now updated for SQL:2023 SQL All-in-One For Dummies has everything you need to get started with the SQL programming language, and then to level up your skill with advanced applications. This relational database coding language is one of the most used languages in professional software development. And, as it becomes ever more important to take control of data, there's no end in sight to the need for SQL know-how. You can take your career to the next level with this guide to creating databases, accessing and editing data, protecting data from corruption, and integrating SQL with other languages in a programming environment. Become a SQL guru and turn the page on the next chapter of your coding career. Get 7 mini-books in one, covering basic SQL, database development, and advanced SQL concepts Read clear explanations of SQL code and learn to write complex queries Discover how to apply SQL in real-world situations to gain control over large datasets Enjoy a thorough reference to common tasks and issues in SQL developmentThis Dummies All-in-One guide is for all SQL users--from beginners to more experienced programmers. Find the info and the examples you need to reach the next stage in your SQL journey SQL (Computer program language) Relational databases SQL (Langage de programmation) Bases de données relationnelles Blum, Richard 1962- Verfasser (DE-588)14320713X aut Erscheint auch als Online-Ausgabe 978-1-394-24231-3 Erscheint auch als Druck-Ausgabe, pbk 978-1-394-24229-0 |
| spellingShingle | Taylor, Allen G. 1945- Blum, Richard 1962- SQL all-in-one for dummies Intro -- Title Page -- Copyright Page -- Table of Contents -- Introduction -- About This Book -- Foolish Assumptions -- Icons Used in This Book -- Beyond the Book -- Where to Go from Here -- Book 1 Getting Started with SQL -- 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 -- Defining what makes a database relational -- Protecting the definition of relational databases with Codd's rules -- Highlighting the relational database model's inherent flexibility -- 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 -- Entities -- Attributes -- Identifiers -- Relationships -- Drawing Entity-Relationship diagrams -- Maximum cardinality -- Minimum cardinality -- Understanding advanced ER model concepts -- Strong entities and weak entities -- ID-dependent entities -- Supertype and subtype entities -- Incorporating business rules -- 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 -- Views -- Schemas -- Domains -- 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 -- Adding data the dull and boring way (typing it in) -- Adding incomplete records -- Adding data in the fastest and most efficient way: Bypassing typing altogether -- 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 -- INTEGER -- SMALLINT -- BIGINT -- NUMERIC -- DECIMAL -- DECFLOAT -- Approximate numerics -- REAL -- DOUBLE PRECISION -- FLOAT. Character strings -- CHARACTER -- CHARACTER VARYING -- CHARACTER LARGE OBJECT (CLOB) -- NATIONAL CHARACTER, NATIONAL CHARACTER VARYING, and NATIONAL CHARACTER LARGE OBJECT -- Binary strings -- BINARY -- BINARY VARYING -- BINARY LARGE OBJECT (BLOB) -- Booleans -- Datetimes -- DATE -- TIME WITHOUT TIME ZONE -- TIME WITH TIME ZONE -- TIMESTAMP WITHOUT TIME ZONE -- TIMESTAMP WITH TIME ZONE -- Intervals -- XML type -- ROW type -- Collection types -- ARRAY -- Multiset -- REF types -- JSON types -- User-defined types -- Distinct types -- Structured types -- Data type summary -- Handling Null Values -- Applying Constraints -- Column constraints -- NOT NULL -- UNIQUE -- CHECK -- Table constraints -- Foreign key constraints -- Assertions -- Book 2 Developing Relational Databases -- 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 -- The users' data model -- Statement of Requirements -- Evaluation phase -- Determining project scope -- Reassessing feasibility -- Documenting the Evaluation phase -- Design phase -- Designing the database -- The database application -- Documenting the Design phase -- Implementation phase -- Final Documentation and Testing phase -- Testing the system with sample data -- Finalizing the documentation -- Delivering the results (and celebrating) -- 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 -- Point query -- Multipoint query -- Range query -- Prefix match query -- Extremal query -- Ordering query -- Grouping query -- Equi-join query -- 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 -- A typical query -- The execution plan -- 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 Writing 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 -- COUNT -- AVG -- MAX -- MIN -- SUM -- LISTAGG -- ANY_VALUE -- Dissecting data with value functions -- String value functions -- Numeric value functions -- Datetime value functions -- Polymorphic table functions -- Using Expressions -- Numeric value expressions -- String value expressions -- Datetime value expressions -- Interval value expressions -- Boolean value expressions -- Array value expressions -- Conditional value expressions -- Handling different cases -- The NULLIF special CASE -- Bypassing null values with COALESCE -- Converting data types with a CAST expression -- Casting one SQL data type to another -- Using CAST to overcome data type incompatibilities between SQL and its host language -- Row value expressions -- Chapter 2 SELECT Statements and Modifying Clauses -- Finding Needles in Haystacks withthe SELECT Statement -- Modifying Clauses -- FROM clauses -- WHERE clauses -- Comparison predicates -- BETWEEN -- IN and NOT IN -- LIKE and NOT LIKE -- NULL -- ALL, SOME, and ANY -- EXISTS -- UNIQUE -- DISTINCT -- OVERLAPS -- MATCH -- The MATCH predicate and referential integrity -- Logical connectives -- 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 retrieve rows satisfying a condition -- Subqueries that retrieve rows that don't satisfy a condition -- Subqueries that return a single value -- Quantified subqueries return a single value -- Correlated subqueries -- Using a subquery as an existence test SQL (Computer program language) Relational databases SQL (Langage de programmation) Bases de données relationnelles |
| title | SQL all-in-one for dummies |
| title_auth | SQL all-in-one for dummies |
| title_exact_search | SQL all-in-one for dummies |
| title_full | SQL all-in-one for dummies by Allen G. Taylor with Richard Blum |
| title_fullStr | SQL all-in-one for dummies by Allen G. Taylor with Richard Blum |
| title_full_unstemmed | SQL all-in-one for dummies by Allen G. Taylor with Richard Blum |
| title_short | SQL all-in-one for dummies |
| title_sort | sql all in one for dummies |
| topic | SQL (Computer program language) Relational databases SQL (Langage de programmation) Bases de données relationnelles |
| topic_facet | SQL (Computer program language) Relational databases SQL (Langage de programmation) Bases de données relationnelles |
| work_keys_str_mv | AT tayloralleng sqlallinonefordummies AT blumrichard sqlallinonefordummies |