Oracle PL/SQL Programming
School: Learning Tree International Venue: Annapolis, Atlanta, Baltimore, Boston, Chicago, Dallas, Los Angeles, New York, Philadelphia Tel.: 1-888-843-8733You 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 abstract code
Course Benefits
The Oracle PL/SQL languageāa flexible procedura...
Full archival course description>>
|
SQL Programming Language Introduction
School: Learning Tree International Venue: Annapolis, Atlanta, Baltimore, Boston, Chicago, Dallas, Los Angeles, New York, Philadelphia Tel.: 1-888-843-8733You Will Learn How To
Write SQL code based on ANSI/ISO standards to build and maintain database structures Update database content with SQL and transaction handling Retrieve data from single or multiple tables Process data with row and aggregate functions Manipulate data with correlated and noncorrelated subqueries Apply views to break down problems and enhance security
Course Benefits
SQL forms the cornerstone of all relational database operations. The ...
Full archival course description>>
|
SQL Server Transact-SQL Programming
School: Learning Tree International Venue: Annapolis, Atlanta, Baltimore, Boston, Chicago, Dallas, Los Angeles, New York, Philadelphia Tel.: 1-888-843-8733You Will Learn How To
Develop database applications for SQL Server databases with Transact-SQL Create modular code using stored procedures Develop reusable code with scalar- and table-valued functions Handle Transact-SQL runtime errors to create robust software Audit data changes using AFTER triggers Manage concurrency using transactions and locking options
Course Benefits
Transact-SQL is integral to the power of SQL Server. Transact-SQL features allow d...
Full archival course description>>
|
DB2 SQL Format: Online
School: ExitCertified USA Venue: Houston, Las Vegas, Philadelphia, Phoenix, New York City, Sacramento, San Francisco, San Jose Tel.: 1.800.803.3948Discuss basic relational database concepts Use some of the OLAP features of DB2, such as GROUPing and RANKing functions Create tables, views and indexes Use referential integrity, check constraints and triggers Use outer joins, and join tables to themselves Use CASE expressions, and the CAST function Identify the impact of Summary Tables, Materialized Query Tables, and temporary tables Use complex subqueries Use a greater number of scalar SQL functions Use adv...
Full archival course description>>
|
SQL Format: Online
School: Community College of Aurora Venue: Aurora, Denver Tel.: 303-360-4700CCA is here to meet the needs of students as well as the needs of industry. We offer courses that you can start at any time and go at your own pace, whether you fast track your classes or take the full time to complete them. If you need to learn new skills quickly, this is the place for you. We offer both day and evening courses. Choose from a variety of classes and with a convenient schedule that fits your busy life. Official Website: http://www.ccaurora.edu/
|