Muutke küpsiste eelistusi

Wiley Pathways Introduction to Database Management, Project Manual [Pehme köide]

4.00/5 (2 hinnangut Goodreads-ist)
, , With , (Consultant), , (University of Memphis), (Database Consultant, Oregon City, OR)
  • Formaat: Paperback / softback, 312 pages, kõrgus x laius x paksus: 277x216x20 mm, kaal: 612 g
  • Ilmumisaeg: 04-May-2007
  • Kirjastus: John Wiley & Sons Inc
  • ISBN-10: 047011410X
  • ISBN-13: 9780470114100
Teised raamatud teemal:
Wiley Pathways Introduction to Database Management, Project ManualSuurem pilt
  • Formaat: Paperback / softback, 312 pages, kõrgus x laius x paksus: 277x216x20 mm, kaal: 612 g
  • Ilmumisaeg: 04-May-2007
  • Kirjastus: John Wiley & Sons Inc
  • ISBN-10: 047011410X
  • ISBN-13: 9780470114100
Teised raamatud teemal:
Püsilink: https://www.kriso.ee/db/9780470114100.html
Märksõnad:
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.
Introduction to Data and Data Management
Identifying Business Data
2(2)
Identifying Human Data Sources
4(1)
Installing SQL Server 2005 Evaluation Edition
5(7)
Learning About SQL Server Management Studio
12(7)
Identifying Key Management Areas
19(2)
Introducing Databases and Database Management Systems
Comparing Database Models
21(2)
Identifying DBMS Architecture and Components
23(1)
Reviewing Server Hardware Resources
24(8)
Investigating SQL Server Databases
32(3)
Identifying Application Requirements
35(4)
Data Modeling
Understanding Data Modeling Concepts
39(1)
Recognizing Entities, Attributes, and Identifiers
40(2)
Recognizing Relationships and Business Rules
42(3)
Reading an ERD
45(2)
Creating an ERD
47(3)
Viewing Basic Database Objects
50(9)
Designing a Database
Understanding Key Concepts
59(1)
Converting Relationships
60(5)
Reviewing a Normalized Database
65(4)
Recognizing Normalization Errors
69(4)
Normalizing Data
73(5)
Implementing a Database
Understanding Terms and Concepts
78(1)
Identifying Solution Requirements
79(5)
Creating a Database
84(4)
Creating Tables, Part 1
88(3)
Setting Table Constraints
91(5)
Creating Tables, Part 2
96(6)
Understanding the SQL Language
Understanding Terms and Concepts
102(2)
Identifying Help Resources
104(7)
Comparing Command Environments
111(5)
Using the Select Command
116(5)
Using DDL Commands
121(5)
Using DML Commands
126(6)
Data Access and Manipulation
Understanding Data Access
132(1)
Retrieving Data
133(5)
Using Advanced Data Retrieval
138(3)
Using Batches and Scripts
141(3)
Recognizing and Correcting Syntax Errors
144(5)
Improving Data Access
Understanding Database Monitoring and Optimization
149(2)
Investigating Resources and Configuration Settings
151(12)
Monitoring Performance
163(9)
Recognizing Bottlenecks
172(3)
Using Indexes and Views
175(4)
Using Procedures and Functions
179(5)
Database Administration
Understanding Administration
184(2)
Understanding Roles and Responsibilities
186(2)
Matching Life Cycle Requirements
188(2)
Resolving Administration Issues
190(6)
Managing ``As-Needed'' and Periodic Tasks
196(14)
Transactions and Locking
Understanding Transactions and Locking
210(2)
Understanding Transaction Types
212(7)
Understanding Transaction Isolation and Locking
219(7)
Using Transactions
226(5)
Monitoring Transactions and Clearing Blocked Transactions
231(5)
Data Access and Security
Understanding Data Access and Security
236(2)
Designing for Access and Security
238(4)
Understanding Your Security Environment
242(7)
Managing Security Principals
249(6)
Managing Permissions
255(8)
Managing Backups
263(4)
Supporting Database Applications
Understanding Data Configurations
267(2)
Designing Data Environments
269(8)
Working in a Distributed Environment
277(7)
Using Distributed Queries
284(7)
Using Replication
291(8)
Understanding Data Issues
299
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.