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

  • Effective Outlook

    Effective Outlook

    SGD $79.60

    Course Description

    Email is the most widely used form of business communication, but also one of the main causes of lost productivity in the workplace. Managing tasks and meetings is crucial to working effectively and professionally, so proficiency with emails and email-management systems has a powerful impact on the day-to-day productivity, efficiency, punctuality and success of businesses. This course will help you to improve the organization and productivity of your staff by optimizing their use of Microsoft Outlook. It will teach principles and techniques that ensure an efficient and effective use of emails, contacts, calendars and notes throughout the business. ​Discover ways for you to stay afloat of your emails.- Learn the different functions in Outlook that can help with your emails- Discover ways that suit your style of maintaining your inbox- Enable yourself to be more productive with Outlook - Learn about the advantages of using Outlook 

    Read more...

  • Google Docs & More: Maximize your online collaboration with Google

    Google Docs & More: Maximize your online collaboration with Google

    SGD $99.00

    Course Description

    Use Google Docs to create documents for collaboration with others online. Google™ Docs has numerous tools for editing and formatting your documents. In this online training series, we’ll learn to format text, add images, links, and comments. We’ll also explore tools for replacing words, checking spelling, and adding a table of contents. Make it easy to share your documents online and collaborate with others. We’ll explore some sharing options through email, invite individuals to collaborate, and manage our list of editors. You’ll also learn to assign ownership of a document, and set downloading options.Make it easy to share your documents online and collaborate with others!- Learn and understand the basics of Google Docs and their features- Be updated on the new kind of Web mail - Learn techniques of Goggle's spreadsheet functions - Know how Google™ Forms can bring productivity and results This course is SkillsFuture Credit Eligible.

    Read more...

  • Maximize your Database with Microsoft Access 2013

    Maximize your Database with Microsoft Access 2013

    SGD $40.00

    Course Description

    Microsoft Access 2013 is the latest version of the number one database application in the world, and this is a big release. Access 2013 brings quite a few changes, all designed to make database applications easier to design and implement. The ability to quickly create Web Applications that run in the user's browser, regardless of which device they use, is one of the major changes in the latest release. In this VTC course, author Mark Long takes you step by step through Access 2013 to quickly get you up to speed on these changes. Access is everywhere, from small one-person businesses up to the largest corporations in the world. It's where most data first gets stored before progressing to SQL Server, cloud delivery, and enterprise data services. Understanding Access is vital to real world database creation/maintenance/design and this course will show you what you need to get there. Realise the full potential of your data with Microsoft Access. - Learn about the functions in Microsoft Access that can help your understand data better - Know the different ways of vizualising your data with Microsoft Access- Pick up the knowledge of utilizing Access for better understanding your data- Learn how you can stretch your data for optimum analysis 

    Read more...


Content

Introduction

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

+

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

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 Monitor

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

Optimizing Code

+

Levels of Optimization

UNION vs. OR Optimization

JOIN vs. WHERE

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

+
Resource Files

Wrap Up & Work Files

Credits

+

About the Author

SkillsFuture Credit Eligible
SGD $45.00
(Price excludes GST)
GET ACCESS NOW
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.