Gillenson M.L. Wiley Pathways Introduction to Database Management

Wiley, 2007. — 504 p. — ISBN: 0470101865, 9780470101865You 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.Introducing to Data and Data Management
Identifying Business Data
Identifying Human Data Sources
Installing SQL Server 2005 Evaluation Edition
Learning About SQL Server Management Studio
Identifying Key Management Areas
Introducing Databases and Database Management Systems
Comparing Database Models
Identifying DBMS Architecture and Components
Reviewing Server Hardware Resources
Investigating SQL Server Databases
Identifying Application Requirements
Data Modeling
Understanding Data Modeling Concepts
Recognizing Entities, Attributes, and Identifiers
Recognizing Relationships
Reading an ERD
Creating an ERD
Viewing Basic Database Objects
Designing a Database
Recognizing Key Concepts
Converting Relationships
Reviewing a Normalized Database
Recognizing Normalization Errors
Normalizing Data
Implementing a Database
Understanding Terms and Concepts
Identifying Solution Requirements
Creating a Database
Creating Tables, Part 1
Setting Table Constraints
Creating Tables, Part 2
Understanding the SQL Language
Understanding Terms and Concepts
Investigating Help Resources
Comparing Command Environments
Using the SELECT Statement
Using DDL Commands
Using DML Commands
Data Access and Manipulation
Understanding Data Access
Retrieving Data
Using Advanced Data Retrieval
Using Batches and Scripts
Recognizing and Correcting Errors
Improving Data Access
Understanding Data Access
Investigating Resources and Configuration Settings
Monitoring Performance
Recognizing Bottlenecks
Using Views and Indexes
Using Procedures and Functions
Database Administration
Understanding Administration
Understanding Roles and Responsibilities
Matching Lifecycle Requirements
Resolving Administration Issues
Managing "As-needed" and Periodic Tasks
Transactions and Locking
Understanding Transactions and Locking
Understanding Transaction Types
Understanding Transaction Isolation and Locking
Using Transactions
Monitoring Transactions and Clearing Blocked Transactions
Data Access and Security
Understanding Data Access and Security
Designing for Security
Understanding Your Security Environment
Managing Security Principals
Managing Permissions
Managing Backups
Supporting Database Applications
Understanding Support Configurations
Designing Data Environments
Working in a Distributed Environment
Using Distributed Queries
Using Replication
Understanding Data Issues