Ibrar Ahmed's Books

Database Design and Modeling with PostgreSQL and MySQL

Build efficient and scalable databases for modern applications using open source databases

By: Alkin Tezuysal,Ibrar Ahmed

Write a review Read reviews Take a Quiz Solve Book Puzzle

Database Design and Modeling with PostgreSQL and MySQL

Build efficient and scalable databases for modern applications using open source databases

By: Alkin Tezuysal,Ibrar Ahmed

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 DescriptionDatabase 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.

Average ratings

N/A

Write a review

Solve jigsaw puzzle

Age

Page Count

222

Publisher

Packt Publishing Ltd

Published Date

ISBN 10

1803240962

ISBN 13

9781803240961

Assignments as Controversies

Digital Literacy and Writing in Classroom Practice

By: Ibrar Bhatt

Write a review Read reviews Take a Quiz Solve Book Puzzle

Assignments as Controversies

Digital Literacy and Writing in Classroom Practice

By: Ibrar Bhatt

Approaching academic assignments as practical controversies, this book offers a novel approach to the study of digital literacy. Through in-depth accounts of assignment writing in college classrooms, Bhatt examines ways of understanding how students engage with digital media in curricular activities and how these give rise to new practices of information management and knowledge creation. He further considers what these new practices portend for a stronger theory of digital literacy in an age of informational abundance and ubiquitous connectivity. Looking also at how institutional digital learning policies and strategies are applied in classrooms, and how students may embrace or avoid imposed technologies, this book offers an in-depth study of learner practices. It is through the comprehensive study of such practices that we can better understand the efficacy of technological investments in education, and the dynamic nature of digital literacy on the part of students charged with using those technologies.

Average ratings

N/A

Write a review

Solve jigsaw puzzle

Age

Page Count

158

Publisher

Routledge

Published Date

ISBN 10

131728920X

ISBN 13

9781317289203

Database Design and Modeling with PostgreSQL and MySQL

Build efficient and scalable databases for modern applications using open source databases

By: Alkin Tezuysal,Ibrar Ahmed

Write a review Read reviews Take a Quiz Solve Book Puzzle

Database Design and Modeling with PostgreSQL and MySQL

Build efficient and scalable databases for modern applications using open source databases

By: Alkin Tezuysal,Ibrar Ahmed

Average ratings

N/A

Write a review

Solve jigsaw puzzle

Age

Page Count

222

Publisher

Packt Publishing Ltd

Published Date

ISBN 10

1803240962

ISBN 13

9781803240961

PostgreSQL 9.6 High Performance

By: Ibrar Ahmed,Gregory Smith

Write a review Read reviews Take a Quiz Solve Book Puzzle

PostgreSQL 9.6 High Performance

By: Ibrar Ahmed,Gregory Smith

Enhance the performance of your PostgreSQL system with this handy guide while avoiding common pitfalls that can slow it down.About This Book* Learn the right techniques to obtain optimal PostgreSQL database performance, ranging from initial design to routine maintenance* Fine tune the performance of your queries and avoid the common pitfalls that can slow your system down* Contains tips and tricks on scaling successful database installations, and ensuring a highly available PostgreSQL solutionWho This Book Is ForThis book is for intermediate to advanced database administrators and developers who use or plan to exploit the features of PostgreSQL in the best possible manner. While administrators can benefit from the topics related to the installation, configuration, and optimization of the server, developers will learn how to write optimal queries and address performance issues in their database design. This book will also benefit the PostgreSQL internal architects in being able to monitor the performance using benchmarking tools.What You Will Learn* Learn the best practices to configure your PostgreSQL 9.6 database for optimal performance* Write optimal queries and techniques to detect performance issue in queries* Fine tune the performance of your queries using benchmarking and indexing techniques* Ensure high performance and a highly available database using the scaling and replication techniques* Discover how to make informed speed and reliability trade-offs* Handle increasing database workloads without any hassle* Use monitoring insights to continuously rework the design and configuration for best performanceIn DetailDatabase administrators and developers spend years learning techniques to configure their PostgreSQL database servers for optimal performance, mostly when they encounter performance issues. Scalability and high availability of the database solution is equally important these days. This book will show you how to configure new database installations and optimize existing database server installations using PostgreSQL 9.6.You will start with the basic concepts of database performance, because all successful database applications are destined to eventually run into issues when scaling up their performance. You will not only learn to optimize your database and queries for optimal performance, but also detect the real performance bottlenecks using PostgreSQL tools and some external tools. Next, you will learn how to benchmark your hardware and tune your operating system. Optimize your queries against the database with the help of right indexes, and monitor every layer, ranging from hardware to queries. Moving on, you will see how connection pooling, caching, partitioning, and replication will help you handle increasing database workloads.Achieving high database performance is not easy, but you can learn it by using the right guide--PostgreSQL 9.6 High Performance.Style and approachThis book has been organized in such a manner that will help you understand basic PostgreSQL 9.6 performance tuning to advanced-level configuration. There are many real-world problems explained in this book and explained in clear language, because improving database performance requires an equal mix of understanding theoretical concepts and working through hands-on examples.

Average ratings

N/A

Write a review

Solve jigsaw puzzle

Age

Page Count

508

Published Date

ISBN 10

1784392979

ISBN 13

9781784392970

Book's by Ibrar Ahmed

Database Design and Modeling with PostgreSQL and MySQL

Database Design and Modeling with PostgreSQL and MySQL

Assignments as Controversies

Assignments as Controversies

Database Design and Modeling with PostgreSQL and MySQL

Database Design and Modeling with PostgreSQL and MySQL

PostgreSQL 9.6 High Performance

PostgreSQL 9.6 High Performance

Username

Password

Username

Password

Password again

Birthday

Email