Instructor Led Database Administrators Training in Canada

Oracle 10g Administration Comprehensive, hands-on class focusing on the day-to-day tasks a DBA will perform to create, maintain and manage an Oracle 10g Database such as security, creating and managing users, creating and managing database objects (tablespaces, tables, indexes, etc.), running utilities, configuring Oracle networking, and simple backup and recovery techniques. Provides an overview of the Oracle Data  more...

Oracle 10g 11g PL SQL Programming This class will teach you how to write efficient and scalable PL/ SQL programs to create database-intensive PL/ SQL applications. Learning how to create efficient, scalable PL/ SQL programs is an important objective of this course. To meet that objective, the course includes instruction on such things as the proper use of bind variables, bulk processing, pipelining, benchmarking different  more...

Oracle 10g 11g Advanced SQL ...to query Oracle databases including developers, analysts, database administrators and decision support personnel. Persons working in a data warehouse or decision support environment will benefit greatly from the lessons on analytic functions, grouping with CUBE and ROLLUP, modeling (the Oracle10g MODEL clause) and coding queries on partitioned data. Further, this course is well suited for  more...

Oracle 10g 11g Introduction to SQL This course is designed for developers who are new to relational database and need to know how to query, update and create basic objects in Oracle databases. Students receive a comprehensive introduction to Oracle's implementation of the SQL language and the common query tools, SQL*Plus and iSQL*Plus. The course includes a lesson on basic relational database concepts. LEARNING  more...

Updating Your SQL Server 2005 Skills to SQL Server 2008 - nexient This course is intended for experienced SQL Server 2005 developers & database administrators who want to upgrade their skills to SQL Server 2008. Learn how to: Describe the new features of SQL Server 2008; Manage, Optimize, Secure & SQL Server 2008...  more...

Writing Queries Using Microsoft SQL Server 2008 Transact-SQL This course is intended for SQL Server database administrators, implementers, system engineers, and developers who are responsible for writing queries.  more...

Designing Microsoft SQL Server 2005 Infrastructure and Services This course provides database administrators working in enterprise environments with the knowledge and skills to design a Microsoft SQL ServerT 2005 database infrastructure.  more...

Designing Security for Microsoft SQL Server 2005 This course enables database administrators in enterprise environments to design security for database systems using Microsoft SQL ServerT 2005.  more...

Designing a High Availability Database Solutions Using Microsoft SQL Server 2005 The course focuses on teaching experienced database administrators working in enterprise environments to design database solutions that meet the availability needs of their organization.  more...

Troubleshooting and Optimizing Database Servers using Microsoft SQL Server 2005 This workshop teaches database administrators working in enterprise environments how to determine and troubleshoot performance issues using Microsoft SQL Server 2005. The primary focus of this workshop is to teach the overall process of troubleshooting.  more...

2786B Designing a Microsoft SQL Server 2005 Infrastructure MS Certification This two-day instructor-led course provides database administrators working in enterprise environments with the knowledge and skills to design a Microsoft SQL ServerT 2005 database infrastructure.  more...

2790A Troubleshooting and Optimizing Database Servers Using Microsoft SQL Server 2005 MS Certification The purpose of this two-day workshop is to teach database administrators working in enterprise environments how to determine and troubleshoot performance issues using Microsoft SQL Server 2005.  more...

2786 - Designing a Microsoft SQL Server 2005 Infrastructure This two-day instructor-led course provides database administrators working in enterprise environments with the knowledge and skills to design a Microsoft SQL ServerT 2005 database infrastructure.  more...