Self Study, Tutorial Video on CD - DVD. The tutor guides you using step-by-step examples. Learn directly from your own desk high quality training videos at an affordable price. Works on both PC and Mac.

This Database Optimization Tutorial Video - Training CD provides an excellent guide to getting the most out of your data and associated database systems. Though the demonstrations are shown using Microsoft SQL server, the concepts presented carry across to all database types, whether you are using Access, MySQL, Oracle, or any other mainstream database solution. Throughout this multi-part video tutorial, you will be shown a number of techniques that you can test and then apply to your own set-ups. The focus of the training is on proper design, peak performance, and optimization of not only your data but also the accompanying network and system components that control the efficiency with which your database works. Complicated ideas are broken down and explained point by point. While this is not a beginner's course, even those with a baseline understanding of databases will find the tutorial video helpful and easy to use. Technology database professional Lauri Matson offers expert advice with step by step examples that are easy to comprehend. The tutorial video can now be ordered on CD / DVD or watched instantly over streaming video by those who subscribe to the monthly subscriber plan. Both options offer comprehensive and cost effective instruction you can watch right from your own desk.

Associated Tutorials: Microsoft SQL Reporting Services | Crystal Reports Training Video | FileMaker 10 Server | Microsoft SQL Server 2008 | Data Modeling | Microsoft SQL Server 2008 Development Tutorial | Microsoft Access 2010 Tutorial | MySQL 5 Development

Database Optimization Tutorial CD / DVD

When you order this Database Optimization Video Tutorial CD You'll Receive...
Over 8 hours of high quality video-based training that walks you through the program in easy to follow stages.

A training video that focuses on real life examples and teaches you
real life skills. These tutorials are structured to increase not only your skills but also your earning potential.

With this Training Video you will...
Learn Database Optimization from a leading expert and quickly master the skills required to work in a commercial environment.

Learn how to simplify your workflow and increase your productivity using tips and techniques of the pros. Ideal training for Beginners and Advanced users alike

Customer Comments
" I used to use Excel on a daily basis but hadn't touched in years...Got a new job where I had to use it again and your tutorial got me back to where I was and then some in just a matter of days. "Barry Eastment, Florida

Database Optimization Tutorial CD / DVD

Create the best self-paced learning environment right on your own desktop.
Professionally created, comprehensive video based training that's easy to follow. At an unbelievable price.

Topics Covered on this Training Course

This Training is 8 Hours in Duration and Covers 111 Lessons.
Welcome to Your Database Optimization Course How to Design for Efficiency How to Test Your Setup
We hope you enjoyed the free videos above. To watch all this course including the chapters below please purchase the CD.
$99.95
How to Conduct an Audit
  • Audit Fundamentals
  • Working with Audit Components
  • Audit Component Examples and Tips
  • How to Create Audits Using Procedures
Understanding Relationships and Joins
  • Introduction to Relationships
  • Introduction to Joins
  • How to Optimize Joins
  • Using Joins and Database Indexing
Understanding Referential Integrity
  • Integrity Best Practices
  • More Tips on Integrity
  • Using Primary, Foreign and Candidate Keys
  • Techniques to Troubleshoot Integrity Issues
Understanding Data Types and Validation
  • Understanding Unions
  • Working with UNION Within SQL
  • Tips on Standards
  • Best Practices for Validation
Understanding Data Model Creation
  • Conceptual, Logical & Physical Model Types
  • Understanding Relational Modeling
  • Working with the Entity Model
  • Introduction to Schemas
How to Normalize Databases
  • Normalization Tip: the First Normal Form
  • Normalization Tip: the Second Normal Form
  • Normalization Tip: the Third Normal Form
  • Understanding Denormalization
Working with Temporary Tables
  • Temporary Table Creation and Usage
  • Working with Heap and Memory Table Types
  • Understanding EXPLAIN Statements
How to Optimize Queries and Views
  • Execution Plan Fundamentals
  • Working with SQL Execution Plans
  • Work with Execution Plans via Profiler
  • Using SET SHOWPLAN_TEXT
Strategies for Indexing
  • Creating Effective Index Techniques
  • Utilizing Short, Distinct Keys
  • SQL Indexing Fundamentals
  • Indexing and Optimization Fundamentals
Working with Clustered Indexes
  • Comparing Clustered versus Non-Clustered
  • Working with Clustered Index Types
  • Performance and Efficiency Considerations
Addition Tuning and Tweaks
  • Unwanted Data Removal Tips
  • Useful Examples of SHRINKFILE
  • Using the Database Tuning Advisor
  • Data Tuning Advisor in Practice
Types of Data and Quality Considerations
  • Considerations for Data Quality
  • Working with Different Data Types
  • Oracle Data Types Versus SQL Data
  • SQL Data Types in Practice
Effective Database Creation Tips
  • How to Create a Database for Longevity
  • Documentation Options and Considerations
  • Common Approaches to Databases
Working with Stored Procedures
  • Utilizing Stored Procedures, Functions, and Triggers
  • How to Write Stored Procedures
  • Function Creation and Usage
  • Introduction to Triggers
Understanding Hardware Considerations
  • Understanding CPUs and I/O
  • Available Memory / RAM
  • Networking Structure and Management
Hands-on with Performance Info
  • Using the Task Manager
  • Comparing System and Performance Monitors
  • Working with the Performance Monitor
  • Working with Your SQL Database I/O Report
  • Real World Tip: sys.dm_io_virtual_file_stats
Database Monitoring Options
  • How to Use the Event Viewer
  • Utilizing the SQL Activity Monitor
  • Working with Locks and Deadlocks
  • Available Monitoring Service Options
Addressing Security Concerns
  • Assigning Privileges
  • How to Use Role-Based Authorization Options
  • Understanding GRANT & REVOKE Statements
  • SQL Security Fundamentals and Tips
Introduction to Lifecycle Fundamentals
  • About Effective Lifecycle Management
  • Approaching the Database Lifecycle
  • How to Work with the SQL Management Plan
Working with Baselines and SQL Profiler
  • Understanding Baselines
  • Working with the Profiler and SQL
  • About Trace and Additional Profiler Options
  • Understanding Work File Terminology
Poor Performance Warning Signs
  • How to Test the Databases
  • Troubleshooting and Management
  • Performance Tips and Resources
How to Streamline Your Code
  • Available Optimization Approaches
  • Comparing UNION versus OR Optimizing
  • Optimization Tips: JOIN and WHERE
  • Working with Weak Joins
  • Additional Programming Techniques
Stats and Auditing
  • Statistics Fundamentals
  • Working with Statistics and SQL Databases
  • Approaches to Auditing Generally
  • Approaches to SQL Audits
Additional Components and Considerations
  • Using the Database Consistency Checker
  • Database Consistency Checker and SQL
  • Using System Catalog Functionality
  • Using System Catalog Functionality Within SQL
Database To Do List
  • Design and Structure Considerations
  • Examining Influences and Your Constraints
  • Enhancements and Tweaks
  • Your Index Considerations
  • Further Tips and Considerations
Other Important Information
  • Understanding Business Intelligence
  • Thinking About Archival
  • Working with ADONET
Course in Closing
  • What You've Learned / Sample File Info
Tutor Bio
  • Lauri Matson

Select Playback Format for the Free Demos:

Quicktime
Flash

Did You Know ?

We offer more than 700 video-based courses, and you can watch the first three chapters of every listed course for FREE with no obligation to buy.

About this Database Optimization Training CD

Title Database Optimization
Tutor Lauri Matson
Other tutorials by Lauri Matson
Videos 111 Lessons- Video run time: 8 hours
Compatibility Vista, XP, Windows 7, Mac OSX
Released 2010
Work files Yes
Availability Immediate Dispatch
Price US / Canadian Sales Only $99.95
Closed Captions Closed Captions are available on this title
156 in stock
Purchase Orders from Schools, Colleges, Government and Military Accepted

Mutli User Training Options

This training video is also available in Multi-user format, ideal for Schools, Universities, or Corporate users where training multiple delegates is the most cost effective way of training.

10 Multi User $500

Not Sure Which Titles to Buy? Unlimited Access to all -$30

Need to learn more than one topic? Get Unlimited Access to all the courses listed on this site for just $30!
Unlimited Access to over 70,000+ Training Videos

Not sure which training CD titles to purchase? Why not join our Online University and have unlimited access to all our tutorial videos for one low price of $30 per month.
No contract .
No minimum period.
No commitment on your part.

Within minutes you'll have instant, unlimited access to over 700 courses covering over 6000+ hours of training, all from the comfort of your own desk.

Need to learn from more than one location? Not a problem, you're free to access the training from anywhere you wish. It's highly cost effective learning with no limits. We also offer Multi User accounts for companies and schools who need to train multiple users.
Online Learning with No Limits

Why Is This Training Format So Effective?

  • Learn Database Optimization from an accredited expert in days.

Want to hear what our customers say about our products?

Related Training Videos

FileMaker Tutorials | Microsoft Access Tutorials | Crystal Reports Training| Online Database Optimization Training Courses

Prove your Knowledge - Free Certificate

Prove Your Credentials!
Free Certificate.