SQL

at school(s) in Philadelphia or delivered online/live/on-site/by e-learning

Oracle PL/SQL Programming
Course Format: Classroom
School/Trainer: Learning Tree International [All Courses]
Training Center(s)/Venue(s): Atlanta, Boston, Chicago, Los Angeles, Baltimore, New York, Philadelphia, United States
Jobs & Resumes: Atlanta, Boston, Chicago, Los Angeles, Baltimore, New York, Philadelphia
Houses & Roommates: Atlanta, Boston, Chicago, Los Angeles, Baltimore, New York, Philadelphia

you will learn how to Develop efficient PL/SQL programs to access Oracle databases Create stored procedures and functions for maximum reuse and minimum code maintenance Design modular applications using packages Manage data retrieval for front-end applications Bulk bind collections to increase the speed of data movement operations Invoke native dynamic SQL to develop high-level abstr......

Course description>>
 

you will learn how to Configure and optimize MySQL on multiple platforms Design, create and maintain MySQL databases Construct efficient SQL queries incorporating MySQL extensions Identify the correct database table types to use in your application Manage MySQL using graphical tools Optimize database performance and enhance reliability who should attend This course provides a co......

Course description>>
 

you will learn how to Build ADO.NET 2.0 applications for SQL Server 2005 Maximize performance using ADO.NET’s connected model Read and process data from SQL Server and XML sources Retrieve and modify disconnected data Ensure data consistency with transactions and exception handling Exploit the powerful data-binding capabilities of ADO.NET course benefits Organizations need ......

Course description>>
 

you will learn how to Develop database applications for SQL Server 2000 with Transact-SQL Query and modify data with Transact-SQL Create and debug stored procedures Take advantage of AFTER and INSTEAD OF triggers Manage concurrency using transactions and locking options Exchange data effectively using Transact-SQL’s support for XML Tune database queries for optimal performance......

Course description>>
 

you will learn how to Develop database solutions using Access as a front-end to SQL Server Create tables, views and stored procedures in SQL Server Upsize Access data to exploit SQL Server capabilities Optimize Access forms and reports based on linked SQL Server data Transform Access queries into stored procedures and views Employ ADO programming practices to manage data using VBA ......

Course description>>
 

you will learn how to Design and implement high-performance databases for SQL Server 2005 and 2000 Create indexes that optimize different types of queries Design transactions that maximize concurrency and minimize contention Interpret the data access plans produced by the query optimizer Minimize I/O by designing efficient physical data structures Improve response time by introducing......

Course description>>
 

Pages:- 1 2 3 4 5 6 7 8 9 10 11 ...
[ Workshops ] [ Online Courses ] [ Corporate Training ] [ Topics ] [ Locations ] [ Schools ] [ Job Seekers ]

Dear Visitor: You are strongly recommended to bookmark this page and come back later, since new course may be available anytime. Click to Proceed>>