{"product_id":"wiley-pathways-introduction-to-database-management-project-manual-paperback-softback-9780470114100","title":"Wiley Pathways Introduction to Database Management, Project Manual (Paperback \/ softback) 9780470114100","description":"\u003cfont face=\"Georgia\"\u003e\r\n\u003cp\u003e\u003cfont size=\"6\"\u003eWiley Pathways Introduction to Database Management, Project Manual\u003c\/font\u003e\u003cbr\u003e\r\n\r\n\r\n\r\n\r\n\r\n\u003c\/p\u003e\n\u003cp\u003e\u003cfont size=\"4\"\u003eMark L. Gillenson (Author), Paulraj Ponniah (Author), Alex Kriegel (Author), Boris M. Trukhnov (Author), Allen G. Taylor (Author), Gavin Powell (Author), Frank Miller (With)\u003c\/font\u003e\u003c\/p\u003e\r\n\r\n\u003cp\u003e\u003cfont size=\"3\"\u003e9780470114100, Wiley\u003c\/font\u003e\u003c\/p\u003e\r\n\r\n\u003cp\u003e\u003cfont size=\"3\"\u003ePaperback \/ softback, published 4 May 2007\u003c\/font\u003e\u003c\/p\u003e\r\n\r\n\u003cp\u003e\u003cfont size=\"3\"\u003e312 pages\u003cbr\u003e27.7 x 21.6 x 2 cm, 0.612 kg\u003c\/font\u003e\u003c\/p\u003e\r\n\r\n\r\n\r\n\r\n\r\n\u003cp align=\"justify\"\u003e\u003cstrong\u003e\u003cfont size=\"3\"\u003eYou can get there\u003cbr\u003e \u003cbr\u003e 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:\u003cbr\u003e * Install SQL Server 2005\u003cbr\u003e * Read and create an ERD\u003cbr\u003e * Design and implement a database\u003cbr\u003e * Use DDL and DML commands\u003cbr\u003e * Use and monitor transactions\u003cbr\u003e * Manage security principles, permissions, and backups\u003cbr\u003e * Design data environments\u003cbr\u003e * Use replication\u003cbr\u003e \u003cbr\u003e 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.\u003cbr\u003e \u003cbr\u003e Introduction to Databases Project Manual is an excellent companion to Gillenson's Introduction to Databases (ISBN: 978-0-470-10186-5).\u003cbr\u003e \u003cbr\u003e Wiley Pathways helps you achieve your goals\u003cbr\u003e \u003cbr\u003e 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.\u003c\/font\u003e\u003c\/strong\u003e\u003c\/p\u003e\r\n\r\n\u003cp\u003e\u003cfont size=\"3\"\u003e\u003cp\u003e\u003cb\u003e1 Introduction to Data and Data Management\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003e1.1 Identifying Business Data 2\u003c\/p\u003e \u003cp\u003e1.2 Identifying Human Data Sources 4\u003c\/p\u003e \u003cp\u003e1.3 Installing SQL Server 2005 Evaluation Edition 5\u003c\/p\u003e \u003cp\u003e1.4 Learning about SQL Server Management Studio 12\u003c\/p\u003e \u003cp\u003e1.5 Identifying Key Management Areas 19\u003c\/p\u003e \u003cp\u003e\u003cb\u003e2 Introducing Databases and Database Management Systems\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003e2.1 Comparing Database Models 21\u003c\/p\u003e \u003cp\u003e2.2 Identifying DBMS Architecture and Components 23\u003c\/p\u003e \u003cp\u003e2.3 Reviewing Server Hardware Resources 24\u003c\/p\u003e \u003cp\u003e2.4 Investigating SQL Server Databases 32\u003c\/p\u003e \u003cp\u003e2.5 Identifying Application Requirements 35\u003c\/p\u003e \u003cp\u003e\u003cb\u003e3 Data Modeling\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003e3.1 Understanding Data Modeling Concepts 39\u003c\/p\u003e \u003cp\u003e3.2 Recognizing Entities, Attributes, and Identifiers 40\u003c\/p\u003e \u003cp\u003e3.3 Recognizing Relationships and Business Rules 42\u003c\/p\u003e \u003cp\u003e3.4 Reading an ERD 45\u003c\/p\u003e \u003cp\u003e3.5 Creating an ERD 47\u003c\/p\u003e \u003cp\u003e3.6 Viewing Basic Database Objects 50\u003c\/p\u003e \u003cp\u003e\u003cb\u003e4 Designing a Database\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003e4.1 Understanding Key Concepts 59\u003c\/p\u003e \u003cp\u003e4.2 Converting Relationships 60\u003c\/p\u003e \u003cp\u003e4.3 Reviewing a Normalized Database 65\u003c\/p\u003e \u003cp\u003e4.4 Recognizing Normalization Errors 69\u003c\/p\u003e \u003cp\u003e4.5 Normalizing Data 73\u003c\/p\u003e \u003cp\u003e\u003cb\u003e5 Implementing a Database\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003e5.1 Understanding Terms and Concepts 78\u003c\/p\u003e \u003cp\u003e5.2 Identifying Solution Requirements 79\u003c\/p\u003e \u003cp\u003e5.3 Creating a Database 84\u003c\/p\u003e \u003cp\u003e5.4 Creating Tables, Part 1 88\u003c\/p\u003e \u003cp\u003e5.5 Setting Table Constraints 91\u003c\/p\u003e \u003cp\u003e5.6 Creating Tables, Part 2 96\u003c\/p\u003e \u003cp\u003e\u003cb\u003e6 Understanding the SQL Language\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003e6.1 Understanding Terms and Concepts 102\u003c\/p\u003e \u003cp\u003e6.2 Identifying Help Resources 104\u003c\/p\u003e \u003cp\u003e6.3 Comparing Command Environments 111\u003c\/p\u003e \u003cp\u003e6.4 Using the SELECT Command 116\u003c\/p\u003e \u003cp\u003e6.5 Using DDL Commands 121\u003c\/p\u003e \u003cp\u003e6.6 Using DML Commands 126\u003c\/p\u003e \u003cp\u003e\u003cb\u003e7 Data Access and Manipulation\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003e7.1 Understanding Data Access 132\u003c\/p\u003e \u003cp\u003e7.2 Retrieving Data 133\u003c\/p\u003e \u003cp\u003e7.3 Using Advanced Data Retrieval 138\u003c\/p\u003e \u003cp\u003e7.4 Using Batches and Scripts 141\u003c\/p\u003e \u003cp\u003e7.5 Recognizing and Correcting Syntax Errors 144\u003c\/p\u003e \u003cp\u003e\u003cb\u003e8 Improving Data Access\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003e8.1 Understanding Database Monitoring and Optimization 149\u003c\/p\u003e \u003cp\u003e8.2 Investigating Resources and Configuration Settings 151\u003c\/p\u003e \u003cp\u003e8.3 Monitoring Performance 163\u003c\/p\u003e \u003cp\u003e8.4 Recognizing Bottlenecks 172\u003c\/p\u003e \u003cp\u003e8.5 Using Indexes and Views 175\u003c\/p\u003e \u003cp\u003e8.6 Using Procedures and Functions 179\u003c\/p\u003e \u003cp\u003e\u003cb\u003e9 Database Administration\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003e9.1 Understanding Administration 184\u003c\/p\u003e \u003cp\u003e9.2 Understanding Roles and Responsibilities 186\u003c\/p\u003e \u003cp\u003e9.3 Matching Life Cycle Requirements 188\u003c\/p\u003e \u003cp\u003e9.4 Resolving Administration Issues 190\u003c\/p\u003e \u003cp\u003e9.5 Managing \"As-Needed\" and Periodic Tasks 196\u003c\/p\u003e \u003cp\u003e\u003cb\u003e10 Transactions and Locking\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003e10.1 Understanding Transactions and Locking 210\u003c\/p\u003e \u003cp\u003e10.2 Understanding Transaction Types 212\u003c\/p\u003e \u003cp\u003e10.3 Understanding Transaction Isolation and Locking 219\u003c\/p\u003e \u003cp\u003e10.4 Using Transactions 226\u003c\/p\u003e \u003cp\u003e10.5 Monitoring Transactions and Clearing Blocked Transactions 231\u003c\/p\u003e \u003cp\u003e\u003cb\u003e11 Data Access and Security\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003e11.1 Understanding Data Access and Security 236\u003c\/p\u003e \u003cp\u003e11.2 Designing for Access and Security 238\u003c\/p\u003e \u003cp\u003e11.3 Understanding Your Security Environment 242\u003c\/p\u003e \u003cp\u003e11.4 Managing Security Principals 249\u003c\/p\u003e \u003cp\u003e11.5 Managing Permissions 255\u003c\/p\u003e \u003cp\u003e11.6 Managing Backups 263\u003c\/p\u003e \u003cp\u003e\u003cb\u003e12 Supporting Database Applications\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003e12.1 Understanding Data Configurations 267\u003c\/p\u003e \u003cp\u003e12.2 Designing Data Environments 269\u003c\/p\u003e \u003cp\u003e12.3 Working in a Distributed Environment 277\u003c\/p\u003e \u003cp\u003e12.4 Using Distributed Queries 284\u003c\/p\u003e \u003cp\u003e12.5 Using Replication 291\u003c\/p\u003e \u003cp\u003e12.6 Understanding Data Issues 299\u003c\/p\u003e\u003c\/font\u003e\u003c\/p\u003e\r\n\r\n\u003cp\u003e\u003cfont size=\"3\"\u003eSubject Areas: Computer networking \u0026amp; communications [\u003ca title=\"See our other books on Computer networking \u0026amp; communications\" href=\"https:\/\/freshlyprintedbooks.co.uk\/search?q=%22Computer%20networking%20\u0026amp;%20communications%20%5BUT%5D%22\"\u003eUT\u003c\/a\u003e]\u003c\/font\u003e\u003c\/p\u003e\r\n\r\n\r\n\u003c\/font\u003e","brand":"Wiley","offers":[{"title":"Brand New","offer_id":52257072742680,"sku":"9780470114100","price":41.96,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0730\/2037\/5320\/files\/9780470114100.jpg?v=1781276289","url":"https:\/\/freshlyprintedbooks.co.uk\/products\/wiley-pathways-introduction-to-database-management-project-manual-paperback-softback-9780470114100","provider":"Freshly Printed Books","version":"1.0","type":"link"}