Notice : You are now accessing LOOP SIT SERVER. This is not meant for public access. For the actual LOOP Website please visit www.LOOP.sg instead


Database Optimization


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

  • Utilize your Business Intelligence with Analytics

    Utilize your Business Intelligence with Analytics

    SGD $45.00

    Course Description

    Data is the fuel that powers modern business and the ability to aggregate and quickly slice and dice data to make accurate, timely decisions is vital in today's environment. Business intelligence is the set of techniques and tools that transform raw, day-to-day, operational data into categorized, aggregated, useful information for fast business analysis purposes. Microsoft's business intelligence tools including SQL Server 2014, SQL Server Analysis Services, Visual Studio/SSDT and Excel provide end users with the power to perform self-service BI and it provides developers the tools they need to create enterprise level BI systems. In this course, Mark Long, teaches you how to work with these tools to create multidimensional data cubes and Microsoft's new tabular data model to provide BI services and help you prepare for Microsoft's certification exam 70-466 Implementing Data Models and Reports with SQL Server.Data plays an integral part in understanding analysis.- Learn how to maintain your database - Know how you should sort your data in SQL Server - Learn about the different functions of data warehouse- Be able to handle and monitor the activity in your database This course is eligible for SkillsFuture Credit.  

    Read more...

  • An Essential Online Course: PivotTable Course (PC: 2013 & 2007/10)

    An Essential Online Course: PivotTable Course (PC: 2013 & 2007/10)

    SGD $49.60

    Course Description

    Microsoft Excel is an important and powerful program for many businesses. The PivotTable feature is one of the most useful, powerful and misunderstood features. PivotTables are absolutely not just about big data and large companies. Although PivotTables can work with very large data sets they are just as useful for micro businesses trying to understand where their sales opportunities lie or for individuals working on their household finances or even their fantasy football leagues. This PivotTable course from Skillsology teaches you how to draw these conclusions easily and present and manage your findings effectively. Using screenshots, video examples and exercises, you’ll soon be able to make the most out of your data, whether ‘Big’ or small, to further your business or personal life. Turn redundant data into useful analysis with PivotTable.  - Manage your data and information in a more intelligent system  - Realize your data's full potential to your advantage  - Discover ways to enhance your data output  - Learn about the advantages of PivotTable    This training is for PivotTable (PC version: 2013, 2007/10) This course is SkillsFuture Credit Eligible.

    Read more...

  • Access 2010 and Beyond

    Access 2010 and Beyond

    SGD $99.00

    Course Description

    Microsoft Access is a DBMS (also known as Database Management System) from Microsoft that combines the relational Microsoft Jet Database Engine with a graphical user interface and software-development tools. It is a member of the Microsoft Office suite of applications, included in the Professional and higher editions or sold separately. Microsoft® Access® 2010 is an easy-to-use database software that helps you track and report information with ease. This training series will teach you how to use the results-oriented user interface that's context-sensitive and optimized for efficiency and flexibility. Become comfortable with the new look and feel and the many great features of Access 2010 in this online tutorial series.Maximize your skills in Microsoft Access 2010 and beyond now!- Use the results-oriented user interface and the many great features of Access 2010 to 2013- Maximize your database with Microsoft Access- Take your working knowledge of tables, queries, reports and forms to dress up your forms and reports- Know how to build your own database with personalized tables and queries This course is SkillsFuture Credit Eligible.

    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.