Microsoft Power BI – Training Calgary « click for details
2 days | | $1,190 PLUS TAX

Prerequisite:

This two-day course provides students with the knowledge and skills to analyze data with Power BI.

Dates

Online:
Feb 22-23
Mar 21-22
Apr 24-25
May 10-11
Jun 26-27

More dates

Microsoft Power BI – Training Calgary 2 days | | $1,190 PLUS TAX

This two-day course provides students with the knowledge and skills to analyze data with Power BI. Prerequisite:

COURSE OUTLINE

Introduction to self-service BI solutions

» Introduction to business intelligence
» Introduction to data analysis
» Introduction to data visualization
» Overview of self-service BI
» Considerations of self-service BI
» Microsoft tools for self-service BI
» Lab: Exploring an enterprise BI solution

Introducing Power BI

» Power BI
» The Power BI service
» Power BI mobile apps
» Lab: Cresting a Power BI dashboard

Power BI data

» Using Excel as a Power BI data source
» Using databases as a Power BI data source
» The Power BI service
» Lab: Import data into Power BI

Shaping & combining data

» Power BI desktop queries
» Shaping data
» Combining data
» Lab: Shaping and combining data

Modelling data

» Relationships
» DAX queries
» Calculations and measures
» Lab: Modelling data

Interactive data visualizations

» Creating Power BI reports
» Managing a Power BI solution
» Lab: Creating a Power BI report

Dates

Online:
Feb 22-23
Mar 21-22
Apr 24-25
May 10-11
Jun 26-27
Jul 12-13
Also runs on request.

Preferred date

Preferred date

Developing SQL Data Models « click for details
3 days | | $1,785 PLUS TAX

Prerequisite:

This course is aimed at database professionals who fulfill a Business Intelligence (BI) developer role. Students will learn to implement multidimensional databases by using SQL Server Analysis Services (SSAS), and at creating tabular semantic data models.

Dates

Please call for dates

More dates

Developing SQL Data Models 3 days | | $1,785 PLUS TAX

TARGET AUDIENCE

The primary audience for this course are database professionals who need to fulfil BI Developer role to create enterprise BI solutions. Primary responsibilities will include:

» Implementing multidimensional databases by using SQL Server Analysis Services
» Creating tabular semantic data models for analysis by using SQL Server Analysis Services
» The secondary audiences for this course are ‘power’ information workers/data analysts.

COURSE OBJECTIVES

After completing this course, students will be able to:

» Describe the components, architecture, and nature of a BI solution
» Create a multidimensional database with analysis services
» Implement dimensions in a cube
» Implement measures and measure groups in a cube
» Use MDX syntax
» Customize a cube
» Implement a tabular database
» Use DAX to query a tabular model
» Use data mining for predictive analysis

COURSE OUTLINE

INTRODUCTION TO BUSINESS INTELLIGENCE AND DATA MODELING

» Introduction to Business Intelligence
» The Microsoft business intelligence platform
» Lab : Exploring a Data Warehouse

CREATING MULTIDIMENSIONAL DATABASES

» Introduction to multidimensional analysis
» Creating data sources and data source views
» Creating a cube
» Overview of cube security
» Lab : Creating a multidimensional database

WORKING WITH CUBES AND DIMENSIONS

» Configuring dimensions
» Define attribute hierarchies
» Sorting and grouping attributes
» Lab : Working with Cubes and Dimensions

WORKING WITH MEASURES AND MEASURE GROUPS

» Working with measures
» Working with measure groups
» Lab : Configuring Measures and Measure Groups

INTRODUCTION TO MDX

» MDX fundamentals
» Adding calculations to a cube
» Using MDX to query a cube
» Lab : Using MDX

CUSTOMIZING CUBE FUNCTIONALITY

» Implementing key performance indicators
» Implementing actions
» Implementing perspectives
» Implementing translations
» Lab : Customizing a Cube

IMPLEMENTING A TABULAR DATA MODEL BY USING ANALYSIS SERVICES

» Introduction to tabular data models
» Creating a tabular data model
» Using an analysis services tabular model in an enterprise BI solution
» Lab : Working with an Analysis services tabular data model

INTRODUCTION TO DATA ANALYSIS EXPRESSION (DAX)

» DAX fundamentals
» Using DAX to create calculated columns and measures in a tabular data model
» Lab : Creating Calculated Columns and Measures by using DAX

PERFORMING PREDICTIVE ANALYSIS WITH DATA MINING

» Overview of data mining
» Using the data mining add-in for Excel
» Creating a custom data mining solution
» Validating a data mining model
» Connecting to and consuming a data mining model
» Lab : Perform Predictive Analysis with Data Mining

Dates

Please call for dates

Preferred date

Preferred date

SQL Server Performance Tuning and Optimization « click for details
5 days | | $2,970 PLUS TAX

Prerequisite:

The course offers a comprehensive coverage of SQL Server architecture, indexing and statistics strategies, optimize transaction log operations, tempdb and data file configuration, transactions and isolation levels, and locking and blocking.

Dates

Please call for dates

More dates

SQL Server Performance Tuning and Optimization 5 days | | $2,970 PLUS TAX

TARGET AUDIENCE

The primary audience for this course is individuals who administer and maintain SQL Server databases and are responsible for optimal performance of SQL Server instances that they manage. These individuals also write queries against data and need to ensure optimal execution performance of the workloads.

The secondary audiences for this course are individuals who develop applications that deliver content from SQL Server databases.

COURSE OBJECTIVES

After completing this course, students will be able to:

» Understand and utilize the new cardinality estimator.
» Understand and utilize memory-optimized tables.
» Understand and utilize startup stored procedures.
» Understand and utilize Instant File Initialization.
» Understand how SQL stored data.
» Understand how SQL locates data.
» Understand temporary table internals.
» Understand and utilize the new cardinality estimator.
» Understand and utilize memory-optimized tables.
» Understand performance.
» Understand and utilize startup stored procedures.
» Understand database structures.
» Understand and utilize Instant File Initialization.
» Understand how SQL stored data.
» Understand how SQL locates data.
» Understand temporary table internals.
» Understand and utilize table valued parameters.
» Understand concurrency.
» Understand and utilize transactions.
» Understand isolation levels.
» Understand and utilize SQL Server locking architecture.
» Understand SQL and Storage Area Networks (SAN).
» Understand and utilize SQL on virtual machines.
» Understand SQLIO Utility and its uses.
» Understand and utilize partitioned tables and indexes.
» Understand and utilize the Resource Governor.
» Understand and utilize Activity Monitor.
» Understand Live Query Statistics.
» Understand how to monitor SQL using Transact-SQL.
» Understand and utilize performance DMVs.
» Understand indexes and their importance.
» Understand index types.
» Create and alter indexes.
» Understand and utilize index metadata.
» Understand and utilize Database Tuning Advisor.
» Understand and utilize Index Data Management Objects.
» Understand fragmentation of indexes and utilize page splits.
» Understand index storage strategies.
» Understand and utilize indexed views.
» Understand monitoring indexes.
» Understand index best practices.
» Understand and utilize statistics objects.
» Understand and utilize histogram.
» Understand and utilize new vs old cardinality estimator.
» Understand and utilize incremental statistics.
» Understand and utilize computed columns.
» Understand & utilize filtered statistics.
» Understand & utilize ascending keys.
» Understand & utilize statistics maintenance plan.
» Understand architecture.
» Understand & utilize tables and indexes.
» Understand & utilize the hash index.
» Understand & utilize natively compiled stored procedures.
» Understand restrictions.
» Understand & utilize the Analyze Migrat

COURSE OUTLINE

COURSE OVERVIEW

» Introduction
» Course Materials
» Facilities
» Prerequisites
» What We’ll Be Discussing
» Lab: Course Overview

SQL 2014 ARCHITECTURE

» The New Cardinality Estimator
» Memory-Optimized Tables
» Understanding Performance for Developers
» Understanding Startup Parameters
» Startup Stored Procedures
» Database Structures
» Instant File Initialization
» How SQL Stores Data
» How SQL Locates Data
» Lab: SQL 2014 Architecture

THE DATABASE ENGINE

» Four Important Concepts
» Temporary Tables Internals
» Concurrency
» Transactions
» Isolation Levels
» SQL Server Locking Architecture
» SQL and Storage Area Networks (SAN)
» SQL on VMs
» SQLIO Utility
» Partitioned Tables and Indexes
» Lab: The Database Engine

SQL PERFORMANCE TOOLS

» The Resource Governor
» Activity Monitor
» Live Query Statistics
» Monitoring SQL with Transact-SQL
» Dynamic Management Objects (DMOs) and Performance Tuning
» Lab: SQL Performance Tools

QUERY OPTIMIZING AND OPERATORS

» Tuning Process
» Performance Monitor Tool
» SQL Query Processing Steps
» Understanding Execution Plans
» SET STATISTICS TIME and SET STATISTICS IO
» Data Access Operators
» Troubleshooting Queries
» Lab: Query Optimizing and Operators

UNDERSTANDING INDEXES

» Introduction to Indexes
» Index Types by Storage
» Index Types by Column Designation
» Creating and Altering Indexes
» Metadata
» Data Management Views for Indexing
» Database Engine Tuning Advisor
» Index Data Management Objects
» SQL Server Fragmentation
» Patterns
» Index Storage Strategies
» Indexed Views
» Monitoring Indexes
» Index Dynamic Management Objects (DMOs)
» Best Practices
» Lab: Understanding Indexes

UNDERSTANDING STATISTICS

» Statistics
» Cardinality Estimator
» Incremental Statistics
» Computed Columns Statistics
» Filtered Statistics
» Maintenance
» Lab: Understanding Statistics

IN-MEMORY DATABASE

» Architecture
» Tables and Indexes
» Natively Compiled Stored Procedures
» Restrictions
» Analyze Migrate Report Tool
» In-Memory Data Management Views (DMV)
» Lab: In-Memory Database

SQL PROFILER AND SQL TRACE

» SQL Trace
» SQL Trace Architecture
» SQL Server Profiler
» Lab: SQL Profiler and SQL Trace

QUERY ISSUES AND HINTS

» Query Hints
» Plan Guides
» Plan Freezing
» Join Orders
» Lab: Query Issues and Hints

Dates

Please call for dates

Preferred date

Preferred date

SQL Server 2014 High Availability « click for details
3 days | | $1,785 PLUS TAX

Prerequisite:

This course provides an in-depth review of SQL Server 2014 High Availability, including concepts for HA, drill-through of the various technologies available with SQL Server 2014, and how to implement high availability using those technologies.

Dates

Call for dates

More dates

SQL Server 2014 High Availability 3 days | | $1,785 PLUS TAX

COURSE OBJECTIVES

Upon completion of this course, the student will be able to:

» Design a SQL Server 2014 availability solution to meet their availability goals.
» Implement that design using the available technologies in SQL Server 2014.
» Implement system maintenance while understanding the availability implications.
» Troubleshoot problems with High Availability in SQL Server 2014.

COURSE OUTLINE

HIGH AVAILABILITY OVERVIEW

» Defining High Availability
» Achieving High Availability

OVERVIEW OF WINDOWS SERVER FAILOVER CLUSTERING

» Failover Clustering Concepts
» Cluster Resources
» Setting up a Windows Failover Cluster
» MSDTC Clustering
» LAB: Creating Your Windows Server Failover Cluster

SQL SERVER 2014 HIGH AVAILABILITY OVERVIEW

» SQL Server 2014 High Availability (HA) Technologies
» High-level Considerations on Technology Choices
» Common Combinations

ALWAYSON FAILOVER CLUSTERING

» SQL Server Failover Clustering – Definitions and History
» SQL Server 2014 Failover Clustering Instance (FCI)
» Maintaining a SQL Server 2014 FCI
» Multi-Site Failover Clustering
» LAB: Installing a Two-Node Failover Clustered SQL Server and Analysis Services Installation

ALWAYSON AVAILABILITY GROUPS

» Availability Group Concepts
» Partners and Secondary Servers
» LAB A: Creating an Availability Group Hosted on Three Servers: Primary, Synchronous Secondary, and Asynchronous Secondary
» LAB B: Database Backups for Secondary Replicas: Creating Automated Database Backups on All Secondary Replicas

LEGACY DATABASE MIRRORING

» Database Mirroring Overview
» Database Mirroring Architecture
» Enabling Database Mirroring
» Database Mirroring Operations
» LAB: Enabling Database Mirroring Between Two Servers

LEGACY LOG SHIPPING

» Log Shipping Overview
» Log Shipping Architecture
» Configuring Log Shipping
» Log Shipping Internals
» Administering Log Shipping
» LAB: Enabling Log Shipping Between Two Servers

USING REPLICATION FOR HIGH AVAILABILITY

» Replication Overview
» Replication Types
» Replication Architecture
» Configuring Replication
» Replication Monitoring
» LAB: Enabling Transactional Replication with Three Servers

HIGH AVAILABILITY SOLUTIONS INTEROPERABILITY

» AlwaysOn Failover Cluster Instances with AlwaysOn Availability Groups
» AlwaysOn Failover Cluster Instances with Legacy Database Mirroring
» AlwaysOn Availability Groups with Replication
» LAB: Creating AlwaysOn Availability Groups Running a Primary Replica on an AlwaysOn Failover Cluster Instance

HIGH AVAILABILITY WITH VIRTUALIZATION

» Hyper-V in Windows Server 2008 R2
» Improvements in Windows Server 2012/R2
» SQL Server Hyper-V Support
» Hyper-V HA Considerations
» Using Cluster Shared Volumes for High Availability
» Live Migration
» Using Guest Clustering
» Using Azure Virtual Machines
» Using VMWare

MEETING YOUR AVAILABILITY GOAL

» Technology Choices
» Servicing for Availability
» Ongoing Maintenance
» Indexing
» Partitioning
» Processes and Procedures for Availability
» Rule No.1
» Understanding the Technologies Used
» Understanding the Procedures and Escalation Paths
» Planned Downtime

Dates

Call for dates

Preferred date

Preferred date

Database Administration Fundamentals « click for details
3 days | | $1,785 PLUS TAX

Prerequisite:

This three-day MTA Training course helps you prepare for Microsoft Exam 98-364, and build an understanding of these topics: Core Database Concepts, Creating Database Objects, Manipulating Data, Data Storage, and Administering a Database.

Dates

Please call for dates

More dates

Database Administration Fundamentals 3 days | | $1,785 PLUS TAX

TARGET AUDIENCE

The Microsoft Technology Associate (MTA) is Microsoft’s newest suite of technology certification exams that validate fundamental knowledge needed to begin building a career using Microsoft technologies. This program provides an appropriate entry point to a future career in technology and assumes some hands-on experience or training but does not assume on-the-job experience.

COURSE OBJECTIVES

After completing this course, students will be able to:

» Understand Core Database Concepts
» Create Database Objects
» Manipulate Data
» Understand Data Storage
» Administer a Database

COURSE OUTLINE

» UNDERSTANDING CORE DATABASE CONCEPTS
» CREATING DATABASE OBJECTS
» MANIPULATING DATA
» UNDERSTANDING DATA STORAGE
» ADMINISTERING A DATABASE

Dates

Please call for dates

Preferred date

Preferred date

Microsoft Report Builder 3.0 with SQL 2008R2, SQL 2012, and SQL 2014 « click for details
2 days | | $1,190 PLUS TAX

Prerequisite:

The course covers the Report Builder 3.0 wizards, basics of report design, intermediate reports with report parameters and report expressions, report visualizations including graphs, charts, images and gauges.

Dates

Please call for dates

More dates

Microsoft Report Builder 3.0 with SQL 2008R2, SQL 2012, and SQL 2014 2 days | | $1,190 PLUS TAX

TARGET AUDIENCE

This course is intended for Power Users, Developers and IT Professionals that will be involved with the design, development and maintenance of reports created with Report Builder 3.0

COURSE OBJECTIVES

After completing this course, students will be able to:

» Plan the reports.
» Use Report Builder 3.0 and understand the parts of the interface.
» Launch Report Builder 3.0 from multiple sources.
» Understand management options.
» Create embedded data sources and datasets.
» Create shared data sources and datasets.
» Create shared data sources and datasets.
» Understand and utilize the Table or Matrix Wizard.
» Understand and utilize the Chart Wizard.
» Understand and utilize the Map Wizard.
» Understand and utilize lists.
» Understand and utilize tables.
» Understand and utilize matrices.
» Understand and utilize data regions.
» Understand and utilize parameters.
» Understand and utilize expressions.
» Understand and utilize report parts.
» Understand and utilize formatting options.
» Understand visualization options.
» Understand and utilize charts.
» Understand and utilize sparklines.
» Understand and utilize gauges.
» Understand and utilize maps.
» Understand filtering, grouping, and sorting.
» Understand and utilize dynamic headers and footers.
» Understand and utilize report templates.
» Understand and utilize HTML and texboxes.
» Understand and utilize lists as containers.
» Understand and utilize subreports.
» Understand report subscription options.
» Understand security.

COURSE OUTLINE

EXPLORING THE REPORT BUILDER ENVIRONMENT

» Introducing the Report Builder Environment
» Working with Existing Reports
» Lab: Exploring the Report Builder Application

ADDING DATA TO TABLE REPORTS

» Create Report Data Sources
» Create Report Datasets
» Work with the Tablix Data Region
» Create a Table Report
» Lab: Creating Table Reports

FORMATTING DATA AND CREATING EXPRESSIONS IN REPORTS

» Formatting Reports
» Sorting and Filtering Report Data
» Adding Data to a Dataset
» Creating Simple Expressions
» Creating Complex Expressions
» Lab: Formatting Reports

GROUPING REPORT DATA

» Group Data in Reports
» Group Data Using an Expression
» Creating Subgroups and Group Aggregates
» Lab: Creating Reports with Groups and Aggregates

MATRIX REPORTS

» Creating and Modifying Matrix Data Regions
» Creating and Modifying Column Groups
» Lab: Creating Matrix Reports

CHARTS

» Create and Modify Chart Wizard Reports
» Add Charts to Existing Reports
» Modify Charts in Reports
» Lab: Creating Charts and Chart Reports

PRINTING AND EXPORTING REPORTS

» Print Features and Print Options
» Export Reports
» Lab: Printing and Exporting Reports

Dates

Please call for dates

Preferred date

Preferred date

Oracle 12c SQL Fundamentals « click for details
5 days | | $2,695 PLUS TAX

Prerequisite:

This textbook takes a unique approach to SQL training in that it incorporates data modeling theory, relational database theory, graphical depictions of theoretical concepts and numerous examples of actual SQL syntax into one learning vehicle.

Dates

Please call for dates

More dates

Oracle 12c SQL Fundamentals 5 days | | $2,695 PLUS TAX

COURSE OBJECTIVES

The first portion of this textbook considers the logical models upon which a relational database is based and the various configurations and environments in which you may work with the Oracle database. The next segment focuses on the actual SQL syntax for writing database queries. You will begin with the simplest of queries and then proceed onto moderately complex query scenarios. Finally, this textbook covers the DDL, DML and transaction control portions of the SQL language that allow one to create, maintain and manipulate application database objects and application data.

COURSE OUTLINE

RELATIONAL DATABASES & DATA MODELS

» About Data Models
» About the Relational Model
» The Electronics Data Model
» About the Relational DBMS

SELECTION & SETUP OF THE DATABASE INTERFACE

» Considering Available Tools
» Selecting the Appropriate Tool
» Oracle Net Database Connections
» Oracle PAAS Database Connections
» Setup SQL Developer
» Setup SQL*Plus
» Setup Jdeveloper

USING THE DATABASE INTERFACE

» About Bind & Substitution Variables
» Using SQL Developer
» Using SQL*Plus

INTRODUCTION TO THE SQL LANGUAGE

» About the SQL Language
» Characteristics of SQL
» Introducing SQL Using Select
» SQL Rules

THE SELECT STATEMENT

» The Select Statement
» Distinct/Unique Keyword
» Using Alias Names

RESTRICTING RESULTS WITH THE WHERE CLAUSE

» About Logical Operators
» Equality Operator
» Boolean Operators
» REGEXP_LIKE()
» In Operator

SORTING DATA WITH THE ORDER BY CLAUSE

» About the Order by Clause
» Multiple Column Sorts
» Specify the Sort Sequence
» About Null Values within Sorts
» Using Column Aliases

PSEUDO COLUMNS, FUNCTIONS & TOP-N QUERIES

» Rowid Pseudo Column
» ORA_ROWSCN PSEUDO Column
» ROWNUM Pseudo Column
» About the Built-In Functions
» SYSDATE
» User & UID
» SESSIONTIMEZONE Function
» Using the Dual Table
» Row Limiting & Top-N Queries
» FETCH First x Rows Only Clause
» OFFSET x Rows Clause
» FETCH…PERCENT Clause
» The WITH TIES Option

JOINING TABLES

» About Joins
» Inner Joins
» Reflexive Join
» Non-Key Join
» Outer Join

USING THE SET OPERATORS

» About the Set Operators
» SQL Set Operator Examples
» UNION Example
» INTERECT Example
» MINUS Example
» UNION All

SUMMARY FUNCTIONS USING SUB-QUERIES

» Finding Data with Sub-Queries
» Standard Sub-Queries
» Correlated Sub-Queries
» The EXISTS Operator

AGGREGATING DATA WITHIN GROUPS

» About Summary Groups
» Find Groups within the Tables
» Select Data From the Base Tables
» Select Groups from the Results

USE DDL TO CREATE & MANAGE TABLES

» Create Table Statement
» Column Data Types
» Not Null
» Default
» Describe
» Alter Table Statement
» Drop Table Statement
» Table DDL Using SQL Developer
» Alter User Statement
» Alter Session Statement
» NLS_Language
» NLS_Date

USE DML TO MANIPULATE DATA

» The Insert Statement
» The Delete Statement
» The Update Statement
» About Transactions
» Transaction Rollback
» Transaction Commit
» Transaction Savepoint
» The Set Transaction Statement
» Set Transaction Read Only Statement Rules

UNDERSTANDING THE DATA MODELS

» The Company Data Model
» The Electronics Data Model

ABOUT THE SQL-99 STANDARD

» SQL-92 & SQL-99
» Cross Joins
» Natural Joins
» Inner Joins
» Implicit Inner Join
» Outer Joins
» Anti Joins
» Named Sub-Queries

ENHANCING GROUPS WITH ROLLUP & CUBE

» Using Rollup
» The Grouping() Function
» Using Cube

SQL FUNCTIONS: CHARACTER HANDLING

» What are the SQL Functions?
» String Formatting Functions
» UPPER(), LOWER() Example
» INITCAP() Example
» Character Codes Functions
» CHR((), ASCII() Examples
» PAD & TRIM Functions
» RPAD() Example
» RTRIM() Example
» TRIM() Example
» String Manipulation Functions
» DECODE () Example
» SUBSTR() Example
» INSTR() Example
» TRANSLATE() Example
» REPLACE() Example
» String Comparison Functions
» LEAST() Example
» Phonetic Search Function
» SOUNDEX() Example

SQL FUNCTIONS: NUMERIC HANDLING

» About the Numeric Data Functions
» GREATEST() Example
» ABS() Example
» ROUND() Example
» TRUNC() Example
» SIGN() Example
» TO_NUMBER() Example & Data ype Conversions
» NULL VALUES FUNCTIONS
» NVL() & NVL2() Function
» NVL() Example (Character)
» NVL() Example (Numeric Loss of Data)
» NVL() Example (Numeric Output)
» NVL2() Example
» COALESCE() Function
» NULLIF() Function

SQL FUNCTIONS: DATE HANDLING

» Date Formatting Functions
» TO_CHAR() & TO_DATE() Format Patterns
» TO_CHAR() Examples
» TO_DATE() Examples
» EXTRACT() Example
» Date Arithmetic Functions
» MONTHS_BETWEEN() Example
» ADD_MONTHS() Example
» LAST_DAY() Example
» NEXT_DAY() Example
» TRUNC(), ROUND() Dates Example
» NEW_ TIME() Example
» About V$TIMEZONE_NAMES
» CAST() FUNCTION & TIME ZONES

DATABASE OBJECTS: ABOUT DATABASE OBJECTS

» About Database Objects
» About Schemas
» Making Object References

DATABASE OBJECTS: RELATIONAL VIEWS

» About Relations Views
» The Create View Statement
» Why Use Views?
» Accessing Views with DML
» Maintaining View Definitions
» Alter View
» Drop View
» DDL Using SQL Developer

DATABASE OBJECTS: INDEXES

» About Indexes
» Create & Drop Index Statements
» Indexes & Performance
» Data Dictionary Storage

DATABASE OBJECTS: CREATING OTHER OBJECTS

» About Sequences
» Referencing NEXTVAL
» Referencing CURRVAL
» Within the DEFAULT Clause
» Alter Sequence & Drop Sequence
» ALTER SEQUENCE
» DROP SEQUENCE
» About Identity Columns
» CREATE TABLE…GENERATED AS IDENTITY
» ALTER TABLE…GENERATED AS IDENTITY
» Start With Limit Value
» ALTER TABLE…DROP IDENTITY
» About Synonyms
» CREATE & DROP SYNONYM Statements
» CREATE SYNONYM
» DROP SYNONYM
» Public Vs Private Synonyms
» CREATE SCHEMA AUTHORIZATION

DATABASE OBJECTS: OBJECT MANAGEMENT USING DDL

» The RENAME Statement
» TABLESPACE Placement
» CREATE TABLE…TABLESPACE
» The Comment Statement
» The TRUNCATE TABLE Statement

DATABASE OBJECTS: SECURITY

» About Object Security
» Grant Object Privileges
» Revoke Object Privileges
» Object Privileges & SQL Developer

DATA INTEGRITY USING CONSTRAINTS

» About Constraints
» NOT NULL Constraint
» NOT NULL Example
» CHECK Constraint
» UNIQUE Constraint
» PRIMARY KEY Constraint
» REFERENCES Constraint
» ON DELETE CASCADE Example
» ON DELETE SET NULL Example
» Constraints on Existing Tables
» Constraints & SQL Developer

MANAGING CONSTRAINT DEFINITIONS

» RENAMING & DROPPING Constraints
» ENABLING & DISABLING Constraints
» DEFERRED Constraint Enforcement
» SET CONSTRAINTS
» Handling Constraint Exceptions
» Constraints with Views
» DATA Dictionary Storage

THE DATA DICTIONARY STRUCTURE

» More About the Data Dictionary
» OBJECT-SPECIFIC Dictionary Views
» USER_UPDATABLE_COLUMNS
» The Dictionary Structure
» METADATA & SQL Developer

Dates

Please call for dates

Preferred date

Preferred date

Oracle Database 11g R2 – SQL Tuning, Architecture and Internals « click for details
5 days | | $2,695 PLUS TAX

Prerequisite:

Students will reveal the underlying architecture of the Oracle database environment. This course is also intended to be of help to information technology (IT) managers and executives who require an understanding of the technology.

Dates

Please call for dates

More dates

Oracle Database 11g R2 – SQL Tuning, Architecture and Internals 5 days | | $2,695 PLUS TAX

TARGET AUDIENCE

The primary target audiences for this course are: Senior application designers and database developers; PL/SQL developers; Database administrators; Web server administrators; System administrators; Implementation specialists; Data center support engineers.

COURSE OUTLINE

THE BROADER ORACLE ENTERPRISE ARCHITECTURE

About Enterprise Architectures

» About Parallelization
» SMP
» The Database Server Stack
» The Database Server Software
» V$Version

EXPLORING THE ORACLE DATABASE INSTANCE

» Database Instance Configurations
» About the Sga
» Using V$Sga_Dynamic_Components
» About the Pga
» Managing Instance Memory

EXPLORING THE INSTANCE PROCESSES

» Instance Background Processes
» Sql Execution Processes
» Using V$Session
» About the Pga
» Sql Statement Execution

EXPLORING LOGICAL STORAGE: DATABASE OBJECTS

» Application Database Objects
» Schema & Ownership Context
» Editions Context & Redefinition

APPLICATION DATABASE OBJECTS

» About the Database Files
» Database Server Parameter File
» Control Files
» Alert Log & Trace Files

EXPLORING PHYSICAL STORAGE: TABLESPACES

» Tablespaces & Data Files
» AUTOEXTEND Options
» About Temporary Segments
» About Index Segments

TUNING & THE ORACLE DATABASE ADVISORY FRAMEWORK

» The Challenges of Tuning
» Performance Metrics
» Management & Advisory Framework
» Addm & Awr
» Sql Tuning Privileges

VIEWING & MONITORING THE EXECUTION PLAN

» About the Execution Plan
» Collecting Performance Statistics
» Viewing the Execution Plan
» Real-Time Sql Monitoring

UNDERSTANDING THE OPTIMIZER

» Optimization Methods
» Optimization Goals
» Optimizer_Mode
» Optimizer_Features_Enable
» Optimizer Components
» Execution Plan Operations

EXECUTION PLAN METHODS & OPERATIONS

» Table Access Methods
» Join Methods
» Index Operations
» Data Operations

MANAGING OPTIMIZER STATISTICS

» More About Optimizer Statistics
» Automatic Maintenance Tasks
» Manually Gathering Statistics
» GATHER_TABLE_STATS()
» GATHER_INDEX_STATS()
» GATHER_SCHEMA_STATS()
» GATHER_DATABASE_STATS()
» GATHER_SYS Parameter
» GATHER_DICTIONARY_STATS()
» GATHER_FIXED_OBJECTS_STATS()
» Using Historical Statistics
» Dynamic Sampling
» Locking Statistics

ENHANCED OPTIMIZER STATISTICS

» About Optimizer System Statistics
» Manage System Statistics
» CREATE_STAT_TABLE(), DROP_STAT_TABLE()
» CREATE_STAT_TABLE()
» DROP_STAT_TABLE()
» GATHER_SYSTEM_STATS()
» GET_SYSTEM_STATS()
» SET_SYSTEM_STATS()
» IMPORT_SYSTEM_STATS(), EXPORT_SYSTEM_STATS()
» IMPORT_SYSTEM_STATS()
» EXPORT_SYSTEM_STATS()
» DELETE_SYSTEM_STATS()
» Pending & Published Statistics

HISTOGRAMS & EXTENDED STATISTICS

» Why Are Histograms Needed?
» Histograms Internal Structure
» Manually Managing Histograms
» Expression Statistics
» Multicolumn Statistics

APPLICATION TRACING

» Application Tracing Packages
» SET_SQL_TRACE()
» TRACE_ENABLE()
» SET_IDENTIFIER()
» Em Application Monitoring & Tuning
» Real-Time Monitoring
» Using TRCSESS & TKPROF

ADDM & THE SQL TUNING ADVISOR

» ADDM Performance Analysis
» Using the Sql Tuning Advisor
» Automatic Sql Tuning
» Configuring Automatic Sql Tuning

THE SQL ACCESS ADVISOR

» Using the Sql Access Advisor
» Sql Access Advisor Templates
» Performing a Quick Tune Task
» Index Database Parameters
» OPTIMIZER_INDEX_COST_ADJ
» OPTIMIZER_INDEX_CACHING
» SKIP_UNUSABLE_INDEXES
» OPTIMIZER_USE_INVISIBLE_INDEXES

USING THE SQL ACCESS ADVISOR

» Sql Management Base Architecture
» LOAD_PLANS_FROM_SQLSET()
» LOAD_PLANS_FROM_CURSOR_CACHE()
» Using Plan Baselines
» Plan Management Using Em

MANAGING CURSOR SHARING

» About Cursor Sharing
» Bind Variables & Cursor Sharing
» The Cursor_Sharing Parameter
» Finding Candidates For Rewrite

OPTIMIZER HINTS

» What Are Hints?
» Hint Explanations

Dates

Please call for dates

Preferred date

Preferred date

Contact Us

Tech Classes

Where is it?

What’s included

Why choose us?

Most classes are guaranteed to run. Training is available on your choice of Mac or PC.

Microsoft Power BI – Training Calgary « click for details 2 days | | $1,190 PLUS TAX

Dates

Microsoft Power BI – Training Calgary 2 days | | $1,190 PLUS TAX

COURSE OUTLINE

Introduction to self-service BI solutions

Introducing Power BI

Power BI data

Shaping & combining data

Modelling data

Interactive data visualizations

Dates

Developing SQL Data Models « click for details 3 days | | $1,785 PLUS TAX

Dates

Developing SQL Data Models 3 days | | $1,785 PLUS TAX

TARGET AUDIENCE

COURSE OBJECTIVES

COURSE OUTLINE

INTRODUCTION TO BUSINESS INTELLIGENCE AND DATA MODELING

CREATING MULTIDIMENSIONAL DATABASES

WORKING WITH CUBES AND DIMENSIONS

WORKING WITH MEASURES AND MEASURE GROUPS

INTRODUCTION TO MDX

CUSTOMIZING CUBE FUNCTIONALITY

IMPLEMENTING A TABULAR DATA MODEL BY USING ANALYSIS SERVICES

INTRODUCTION TO DATA ANALYSIS EXPRESSION (DAX)

PERFORMING PREDICTIVE ANALYSIS WITH DATA MINING

Dates

SQL Server Performance Tuning and Optimization « click for details 5 days | | $2,970 PLUS TAX

Dates

SQL Server Performance Tuning and Optimization 5 days | | $2,970 PLUS TAX

TARGET AUDIENCE

COURSE OBJECTIVES

COURSE OUTLINE

COURSE OVERVIEW

SQL 2014 ARCHITECTURE

THE DATABASE ENGINE

SQL PERFORMANCE TOOLS

QUERY OPTIMIZING AND OPERATORS

UNDERSTANDING INDEXES

UNDERSTANDING STATISTICS

IN-MEMORY DATABASE

SQL PROFILER AND SQL TRACE

QUERY ISSUES AND HINTS

Dates

SQL Server 2014 High Availability « click for details 3 days | | $1,785 PLUS TAX

Dates

SQL Server 2014 High Availability 3 days | | $1,785 PLUS TAX

COURSE OBJECTIVES

COURSE OUTLINE

HIGH AVAILABILITY OVERVIEW

OVERVIEW OF WINDOWS SERVER FAILOVER CLUSTERING

SQL SERVER 2014 HIGH AVAILABILITY OVERVIEW

ALWAYSON FAILOVER CLUSTERING

ALWAYSON AVAILABILITY GROUPS

LEGACY DATABASE MIRRORING

LEGACY LOG SHIPPING

USING REPLICATION FOR HIGH AVAILABILITY

HIGH AVAILABILITY SOLUTIONS INTEROPERABILITY

HIGH AVAILABILITY WITH VIRTUALIZATION

MEETING YOUR AVAILABILITY GOAL

Dates

Database Administration Fundamentals « click for details 3 days | | $1,785 PLUS TAX

Dates

Database Administration Fundamentals 3 days | | $1,785 PLUS TAX

TARGET AUDIENCE

COURSE OBJECTIVES

COURSE OUTLINE

Dates

Microsoft Report Builder 3.0 with SQL 2008R2, SQL 2012, and SQL 2014 « click for details 2 days | | $1,190 PLUS TAX

Dates

Microsoft Report Builder 3.0 with SQL 2008R2, SQL 2012, and SQL 2014 2 days | | $1,190 PLUS TAX

TARGET AUDIENCE

COURSE OBJECTIVES

COURSE OUTLINE

Microsoft Power BI – Training Calgary « click for details
2 days | | $1,190 PLUS TAX

Developing SQL Data Models « click for details
3 days | | $1,785 PLUS TAX

SQL Server Performance Tuning and Optimization « click for details
5 days | | $2,970 PLUS TAX

SQL Server 2014 High Availability « click for details
3 days | | $1,785 PLUS TAX

Database Administration Fundamentals « click for details
3 days | | $1,785 PLUS TAX

Microsoft Report Builder 3.0 with SQL 2008R2, SQL 2012, and SQL 2014 « click for details
2 days | | $1,190 PLUS TAX

Oracle 12c SQL Fundamentals « click for details
5 days | | $2,695 PLUS TAX

Oracle Database 11g R2 – SQL Tuning, Architecture and Internals « click for details
5 days | | $2,695 PLUS TAX

Plans change, and we can accommodate all reasonable requests. Sometimes there are hard costs
involved but we’ll work with you to reduce or avoid them altogether. Please direct all cancellation
and rescheduling emails to learning@thetrainingcompany.ca