SQL Advanced

ProTech Professional Technical Services Canada, Ltd.
Calgary, Edmonton, Ottawa, Toronto, Vancouver, Victoria, Winnipeg, Canada

Course Format: Classroom | E-learning | Virtual Class | Online | On-site | Blended | Self-paced

Course Description:

'' This course is intended to give experienced application developers better query testing techniques, more depth with complex SQL syntax, a good grasp of performance considerations, and an overview of writing stored procedures, functions and triggers.

Audience: This course is designed for application developers who work in any relational database environment, including Oracle, SQL Server, Sybase, DB2 for z/OS or Universal Database, Access, Ingres,Informix, and many others.

Topics:
Introduction
Statistics and Access Paths
Locking and Performance Issues
Advanced Joins
Advanced Subqueries
Set Operators
Case Logic
Advanced Use of SQL Functions
Advanced Summarization
Stored Procedures
User Defined Functions
Triggers
Prerequisites: Students should take SQL for Application Developers, or have recent training in SQL, or at least six months of hands-on experience with SQL in any database environment
...''

Phone:866-821-9311

School Address:

111 Peter Street
Suite 626
Toronto, ON M5V 2H1 Canada

Jobs & Resumes: Calgary, Edmonton, Ottawa, Toronto, Vancouver, Victoria, Winnipeg
Houses & Roommates: Calgary, Edmonton, Ottawa, Toronto, Vancouver, Victoria, Winnipeg

Project Management Leadership Skills
Project Management Negotiation Techniques
Project Management Skills for the Business Analyst
Quality Management and Project Integration
RACF Administration
RH033 Red Hat Linux Essentials
RH253 Red Hat Linux Networking and Security
SAP Overview
Software Testing Methods and Tools
Solaris Internals
SQL Basics
Storage Network Foundations
Storage Networking Management/Administration
Structured Systems Analysis and Design
Tivoli Identity Manager 4.5 System Admini
UNIX and Linux System B
UNIX Performance Management
UNIX Systems Administration
VoIP Boot Camp

Notice: The course description on this page was captured from the Internet as historical reference or submitted by visitors. It was archived statically and not updated from day to day.
 

Tips: In most cases you will get a unique submit code along with your each posting on this website. Please provide it as well as the message title if you want any assistance for editing/removal.