Database Optimization

Visuel non disponible

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.

Formateur : Lauri Matson
Enregistré sur PC | Langue: Anglais
Durée : 8 | Leçons: 111

Compatible Mac, Windows & iPad (en VOD)
143,52 € En stock

Acheter sur CD
ou DVD
Acheter des Crédits
pour Consultation
En savoir plus >>


TVA incluse, Hors Livraison 143,52 €

Accès à l'unité

Cette formation nécessite crédits

10 Crédits 10,00 € TTC commander
35 Crédits 30,00 € TTC commander
60 Crédits 50,00 € TTC commander
130 Crédits 100,00 € TTC commander

  • Conducting an Audit

    • (03:55) Understanding Audits
    • (03:27) Components of Audits
    • (04:33) Examples of Components
    • (04:15) Creating Audits Through Procedures

  • Relationships & Joins

    • (05:12) Relationships
    • (05:39) Understanding Joins
    • (06:05) Optimizing Joins
    • (02:15) Joins & Indexing

  • Referential Integrity

    • (02:39) Proper Use of Integrity
    • (06:15) Integrity Continued
    • (05:31) Primary/Foreign/Candidate Keys
    • (05:03) Troubleshooting Integrity

  • Data Types & Validations

    • (02:02) Unions
    • (03:11) UNION in SQL
    • (05:30) Standards
    • (04:54) Validation

  • Creating a Data Model

    • (05:37) Conceptual/Logical/Physical Models
    • (04:41) Relational Modeling
    • (03:04) Entity Model
    • (04:23) Schemas

  • Database Normalization

    • (04:31) First Normal Form
    • (04:39) Second Normal Form
    • (03:33) Third Normal Form
    • (06:26) Denormalization

  • Temporary Tables

    • (03:54) Creating & Using Temporary Tables
    • (03:08) Heap & Memory Tables
    • (05:16) EXPLAIN Statement

  • Query/Views Optimization

    • (04:45) Introduction to Execution Plans
    • (05:07) Running the SQL Execution Plan
    • (04:41) Using Profiler for the Execution Plan
    • (04:15) SET SHOWPLAN_TEXT

  • Index Strategies

    • (06:31) Effective Indexes
    • (04:25) Short & Distinct Keys
    • (03:18) Looking at Indexes in SQL
    • (05:35) Optimizing & Indexes

  • Clustered Indexes

    • (04:42) Clustered vs. Non-Clustered Indexes
    • (03:47) Tips for Clustered Indexes
    • (05:57) Significance on Performance

  • More Tuning

    • (05:10) Eliminating Unwanted Data
    • (02:43) SHRINKFILE Examples
    • (02:17) Database Tuning Advisor
    • (05:50) DTA Example

  • Data Types & Quality

    • (05:16) Data Quality
    • (03:08) Overview of Data Types
    • (03:28) SQL vs. Oracle Data Types
    • (03:09) Examples in SQL

  • Best Practices

    • (05:08) Creating a Sustainable Database
    • (05:04) Documentation
    • (04:18) Most Common Practices

  • Stored Procedures & Triggers

    • (04:53) Stored Procedures/Functions/Triggers
    • (05:18) Writing Stored Procedures
    • (04:33) Creating a Function & When to Use
    • (04:43) Working with Triggers

  • Hardware Performance Concepts

    • (03:58) CPU & Input/Output
    • (03:57) Memory Management
    • (04:52) Network Infrastructure

  • Applying Performance Concepts

    • (03:31) Task Manager
    • (02:20) System vs. Performance Monitor
    • (05:13) Performance Monitor
    • (02:24) SQL Database I/O Report
    • (03:04) Examples for sys.dm_io_virtual_file_stats

  • Monitoring

    • (05:49) Event Viewer
    • (05:41) SQL Activity Monitor
    • (04:47) Locks & Deadlocks
    • (03:03) Monitoring Services

  • Database Security

    • (03:56) Privileges
    • (04:24) Role Based Authorization
    • (04:19) GRANT & REVOKE Statements
    • (03:08) Reviewing Security in SQL

  • Understanding Lifecycles

    • (05:39) Lifecycle Management
    • (05:22) The Database Lifecycle
    • (05:06) Using the SQL Management Plan

  • Using Baselines & Profiler

    • (03:34) Importance of Baselines
    • (05:00) SQL Profiler
    • (03:36) Trace & Other Profiler Tools
    • (01:45) Terminology in Work Files

  • Analyzing Slow Performance

    • (05:22) Database Testing
    • (04:57) Thoughts on Troubleshooting
    • (03:42) Generalized Tips

  • Optimizing Code

    • (02:46) Levels of Optimization
    • (02:17) UNION vs. OR Optimization
    • (02:14) JOIN vs. WHERE
    • (02:52) Weak Joins
    • (04:35) Coding Tips

  • Statistics

    • (02:57) Overview of Statistics
    • (04:35) Seeing Statistics in SQL
    • (03:48) Auditing
    • (02:52) Auditing in SQL

  • Other Components

    • (03:34) Database Consistency Checker (DBCC)
    • (03:03) DBCC in SQL
    • (02:28) System Catalog
    • (03:01) System Catalog in SQL

  • Checklists

    • (03:34) Architecture & Design
    • (04:36) Constraints & Influences
    • (05:17) Performance Tuning
    • (03:52) Index Checklist
    • (03:53) General Checklist

  • Odds & Ends

    • (04:16) Business Intelligence
    • (05:15) Archiving
    • (03:29) ADONET

  • Conclusion

    • (03:17) Wrap Up & Work Files

  • Credits

    • (01:58) About the Author
Formateur : Lauri Matson
Langue : Anglais
Durée : 8
Nombre de séquences vidéo : 111 		SKU : 34078
Réf :
ISBN : 1-935320-94-7

Descriptif :

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.




Lauri Matson

Lauri Matson owns and operates a successful consulting business specializing in accounting and computerization. Her company assists small and midsized companies with accounting, networking, and administrative solutions. She has over 30 years of accounting and administrative experience and has taught over 20,000 students in seminar and college settings. As an active consultant, she combines the day-to-day hands-on experience with the tips and tricks that are necessary to successfully incorporate an optimized database in today’s business intelligence systems.

Vous souhaitez recevoir l'aide d'un formateur expérimenté pour parfaire votre apprentissage ? C'est possible grâce a notre centre de formation accompagnée a distance.

Nouveaux Parcours

Tous les parcours »
  • Profitez de conseils personnalisés grâce a des entretiens téléphoniques réguliers avec votre formateur.
  • Confrontez-vous a la réalité des entreprises grâce aux exercices proposés pendant la formation.
  • Obtenez une Attestation de Formation Professionnelle.
  • Contactez-nous pour le financement de votre formation par votre OPCA.