PRODUCT INFO

Product Guarantee

Testimonials

MAIN LINKS

Multi User Training CDs

	This Week's Special Offer NEW TITLE DISCOUNT!
Adobe Photoshop Elements 10 Tutorial

Quicktime is required for the movies, click here to download if needed.
Please Note: The online FREE lessons have been compressed for faster downloads. Purchased CD ROMs/DVDs load almost instantly and have higher sound and video quality. Please allow a few seconds for the FREE online tutorials to load. If you have any difficulties downloading these FREE online tutorials. Please do not hesitate to contact us for download help.

- See right for full details on this Database Optimisation Tutorial

- See far right to purchase this Database Optimisation Training CD

Database Optimisation Tutorial

Professionally created, self-study video training.

About this Tutorial

show details

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...

hide details

Learn this Software - See below for FREE TUTORIALS

Each Course on 1 or 2 CDs
For Mac and PC

FREE Shipping on ALL Orders

Database Optimisation Tutorial Info
	CLICK HERE TO BUY THIS CD
Tutor: Lauri Matson
Duration: 8 hrs / 111 video lessons
Cost for UK: £79.95 + VAT
Cost for EU: €84.95 + VAT
Cost for US & Canada: $124.95
Product Code: 34078
Delivery: Please allow 2-3 days for UK & Europe, 3-5 days US & rest of world IN STOCK - All CDs Shipped Carriage FREE -
Compatibility: MS Windows 7, Vista, XP, 2000, 98, NT, Mac OS X, OS 9

DON'T TAKE OUR WORD FOR IT, SEE OUR CUSTOMER TESTIMONIALS

Benefits of this Software Training

Tuition by expert tutors.

Narrated training videos demonstrate the key tools and professional techniques helping you to work faster and smarter.

Learning is fast as the trainers provide a beginners guide using simplistic terms and minimal jargon.

Personal Tutoring - Step-by-step video training from your own desktop. Delivered via DVD/CD training or online tuition.

The tutor transfers knowledge to you quickly and effectively.

All the concepts of each application are explained clearly and precisely.

Every course works on PC and Mac.

Alternative to a boring book or manual and expensive training courses, seminars, workshops & classes.

Jump to and from lessons - learn at your own pace.

The visual and practical nature shortens the learning curve compared to standard training manuals and for dummies books.
Customer Testimonials

CD CONTENTS & FREE VIDEO TUTORIALS

Click on any linked lesson below for a FREE demo
Purchased CD tutorials load almost instantly and have higher sound & video quality. For tutorial support see left

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 above. To view the complete contents, including ALL the lessons below and above, please purchase the CD.
CLICK HERE TO BUY THIS CD

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


[ Home \| Video Training CDs/DVD \| Site Map \| Resources \| Specialist Categories \| Specialist Categories 2 \| Specialist Categories 3 ]
UK & Europe Marrutt Software Training Bellbrook Industrial Estate Uckfield, East Sussex, TN22 1QL United Kingdom UK Tel: +44 (0) 1825 764057 UK Fax: +44 (0) 1825 768841	US & Canada Marrutt Software Training 244 5th Ave # 1877 New York, NY 10001 United States US Tel: 646-736-7932 US Fax: 646-895-7649