Sams Teach Yourself Beginning Databases in 24

In just 24 lessons of one hour or less, you will learn the basics of databases, as well as techniques to design and build efficient databases and query them to extract useful information. Using a straightforward, step-by-step approach, each lesson builds on the previous one, allowing you to learn the essentials of databases from the ground up. Example code and databases demonstrate the authors' techniques and exercises written for MySQL offers the reader hands-on learning with an open-source database. Included are techniques for designing a database, building a database, querying a database, and where to go next to further your database skills. Book jacket.

Ryan Stephens is president and CEO of Perpetual Technologies, Inc., an information technology consulting and training firm in Indianapolis, Indiana. He has specialized in database technology and SQL for over 13 years, working as an Oracle programmer/analyst, Oracle database administrator, consultant, IT manager, and adjunct professor at Indiana University-Purdue University in Indianapolis, where he has taught SQL, PL/SQL, UNIX, Oracle Oracle DBA, Oracle Development, and database design courses. Ryan resides in Indianapolis with his wife, Tina, and their children, Daniel, Autumn, and Baby Stephens.

Ronald R. Plew is vice president and CIO for Perpetual Technologies, Inc., in Indianapolis, Indiana. Ron has served as an adjunct professor at Indiana University-Purdue University in Indianapolis, where he has taught SQL and various database courses. He holds a Bachelor of Science degree in Business Management/Administration from Indiana Institute of Technology, Fort Wayne, Indiana. Ron also serves in the Indiana Army National Guard, where he is the programmer/analyst for the 433rd Personnel Detachment. Ron's hobbies include golf, chess, and collecting Indianapolis 500 racing memorabilia. He shares ownership of Plew's Indy 500 Museum with his brothers, Mark and Dennis; his sister, Arleen; and mother, Betty. Ron lives in Indianapolis with his wife Linda. Ron and Linda have four children, ten grandchildren, and one great grandchild.

Introduction	p. 1
Database Fundamentals	p. 3
What Is a Database?	p. 5
What Is Data?	p. 6
What Is a Database?	p. 7
Standard Features of a Modern Database	p. 9
What Is a Database Management System?	p. 10
Why Are Databases So Popular?	p. 11
Summary	p. 12
Workshop	p. 12
History and Evolution of Database Environments	p. 15
Exploration of Modern Database Environments	p. 16
Understanding the Client/Server Environment	p. 18
Understanding the Multitier Environment	p. 21
Understanding the Web Environment	p. 23
Summary	p. 26
Q&A	p. 26
Workshop	p. 26
Relating to Modern Databases	p. 29
Using the Internet	p. 30
Everyday Transactions	p. 36
Nontechnology Databases	p. 42
Summary	p. 43
Workshop	p. 43
Relating to Modern Databases Users	p. 47
Techies--From Idea Inception to Implementation and Management	p. 48
Internal Database Users	p. 57
Summary	p. 58
Workshop	p. 59
Database Architecture and Storage	p. 63
Understanding Modern Database Architectures and Environments	p. 65
Exploration of "Legacy" Database Architectures	p. 66
Exploration of Modern Architectures	p. 71
Understanding Multimedia Databases	p. 81
Understanding Distributed Databases	p. 82
Summary	p. 83
Q&A	p. 83
Workshop	p. 83
Understanding Relational Database Architecture	p. 87
Why Was the Relational Database Needed?	p. 88
Understanding How Relational Databases Solve Today's Data Storage Needs	p. 89
Basic Elements of a Relational Database	p. 90
Understanding Relationships Between Data	p. 96
How to Communicate with a Relational Database	p. 98
Summary	p. 100
Q&A	p. 100
Workshop	p. 101
Using Tables and Keys for Fundamental Data Storage	p. 105
Types of Tables	p. 106
Defining Tables	p. 107
Using Keys to Define Relationships	p. 108
Normalizing Tables	p. 113
Managing Tables	p. 117
Summary	p. 117
Q&A	p. 117
Workshop	p. 118
Optimizing Data Storage with Indexes	p. 121
Understanding the Need for Indexes	p. 122
Classifying Indexes	p. 123
Types of Indexes	p. 124
Other Objects That Optimize Storage	p. 127
How Indexes Are Used	p. 131
Cost Optimizer and Hints	p. 132
Summary	p. 133
Q&A	p. 134
Workshop	p. 134
Organizing Data Appropriately in Databases and Schemas	p. 137
Understanding Database and Schema Terminology	p. 138
Database Organization at the Database Level	p. 139
Database Organization at the Schema Level	p. 140
Distributed Databases	p. 145
Application of Covered Concepts to a Sample Database	p. 146
Summary	p. 147
Q&A	p. 148
Workshop	p. 148
Welcome to Object-Oriented Databases	p. 151
Overview of Object-Oriented Databases	p. 152
Why Are Object-Oriented Databases Needed?	p. 156
Understanding Basic Object-Oriented Database Theory	p. 158
Object-Oriented Databases in the Real World	p. 162
Summary	p. 163
Q&A	p. 163
Design, Implementation, and Management	p. 167
Understanding the Basics of Database Design	p. 169
Defining Database Design	p. 169
Planning for Database Design	p. 170
Modeling Entities and Relationships	p. 172
Designing Tables	p. 175
Understanding Post-Design Tasks	p. 181
Understanding Database Design Methodology	p. 181
Summary	p. 183
Workshop	p. 183
Learning Basic Database Administration	p. 185
Understanding Database Administration	p. 186
Creating the Database Environment	p. 187
Managing Database Security	p. 189
Monitoring the Database	p. 194
Managing Backup and Recovery	p. 196
Managing Space Utilization and System Resources	p. 201
Tuning the Database for Optimal Performance	p. 202
Summary	p. 205
Workshop	p. 205
Managing the Database Life Cycle	p. 207
Understanding the Software Life Cycle	p. 207
Managing Changes to the Database Throughout Its Life	p. 215
Redesigning the Database	p. 218
Understanding the Impact of Changes on Database Components	p. 219
Summary	p. 220
Workshop	p. 221
Accessing Databases	p. 223
Understanding Basic Database Connection Methods	p. 225
Overview of Database Connection Methods	p. 226
Overview of Database Connection Software	p. 229
Summary	p. 242
Workshop	p. 243
Understanding the Standard Database Language: SQL	p. 245
Overview of SQL	p. 246
Understanding the Basic Components of SQL	p. 247
Using SQL for Databases and Applications	p. 251
Exploring an Open Source Solution: MySQL	p. 251
Summary	p. 255
Workshop	p. 255
Creating Databases and Database Objects	p. 257
Creating a Database	p. 258
Understanding Data Definition	p. 259
Creating a MySQL Database	p. 267
Using MySQL for Database and Object Creation	p. 271
Summary	p. 272
Workshop	p. 272
Interacting with Databases to Manage and Retrieve Data	p. 275
Overview of Data Manipulation	p. 276
Overview of Data Retrieval	p. 279
Summary	p. 284
Workshop	p. 285
Effective Reporting and Data Usage	p. 287
What Is Database Reporting?	p. 288
Summary	p. 301
Q&A	p. 302
Workshop	p. 302
Practical Database Integration with Business	p. 305
Using Databases to Process and Manage Data	p. 307
Overview of Data Processing	p. 308
Explanation of OLTP Databases	p. 311
Issues with OLTP Databases	p. 313
OLTP Database Variations	p. 315
Summary	p. 318
Workshop	p. 319
Using Databases for Business Analysis	p. 323
Overview of Data Analysis	p. 324
How Is Data Used?	p. 330
A Real-World Example of Using Data for Business Analysis	p. 334
Summary	p. 334
Workshop	p. 334
Building Applications That Use Databases	p. 337
Traditional Approaches to Data Storage	p. 338
Overview of the Database-Enabled Application	p. 339
Creating the Database Application	p. 341
Connecting to a Database from an Application	p. 345
Summary	p. 349
Q&A	p. 349
Workshop	p. 349
Popular Database Software and Third-Party Tools	p. 353
Commercial Database Servers	p. 354
Open Source Database Servers	p. 360
Desktop Databases	p. 363
Third-Party Database Administration Software	p. 364
Third-Party Data-Mining Software	p. 366
Database Development Software	p. 368
Summary	p. 370
Workshop	p. 371
Future of Databases	p. 373
Previewing Emerging Database Trends	p. 375
Modern Database Technologies	p. 376
Data Storage and Migration	p. 384
Summary	p. 391
Workshop	p. 392
Where Do I Go from Here?	p. 393
Choosing a Database Vendor	p. 394
Choosing a Career Path	p. 394
Careers in Database Technology	p. 394
Training	p. 395
Staying Current with Technology	p. 401
Setting Your Career Agenda	p. 402
Summary	p. 403
Workshop	p. 403
Appendices	p. 405
SQL Command Quick Reference	p. 407
SQL Statements	p. 407
SQL Clauses	p. 411
Glossary	p. 413
Index	p. 423
Table of Contents provided by Ingram. All Rights Reserved.

What is included with this book?

The New copy of this book will include any supplemental materials advertised. Please check the title of the book to determine if it should include any access cards, study guides, lab manuals, CDs, etc.

The Used, Rental and eBook copies of this book are not guaranteed to include any supplemental materials. Typically, only the book itself is included. This is true even if the title states it includes any access cards, study guides, lab manuals, CDs, etc.

FREE SHIPPING

Amazon no longer offers textbook rentals. We do!

Sams Teach Yourself Beginning Databases in 24 Hours

Summary

Author Biography

Table of Contents

Supplemental Materials