You can get thereIntroduction to Databases Project Manual offers a wealth of easy-to-read, practical, up-to-date activities that reinforce fundamental database design and management concepts. You'll also learn to develop the core competencies and skills you'll need in the real world, such as how to:* Install SQL Server 2005* Read and create an ERD* Design and implement a database* Use DDL and DML commands* Use and monitor transactions* Manage security principles, permissions, and backups* Design data environments* Use replicationWith five to seven projects per chapter ranging from easy to more advanced, Introduction to Databases Project Manual is ideal for both traditional and online courses that are oriented toward strengthening database management skills.Introduction to Databases Project Manual is an excellent companion to Gillenson's Introduction to Databases (ISBN: 978-0-470-10186-5).Wiley Pathways helps you achieve your goalsNot 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 and project manuals 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 wiley.com/go/pathways.

1. Introducing to Data and Data Management1.1 Identifying Business Data1.2 Identifying Human Data Sources1.3 Installing SQL Server 2005 Evaluation Edition1.4 Learning About SQL Server Management Studio1.5 Identifying Key Management Areas2. Introducing Databases and Database Management Systems2.1. Comparing Database Models2.2 Identifying DBMS Architecture and Components2.3 Reviewing Server Hardware Resources2.4 Investigating SQL Server Databases2.5 Identifying Application Requirements3. Data Modeling3.1 Understanding Data Modeling Concepts3.2 Recognizing Entities, Attributes, and Identifiers3.3 Recognizing Relationships3.4 Reading an ERD3.5 Creating an ERD3.6 Viewing Basic Database Objects4. Designing a Database4.1. Recognizing Key Concepts4.2 Converting Relationships4.3 Reviewing a Normalized Database4.4 Recognizing Normalization Errors4.5 Normalizing Data5. Implementing a Database5.1 Understanding Terms and Concepts5.2 Identifying Solution Requirements5.3 Creating a Database5.4 Creating Tables, Part 15.5 Setting Table Constraints5.6 Creating Tables, Part 26. Understanding the SQL Language6.1 Understanding Terms and Concepts6.2 Investigating Help Resources6.3 Comparing Command Environments6.4 Using the SELECT Statement6.5 Using DDL Commands6.6 Using DML Commands7. Data Access and Manipulation7.1 Understanding Data Access7.2 Retrieving Data7.3 Using Advanced Data Retrieval7.4 Using Batches and Scripts7.5 Recognizing and Correcting Errors8. Improving Data Access8.1 Understanding Data Access8.2 Investigating Resources and Configuration Settings8.3. Monitoring Performance8.4. Recognizing Bottlenecks8.5. Using Views and Indexes8.6. Using Procedures and Functions9. Database Administration9.1 Understanding Administration9.2 Understanding Roles and Responsibilities9.3 Matching Lifecycle Requirements9.4 Resolving Administration Issues9.5 Managing "As-needed" and Periodic Tasks10. Transactions and Locking10.1 Understanding Transactions and Locking10.2 Understanding Transaction Types10.3 Understanding Transaction Isolation and Locking10.4 Using Transactions10.5 Monitoring Transactions and Clearing Blocked Transactions11. Data Access and Security11.1 Understanding Data Access and Security11.2 Designing for Security11.3 Understanding Your Security Environment11.4 Managing Security Principals11.5 Managing Permissions11.6 Managing Backups12. Supporting Database Applications12.1 Understanding Support Configurations12.2 Designing Data Environments12.3 Working in a Distributed Environment12.4 Using Distributed Queries12.5 Using Replication12.6 Understanding Data Issues