Join us on a literary world trip!
Add this book to bookshelf
Grey
Write a new comment Default profile 50px
Grey
Subscribe to read the full book or read the first pages for free!
I want to read the book!
All characters reduced
Database Design and Modeling with PostgreSQL and MySQL - Build efficient and scalable databases for modern applications using open source databases - cover

Database Design and Modeling with PostgreSQL and MySQL - Build efficient and scalable databases for modern applications using open source databases

Alkin Tezuysal, Ibrar Ahmed

Publisher: Packt Publishing

  • 0
  • 0
  • 0

Summary

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.
Available since: 07/26/2024.
Print length: 222 pages.

Other books that might interest you

  • Boy Who Harnessed the Wind The: Book Summary & Analysis - cover

    Boy Who Harnessed the Wind The:...

    Briefly Summaries

    • 0
    • 0
    • 0 
    This is a concise summary and analysis of The Boy Who Harnessed the Wind, by William Kamkwamba and Bryan Mealer.
 
It is not the original book and is not affiliated with or endorsed by William Kamkwamba and Bryan Mealer.
 
Ideal those seeking a quick and insightful overview.
The Boy Who Harnessed the Wind is an inspiring true story of a young boy from Malawi who, against all odds, builds a windmill to provide electricity for his village. With limited resources and formal education, he uses his ingenuity and determination to overcome poverty and drought, transforming his community. The book highlights themes of perseverance, innovation, and the power of education to change lives.
    Show book
  • Lost in the Stream - How Algorithms Redefined the Way Movies Are Made and Watched - cover

    Lost in the Stream - How...

    Jeff Rauseo

    • 0
    • 0
    • 0 
    This engaging book by Jeff Rauseo blends film history with a modern guide to streaming, helping you navigate the complex history of movie making and ultimately how to know what to watch in the vast ocean of content. From the golden age of Hollywood to the best new movies to stream, Rauseo breaks down the ever-evolving movie watching experience to help us understand the good, the bad, and the ugly of streaming. 
 
Ever feel overwhelmed by endless streaming choices? Jeff Rauseo's Lost in the Stream is your ultimate roadmap, combining movie history insights with an in-depth breakdown of how streaming influences the movies that are made and the ones that we are shown. Whether you're searching for the best new movies to stream, hidden Amazon Prime movies, or fun movies to watch on Netflix, this book has you covered. 
 
Blending nostalgia with today's streaming hits, Lost in the Stream dives deep into the iconic history of film that shaped the art while helping you discover new favorites. It's the perfect companion for movie buffs and casual viewers alike. Inside, you'll find a breakdown of the evolution of film watching, from drive-ins to Blockbuster nights and beyond; engaging insights into the impact finances and algorithms have on the movies that are made; and a guide to discovering the best films for you.
    Show book
  • The Magic Beneath Our Feet - Uncovering the Hidden World of Mushrooms - cover

    The Magic Beneath Our Feet -...

    MERLIN STAMETS, PAUL SHELDRAKE

    • 0
    • 0
    • 0 
    The Magic Beneath Our Feet: Uncovering the Hidden World of Mushrooms! 
Eureka! Welcome to the bewitching realm that exists right beneath our unsuspecting feet. In “The Magic Beneath Our Feet: Uncovering the Hidden World of Mushrooms,” we pull back the earthy curtains, revealing a kingdom teeming with wonders beyond your wildest dreams. Let's embark on this spore-tacular journey, shall we? 
Mushroom Mysteries Unveiled: Think you know mushrooms? Think again. Venture beyond the ordinary button mushroom and encounter extravagant species, each carrying tales of lore, ancient medicine, and the secrets of nature’s intricate web. 
Gastronomic Delights & Healing Allies: From truffles that are worth their weight in gold to humble fungi with unparalleled healing properties—get ready to elevate your culinary adventures and wellness regimes. It's gourmet and healing, all rolled into one! 
Unfurling this narrative is akin to embarking on an epic odyssey across uncharted territories, where every turn uncovers a revelation, a mystery, or a miracle. “The Magic Beneath Our Feet” isn’t just an exposition—it's an exhilarating expedition. An awakening to the fascinating world that, while unseen, is very much alive, pulsating, and brimming with tales of nature's marvels. 
So, lace up those hiking boots, grab your trusty field guide, and join us on this exhilarating journey. From the shadows of the forest floor to the bustling ecosystems of our own backyards, we’ll traverse landscapes and time, unearthing stories, wisdom, and a newfound appreciation for the incredible fungi among us. 
Discover. Dream. Delve. The Fungi Frontier Awaits! 🍄📚🌲
    Show book
  • Touchpad iPrime Ver 11 Class 5 - cover

    Touchpad iPrime Ver 11 Class 5

    Team Orange

    • 0
    • 0
    • 0 
    Computer Science Textbook Designed for Joyful Learning 

KEY FEATURES 
- National Education Policy 2020 
- Tech Funda: This section provides a practical information or tip to the students. 
- Clickipedia: This section provides interesting computer facts. 
- Hands-On: This section contains an activity for Home assignment. 
- QR Code: Scan the QR Code given on the first page of each chapter to start chapter animation. 
- Crack the Code: This section has puzzle or fun based activity to help understand the concepts better. 
- Digital Resources 

DESCRIPTION 
Touchpad iPRIME (Ver 1.1) series based on Windows 7 & MS Office 2010 is comprehensively designed as per the new ICSE syllabus. Learning is done best when it’s fun-filled and activity based. To ensure that the content intrigues the students at all times and keeps them interested throughout the course of the book, we have included interesting key features like Student Corner, Tech Funda, Clickipedia, Comp Caution, Reboot, One Touch Learn, Let’s Do It, Crack The Code, Hands-On, Fun In Lab, Teacher’s Corner, Worksheet, Test Sheet, Project, Speech Drill, Supplement Pages and Glossary. 

WHAT WILL YOU LEARN 
You will learn about: 
- Fundamentals of computers 
- ICT Tools 
- Computational Thinking 
- Computer Software 
- Features of MS Word 2010 
- Presentation 
- Scratch Programming 
- Internet Services 

WHO THIS BOOK IS FOR 
Grade - 5 

TABLE OF CONTENTS 
1. Evolution of Computers 
2. Computer Software 
3. Advanced Features of MS Word 2010 
4. Graphics in MS Word 2010 
5. Presentation Software—Special Effects 
6. An Introduction to Scratch Programming 
7. Internet Services 
8. Project Work 
9. Explore More (Microsoft Office 2013) 
10. OGO Cyber Sample Questions 
11. Glossary
    Show book
  • The Seaweed Revolution - How Seaweed Has Shaped Our Past and Can Save Our Future - cover

    The Seaweed Revolution - How...

    Vincent Doumeizel

    • 0
    • 0
    • 0 
    Accessible and engaging, topical reading with case studies from around the world. Written by world expert with guaranteed media coverage. First mainstream book looking at seaweed from an environmental standpoint. Will appeal to fans of popular science and those with interest in environmental issues.
    Show book
  • PHP - PHP Basics for Beginners - cover

    PHP - PHP Basics for Beginners

    Andy Vickler

    • 0
    • 0
    • 0 
    Explore the dynamic world of web development through PHP, get to know the potential of PHP. 
Do you get overwhelmed when thing to start a web development career? Are you not sure which language to choose? Are you unsure if PHP is the right language? Or you know PHP is the one but you don’t know where to start! 
If so, the simple solution is right below: PHP Basics for Beginners. 
This audiobook will answer all your queries and proof its worth as the best language for web development. As it was mainly designed for the purpose of website development. So one of your questions is already answered and I’ll encourage you to take the step and listen to the audiobook to find out the glorious thing PHP can do to you career. 
Imagine building your very first site and attracting prospects from the design and performance of your website. Imagine building your own gadgets in the site and amusing your audience. With PHP Basics for Beginners you can embark on that journey you always imagined in the back of your head. 
You’ll receive the basic yet curtail information regarding PHP, from its origin to the modern use of PHP. After listening to this audiobook you’ll understand the core steps you need to take for the PHP to execute and in a matter of days you’ll be executing PHP for your websites. 
Along with these amazing discoveries you’ll also get to code on smaller functions. By the end of this audiobook, if you keep it in practice along with listening to it, you’ll end up with a website. The audiobook not only talks about the theory and tactics of PHP but also teaches you how you can claim a career in web development via PHP.
    Show book