Gespeichert in:
| Beteiligte Personen: | , |
|---|---|
| Format: | Elektronisch E-Book |
| Sprache: | Englisch |
| Veröffentlicht: |
Birmingham, UK
Packt Publishing
June 2024
|
| Ausgabe: | 1st edition |
| Links: | https://ebookcentral.proquest.com/lib/th-deggendorf/detail.action?docID=31516395 https://portal.igpublish.com/iglibrary/search/PACKT0007468.html https://portal.igpublish.com/iglibrary/search/PACKT0007468.html https://portal.igpublish.com/iglibrary/search/PACKT0007468.html |
| Umfang: | 1 Online-Ressource (xviii, 203 Seiten) |
| ISBN: | 9781803240961 |
Internformat
MARC
| LEADER | 00000nam a2200000 c 4500 | ||
|---|---|---|---|
| 001 | BV049773805 | ||
| 003 | DE-604 | ||
| 005 | 20250513 | ||
| 007 | cr|uuu---uuuuu | ||
| 008 | 240709s2024 xx o|||| 00||| eng d | ||
| 020 | |a 9781803240961 |9 978-1-80324-096-1 | ||
| 035 | |a (ZDB-221-PDA)9781803240961 | ||
| 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 |a DE-706 |a DE-91 | ||
| 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 | ||
| 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 |
| 856 | 4 | 0 | |u https://portal.igpublish.com/iglibrary/search/PACKT0007468.html |x Verlag |z URL des Erstveröffentlichers |3 Volltext |
| 912 | |a ZDB-30-PQE | ||
| 912 | |a ZDB-221-PDA | ||
| 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 | |
| 966 | e | |u https://portal.igpublish.com/iglibrary/search/PACKT0007468.html |l DE-91 |p ZDB-221-PDA |q TUM_Paketkauf_2025 |x Verlag |3 Volltext | |
| 966 | e | |u https://portal.igpublish.com/iglibrary/search/PACKT0007468.html |l DE-706 |p ZDB-221-PDA |x Verlag |3 Volltext | |
Datensatz im Suchindex
| _version_ | 1832048239265710080 |
|---|---|
| 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 ZDB-221-PDA |
| 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 | (ZDB-221-PDA)9781803240961 (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>00000nam a2200000 c 4500</leader><controlfield tag="001">BV049773805</controlfield><controlfield tag="003">DE-604</controlfield><controlfield tag="005">20250513</controlfield><controlfield tag="007">cr|uuu---uuuuu</controlfield><controlfield tag="008">240709s2024 xx o|||| 00||| 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">(ZDB-221-PDA)9781803240961</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><subfield code="a">DE-706</subfield><subfield code="a">DE-91</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="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="856" ind1="4" ind2="0"><subfield code="u">https://portal.igpublish.com/iglibrary/search/PACKT0007468.html</subfield><subfield code="x">Verlag</subfield><subfield code="z">URL des Erstveröffentlichers</subfield><subfield code="3">Volltext</subfield></datafield><datafield tag="912" ind1=" " ind2=" "><subfield code="a">ZDB-30-PQE</subfield></datafield><datafield tag="912" ind1=" " ind2=" "><subfield code="a">ZDB-221-PDA</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><datafield tag="966" ind1="e" ind2=" "><subfield code="u">https://portal.igpublish.com/iglibrary/search/PACKT0007468.html</subfield><subfield code="l">DE-91</subfield><subfield code="p">ZDB-221-PDA</subfield><subfield code="q">TUM_Paketkauf_2025</subfield><subfield code="x">Verlag</subfield><subfield code="3">Volltext</subfield></datafield><datafield tag="966" ind1="e" ind2=" "><subfield code="u">https://portal.igpublish.com/iglibrary/search/PACKT0007468.html</subfield><subfield code="l">DE-706</subfield><subfield code="p">ZDB-221-PDA</subfield><subfield code="x">Verlag</subfield><subfield code="3">Volltext</subfield></datafield></record></collection> |
| id | DE-604.BV049773805 |
| illustrated | Not Illustrated |
| indexdate | 2025-05-13T12:01:08Z |
| 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 DE-706 DE-91 DE-BY-TUM |
| owner_facet | DE-1050 DE-706 DE-91 DE-BY-TUM |
| physical | 1 Online-Ressource (xviii, 203 Seiten) |
| psigel | ZDB-30-PQE ZDB-221-PDA ZDB-30-PQE FHD01_PQE_Kauf ZDB-221-PDA TUM_Paketkauf_2025 |
| publishDate | 2024 |
| publishDateSearch | 2024 |
| publishDateSort | 2024 |
| publisher | Packt Publishing |
| record_format | marc |
| 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 |
| url | https://portal.igpublish.com/iglibrary/search/PACKT0007468.html |
| work_keys_str_mv | AT tezuysalalkin databasedesignandmodelingwithpostgresqlandmysqlbuildefficientandscalabledatabasesformodernapplicationsusingopensourcedatabases AT ahmedibrar databasedesignandmodelingwithpostgresqlandmysqlbuildefficientandscalabledatabasesformodernapplicationsusingopensourcedatabases |