Beginning databases in 24 hours

Database technology has become commonplace in virtually all types of computer uses, ranging from even the most simple Web sites to numerous casual personal tasks. Sams Teach Yourself Beginning Databases in 24 Hours provides a solid foundation that any reader needing to learn current database technologies can apply and use today.

This book has an easy-to-understand format and includes numerous real-world examples that will help the reader relate to databases that are in use by businesses today. Numerous diagrams and code examples, quizzes and exercises that increase the reader's understanding of the material are a key benefit of Sams Teach Yourself Beginning Databases in 24 Hours.

After completing this book, a reader will be able to build and use simple databases using any modem database tool and will be prepared to move on to more complex projects.

Contents

• Introduction
  • Database Fundamentals
  • Hour 1 What Is a Database?
  • Hour 2 History and Evolution of Database Environments
  • Hour 3 Relating to Modern Databases
  • Hour 4 Relating to Modern Database Users

• Database Architecture and Storage
  • Hour 5 Understanding Modern Database Architectures and Environments
  • Hour 6 Understanding Relational Database Architecture
  • Hour 7 Using Tables and Keys for Fundamental Data Storage
  • Hour 8 Optimizing Data Storage with Indexes
  • Hour 9 Organizing Data Appropriately in Databases and Schemas
  • Hour 10 Welcome to Object-Oriented Databases

• Design, Implementation, and Management
  • Hour 11 Understanding the Basics of Database Design
  • Hour 12 Learning Basic Database Administration
  • Hour 13 Managing the Database Life Cycle

• Accessing Databases
  • Hour 14 Understanding Basic Database Connection Methods
  • Hour 15 Understanding the Standard Database Language: SQL
  • Hour 16 Creating Databases and Database Objects
  • Hour 17 Interacting with Databases to Manage and Retrieve Data
  • Hour 18 Effective Reporting and Data Usage

• Practical Database Integration with Business
  • Hour 19 Using Databases to Process and Manage Data
  • Hour 20 Using Databases for Business Analysis
  • Hour 21 Building applications that use databases
  • Hour 22 Popular database software and third-party tools

• Future of databases
  • Hour 23 Previewing emerging database trends
  • Hour 24 Where do I go from here ?

• Appendices
  • SQL command quick reference
  • Glossary

• Index