Like us and Save! Join our Mailing List and Save!

Database Optimization Tutorial

A professionally created, self-study video training course
Includes 8 hours of easy to follow Database Optimization video tutorials presented by an industry expert.
The training is delivered to your desktop allowing you to learn at a time that suits you and at your own pace.
You can start learning online right away. Sample Database Optimization tutorial videos by clicking a blue link below:
  • Tutor: Lauri Matson
  • Duration: 8 hours
  • Video lessons: 111
  • Product code: 34078
  • In stock: YES
  • Available on: Online Subscription
  • Work files included: YES
  • Works on: MS Windows PC & Mac
  • Recommended: SQL / Oracle Tutorials
Get the very most out of your data and learn valuable techniques and skills to configure, monitor and manage your database with the help of this easy-to-follow, Database Optimisation tutorial.

Presented by expert Database trainer Lauri Matson, he uses step-by-step video training movies to help demonstrate and explain important database optimisation concepts and techniques, which will help users to develop a tuning strategy for maximum performance, evaluate applications and structures for efficient design, grasp best practices for designing, optimising and maintaining your database and so much more.

This course is applicable to all mainstream database solutions including Microsoft SQL Server (where demonstrations are shown), MS Access, Oracle and MySQL.

You can view the full training contents below and start learning right away, click any blue linked lesson to access the FREE Database Optimisation video tutorials downloadable from this web page...
What Our Customers Are Saying

"With all the training Manuals I've purchased, I must say that this is the best instructional on this piece of software i've come across. I feel that I will now be able to tap into that power with this excellent tutorial."Ian Ramsden, Fusion Systems;
Free Sample

Click a blue link to evaluate!
Introduction & Disclaimers
Optimizing a Database
Some Common Problems

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

Troubleshooting & Testing
What to Look for
Types of Testing
SQLdiag Tool
We hope you enjoyed the free lessons. To view the complete contents, including all lessons below & above, please purchase the full course via online subscription.
Paid Content

Get all lessons with purchase
Conducting an Audit
Understanding Audits
Components of Audits
Examples of Components
Creating Audits Through Procedures

Relationships & Joins
Understanding Joins
Optimizing Joins
Joins & Indexing

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

Data Types & Validations

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

Database Normalization
First Normal Form
Second Normal Form
Third Normal Form

Temporary Tables
Creating & Using Temporary Tables
Heap & Memory Tables
EXPLAIN Statement

Query/Views Optimization
Introduction to Execution Plans for Querying
Running the SQL Execution Plan
Using Profiler for the Execution Plan

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
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
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 Monitoring
SQL Database I/O Report
Examples for sys.dm_io_virtual_file_stats

Event Viewer
SQL Activity Monitor
Locks & Deadlocks
Monitoring Services

Database Security
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

Optimising Code
Levels of Optimization
UNION vs. OR Optimization
Optimizing Weak Joins
Coding Tips

Overview of Statistics
Seeing Statistics in SQL
Auditing in SQL

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

Architecture & Design
Constraints & Influences
Performance Tuning
Index Checklist
General Checklist

Odds & Ends
Business Intelligence

Wrap Up & Work Files

About the Tutor
Purchase Info
This course is available via a 3 month and a 1 year online subscription and is priced as below:
3 Month Online Subscription (90 days)

1 Year Online Subscription
30% OFF!

Once subscribed, you will receive 111 Database Optimization training videos (listed left), lasting a total of 8 hours.

*no further discounts can be applied to the online subscription.

Delivery Details
Subscription Access codes will be sent when payment processed (within one hour average)
All DVD courses have a 100% money back guarantee. If you are not happy with your course contact us within 30 days of purchase for a refund.
View our full product guarantee
Need to Train Multiple Users?
This Database Optimization course is available in multi-user format ideal for corporate users, schools and universities.

The course loads directly onto your server and delivered to multiple users over your network.

An unlimited number of users can access the training with a pre-determined number viewing the tuition at any one time.

Training Multiple Users

Load onto your server
Deliver on your network or existing learning management system

For companies and educational establishments wanting multi user access to training resources, we offer this Database Optimization course to do just that.
Now you can integrate training or technical support within your own computer network, or allow employees or students to gain access to training and support from home or any other location that they can gain access to your organizations network.

The courses can be played over a LAN using a standard browser such as Microsoft Internet Explorer, Safari or Firefox.
The movies are viewed using Adobe Flash (same method as YouTube) and are slightly compressed in order to not clog the network.
All advanced and the "for dummies" courses are available via this multi user solution and can be copied directly to a hard disk for faster access and the access page may be customized, if needed, using a html editor.

More than one title can exist on your server and the supplied player will automatically show titles that are available.
Simply purchase more user licences (supplied as files) and drop them into the folder. This will automatically increase the number of users allowed onto the system. All purchases are backed up by excellent after-sales support team and easy to follow instruction manual.
You can order multi user online or speak to our knowledgeable sales team.
Multi users are sold in 10 user licenses. For each 10 user licenses, you can have up to 10 people viewing that training at any one time.
Closely Related Courses
We recommend the Beginners SQL Tutorial
We also recommend the Oracle 12c
Prove Your Capabilities
Once a course is completed you can download a free certificate.

This certifies that you have started from the beginners level, have now viewed all instruction. The certificate advises you now possess essential skills and an in-depth knowledge of Database Optimization. Show your boss or potential employer!
Weekly Specials
    Get 10% Off Today! Join our Email Newsletter
This Weeks Special Offer
See the new and discounted
SketchUp Pro 2015
Recommended courses to watch next
Beginners Oracle PL/SQL | Real Application Clusters in Oracle 11g | Microsoft SQL Server 2008 Development | Microsoft SQL Server 2012 Certification Exam 70-463 | Beginners Oracle 11g Tutorial | Complete Range of Oracle Tutorials | Data Modeling | Microsoft SQL Reporting Services | Complete Range of Microsoft Access Tutorials | Crystal Reports 2011
A recent customer speaks out...
"I received my Civil 3d training cd today and I wanted to send a thank you email. I am very pleased with your service. I also have the Revit Architecture training cd. I first ordered this as a download, and upon having difficulty I was very pleased with your prompt fix to the problem by sending the cd instead of using the download program. Again I thank you and look forward to future business with you."Brett Carmer, Indiana