Like us and Save! Join our Mailing List and Save!
FULL CONTACT INFO

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

"One of the MOST EFFECTIVE training tools out on the market today, BAR NONE!!!!!! (and at an affordable price)."Robert McClain Kansas City, KS
COMPLETE COURSE CONTENTS
Free Sample
Section

Click a blue link to evaluate!
Introduction
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
Section

Get all lessons with purchase
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 for Querying
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 Monitoring
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

Optimising Code
Levels of Optimization
UNION vs. OR Optimization
JOIN vs. WHERE
Optimizing 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 Tutor
Purchase Info
This course is available via a 3 month and a 1 year online subscription and is priced as below:
CURRENCY
 
3 Month Online Subscription (90 days)

1 Year Online Subscription
30% OFF!

Item(s):
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.

Worldwide
Shipping
Delivery Details
Subscription Access codes will be sent when payment processed (within one hour average)
|
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


USING THE SAME EXCELLENT CONTENT AS SINGLE USER COURSES
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.

EASILY VIEWED OVER A 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.

ADDITIONAL USERS AND TITLES CAN BE ADDED
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
AutoCAD 2015 for Mac
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...
"We have purchased 11 of these training CDs to date. Their structure and content have improved our technical skills at our own pace. We've extracted ourselves from many a production problem by referring back to the relevant CD."Ian Walsh, Slide FX Ltd, Ireland