|
Showing 1 - 5 of
5 matches in All Departments
This is a step-by-step instructional guide to get you started
easily with phpMyAdmin and teach you to manage and perform database
functions on your database. You will first be introduced to the
interface and then build basic tables and perform both simple and
advanced functions on the created database. The book progresses
gradually and you will follow it best by reading it sequentially.
If you are a developer, system administrator, or web designer who
wants to manage MySQL databases and tables efficiently, then this
book is for you. This book assumes that you are already
wellacquainted with MySQL basics. This book is a must-read for
every serious phpMyAdmin user who would like to use this
outstanding application to its full power.
This book is a tutorial that systematically explains and
demonstrates the potential of this tool. It then goes on to show
the less well known and generally under-used features and
capabilities of phpMyAdmin in depth. Whether you are an experienced
developer, system administrator, web designer or new to MySQL,
phpMyAdmin is a must-have tool for anyone who needs to manage MySQL
databases and tables. This book is a must-read for every serious
phpMyAdmin user who would like to use this outstanding application
to its full power.
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. 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 4: Data Grouping Chapter 5: Data Structure Tuning
Chapter 6: Case Study: An Airline System
Discover the real power of phpMyAdmin. Increase your MySQL
productivity and control. .Learn to unlock the full potential of
phpMyAdmin .Increase your productivity and control when working
with your databases .Benefit from in-depth, practical coverage of
using phpMyAdmin to manage users and privileges and getting server
and database statistics .Get to grips with the hidden features and
capabilities of phpMyAdmin This book is a comprehensive guide
helping you to unlock the full potential of phpMyAdmin. Whether you
are an experienced developer, system administrator, web designer or
new to MySQL and phpMyAdmin, this book will show you how to
increase your productivity and control when working with your
MySQL. Whether you are an experienced developer, system
administrator, web designer or new to MySQL and phpMyAdmin, this
book will show you how to increase your productivity and control
when working with your databases. You will learn how to:
.Administer MySQL users and privileges, and get statistics about
MySQL servers and databases .Manage databases, table data and
structures, and indexes .Use bookmarks and metadata .Generate
multiple SQL queries .Generate better documentation of evolving
table structures Along the way you'll build a more detailed
understanding of SQL and how it works in MySQL. In the book you'll
learn about: . Installing, configuring, and customizing phpMyAdmin.
. MySQL administration. . Managing databases, table data and
structures. . Managing indexes. . Exporting databases and table
data and structures. . Searching databases and tables . Using
metadata and bookmarks . Generating multiple SQL queries .
Documenting table structures . Mime-based transformation
|
You may like...
Loot
Nadine Gordimer
Paperback
(2)
R398
R330
Discovery Miles 3 300
Loot
Nadine Gordimer
Paperback
(2)
R398
R330
Discovery Miles 3 300
Barbie
Margot Robbie, Ryan Gosling, …
DVD
R194
Discovery Miles 1 940
Loot
Nadine Gordimer
Paperback
(2)
R398
R330
Discovery Miles 3 300
Loot
Nadine Gordimer
Paperback
(2)
R398
R330
Discovery Miles 3 300
Poor Things
Emma Stone, Mark Ruffalo, …
DVD
R449
R329
Discovery Miles 3 290
|