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

  • Microsoft Outlook 2013

    Microsoft Outlook 2013

    SGD $45.00

    Course Description

    Microsoft Outlook remains the email, contact, and calendar application of choice for millions of businesses and over a billion end users worldwide. The 2013 version brings with it some exciting updates: a streamlined interface, integration with social networks such as LinkedIn and Facebook, mail and calendar Peek, and new mailbox cleanup tools. Author Brian Culp serves as your tour guide through these new features and dozens upon dozens more. He takes users from program installation and set up through utilizing Outlook as a complete task and communication management program. Whether you are using it as a stand-alone program or working in a corporate environment with a Microsoft Exchange back-end, this VTC course will show you how to get the most out of Microsoft Outlook 2013. Find out more about Microsoft's productivity tools!- Learn and understand the purpose of Microsoft's tools- Know more about the functionality and features of each application- Learn about functions that you never knew existed in Microsoft's tools- Be fluent and an efficient user in Microsoft tools by the end of this course 


  • Learn about Digital Audio with Steinberg Cubase 6

    Learn about Digital Audio with Steinberg Cubase 6

    SGD $49.00

    Course Description

    Steinberg's Cubase 6 is the latest update to the extremely popular professional digital audio workstation music software. In this course, author Mark Struthers will demonstrate how to make initial input and output connections to the program from the soundcard before examining routing in more detail. Additionally, insert and group effects are explored to help show how to enhance recorded audio tracks. Mark will walk you through the many-featured project window before showing you how to create and save your own project. Within the Cubase workflow, important terms such as clips, events, and parts are explained along with the distinction between lanes and tracks. Mark also covers insert and send effects, quantization, time stretch, and the Media Bay. Cubase comes equipped with VST instruments and, in particular, Groove Agent One and Halion Sonic SE are explored before working through the concepts behind a final mix and export to a finished audio track. Be able to produce music recording, arranging and editing with Steinberg. - Learn how to work with audio files using Steinberg- Know how Steinberg works as an audio editing software- Enable yourself to be able to produce your own music with Steinberg - Learn about the different techniques used in Steinberg to achieve quality audioThis course is SkillsFuture Credit Eligible.


  • Microsoft Word: Essential 2013, 2016 & Online

    Microsoft Word: Essential 2013, 2016 & Online

    SGD $99.00

    Course Description

    Microsoft® Word 2013 offers enhanced features to help you create professional-quality documents, collaborate with your peers and expanded access to your files. In this online training series, you will learn about the new interface, and the basics of how to create high-quality documents that you can be proud of. Additionally, learn about Microsoft® Word 2016 and its newly introduced features as well as Word Online, increasing your word processing capabilities!Learn about the new interface of Microsoft Word 2013, and the basics of how to create high-quality documents that you can be proud of.- Master Microsoft Word 2013 with this excellent online tutorial- Know about the basics and newly added functions in Microsoft Word 2016 - Learn how you can apply this techniques into actual documents - Be able to create dynamic and of high-quality documents using Microsoft WordThis 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.