Database Optimization

  • Database Optimization, Singapore SKillsFuture elarning online course
  • Database Optimization, Singapore SKillsFuture elarning online course
  • Database Optimization, Singapore SKillsFuture elarning online course
  • Database Optimization, Singapore SKillsFuture elarning online course
  • Database Optimization, Singapore SKillsFuture elarning online course
  • Database Optimization, Singapore SKillsFuture elarning online course

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

Learn how you can manage your database from becoming redundant.

- Find out how you can mange your database
- Learn ways to fully utlize your data's potential
- Know how to analyze reports from your data
- Learn how to apply formula, queries and commands into your database

This course is SkillsFuture Credit Eligible.

Course Objectives

1. Understand the basics of Reporting 
2. Understand the best practices of a database
3. Know how to use queries and view optimization when viewing data 
4. Understand about the importance of data integrity 
5. Know how to prepare data for storing

Related Courses

  • An Essential Online Course: Increase Your Productivity with Microsoft SharePoint

    An Essential Online Course: Increase Your Productivity with Microsoft SharePoint

    SGD $79.60

    Course Description

    As companies and organizations globalize and economies interweave, teams are increasingly separated by geography, time zones, languages and cultural differences. No matter the environment, SharePoint helps turn individuals into high-performing project teams by providing - a consistent web-site interface, content management, collaboration, work management and business intelligence and reporting through integration with MS Excel and Excel Services Increase your productivity by utilizing SharePoint. - Discover how SharePoint can be added to your advantage  - Explore the different features of SharePoint that can increase your productivity  - Know the different features in SharePoint to gain full usability   This course is Skillsfuture Credit Eligible.


  • Strategize with Service Oriented Architecture

    Strategize with Service Oriented Architecture

    SGD $40.00

    Course Description

    This training has been created to provide you with relevant and important information concerning SOA: Service Orientated Architecture. During this training we will be concentrating on the main points of applying design strategies to a service orientated architecture. You will also learn all there is to know about SOA, how to design and apply the best principles, tips and techniques with detailed practices and principles. We will also be covering various aspects of legacy systems and applications, providing information on security, and appropriate governance with clear details to help you achieve success with SOA, including the design and creation of services for implementation within your enterprise. By the end of this training you will have a high level overview of the benefits of SOA, how to design and implement SOA in your business today. Very little is discussed regarding APIs or code unless used to display the implications of certain technologies and standards. This is a technical training, which is focused on architects, designers, business analysts, IT managers and executives.Achieve success with Service Oriented Architecture. - Know how to align your business strategy - Identify what sort of strategy your business needs to strive - Learn how strategies can help bring your business to greater heights- Know the benefits of Service Oriented Architecture 


  • 1st step towards 3D Modelling: Substance Designer 2.1

    1st step towards 3D Modelling: Substance Designer 2.1

    SGD $45.00

    Course Description

    Substance Designer is a revolutionary next generation tool for the creation of smart textures for 3D. Designed to fully leverage Raster, Vector, and Procedural image-making technologies along with advanced filtering techniques to create multichannel texture assets which can be dynamically changed by the end user at run time. The resulting files, known as “Substances,’ are a remarkably flexible solution for many 3D texturing needs including Video Game Design and Architectural Visualization. This latest version of Substance Designer is a must-have for anybody who is serious about working in 3D. Taught by 2D and 3D artist Jason Maranto, this VTC course is designed to quickly elevate your understanding of this powerful application. Focusing heavily on the sophisticated tools available within Substance Designer and taught in an in-depth but easy-to-follow style, this course will help you master Substance Designer to create 3D texture assets of unparalleled flexibility and power.Discover more possibilities with 3D modelling.- Learn about the multiple functions in Substance Designer - Find out how Substance Designer can produce satisfactory models - Know more about the versatility of creating 3D models- Upgrade your modelling process to the latest software available in the market This course is SkillsFuture Credit Eligible.




Preview Available


Introduction & Disclaimers

Optimizing a Database

Some Common Problems

Designing for Performance

Preview Available


Planning & Process Principles

Design Principles

Client/Server Interaction

Troubleshooting & Testing


What to Look for

Types of Testing

SQLdiag Tool

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

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 Monitor

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

Optimizing Code


Levels of Optimization

UNION vs. OR Optimization


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




Resource Files

Wrap Up & Work Files



About the Author

SkillsFuture Credit Eligible
SGD $45.00
(Price excludes GST)
Convince your boss email
This site is best viewed using the latest versions of Google Chrome, Apple Safari, Mozilla FireFox, Microsoft Internet Explorer 11 and Edge which supports HTML5/Webkit technologies.