Database design and modeling with PostgreSQL and MySQL: build efficient and scalable databases for modern applications using open source databases
Gespeichert in:
| Hauptverfasser: | , |
|---|---|
| Format: | Elektronisch E-Book |
| Sprache: | English |
| Veröffentlicht: |
Birmingham, UK
Packt Publishing
June 2024
|
| Ausgabe: | 1st edition |
| Online-Zugang: | DE-1050 |
| Beschreibung: | 1 Online-Ressource (xviii, 203 Seiten) |
| ISBN: | 9781803240961 |
Internformat
MARC
| LEADER | 00000nmm a2200000 c 4500 | ||
|---|---|---|---|
| 001 | BV049773805 | ||
| 003 | DE-604 | ||
| 007 | cr|uuu---uuuuu | ||
| 008 | 240709s2024 |||| o||u| ||||||eng d | ||
| 020 | |a 9781803240961 |9 978-1-80324-096-1 | ||
| 035 | |a (OCoLC)1446263422 | ||
| 035 | |a (DE-599)BVBBV049773805 | ||
| 040 | |a DE-604 |b ger |e rda | ||
| 041 | 0 | |a eng | |
| 049 | |a DE-1050 | ||
| 100 | 1 | |a Tezuysal, Alkin |e Verfasser |4 aut | |
| 245 | 1 | 0 | |a Database design and modeling with PostgreSQL and MySQL |b build efficient and scalable databases for modern applications using open source databases |c Alkin Tezuysal, Ibrar Ahmed |
| 250 | |a 1st edition | ||
| 264 | 1 | |a Birmingham, UK |b Packt Publishing |c June 2024 | |
| 300 | |a 1 Online-Ressource (xviii, 203 Seiten) | ||
| 336 | |b txt |2 rdacontent | ||
| 337 | |b c |2 rdamedia | ||
| 338 | |b cr |2 rdacarrier | ||
| 505 | 8 | |a Cover -- Copyright -- Foreword -- Contributors -- Table of Contents -- Preface -- Part 1: Introduction to Databases -- Chapter 1: SQL and NoSQL Databases: Characteristics, Design, and Trade-Offs -- Understanding databases and data models -- Exploring the relational data model (SQL databases) -- Tables, rows, and columns -- Normalization -- Structured Query Language (SQL) -- ACID transactions -- Navigating the document data model (NoSQL databases) -- Data models in NoSQL -- Types of NoSQL databases -- Key-value stores -- Document stores -- Column-family stores -- Graph databases | |
| 505 | 8 | |a Applying the CAP theorem and NoSQL design choices -- Consistency -- Availability -- Partition tolerance -- Consistency models in NoSQL databases -- NoSQL design choices and use cases -- Managing transaction management and concurrency control in NoSQL -- BASE transactions in NoSQL databases -- Reasons for the BASE model in NoSQL databases -- Implications for data integrity and concurrency control -- Analyzing the advantages and disadvantages of NoSQL databases -- Advantages of NoSQL databases -- Disadvantages of NoSQL databases -- Summary | |
| 505 | 8 | |a Chapter 2: Building a Strong Foundation for Database Design -- The importance of a solid foundation in database design -- Key terms and data models -- Understanding the relational model in detail -- Identifying entities, attributes, and relationships in database design -- Creating an ER diagram -- Advanced database design -- Normalization -- reducing redundancy and improving data integrity -- Achieving normal forms -- 1NF, 2NF, and 3NF -- Ensuring database validity and integrity -- Concluding thoughts -- Summary -- Part 2: Practical Implementation | |
| 505 | 8 | |a Chapter 3: Getting Your Hands Dirty with PostgreSQL and MySQL -- Understanding the sample database -- EDA and preprocessing -- Database schema -- MySQL -- Concluding thoughts -- Summary -- Part 3: Core Concepts in Database Design -- Chapter 4: Mastering the Building Blocks of Database Design and Modeling -- Understanding database objects -- Understanding data types and constraints -- Keys and how to use them -- Database checks and constraints -- Check constraint -- Default constraint -- Not null constraint -- Checking data quality with constraints -- No date in the future | |
| 505 | 8 | |a Value within a specific range -- How to avoid redundancy -- Database consistency and beyond -- Transactions -- ensuring data integrity -- Concurrency control -- managing multiple users -- PostgreSQL -- MySQL -- Summary -- Part 4: Advanced Database Techniques -- Chapter 5: Advanced Techniques for Advanced Databases -- Creating custom views of your data -- Understanding the purpose of views -- The advantages of using views in database management -- Indexing -- how to find data faster -- Understanding indexing -- Types of indexes -- How indexing works -- PostgreSQL indexes -- MySQL indexes | |
| 505 | 8 | |a Stored procedures -- reusable code for your database | |
| 700 | 1 | |a Ahmed, Ibrar |e Verfasser |0 (DE-588)1170927831 |4 aut | |
| 776 | 0 | 8 | |i Erscheint auch als |n Druck-Ausgabe |z 978-1-80323-347-5 |
| 912 | |a ZDB-30-PQE | ||
| 943 | 1 | |a oai:aleph.bib-bvb.de:BVB01-035114930 | |
| 966 | e | |u https://ebookcentral.proquest.com/lib/th-deggendorf/detail.action?docID=31516395 |l DE-1050 |p ZDB-30-PQE |q FHD01_PQE_Kauf |x Aggregator |3 Volltext | |
Datensatz im Suchindex
| _version_ | 1806142620832890880 |
|---|---|
| adam_text | |
| any_adam_object | |
| author | Tezuysal, Alkin Ahmed, Ibrar |
| author_GND | (DE-588)1170927831 |
| author_facet | Tezuysal, Alkin Ahmed, Ibrar |
| author_role | aut aut |
| author_sort | Tezuysal, Alkin |
| author_variant | a t at i a ia |
| building | Verbundindex |
| bvnumber | BV049773805 |
| collection | ZDB-30-PQE |
| contents | Cover -- Copyright -- Foreword -- Contributors -- Table of Contents -- Preface -- Part 1: Introduction to Databases -- Chapter 1: SQL and NoSQL Databases: Characteristics, Design, and Trade-Offs -- Understanding databases and data models -- Exploring the relational data model (SQL databases) -- Tables, rows, and columns -- Normalization -- Structured Query Language (SQL) -- ACID transactions -- Navigating the document data model (NoSQL databases) -- Data models in NoSQL -- Types of NoSQL databases -- Key-value stores -- Document stores -- Column-family stores -- Graph databases Applying the CAP theorem and NoSQL design choices -- Consistency -- Availability -- Partition tolerance -- Consistency models in NoSQL databases -- NoSQL design choices and use cases -- Managing transaction management and concurrency control in NoSQL -- BASE transactions in NoSQL databases -- Reasons for the BASE model in NoSQL databases -- Implications for data integrity and concurrency control -- Analyzing the advantages and disadvantages of NoSQL databases -- Advantages of NoSQL databases -- Disadvantages of NoSQL databases -- Summary Chapter 2: Building a Strong Foundation for Database Design -- The importance of a solid foundation in database design -- Key terms and data models -- Understanding the relational model in detail -- Identifying entities, attributes, and relationships in database design -- Creating an ER diagram -- Advanced database design -- Normalization -- reducing redundancy and improving data integrity -- Achieving normal forms -- 1NF, 2NF, and 3NF -- Ensuring database validity and integrity -- Concluding thoughts -- Summary -- Part 2: Practical Implementation Chapter 3: Getting Your Hands Dirty with PostgreSQL and MySQL -- Understanding the sample database -- EDA and preprocessing -- Database schema -- MySQL -- Concluding thoughts -- Summary -- Part 3: Core Concepts in Database Design -- Chapter 4: Mastering the Building Blocks of Database Design and Modeling -- Understanding database objects -- Understanding data types and constraints -- Keys and how to use them -- Database checks and constraints -- Check constraint -- Default constraint -- Not null constraint -- Checking data quality with constraints -- No date in the future Value within a specific range -- How to avoid redundancy -- Database consistency and beyond -- Transactions -- ensuring data integrity -- Concurrency control -- managing multiple users -- PostgreSQL -- MySQL -- Summary -- Part 4: Advanced Database Techniques -- Chapter 5: Advanced Techniques for Advanced Databases -- Creating custom views of your data -- Understanding the purpose of views -- The advantages of using views in database management -- Indexing -- how to find data faster -- Understanding indexing -- Types of indexes -- How indexing works -- PostgreSQL indexes -- MySQL indexes Stored procedures -- reusable code for your database |
| ctrlnum | (OCoLC)1446263422 (DE-599)BVBBV049773805 |
| edition | 1st 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">BV049773805</controlfield><controlfield tag="003">DE-604</controlfield><controlfield tag="007">cr|uuu---uuuuu</controlfield><controlfield tag="008">240709s2024 |||| o||u| ||||||eng d</controlfield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">9781803240961</subfield><subfield code="9">978-1-80324-096-1</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(OCoLC)1446263422</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(DE-599)BVBBV049773805</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">Tezuysal, Alkin</subfield><subfield code="e">Verfasser</subfield><subfield code="4">aut</subfield></datafield><datafield tag="245" ind1="1" ind2="0"><subfield code="a">Database design and modeling with PostgreSQL and MySQL</subfield><subfield code="b">build efficient and scalable databases for modern applications using open source databases</subfield><subfield code="c">Alkin Tezuysal, Ibrar Ahmed</subfield></datafield><datafield tag="250" ind1=" " ind2=" "><subfield code="a">1st edition</subfield></datafield><datafield tag="264" ind1=" " ind2="1"><subfield code="a">Birmingham, UK</subfield><subfield code="b">Packt Publishing</subfield><subfield code="c">June 2024</subfield></datafield><datafield tag="300" ind1=" " ind2=" "><subfield code="a">1 Online-Ressource (xviii, 203 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="505" ind1="8" ind2=" "><subfield code="a">Cover -- Copyright -- Foreword -- Contributors -- Table of Contents -- Preface -- Part 1: Introduction to Databases -- Chapter 1: SQL and NoSQL Databases: Characteristics, Design, and Trade-Offs -- Understanding databases and data models -- Exploring the relational data model (SQL databases) -- Tables, rows, and columns -- Normalization -- Structured Query Language (SQL) -- ACID transactions -- Navigating the document data model (NoSQL databases) -- Data models in NoSQL -- Types of NoSQL databases -- Key-value stores -- Document stores -- Column-family stores -- Graph databases</subfield></datafield><datafield tag="505" ind1="8" ind2=" "><subfield code="a">Applying the CAP theorem and NoSQL design choices -- Consistency -- Availability -- Partition tolerance -- Consistency models in NoSQL databases -- NoSQL design choices and use cases -- Managing transaction management and concurrency control in NoSQL -- BASE transactions in NoSQL databases -- Reasons for the BASE model in NoSQL databases -- Implications for data integrity and concurrency control -- Analyzing the advantages and disadvantages of NoSQL databases -- Advantages of NoSQL databases -- Disadvantages of NoSQL databases -- Summary</subfield></datafield><datafield tag="505" ind1="8" ind2=" "><subfield code="a">Chapter 2: Building a Strong Foundation for Database Design -- The importance of a solid foundation in database design -- Key terms and data models -- Understanding the relational model in detail -- Identifying entities, attributes, and relationships in database design -- Creating an ER diagram -- Advanced database design -- Normalization -- reducing redundancy and improving data integrity -- Achieving normal forms -- 1NF, 2NF, and 3NF -- Ensuring database validity and integrity -- Concluding thoughts -- Summary -- Part 2: Practical Implementation</subfield></datafield><datafield tag="505" ind1="8" ind2=" "><subfield code="a">Chapter 3: Getting Your Hands Dirty with PostgreSQL and MySQL -- Understanding the sample database -- EDA and preprocessing -- Database schema -- MySQL -- Concluding thoughts -- Summary -- Part 3: Core Concepts in Database Design -- Chapter 4: Mastering the Building Blocks of Database Design and Modeling -- Understanding database objects -- Understanding data types and constraints -- Keys and how to use them -- Database checks and constraints -- Check constraint -- Default constraint -- Not null constraint -- Checking data quality with constraints -- No date in the future</subfield></datafield><datafield tag="505" ind1="8" ind2=" "><subfield code="a">Value within a specific range -- How to avoid redundancy -- Database consistency and beyond -- Transactions -- ensuring data integrity -- Concurrency control -- managing multiple users -- PostgreSQL -- MySQL -- Summary -- Part 4: Advanced Database Techniques -- Chapter 5: Advanced Techniques for Advanced Databases -- Creating custom views of your data -- Understanding the purpose of views -- The advantages of using views in database management -- Indexing -- how to find data faster -- Understanding indexing -- Types of indexes -- How indexing works -- PostgreSQL indexes -- MySQL indexes</subfield></datafield><datafield tag="505" ind1="8" ind2=" "><subfield code="a">Stored procedures -- reusable code for your database</subfield></datafield><datafield tag="700" ind1="1" ind2=" "><subfield code="a">Ahmed, Ibrar</subfield><subfield code="e">Verfasser</subfield><subfield code="0">(DE-588)1170927831</subfield><subfield code="4">aut</subfield></datafield><datafield tag="776" ind1="0" ind2="8"><subfield code="i">Erscheint auch als</subfield><subfield code="n">Druck-Ausgabe</subfield><subfield code="z">978-1-80323-347-5</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-035114930</subfield></datafield><datafield tag="966" ind1="e" ind2=" "><subfield code="u">https://ebookcentral.proquest.com/lib/th-deggendorf/detail.action?docID=31516395</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.BV049773805 |
| illustrated | Not Illustrated |
| indexdate | 2024-08-01T00:23:48Z |
| institution | BVB |
| isbn | 9781803240961 |
| language | English |
| oai_aleph_id | oai:aleph.bib-bvb.de:BVB01-035114930 |
| oclc_num | 1446263422 |
| open_access_boolean | |
| owner | DE-1050 |
| owner_facet | DE-1050 |
| physical | 1 Online-Ressource (xviii, 203 Seiten) |
| psigel | ZDB-30-PQE ZDB-30-PQE FHD01_PQE_Kauf |
| publishDate | 2024 |
| publishDateSearch | 2024 |
| publishDateSort | 2024 |
| publisher | Packt Publishing |
| record_format | marc |
| spelling | Tezuysal, Alkin Verfasser aut Database design and modeling with PostgreSQL and MySQL build efficient and scalable databases for modern applications using open source databases Alkin Tezuysal, Ibrar Ahmed 1st edition Birmingham, UK Packt Publishing June 2024 1 Online-Ressource (xviii, 203 Seiten) txt rdacontent c rdamedia cr rdacarrier Cover -- Copyright -- Foreword -- Contributors -- Table of Contents -- Preface -- Part 1: Introduction to Databases -- Chapter 1: SQL and NoSQL Databases: Characteristics, Design, and Trade-Offs -- Understanding databases and data models -- Exploring the relational data model (SQL databases) -- Tables, rows, and columns -- Normalization -- Structured Query Language (SQL) -- ACID transactions -- Navigating the document data model (NoSQL databases) -- Data models in NoSQL -- Types of NoSQL databases -- Key-value stores -- Document stores -- Column-family stores -- Graph databases Applying the CAP theorem and NoSQL design choices -- Consistency -- Availability -- Partition tolerance -- Consistency models in NoSQL databases -- NoSQL design choices and use cases -- Managing transaction management and concurrency control in NoSQL -- BASE transactions in NoSQL databases -- Reasons for the BASE model in NoSQL databases -- Implications for data integrity and concurrency control -- Analyzing the advantages and disadvantages of NoSQL databases -- Advantages of NoSQL databases -- Disadvantages of NoSQL databases -- Summary Chapter 2: Building a Strong Foundation for Database Design -- The importance of a solid foundation in database design -- Key terms and data models -- Understanding the relational model in detail -- Identifying entities, attributes, and relationships in database design -- Creating an ER diagram -- Advanced database design -- Normalization -- reducing redundancy and improving data integrity -- Achieving normal forms -- 1NF, 2NF, and 3NF -- Ensuring database validity and integrity -- Concluding thoughts -- Summary -- Part 2: Practical Implementation Chapter 3: Getting Your Hands Dirty with PostgreSQL and MySQL -- Understanding the sample database -- EDA and preprocessing -- Database schema -- MySQL -- Concluding thoughts -- Summary -- Part 3: Core Concepts in Database Design -- Chapter 4: Mastering the Building Blocks of Database Design and Modeling -- Understanding database objects -- Understanding data types and constraints -- Keys and how to use them -- Database checks and constraints -- Check constraint -- Default constraint -- Not null constraint -- Checking data quality with constraints -- No date in the future Value within a specific range -- How to avoid redundancy -- Database consistency and beyond -- Transactions -- ensuring data integrity -- Concurrency control -- managing multiple users -- PostgreSQL -- MySQL -- Summary -- Part 4: Advanced Database Techniques -- Chapter 5: Advanced Techniques for Advanced Databases -- Creating custom views of your data -- Understanding the purpose of views -- The advantages of using views in database management -- Indexing -- how to find data faster -- Understanding indexing -- Types of indexes -- How indexing works -- PostgreSQL indexes -- MySQL indexes Stored procedures -- reusable code for your database Ahmed, Ibrar Verfasser (DE-588)1170927831 aut Erscheint auch als Druck-Ausgabe 978-1-80323-347-5 |
| spellingShingle | Tezuysal, Alkin Ahmed, Ibrar Database design and modeling with PostgreSQL and MySQL build efficient and scalable databases for modern applications using open source databases Cover -- Copyright -- Foreword -- Contributors -- Table of Contents -- Preface -- Part 1: Introduction to Databases -- Chapter 1: SQL and NoSQL Databases: Characteristics, Design, and Trade-Offs -- Understanding databases and data models -- Exploring the relational data model (SQL databases) -- Tables, rows, and columns -- Normalization -- Structured Query Language (SQL) -- ACID transactions -- Navigating the document data model (NoSQL databases) -- Data models in NoSQL -- Types of NoSQL databases -- Key-value stores -- Document stores -- Column-family stores -- Graph databases Applying the CAP theorem and NoSQL design choices -- Consistency -- Availability -- Partition tolerance -- Consistency models in NoSQL databases -- NoSQL design choices and use cases -- Managing transaction management and concurrency control in NoSQL -- BASE transactions in NoSQL databases -- Reasons for the BASE model in NoSQL databases -- Implications for data integrity and concurrency control -- Analyzing the advantages and disadvantages of NoSQL databases -- Advantages of NoSQL databases -- Disadvantages of NoSQL databases -- Summary Chapter 2: Building a Strong Foundation for Database Design -- The importance of a solid foundation in database design -- Key terms and data models -- Understanding the relational model in detail -- Identifying entities, attributes, and relationships in database design -- Creating an ER diagram -- Advanced database design -- Normalization -- reducing redundancy and improving data integrity -- Achieving normal forms -- 1NF, 2NF, and 3NF -- Ensuring database validity and integrity -- Concluding thoughts -- Summary -- Part 2: Practical Implementation Chapter 3: Getting Your Hands Dirty with PostgreSQL and MySQL -- Understanding the sample database -- EDA and preprocessing -- Database schema -- MySQL -- Concluding thoughts -- Summary -- Part 3: Core Concepts in Database Design -- Chapter 4: Mastering the Building Blocks of Database Design and Modeling -- Understanding database objects -- Understanding data types and constraints -- Keys and how to use them -- Database checks and constraints -- Check constraint -- Default constraint -- Not null constraint -- Checking data quality with constraints -- No date in the future Value within a specific range -- How to avoid redundancy -- Database consistency and beyond -- Transactions -- ensuring data integrity -- Concurrency control -- managing multiple users -- PostgreSQL -- MySQL -- Summary -- Part 4: Advanced Database Techniques -- Chapter 5: Advanced Techniques for Advanced Databases -- Creating custom views of your data -- Understanding the purpose of views -- The advantages of using views in database management -- Indexing -- how to find data faster -- Understanding indexing -- Types of indexes -- How indexing works -- PostgreSQL indexes -- MySQL indexes Stored procedures -- reusable code for your database |
| title | Database design and modeling with PostgreSQL and MySQL build efficient and scalable databases for modern applications using open source databases |
| title_auth | Database design and modeling with PostgreSQL and MySQL build efficient and scalable databases for modern applications using open source databases |
| title_exact_search | Database design and modeling with PostgreSQL and MySQL build efficient and scalable databases for modern applications using open source databases |
| title_full | Database design and modeling with PostgreSQL and MySQL build efficient and scalable databases for modern applications using open source databases Alkin Tezuysal, Ibrar Ahmed |
| title_fullStr | Database design and modeling with PostgreSQL and MySQL build efficient and scalable databases for modern applications using open source databases Alkin Tezuysal, Ibrar Ahmed |
| title_full_unstemmed | Database design and modeling with PostgreSQL and MySQL build efficient and scalable databases for modern applications using open source databases Alkin Tezuysal, Ibrar Ahmed |
| title_short | Database design and modeling with PostgreSQL and MySQL |
| title_sort | database design and modeling with postgresql and mysql build efficient and scalable databases for modern applications using open source databases |
| title_sub | build efficient and scalable databases for modern applications using open source databases |
| work_keys_str_mv | AT tezuysalalkin databasedesignandmodelingwithpostgresqlandmysqlbuildefficientandscalabledatabasesformodernapplicationsusingopensourcedatabases AT ahmedibrar databasedesignandmodelingwithpostgresqlandmysqlbuildefficientandscalabledatabasesformodernapplicationsusingopensourcedatabases |