가야대학교 분성도서관
주메뉴
자료검색
- Home
- 상세정보
상세정보
부가기능
Database design and modeling with PostgreSQL and MySQL : build efficient and scalable databases for modern applications using open source databases /
상세 프로파일
| 자료유형 | E-Book |
|---|---|
| 개인저자 | Tezuysal, Alkin, author. Ahmed, Ibrar, author. Zaitsev, Peter, writer of foreword. |
| 서명/저자사항 | 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. |
| 발행사항 | Birmingham : Packt Publishing, Limited, 2024. |
| 형태사항 | 1 online resource (222 p.) |
| 소장본 주기 | Added to collection customer.56279.3 |
| ISBN | 1803240962 9781803240961 |
| 기타표준부호 | CIPO000108992 |
| 내용주기 | 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 |
| 요약 | 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. COMPUTERS / Database Administration & Management. COMPUTERS / Data Science / Data Warehousing. COMPUTERS / Data Science / Data Modeling & Design. Data Modeling & Design. Databases. COMPUTERS. Data Warehousing. |
| 언어 | 영어 |
| 기타형태 저록 | Print version:Tezuysal, AlkinDatabase Design and Modeling with PostgreSQL and MySQLBirmingham : Packt Publishing, Limited,c2024 |
| 대출바로가기 | https://search.ebscohost.com/login.aspx?direct=true&scope=site&db=nlebk&db=nlabk&AN=3966303 |
소장정보
- 소장정보
인쇄
| No. | 등록번호 | 청구기호 | 소장처 | 도서상태 | 반납예정일 | 예약 | 서비스 | 매체정보 |
|---|---|---|---|---|---|---|---|---|
| 1 | WE00030768 | 005.74 | 가야대학교/전자책서버(컴퓨터서버)/ | 대출가능 |
|
카피라이터
