SQL Programming school training courses in Chicago, IL (public, in-house or online)

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 abstract code

Course Benefits

The Oracle PL/SQL language—a flexible procedura...

Full archival course description>>

You 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>>

You 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>>

Learn an array of valuable tips, techniques, and advanced topics to implement cleaner and more efficient code. Lecture and lab emphasis is on good coding practices, manipulating numbers and dates, joins and subqueries, applied case logic, cursors, and proper Stored Procedure development and debugging, as well as generalized methods for solving specific problems.
Course Objectives :
Upon completion of this course, you will be able to:
Describe ASE Access Methods
Explain how the Que...

Full archival course description>>

Discuss 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>>