Saved in:
| Main Authors: | , |
|---|---|
| Other Authors: | |
| Format: | Electronic eBook |
| Language: | English |
| Published: |
Birmingham
Packt Publishing, Limited
2024
|
| Edition: | 1st edition. |
| Subjects: | |
| Links: | https://learning.oreilly.com/library/view/-/9781803233475/?ar |
| Summary: | Become well-versed with database modeling and SQL optimization, and gain a deep understanding of transactional systems through practical examples and exercises Key Features Get to grips with fundamental-to-advanced database design and modeling concepts with PostgreSQL and MySQL Explore database integration with web apps, emerging trends, and real-world case studies Leverage practical examples and hands-on exercises to reinforce learning Purchase of the print or Kindle book includes a free PDF eBook Book Description Database Design and Modeling with PostgreSQL and MySQL will equip you with the knowledge and skills you need to architect, build, and optimize efficient databases using two of the most popular open-source platforms. As you progress through the chapters, you'll gain a deep understanding of data modeling, normalization, and query optimization, supported by hands-on exercises and real-world case studies that will reinforce your learning. You'll explore topics like concurrency control, backup and recovery strategies, and seamless integration with web and mobile applications. These advanced topics will empower you to tackle complex database challenges confidently and effectively. Additionally, you'll explore emerging trends, such as NoSQL databases and cloud-based solutions, ensuring you're well-versed in the latest developments shaping the database landscape. By embracing these cutting-edge technologies, you'll be prepared to adapt and innovate in today's ever-evolving digital world. By the end of this book, you'll be able to understand the technologies that exist to design a modern and scalable database for developing web applications using MySQL and PostgreSQL open-source databases. What you will learn Design a schema, create ERDs, and apply normalization techniques Gain knowledge of installing, configuring, and managing MySQL and PostgreSQL Explore topics such as denormalization, index optimization, transaction management, and concurrency control Scale databases with sharding, replication, and load balancing, as well as implement backup and recovery strategies Integrate databases with web apps, use SQL, and implement best practices Explore emerging trends, including NoSQL databases and cloud databases, while understanding the impact of AI and ML Who this book is for This book is for a wide range of professionals interested in expanding their knowledge and skills in database design and modeling with PostgreSQL and MySQL. This includes software developers, database administrators, data analysts, IT professionals, and students. While prior knowledge of MySQL and PostgreSQL is not necessary, some familiarity with at least one relational database management system (RDBMS) will help you get the most out of this book. |
| Item Description: | Description based upon print version of record |
| Physical Description: | 1 Online-Ressource (222 p.) |
| ISBN: | 9781803240961 1803240962 9781803233475 |
Staff View
MARC
| LEADER | 00000nam a22000002c 4500 | ||
|---|---|---|---|
| 001 | ZDB-30-ORH-106606611 | ||
| 003 | DE-627-1 | ||
| 005 | 20240902105238.0 | ||
| 007 | cr uuu---uuuuu | ||
| 008 | 240902s2024 xx |||||o 00| ||eng c | ||
| 020 | |a 9781803240961 |9 978-1-80324-096-1 | ||
| 020 | |a 1803240962 |9 1-80324-096-2 | ||
| 020 | |a 9781803233475 |9 978-1-80323-347-5 | ||
| 035 | |a (DE-627-1)106606611 | ||
| 035 | |a (DE-599)KEP106606611 | ||
| 035 | |a (ORHE)9781803233475 | ||
| 035 | |a (DE-627-1)106606611 | ||
| 040 | |a DE-627 |b ger |c DE-627 |e rda | ||
| 041 | |a eng | ||
| 082 | 0 | |a 005.74 |2 23/eng/20240805 | |
| 100 | 1 | |a Tezuysal, Alkin |e VerfasserIn |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 ; foreword by Peter Zaitsev |
| 250 | |a 1st edition. | ||
| 264 | 1 | |a Birmingham |b Packt Publishing, Limited |c 2024 | |
| 300 | |a 1 Online-Ressource (222 p.) | ||
| 336 | |a Text |b txt |2 rdacontent | ||
| 337 | |a Computermedien |b c |2 rdamedia | ||
| 338 | |a Online-Ressource |b cr |2 rdacarrier | ||
| 500 | |a Description based upon print version of record | ||
| 520 | |a Become well-versed with database modeling and SQL optimization, and gain a deep understanding of transactional systems through practical examples and exercises Key Features Get to grips with fundamental-to-advanced database design and modeling concepts with PostgreSQL and MySQL Explore database integration with web apps, emerging trends, and real-world case studies Leverage practical examples and hands-on exercises to reinforce learning Purchase of the print or Kindle book includes a free PDF eBook Book Description Database Design and Modeling with PostgreSQL and MySQL will equip you with the knowledge and skills you need to architect, build, and optimize efficient databases using two of the most popular open-source platforms. As you progress through the chapters, you'll gain a deep understanding of data modeling, normalization, and query optimization, supported by hands-on exercises and real-world case studies that will reinforce your learning. You'll explore topics like concurrency control, backup and recovery strategies, and seamless integration with web and mobile applications. These advanced topics will empower you to tackle complex database challenges confidently and effectively. Additionally, you'll explore emerging trends, such as NoSQL databases and cloud-based solutions, ensuring you're well-versed in the latest developments shaping the database landscape. By embracing these cutting-edge technologies, you'll be prepared to adapt and innovate in today's ever-evolving digital world. By the end of this book, you'll be able to understand the technologies that exist to design a modern and scalable database for developing web applications using MySQL and PostgreSQL open-source databases. What you will learn Design a schema, create ERDs, and apply normalization techniques Gain knowledge of installing, configuring, and managing MySQL and PostgreSQL Explore topics such as denormalization, index optimization, transaction management, and concurrency control Scale databases with sharding, replication, and load balancing, as well as implement backup and recovery strategies Integrate databases with web apps, use SQL, and implement best practices Explore emerging trends, including NoSQL databases and cloud databases, while understanding the impact of AI and ML Who this book is for This book is for a wide range of professionals interested in expanding their knowledge and skills in database design and modeling with PostgreSQL and MySQL. This includes software developers, database administrators, data analysts, IT professionals, and students. While prior knowledge of MySQL and PostgreSQL is not necessary, some familiarity with at least one relational database management system (RDBMS) will help you get the most out of this book. | ||
| 630 | 2 | 0 | |a PostgreSQL |
| 650 | 0 | |a Database management | |
| 650 | 0 | |a Database design | |
| 650 | 0 | |a Application software |x Development | |
| 650 | 4 | |a Bases de données ; Gestion | |
| 650 | 4 | |a Bases de données ; Conception | |
| 650 | 4 | |a Logiciels d'application ; Développement | |
| 700 | 1 | |a Ahmed, Ibrar |e VerfasserIn |4 aut | |
| 700 | 1 | |a Zaitsev, Peter |e MitwirkendeR |4 ctb | |
| 966 | 4 | 0 | |l DE-91 |p ZDB-30-ORH |q TUM_PDA_ORH |u https://learning.oreilly.com/library/view/-/9781803233475/?ar |m X:ORHE |x Aggregator |z lizenzpflichtig |3 Volltext |
| 912 | |a ZDB-30-ORH | ||
| 951 | |a BO | ||
| 912 | |a ZDB-30-ORH | ||
| 049 | |a DE-91 | ||
Record in the Search Index
| DE-BY-TUM_katkey | ZDB-30-ORH-106606611 |
|---|---|
| _version_ | 1835903245829013504 |
| adam_text | |
| any_adam_object | |
| author | Tezuysal, Alkin Ahmed, Ibrar |
| author2 | Zaitsev, Peter |
| author2_role | ctb |
| author2_variant | p z pz |
| author_facet | Tezuysal, Alkin Ahmed, Ibrar Zaitsev, Peter |
| author_role | aut aut |
| author_sort | Tezuysal, Alkin |
| author_variant | a t at i a ia |
| building | Verbundindex |
| bvnumber | localTUM |
| collection | ZDB-30-ORH |
| ctrlnum | (DE-627-1)106606611 (DE-599)KEP106606611 (ORHE)9781803233475 |
| dewey-full | 005.74 |
| dewey-hundreds | 000 - Computer science, information, general works |
| dewey-ones | 005 - Computer programming, programs, data, security |
| dewey-raw | 005.74 |
| dewey-search | 005.74 |
| dewey-sort | 15.74 |
| dewey-tens | 000 - Computer science, information, general works |
| discipline | Informatik |
| edition | 1st edition. |
| format | Electronic eBook |
| fullrecord | <?xml version="1.0" encoding="UTF-8"?><collection xmlns="http://www.loc.gov/MARC21/slim"><record><leader>04502nam a22004692c 4500</leader><controlfield tag="001">ZDB-30-ORH-106606611</controlfield><controlfield tag="003">DE-627-1</controlfield><controlfield tag="005">20240902105238.0</controlfield><controlfield tag="007">cr uuu---uuuuu</controlfield><controlfield tag="008">240902s2024 xx |||||o 00| ||eng c</controlfield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">9781803240961</subfield><subfield code="9">978-1-80324-096-1</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">1803240962</subfield><subfield code="9">1-80324-096-2</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">9781803233475</subfield><subfield code="9">978-1-80323-347-5</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(DE-627-1)106606611</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(DE-599)KEP106606611</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(ORHE)9781803233475</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(DE-627-1)106606611</subfield></datafield><datafield tag="040" ind1=" " ind2=" "><subfield code="a">DE-627</subfield><subfield code="b">ger</subfield><subfield code="c">DE-627</subfield><subfield code="e">rda</subfield></datafield><datafield tag="041" ind1=" " ind2=" "><subfield code="a">eng</subfield></datafield><datafield tag="082" ind1="0" ind2=" "><subfield code="a">005.74</subfield><subfield code="2">23/eng/20240805</subfield></datafield><datafield tag="100" ind1="1" ind2=" "><subfield code="a">Tezuysal, Alkin</subfield><subfield code="e">VerfasserIn</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 ; foreword by Peter Zaitsev</subfield></datafield><datafield tag="250" ind1=" " ind2=" "><subfield code="a">1st edition.</subfield></datafield><datafield tag="264" ind1=" " ind2="1"><subfield code="a">Birmingham</subfield><subfield code="b">Packt Publishing, Limited</subfield><subfield code="c">2024</subfield></datafield><datafield tag="300" ind1=" " ind2=" "><subfield code="a">1 Online-Ressource (222 p.)</subfield></datafield><datafield tag="336" ind1=" " ind2=" "><subfield code="a">Text</subfield><subfield code="b">txt</subfield><subfield code="2">rdacontent</subfield></datafield><datafield tag="337" ind1=" " ind2=" "><subfield code="a">Computermedien</subfield><subfield code="b">c</subfield><subfield code="2">rdamedia</subfield></datafield><datafield tag="338" ind1=" " ind2=" "><subfield code="a">Online-Ressource</subfield><subfield code="b">cr</subfield><subfield code="2">rdacarrier</subfield></datafield><datafield tag="500" ind1=" " ind2=" "><subfield code="a">Description based upon print version of record</subfield></datafield><datafield tag="520" ind1=" " ind2=" "><subfield code="a">Become well-versed with database modeling and SQL optimization, and gain a deep understanding of transactional systems through practical examples and exercises Key Features Get to grips with fundamental-to-advanced database design and modeling concepts with PostgreSQL and MySQL Explore database integration with web apps, emerging trends, and real-world case studies Leverage practical examples and hands-on exercises to reinforce learning Purchase of the print or Kindle book includes a free PDF eBook Book Description Database Design and Modeling with PostgreSQL and MySQL will equip you with the knowledge and skills you need to architect, build, and optimize efficient databases using two of the most popular open-source platforms. As you progress through the chapters, you'll gain a deep understanding of data modeling, normalization, and query optimization, supported by hands-on exercises and real-world case studies that will reinforce your learning. You'll explore topics like concurrency control, backup and recovery strategies, and seamless integration with web and mobile applications. These advanced topics will empower you to tackle complex database challenges confidently and effectively. Additionally, you'll explore emerging trends, such as NoSQL databases and cloud-based solutions, ensuring you're well-versed in the latest developments shaping the database landscape. By embracing these cutting-edge technologies, you'll be prepared to adapt and innovate in today's ever-evolving digital world. By the end of this book, you'll be able to understand the technologies that exist to design a modern and scalable database for developing web applications using MySQL and PostgreSQL open-source databases. What you will learn Design a schema, create ERDs, and apply normalization techniques Gain knowledge of installing, configuring, and managing MySQL and PostgreSQL Explore topics such as denormalization, index optimization, transaction management, and concurrency control Scale databases with sharding, replication, and load balancing, as well as implement backup and recovery strategies Integrate databases with web apps, use SQL, and implement best practices Explore emerging trends, including NoSQL databases and cloud databases, while understanding the impact of AI and ML Who this book is for This book is for a wide range of professionals interested in expanding their knowledge and skills in database design and modeling with PostgreSQL and MySQL. This includes software developers, database administrators, data analysts, IT professionals, and students. While prior knowledge of MySQL and PostgreSQL is not necessary, some familiarity with at least one relational database management system (RDBMS) will help you get the most out of this book.</subfield></datafield><datafield tag="630" ind1="2" ind2="0"><subfield code="a">PostgreSQL</subfield></datafield><datafield tag="650" ind1=" " ind2="0"><subfield code="a">Database management</subfield></datafield><datafield tag="650" ind1=" " ind2="0"><subfield code="a">Database design</subfield></datafield><datafield tag="650" ind1=" " ind2="0"><subfield code="a">Application software</subfield><subfield code="x">Development</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">Bases de données ; Gestion</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">Bases de données ; Conception</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">Logiciels d'application ; Développement</subfield></datafield><datafield tag="700" ind1="1" ind2=" "><subfield code="a">Ahmed, Ibrar</subfield><subfield code="e">VerfasserIn</subfield><subfield code="4">aut</subfield></datafield><datafield tag="700" ind1="1" ind2=" "><subfield code="a">Zaitsev, Peter</subfield><subfield code="e">MitwirkendeR</subfield><subfield code="4">ctb</subfield></datafield><datafield tag="966" ind1="4" ind2="0"><subfield code="l">DE-91</subfield><subfield code="p">ZDB-30-ORH</subfield><subfield code="q">TUM_PDA_ORH</subfield><subfield code="u">https://learning.oreilly.com/library/view/-/9781803233475/?ar</subfield><subfield code="m">X:ORHE</subfield><subfield code="x">Aggregator</subfield><subfield code="z">lizenzpflichtig</subfield><subfield code="3">Volltext</subfield></datafield><datafield tag="912" ind1=" " ind2=" "><subfield code="a">ZDB-30-ORH</subfield></datafield><datafield tag="951" ind1=" " ind2=" "><subfield code="a">BO</subfield></datafield><datafield tag="912" ind1=" " ind2=" "><subfield code="a">ZDB-30-ORH</subfield></datafield><datafield tag="049" ind1=" " ind2=" "><subfield code="a">DE-91</subfield></datafield></record></collection> |
| id | ZDB-30-ORH-106606611 |
| illustrated | Not Illustrated |
| indexdate | 2025-06-25T12:16:12Z |
| institution | BVB |
| isbn | 9781803240961 1803240962 9781803233475 |
| language | English |
| open_access_boolean | |
| owner | DE-91 DE-BY-TUM |
| owner_facet | DE-91 DE-BY-TUM |
| physical | 1 Online-Ressource (222 p.) |
| psigel | ZDB-30-ORH TUM_PDA_ORH ZDB-30-ORH |
| publishDate | 2024 |
| publishDateSearch | 2024 |
| publishDateSort | 2024 |
| publisher | Packt Publishing, Limited |
| record_format | marc |
| spelling | Tezuysal, Alkin VerfasserIn 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 ; foreword by Peter Zaitsev 1st edition. Birmingham Packt Publishing, Limited 2024 1 Online-Ressource (222 p.) Text txt rdacontent Computermedien c rdamedia Online-Ressource cr rdacarrier Description based upon print version of record Become well-versed with database modeling and SQL optimization, and gain a deep understanding of transactional systems through practical examples and exercises Key Features Get to grips with fundamental-to-advanced database design and modeling concepts with PostgreSQL and MySQL Explore database integration with web apps, emerging trends, and real-world case studies Leverage practical examples and hands-on exercises to reinforce learning Purchase of the print or Kindle book includes a free PDF eBook Book Description Database Design and Modeling with PostgreSQL and MySQL will equip you with the knowledge and skills you need to architect, build, and optimize efficient databases using two of the most popular open-source platforms. As you progress through the chapters, you'll gain a deep understanding of data modeling, normalization, and query optimization, supported by hands-on exercises and real-world case studies that will reinforce your learning. You'll explore topics like concurrency control, backup and recovery strategies, and seamless integration with web and mobile applications. These advanced topics will empower you to tackle complex database challenges confidently and effectively. Additionally, you'll explore emerging trends, such as NoSQL databases and cloud-based solutions, ensuring you're well-versed in the latest developments shaping the database landscape. By embracing these cutting-edge technologies, you'll be prepared to adapt and innovate in today's ever-evolving digital world. By the end of this book, you'll be able to understand the technologies that exist to design a modern and scalable database for developing web applications using MySQL and PostgreSQL open-source databases. What you will learn Design a schema, create ERDs, and apply normalization techniques Gain knowledge of installing, configuring, and managing MySQL and PostgreSQL Explore topics such as denormalization, index optimization, transaction management, and concurrency control Scale databases with sharding, replication, and load balancing, as well as implement backup and recovery strategies Integrate databases with web apps, use SQL, and implement best practices Explore emerging trends, including NoSQL databases and cloud databases, while understanding the impact of AI and ML Who this book is for This book is for a wide range of professionals interested in expanding their knowledge and skills in database design and modeling with PostgreSQL and MySQL. This includes software developers, database administrators, data analysts, IT professionals, and students. While prior knowledge of MySQL and PostgreSQL is not necessary, some familiarity with at least one relational database management system (RDBMS) will help you get the most out of this book. PostgreSQL Database management Database design Application software Development Bases de données ; Gestion Bases de données ; Conception Logiciels d'application ; Développement Ahmed, Ibrar VerfasserIn aut Zaitsev, Peter MitwirkendeR ctb |
| 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 PostgreSQL Database management Database design Application software Development Bases de données ; Gestion Bases de données ; Conception Logiciels d'application ; Développement |
| 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 ; foreword by Peter Zaitsev |
| 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 ; foreword by Peter Zaitsev |
| 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 ; foreword by Peter Zaitsev |
| 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 |
| topic | PostgreSQL Database management Database design Application software Development Bases de données ; Gestion Bases de données ; Conception Logiciels d'application ; Développement |
| topic_facet | PostgreSQL Database management Database design Application software Development Bases de données ; Gestion Bases de données ; Conception Logiciels d'application ; Développement |
| work_keys_str_mv | AT tezuysalalkin databasedesignandmodelingwithpostgresqlandmysqlbuildefficientandscalabledatabasesformodernapplicationsusingopensourcedatabases AT ahmedibrar databasedesignandmodelingwithpostgresqlandmysqlbuildefficientandscalabledatabasesformodernapplicationsusingopensourcedatabases AT zaitsevpeter databasedesignandmodelingwithpostgresqlandmysqlbuildefficientandscalabledatabasesformodernapplicationsusingopensourcedatabases |