Creating your MySQL Database: Practical Design Tips and Techniques

Name: Creating your MySQL Database: Practical Design Tips and Techniques
Brand: Packt Publishing
SKU: 9781904811305
Price: 2118.0 INR
Availability: InStock

by Marc Delisle

Save 6%

₹2,118.00

₹2,254.00

(-6%)

₹2,118.00

Imported Edition - Ships in 18-21 Days

Free Shipping in India on orders above Rs. 500

Request Bulk Quantity Quote

Name

Quantity

+91

Company Name

Message

Quantity

More Information

ISBN13: 9781904811305
Binding: Paperback
Subject: N/A
Publisher: Packt Publishing
Publisher Imprint: Packt Publishing
Publication Date: November 25, 2006
Pages: 108
Original Price: USD 22.99
Language: English
Edition: N/A
Item Weight: 200 grams
BISAC Subject(s): Database Administration & Management

About The Book

This book is an innovative and essential short guide for everyone on how to structure your data and set-up your MySQL database tables efficiently and easily. If you're creating a dynamic web application using open-source tools, then you're probably going to be setting up a MySQL database. Getting the design of this database right for your application and its data is vital, but it's often an intimidating and little-known process for non-developers and developers alike. Written by the creator of the popular phpMyAdmin tool, this book is a short but complete guide on how to design good data structures for MySQL. For most of us, setting up the database for an application is often an afterthought. While you don't need to be a professional database designer to create a working application, knowing a few insider tips and techniques can make both the process easier and the end result much more effective. This book doesn't set out to make you an expert in data analysis, but it does provide a quick and easy way to raise your game in this essential part of getting your application right. The book covers: Asking users the right questions to collect relevant data for the system you are building Detecting bad structures Sound data-naming techniques, for both table and column names Modeling data with future growth in mind Implementing security policies with data privileges and views Tuning the structure for performance Producing system documentation (data dictionary, relational schema) Testing the model with appropriate SQL queries This book takes a practical approach, implementing all theoretical concepts with examples. It is a fast-paced tutorial that focuses on critical decisions that you need to make every time you build MySQL databases. It is rich with tips and advice from an experienced practitioner. The book is ideal for anyone working with applications that use a MySQL database backend will benefit greatly from the advice and techniques in this book. Although a working knowledge of both SQL and MySQL is assumed, the book is suitable for both beginners and intermediate users alike. Whether you read it through and absorb the advice or work through it on a live project, the efficiency and maintainability of your databases will certainly improve as a result. Chapter 1: Introduction Chapter 2: Data Collection Chapter 3: Data Naming Chapter 4: Data Grouping Chapter 5: Data Structure Tuning Chapter 6: Case Study: An Airline System

About The Author

Delisle, Marc: - Marc Delisle was awarded "MySQL Community Member of the year 2009" because of his involvement with phpMyAdmin. He started to contribute to the project in December 1998, when he made the multi-language version. He is still involved with phpMyAdmin as a developer and project administrator. Marc is a system administrator at Cegep de Sherbrooke, Qubec, Canada. He has been teaching networking, security, and web application development. In one of his classes, he was pleased to meet a phpMyAdmin user from Argentina. Marc lives in Sherbrooke with his wife and they enjoy spending time with their four children.

Trusted for over 49 years

Family Owned Company

Secure Payment

All Major Credit Cards/Debit Cards/UPI & More Accepted

New & Authentic Products

India's Largest Distributor

Need Support?

Whatsapp Us

Related Category

computers > database administration & management

Bestselling

View All

Atomic Habits (Lead Title)

Clear, James

₹585

₹899

(-35%)

₹585

• Author(s): Clear | James • Publisher: Penguin • Publisher Imprint: Penguin Random House • Subject: General Books

Diary of a Wimpy Kid: Partypooper (Book 20)

Jeff Kinney

₹455

₹699

(-35%)

₹455

• Author(s): Jeff Kinney • Publisher: Penguin Random House Children's UK • Publisher Imprint: Penguin Random House Children's UK • BISAC: Comics & Graphic Novels - Humorous

Satoshi Yagisawa

₹260

₹399

(-35%)

₹260

• Author(s): Satoshi Yagisawa • Publisher: Bonnier Books Ltd • Publisher Imprint: Bonnier Books Ltd

Deep Work: Rules For Focused Success In A Distracted World

Newport, Cal

₹260

₹399

(-35%)

₹260

• Author(s): Newport, Cal • Publisher: Little, Brown Book Group • Publisher Imprint: Piatkus

Can We Be Strangers Again?: A National Bestseller

Shrijeet Shandilya

₹195

₹299

(-35%)

₹195

• Author(s): Shrijeet Shandilya • Publisher: Ebury Press • Publisher Imprint: Ebury Press • BISAC: Romance - GeneralIn the electric haze of college life, three friends are bound by laughter, late-night talks and unspoken promises. But when two of...

View full details

The Secret of Secrets: (Robert Langdon Book 6)

Dan Brown

₹2,245

₹3,250

(-31%)

₹2,245

• Author(s): Dan Brown • Publisher: Transworld Publishers Ltd • Publisher Imprint: Transworld Publishers Ltd • BISAC: Thrillers - EspionageDan Brown is the bestselling author of Digital Fortress, Deception Point, Angels and Demons, The Da Vinci C...

View full details

Magic of the Lost Temple

Sudha Murty

₹179

₹275

(-35%)

₹179

• Author(s): Sudha Murty • Publisher: India Puffin • Publisher Imprint: India Puffin • BISAC: Action & Adventure - General

Rich Dad Poor Dad: What the Rich Teach Their Kids about Money That the Poor and Middle Class Do Not!

₹390

₹599

(-35%)

₹390

• Publisher: Penguin • Publisher Imprint: Penguin Random House • Subject: General Books • BISAC: Personal Finance - GeneralApril of 2022 marks a 25-year milestone for the personal finance classic Rich Dad Poor Dad that still ranks as the #1 Pers...

View full details

Viktor E. Frankl

₹260

₹399

(-35%)

₹260

• Author(s): Viktor E. Frankl • Publisher: Random House • Publisher Imprint: Random Hou • Subject: Medical, Nursing and Health Sciences

Bacchon KI Doctor's Desi Parenting Book: A Doctor-Mom's Guide to Milk, Myths, Motherhood and More

Madhavi Bharadwaj

₹260

₹399

(-35%)

₹260

• Author(s): Madhavi Bharadwaj • Publisher: PRH India • Publisher Imprint: Penguin Ebury Press • BISAC: Parenting - MotherhoodWelcome to the wild, messy, wonderful world of parenting--where the nights are long, the diapers are explosive, and unso...

View full details

The Outsider

Vir Das

₹455

₹699

(-35%)

₹455

• Author(s): Vir Das • Publisher: HarperCollins Publishers India • Publisher Imprint: HarperCollins Publishers India • BISAC: Entertainment & Performing ArtsComedian and actor Vir Das is beloved (by some, tolerated by others, blocked by a few...

View full details

The Very Hungry Caterpillar

Eric Carle

₹293

₹450

(-35%)

₹293

• Author(s): Eric Carle • Publisher: Penguin Books, Limited (UK) • Publisher Imprint: Penguin Books, Limited (UK) • BISAC: Animals - Butterflies, Moths & CaterpillarsEric Carle's The Very Hungry Caterpillar is a perennial favourite with child...

View full details

Too Good to Be True : A smart, funny will-they-won’t-they romance by mostlysane

Prajakta Koli

₹260

₹399

(-35%)

₹260

• Author(s): Prajakta Koli • Publisher: Harper Fiction India • Publisher Imprint: Harper Fiction India • BISAC: Romance - ContemporaryWinner of the Amazon India Popular Choice Debut Book 2025 Award. From one of India's most-loved creators comes s...

View full details

Creating your MySQL Database: Practical Design Tips and Techniques

Related Category

Bestselling

Atomic Habits (Lead Title)

Diary of a Wimpy Kid: Partypooper (Book 20)

Ikigai

The Courage To Be Disliked How To Free Yourself Change Your Life And Achieve Real Happiness Courage To Series

12 Years: My Messed-up Love Story

The Mountain Is You: Transforming Self-Sabotage Into Self-Mastery

The Art of Spending Money: Simple Choices for a Richer Life

Mother Mary Comes To Me

Truth without Apology: A Guide for Those Who Can Stand It

Grandma's Bag of Stories

Days at the Morisaki Bookshop

Deep Work: Rules For Focused Success In A Distracted World

Can We Be Strangers Again?: A National Bestseller

The Secret of Secrets: (Robert Langdon Book 6)

Magic of the Lost Temple

Rich Dad Poor Dad: What the Rich Teach Their Kids about Money That the Poor and Middle Class Do Not!

World’S Greatest Books For Personal Growth & Wealth (Set Of 4 Books) : Perfect Motivational

The Housemaid: An Addictive Psychological Thriller With Mind-Bending Twists

101 Tales: The Great Panchatantra Collection

Man's Search For Meaning

Bacchon KI Doctor's Desi Parenting Book: A Doctor-Mom's Guide to Milk, Myths, Motherhood and More

The Outsider

The Very Hungry Caterpillar

Too Good to Be True : A smart, funny will-they-won’t-they romance by mostlysane

Customer Reviews

Added to your cart:

Creating your MySQL Database: Practical Design Tips and Techniques

Related Category

Bestselling

Customer Reviews

Country

Country