Wiley Pathways Introduction to Database Management, Project Manual

Häftad, Engelska, 2007

579 kr

Beställningsvara. Skickas inom 5-8 vardagar. Fri frakt över 249 kr.

Beskrivning

You can get there Introduction 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 replication With 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 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 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 www.wiley.com/go/pathways.

Produktinformation

Utgivningsdatum:2007-05-04
Mått:216 x 277 x 20 mm
Vikt:612 g
Format:Häftad
Språk:Engelska
Antal sidor:312
Förlag:John Wiley & Sons Inc
ISBN:9780470114100

Utforska kategorier

Databaser inom Data och IT
Affärsapplikationer inom Data och IT

Mer om författaren

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. 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.

Innehållsförteckning

1 Introduction to Data and Data Management1.1 Identifying Business Data 21.2 Identifying Human Data Sources 41.3 Installing SQL Server 2005 Evaluation Edition 51.4 Learning about SQL Server Management Studio 121.5 Identifying Key Management Areas 192 Introducing Databases and Database Management Systems2.1 Comparing Database Models 212.2 Identifying DBMS Architecture and Components 232.3 Reviewing Server Hardware Resources 242.4 Investigating SQL Server Databases 322.5 Identifying Application Requirements 353 Data Modeling3.1 Understanding Data Modeling Concepts 393.2 Recognizing Entities, Attributes, and Identifiers 403.3 Recognizing Relationships and Business Rules 423.4 Reading an ERD 453.5 Creating an ERD 473.6 Viewing Basic Database Objects 504 Designing a Database4.1 Understanding Key Concepts 594.2 Converting Relationships 604.3 Reviewing a Normalized Database 654.4 Recognizing Normalization Errors 694.5 Normalizing Data 735 Implementing a Database5.1 Understanding Terms and Concepts 785.2 Identifying Solution Requirements 795.3 Creating a Database 845.4 Creating Tables, Part 1 885.5 Setting Table Constraints 915.6 Creating Tables, Part 2 966 Understanding the SQL Language6.1 Understanding Terms and Concepts 1026.2 Identifying Help Resources 1046.3 Comparing Command Environments 1116.4 Using the SELECT Command 1166.5 Using DDL Commands 1216.6 Using DML Commands 1267 Data Access and Manipulation7.1 Understanding Data Access 1327.2 Retrieving Data 1337.3 Using Advanced Data Retrieval 1387.4 Using Batches and Scripts 1417.5 Recognizing and Correcting Syntax Errors 1448 Improving Data Access8.1 Understanding Database Monitoring and Optimization 1498.2 Investigating Resources and Configuration Settings 1518.3 Monitoring Performance 1638.4 Recognizing Bottlenecks 1728.5 Using Indexes and Views 1758.6 Using Procedures and Functions 1799 Database Administration9.1 Understanding Administration 1849.2 Understanding Roles and Responsibilities 1869.3 Matching Life Cycle Requirements 1889.4 Resolving Administration Issues 1909.5 Managing "As-Needed" and Periodic Tasks 19610 Transactions and Locking10.1 Understanding Transactions and Locking 21010.2 Understanding Transaction Types 21210.3 Understanding Transaction Isolation and Locking 21910.4 Using Transactions 22610.5 Monitoring Transactions and Clearing Blocked Transactions 23111 Data Access and Security11.1 Understanding Data Access and Security 23611.2 Designing for Access and Security 23811.3 Understanding Your Security Environment 24211.4 Managing Security Principals 24911.5 Managing Permissions 25511.6 Managing Backups 26312 Supporting Database Applications12.1 Understanding Data Configurations 26712.2 Designing Data Environments 26912.3 Working in a Distributed Environment 27712.4 Using Distributed Queries 28412.5 Using Replication 29112.6 Understanding Data Issues 299