Wiley Pathways Introduction to Database Management

ISBN-13: 9780470101865 / Angielski / Miękka / 2007 / 508 str.

Mark L. Gillenson; Paulraj Ponniah; Alex Kriegel

Opis

You can get there

Where do you want to go? You might already be working in the information technology field and may be looking to expand your skills. You might be setting out on a new career path. Or, you might want to learn more about exciting opportunities in database management.

Wherever you want to go, Introduction to Databases will help you get there. Easy-to-read, practical, and up-to-date, this text not only helps you learn fundamental database design and management concepts, it also helps you master the core competencies and skills you need to succeed in the classroom and in the real world. The book's brief, modular format and variety of built-in learning resources enable you to learn at your own pace and focus your studies.

With this book, you will be able to:
* Appreciate the key role of data in daily business operations and strategic decisions.
* Understand databases, database management systems, and SQL, the software on which they are based, from the ground up.
* Know how to gather and organize critical business information, design a database based on this information, and retrieve and modify that information in a useful manner.
* Use accepted data modeling procedures to design a relational database.
* Master the concept of data normalization and the use of standard normalization rules.
* Explore critical real-world issues including application integration and securing data against disclosure and loss.

Wiley Pathways helps you achieve your goals

Not every student is on the same path, but every student wants to succeed. The Information Technology series in the new Wiley Pathways imprint helps you achieve your goals. The books in this series--Introduction to Databases, Introduction to Programming Using Visual Basic, Introduction to Operating Systems, Networking Basics, Windows Network Administration, Network Security Fundamentals, and PC Hardware Essentials--offer a coordinated information technology curriculum. Learn more at www.wiley.com/go/pathways

Spis treści

1 Introducing to Data and Data Management 1

2 Introducing Databases and Database Management Systems 24

3 Data Modeling 60

4 Designing a Database 104

5 Implementing a Database 146

6 Understanding the SQL Language 184

7 Data Access and Manipulation 223

8 Improving Data Access 263

9 Database Administration 300

10 Transactions and Locking 332

11 Data Access and Security 368

12 Supporting Database Applications 412

Glossary 448

Index 465

O autorze

Dr. Mark L. Gillenson has been practicing, researching, teaching, writing, and, most importantly, thinking, about data and database management for over twenty–five years, split between working for the IBM Corporation and being a professor in the academic world. While working for IBM, he designed databases for IBM′s corporate headquarters, consulted on database issues for some of IBM′s largest customers, taught database management at the prestigious IBM Systems Research Institute in New York, and conducted database seminars throughout the United States and on four continents. In one such seminar, he taught introduction to database to an IBM development group that went on to develop one of IBM′s first relational database management system products, SQL/DS.

Paulraj Ponniah, PhD, a veteran IT professional, specializes in the design and implementation of database and data warehouse systems, as well as in teaching database and data warehouse courses.

Frank Miller has nearly 30 years experience designing, developing, and delivering technical training materials. For 20 of those years, SQL language database management systems have been an area of special interest and expertise. During that time he has written books and other training materials that are used by various schools and professional organizations in the United States and around the world.