clear-dot.gif
Search for a Title:
AddThis Social Bookmark Button
clear-dot.gif ON NOW: ALL Training CD's on sale for $99.95 CDN!!! clear-dot.gif
clear-dot.gif
   Master Database Optimization - Free Tutorials!
clear-dot.gif
clear-dot.gif
clear-dot.gif clear-dot.gif clear-dot.gif
clear-dot.gif clear-dot.gif clear-dot.gif
clear-dot.gif clear-dot.gif clear-dot.gif
clear-dot.gif
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.
Database Optimization Training
Access the complete Database Optimization Training title online with just your Web browser. Join our Online University and have unlimited access to these tutorials for Database Optimization plus all our 400+ other titles for one low price! LEARN MORE or SIGN UP NOW FOR INSTANT ACCESS
OR
Learn Database Optimization from our PC and Mac compatible CDRom. The affordable price of $124.95 gives you high quality software training that is easy for anyone to understand and follow. Start training straight away with our Free lesson links on the right or BUY THIS CD NOW!

Are you ready to start your learning RIGHT NOW? You can have immediate access to more than 2500 hours of VTC Training just minutes from now, and for the incredibly low price of $30/month OR LESS!

The VTC Online University provides unlimited 24/7 access to ALL of VTC's incredible training content.

-- More Info / Subscribe Now! --

FREE Updates
VTC adds training for new software every week, and with the VTC Online University, you get immediate access to these new titles, for no additional cost! There are currently over 450 different software titles, and more are added EVERY MONTH!

-- More Info / Subscribe Now! --

No Long Term Committment
With the VTC Online University, you can signup for as little as ONE MONTH only! There is no minimum time committment, and you can cancel your membership at any time.

-- More Info / Subscribe Now! --

Training a Group?
Our Multi-User Online Account makes training groups of people efficient and cost effective. Businesses, Schools (from Elementary through Post Secondary), and Government Departments alike all over the world enjoy the freedom and benefits of our online training and tutorials from office, school, home, and on the go.

-- Multi-User Licensing Info --

Database Optimization
- Information About This Title -
Click Here To Purchase
Proper Title: Database Optimization
Description: Click here to open / close full description
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.

-Close-
Instructor: Lauri Matson (more by this author)
Instruction: 111 Tutorials - Duration: 8 hrs
First Release: 2010-02-03
Compatitibility: Vista, XP, NT, 2000, 98, Mac OS9, Mac OS X 10.1+
In Stock? Yes - 2-5 days shipping
Price: $124.95 $99.95 ON SALE!
Click Here To Purchase
Why Learn With VTC?!
  1. Let an expert teach you Database Optimization
  2. No classrooms or schedules - you learn on YOUR terms
  3. No books to read - watch instructional video right on your computer
  4. VTC training methods ensure the highest possible retention and fastest learning
  5. Use VTC materials for future reference / refresher
  6. Share CDRom training with others, friends, colleagues
  7. Used by many schools, universities, and big business world wide
  8. The most cost effective training available for Database Optimization
 
Below is content list for all of the lessons included with the Database Optimization Training. Click on the linked lessons to watch Free. You must have Quicktime installed on your computer - if you are using a recent computer, then chances are you already do.
Free Demo Lessons

Introduction
movie image Introduction & Disclaimers
movie image Optimizing a Database
movie image Some Common Problems

Designing for Performance
movie image Planning & Process Principles
movie image Design Principles
movie image Client/Server Interaction

Troubleshooting & Testing
movie image What to Look for
movie image Types of Testing
movie image SQLdiag Tool


... More lessons below ...

Would you like to continue? You can have instant access to the rest of this training for just $30.00 through our Online University, or you can purchase the CDRom version!

. Subscribe Now!
. Online University Info
. Purchase CDRom Now

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

Relationships & Joins
Relationships
Understanding Joins
Optimizing Joins
Joins & Indexing

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

Data Types & 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 & Using Temporary Tables
Heap & 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 & Distinct Keys
Looking at Indexes in SQL
Optimizing & 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 & 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 & Triggers
Stored Procedures/Functions/Triggers
Writing Stored Procedures
Creating a Function & When to Use
Working with Triggers

Hardware Performance Concepts
CPU & 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 & Deadlocks
Monitoring Services

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

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

Using Baselines & Profiler
Importance of Baselines
SQL Profiler
Trace & 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 & Design
Constraints & Influences
Performance Tuning
Index Checklist
General Checklist

Odds & Ends
Business Intelligence
Archiving
ADONET

Conclusion
Wrap Up & Work Files

Credits
About the Author
clear-dot
blue dot
clear-dot

Want to be notified of new releases and other product information?
Enter your email address below to signup for our newsletter.

clear-dot
blue dot
clear-dot
Online Learning | Contact Us | Tech Support | XML RSS Feed
clear-dot
blue dot

VTC Canada
sales@vtcCanada.com


©2012 VTC Canada All Rights Reserved.