[HF.com] VTC.Com Database Optimization

[Nguyen Trung Hoa]

VTC.Com Database Optimization | 317 MB

This Database Optimization course provides viewers with important techniques and checklists to configure, monitor, and manage their databases. You will learn how to develop a tuning strategy, explore the tuning and diagnostic tools, understand the relational database model and implications on performance, evaluate the application for efficient design, structure, and other factors affecting performance and evaluate hardware for effects on performance. Join us as we review best practices in designing, optimizing, and maintaining your database. You will benefit from this course whether you have some experience with optimizing databases or are just starting out. Work files are included. To begin learning today, simply click on the movie links.


Introduction:
Introduction and Disclaimers
Optimizing a Database
Some Common Problems

Designing for Performance:
Planning and Process Principles
Design Principles
Client/Server Interaction

Troubleshooting and Testing:
What to Look for
Types of Testing
SQLdiag Tool

Conducting an Audit:
Understanding Audits
Components of Audits
Examples of Components
Creating Audits Through Procedures

Relationships and Joins:
Relationships
Understanding Joins
Optimizing Joins
Joins and Indexing

Referential Integrity:
Proper Use of Integrity
Integrity Continued
Primary/Foreign/Candidate Keys
Troubleshooting Integrity

Data Types and Validations:
Unions
UNION in SQL
Standards
Validation

Creating a Data Model:
Conceptual/Logical/Physical Models
Relational Modeling
Entity Model
Schemas

Database Normalization:
First Normal Form
Second Normal Form
Third Normal Form
Denormalization

Temporary Tables:
Creating and Using Temporary Tables
Heap and Memory Tables
EXPLAIN Statement

Query/Views Optimization:
Introduction to Execution Plans
Running the SQL Execution Plan
Using Profiler for the Execution Plan
SET SHOWPLAN_TEXT

Index Strategies:
Effective Indexes
Short and Distinct Keys
Looking at Indexes in SQL
Optimizing and Indexes

Clustered Indexes:
Clustered vs. Non-Clustered Indexes
Tips for Clustered Indexes
Significance on Performance

More Tuning:
Eliminating Unwanted Data
SHRINKFILE Examples
Database Tuning Advisor
DTA Example

Data Types and Quality:
Data Quality
Overview of Data Types
SQL vs. Oracle Data Types
Examples in SQL

Best Practices:
Creating a Sustainable Database
Documentation
Most Common Practices

Stored Procedures and Triggers:
Stored Procedures/Functions/Triggers
Writing Stored Procedures
Creating a Function and When to Use
Working with Triggers

Hardware Performance Concepts:
CPU and Input/Output
Memory Management
Network Infrastructure

Applying Performance Concepts:
Task Manager
System vs. Performance Monitor
Performance Monitor
SQL Database I/O Report
Examples for sys.dm_io_virtual_file_stats

Monitoring:
Event Viewer
SQL Activity Monitor
Locks and Deadlocks
Monitoring Services

Database Security:
Privileges
Role Based Authorization
GRANT and REVOKE Statements
Reviewing Security in SQL

Understanding Lifecycles:
Lifecycle Management
The Database Lifecycle
Using the SQL Management Plan

Using Baselines and Profiler:
Importance of Baselines
SQL Profiler
Trace and Other Profiler Tools
Terminology in Work Files

Analyzing Slow Performance:
Database Testing
Thoughts on Troubleshooting
Generalized Tips

Optimizing Code:
Levels of Optimization
UNION vs. OR Optimization
JOIN vs. WHERE
Weak Joins
Coding Tips

Statistics:
Overview of Statistics
Seeing Statistics in SQL
Auditing
Auditing in SQL

Other Components:
Database Consistency Checker (DBCC)
DBCC in SQL
System Catalog
System Catalog in SQL

Checklists:
Architecture and Design
Constraints and Influences
Performance Tuning
Index Checklist
General Checklist

Odds and Ends:
Business Intelligence
Archiving
ADONET

Conclusion:
Wrap Up and Work Files

Code:

http://hotfile.com/dl/23536740/949e856/VTC.Com.Database.Optimization.part1.rar.html
http://hotfile.com/dl/23537286/47f28f3/VTC.Com.Database.Optimization.part2.rar.html
http://hotfile.com/dl/23537945/0da7c2b/VTC.Com.Database.Optimization.part3.rar.html
http://hotfile.com/dl/23538072/8115ac4/VTC.Com.Database.Optimization.part4.rar.html