| Database Optimization Tutorials Online |
 |
|
Description Database Optimization
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. |
| Sample - Preview the First 3 chapters of Database Optimization video free. Free learning Database Optimization online. |
01 Introduction
0101 Introduction & Disclaimers
0102 Optimizing a Database
0103 Some Common Problems
02 Designing for Performance
0201 Planning & Process Principles
0202 Design Principles
0203 Client/Server Interaction
03 Troubleshooting & Testing
0301 What to Look for
0302 Types of Testing
0303 SQLdiag Tool
04 Conducting an Audit
0401 Understanding Audits
0402 Components of Audits
0403 Examples of Components
0404 Creating Audits Through Procedures
05 Relationships & Joins
0501 Relationships
0502 Understanding Joins
0503 Optimizing Joins
0504 Joins & Indexing
06 Referential Integrity
0601 Proper Use of Integrity
0602 Integrity Continued
0603 Primary/Foreign/Candidate Keys
0604 Troubleshooting Integrity
07 Data Types & Validations
0701 Unions
0702 UNION in SQL
0703 Standards
0704 Validation
08 Creating a Data Model
0801 Conceptual/Logical/Physical Models
0802 Relational Modeling
0803 Entity Model
0804 Schemas
09 Database Normalization
0901 First Normal Form
0902 Second Normal Form
0903 Third Normal Form
0904 Denormalization
10 Temporary Tables
1001 Creating & Using Temporary Tables
1002 Heap & Memory Tables
1003 EXPLAIN Statement
11 Query/Views Optimization
1101 Introduction to Execution Plans
1102 Running the SQL Execution Plan
1103 Using Profiler for the Execution Plan
1104 SET SHOWPLAN_TEXT
12 Index Strategies
1201 Effective Indexes
1202 Short & Distinct Keys
1203 Looking at Indexes in SQL
1204 Optimizing & Indexes
13 Clustered Indexes
1301 Clustered vs. Non-Clustered Indexes
1302 Tips for Clustered Indexes
1303 Significance on Performance
14 More Tuning
1401 Eliminating Unwanted Data
1402 SHRINKFILE Examples
1403 Database Tuning Advisor
1404 DTA Example
15 Data Types & Quality
1501 Data Quality
1502 Overview of Data Types
1503 SQL vs. Oracle Data Types
1504 Examples in SQL
16 Best Practices
1601 Creating a Sustainable Database
1602 Documentation
1603 Most Common Practices
17 Stored Procedures & Triggers
1701 Stored Procedures/Functions/Triggers
1702 Writing Stored Procedures
1703 Creating a Function & When to Use
1704 Working with Triggers
18 Hardware Performance Concepts
1801 CPU & Input/Output
1802 Memory Management
1803 Network Infrastructure
19 Applying Performance Concepts
1901 Task Manager
1902 System vs. Performance Monitor
1903 Performance Monitor
1904 SQL Database I/O Report
1905 Examples for sys.dm_io_virtual_file_stats
20 Monitoring
2001 Event Viewer
2002 SQL Activity Monitor
2003 Locks & Deadlocks
2004 Monitoring Services
21 Database Security
2101 Privileges
2102 Role Based Authorization
2103 GRANT & REVOKE Statements
2104 Reviewing Security in SQL
22 Understanding Lifecycles
2201 Lifecycle Management
2202 The Database Lifecycle
2203 Using the SQL Management Plan
23 Using Baselines & Profiler
2301 Importance of Baselines
2302 SQL Profiler
2303 Trace & Other Profiler Tools
2304 Terminology in Work Files
24 Analyzing Slow Performance
2401 Database Testing
2402 Thoughts on Troubleshooting
2403 Generalized Tips
25 Optimizing Code
2501 Levels of Optimization
2502 UNION vs. OR Optimization
2503 JOIN vs. WHERE
2504 Weak Joins
2505 Coding Tips
26 Statistics
2601 Overview of Statistics
2602 Seeing Statistics in SQL
2603 Auditing
2604 Auditing in SQL
27 Other Components
2701 Database Consistency Checker (DBCC)
2702 DBCC in SQL
2703 System Catalog
2704 System Catalog in SQL
28 Checklists
2801 Architecture & Design
2802 Constraints & Influences
2803 Performance Tuning
2804 Index Checklist
2805 General Checklist
29 Odds & Ends
2901 Business Intelligence
2902 Archiving
2903 ADONET
30 Conclusion
3001 Wrap Up & Work Files
31 Credits
3101 About the Author
sku |
|
