Wiley Pathways Introduction to Database Management Project Manual

<p>1 Introduction to Data and Data Management</p>
<p>1.1 Identifying Business Data 2</p>
<p>1.2 Identifying Human Data Sources4</p>
<p>1.3 Installing SQL Server 2005 Evaluation Edition 5</p>
<p>1.4 Learning About SQL Server Management Studio 12</p>
<p>1.5 Identifying Key Management Areas 19</p>
<p>2 Introducing Databases and Database Management Systems</p>
<p>2.1 Comparing Database Models21</p>
<p>2.2 Identifying DBMS Architecture and Components 23</p>
<p>2.3 Reviewing Server Hardware Resources24</p>
<p>2.4 Investigating SQL Server Databases 32</p>
<p>2.5 Identifying Application Requirements 35</p>
<p>3 Data Modeling</p>
<p>3.1 Understanding Data Modeling Concepts39</p>
<p>3.2 Recognizing Entities, Attributes, and Identifiers 40</p>
<p>3.3 Recognizing Relationships and Business Rules 42</p>
<p>3.4 Reading an ERD 45</p>
<p>3.5 Creating an ERD 47</p>
<p>3.6 Viewing Basic Database Objects 50</p>
<p>4 Designing a Database</p>
<p>4.1 Understanding Key Concepts 59</p>
<p>4.2 Converting Relationships 60</p>
<p>4.3 Reviewing a Normalized Database 65</p>
<p>4.4 Recognizing Normalization Errors 69</p>
<p>4.5 Normalizing Data 73</p>
<p>5 Implementing a Database</p>
<p>5.1 Understanding Terms and Concepts 78</p>
<p>5.2 Identifying Solution Requirements 79</p>
<p>5.3 Creating a Database 84</p>
<p>5.4 Creating Tables, Part 1 88</p>
<p>5.5 Setting Table Constraints 91</p>
<p>5.6 Creating Tables, Part 2 96</p>
<p>6 Understanding the SQL Language</p>
<p>6.1 Understanding Terms and Concepts 102</p>
<p>6.2 Identifying Help Resources 104</p>
<p>6.3 Comparing Command Environments 111</p>
<p>6.4 Using the SELECT Command 116</p>
<p>6.5 Using DDL Commands 121</p>
<p>6.6 Using DML Commands 126</p>
<p>7 Data Access and Manipulation</p>
<p>7.1 Understanding Data Access 132</p>
<p>7.2 Retrieving Data 133</p>
<p>7.3 Using Advanced Data Retrieval 138</p>
<p>7.4 Using Batches and Scripts 141</p>
<p>7.5 Recognizing and Correcting Syntax Errors 144</p>
<p>8 Improving Data Access</p>
<p>8.1 Understanding Database Monitoring and Optimization 149</p>
<p>8.2 Investigating Resources and Configuration Settings 151</p>
<p>8.3 Monitoring Performance 163</p>
<p>8.4 Recognizing Bottlenecks 172</p>
<p>8.5 Using Indexes and Views 175</p>
<p>8.6 Using Procedures and Functions 179</p>
<p>9 Database Administration</p>
<p>9.1 Understanding Administration 184</p>
<p>9.2 Understanding Roles and Responsibilities 186</p>
<p>9.3 Matching Life Cycle Requirements 188</p>
<p>9.4 Resolving Administration Issues 190</p>
<p>9.5 Managing "As–Needed" and Periodic Tasks 196</p>
<p>10 Transactions and Locking</p>
<p>10.1 Understanding Transactions and Locking 210</p>
<p>10.2 Understanding Transaction Types 212</p>
<p>10.3 Understanding Transaction Isolation and Locking 219</p>
<p>10.4 Using Transactions 226</p>
<p>10.5 Monitoring Transactions and Clearing Blocked Transactions 231</p>
<p>11 Data Access and Security</p>
<p>11.1 Understanding Data Access and Security 236</p>
<p>11.2 Designing for Access and Security 238</p>
<p>11.3 Understanding Your Security Environment 242</p>
<p>11.4 Managing Security Principals 249</p>
<p>11.5 Managing Permissions 255</p>
<p>11.6 Managing Backups 263</p>
<p>12 Supporting Database Applications</p>
<p>12.1 Understanding Data Configurations 267</p>
<p>12.2 Designing Data Environments 269</p>
<p>12.3 Working in a Distributed Environment 277</p>
<p>12.4 Using Distributed Queries 284</p>
<p>12.5 Using Replication 291</p>
<p>12.6 Understanding Data Issues 299</p>