Beschreibung
Inhaltsangabe1. Introducing to Data and Data Management 1.1 Identifying Business Data 1.2 Identifying Human Data Sources 1.3 Installing SQL Server 2005 Evaluation Edition 1.4 Learning About SQL Server Management Studio 1.5 Identifying Key Management Areas 2. Introducing Databases and Database Management Systems 2.1. Comparing Database Models 2.2 Identifying DBMS Architecture and Components 2.3 Reviewing Server Hardware Resources 2.4 Investigating SQL Server Databases 2.5 Identifying Application Requirements 3. Data Modeling 3.1 Understanding Data Modeling Concepts 3.2 Recognizing Entities, Attributes, and Identifiers 3.3 Recognizing Relationships 3.4 Reading an ERD 3.5 Creating an ERD 3.6 Viewing Basic Database Objects 4. Designing a Database 4.1. Recognizing Key Concepts 4.2 Converting Relationships 4.3 Reviewing a Normalized Database 4.4 Recognizing Normalization Errors 4.5 Normalizing Data 5. Implementing a Database 5.1 Understanding Terms and Concepts 5.2 Identifying Solution Requirements 5.3 Creating a Database 5.4 Creating Tables, Part 1 5.5 Setting Table Constraints 5.6 Creating Tables, Part 2 6. Understanding the SQL Language 6.1 Understanding Terms and Concepts 6.2 Investigating Help Resources 6.3 Comparing Command Environments 6.4 Using the SELECT Statement 6.5 Using DDL Commands 6.6 Using DML Commands 7. Data Access and Manipulation 7.1 Understanding Data Access 7.2 Retrieving Data 7.3 Using Advanced Data Retrieval 7.4 Using Batches and Scripts 7.5 Recognizing and Correcting Errors 8. Improving Data Access 8.1 Understanding Data Access 8.2 Investigating Resources and Configuration Settings 8.3. Monitoring Performance 8.4. Recognizing Bottlenecks 8.5. Using Views and Indexes 8.6. Using Procedures and Functions 9. Database Administration 9.1 Understanding Administration 9.2 Understanding Roles and Responsibilities 9.3 Matching Lifecycle Requirements 9.4 Resolving Administration Issues 9.5 Managing "As-needed" and Periodic Tasks 10. Transactions and Locking 10.1 Understanding Transactions and Locking 10.2 Understanding Transaction Types 10.3 Understanding Transaction Isolation and Locking 10.4 Using Transactions 10.5 Monitoring Transactions and Clearing Blocked Transactions 11. Data Access and Security 11.1 Understanding Data Access and Security 11.2 Designing for Security 11.3 Understanding Your Security Environment 11.4 Managing Security Principals 11.5 Managing Permissions 11.6 Managing Backups 12. Supporting Database Applications 12.1 Understanding Support Configurations 12.2 Designing Data Environments 12.3 Working in a Distributed Environment 12.4 Using Distributed Queries 12.5 Using Replication 12.6 Understanding Data Issues
Autorenportrait
Inhaltsangabe1. Introducing to Data and Data Management 1.1 Identifying Business Data 1.2 Identifying Human Data Sources 1.3 Installing SQL Server 2005 Evaluation Edition 1.4 Learning About SQL Server Management Studio 1.5 Identifying Key Management Areas 2. Introducing Databases and Database Management Systems 2.1. Comparing Database Models 2.2 Identifying DBMS Architecture and Components 2.3 Reviewing Server Hardware Resources 2.4 Investigating SQL Server Databases 2.5 Identifying Application Requirements 3. Data Modeling 3.1 Understanding Data Modeling Concepts 3.2 Recognizing Entities, Attributes, and Identifiers 3.3 Recognizing Relationships 3.4 Reading an ERD 3.5 Creating an ERD 3.6 Viewing Basic Database Objects 4. Designing a Database 4.1. Recognizing Key Concepts 4.2 Converting Relationships 4.3 Reviewing a Normalized Database 4.4 Recognizing Normalization Errors 4.5 Normalizing Data 5. Implementing a Database 5.1 Understanding Terms and Concepts 5.2 Identifying Solution Requirements 5.3 Creating a Database 5.4 Creating Tables, Part 1 5.5 Setting Table Constraints 5.6 Creating Tables, Part 2 6. Understanding the SQL Language 6.1 Understanding Terms and Concepts 6.2 Investigating Help Resources 6.3 Comparing Command Environments 6.4 Using the SELECT Statement 6.5 Using DDL Commands 6.6 Using DML Commands 7. Data Access and Manipulation 7.1 Understanding Data Access 7.2 Retrieving Data 7.3 Using Advanced Data Retrieval 7.4 Using Batches and Scripts 7.5 Recognizing and Correcting Errors 8. Improving Data Access 8.1 Understanding Data Access 8.2 Investigating Resources and Configuration Settings 8.3. Monitoring Performance 8.4. Recognizing Bottlenecks 8.5. Using Views and Indexes 8.6. Using Procedures and Functions 9. Database Administration 9.1 Understanding Administration 9.2 Understanding Roles and Responsibilities 9.3 Matching Lifecycle Requirements 9.4 Resolving Administration Issues 9.5 Managing "As-needed" and Periodic Tasks 10. Transactions and Locking 10.1 Understanding Transactions and Locking 10.2 Understanding Transaction Types 10.3 Understanding Transaction Isolation and Locking 10.4 Using Transactions 10.5 Monitoring Transactions and Clearing Blocked Transactions 11. Data Access and Security 11.1 Understanding Data Access and Security 11.2 Designing for Security 11.3 Understanding Your Security Environment 11.4 Managing Security Principals 11.5 Managing Permissions 11.6 Managing Backups 12. Supporting Database Applications 12.1 Understanding Support Configurations 12.2 Designing Data Environments 12.3 Working in a Distributed Environment 12.4 Using Distributed Queries 12.5 Using Replication 12.6 Understanding Data Issues
Leseprobe
Leseprobe
