SQL Programming school training courses in Columbia, SC (public, in-house or online)

Create database level applications. This class is applicable to Oracle8i, Oracle9i and Oracle Database 10g users. Participants will code procedural constructs including control statements, loops and cursors, create PL/SQL object constructs such as stored database procedures, functions, packages, and database triggers. Participants will develop techniques to enforce business rules within the database and perform value based auditing. Exercises and lab sessions reinforce the learning objectives an...

Full archival course description>>

This course provides a strong basis for anyone needing to read, delete and modify DB2 data, create and interact with DB2 objects. After a brief review of DB2 fundamentals, the three SQL components (DML, DDL and DCL) are covered. The course also introduces the student to the DB2 catalog and the wealth of information found in its contents. Hands-on exercises using DB2 to solve a variety of query requests are integrated with the lecture. Lecture covers V8 features and labs are done in V8.
Desig...

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

CCA 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.

This three-day, instructor-led course provides students with the knowledge and skills to properly manage the SQL Server 2005/2008 database development lifecycle in an Agile environment. The student will learn how to manage changes to the database schema, ensuring quality through T-SQL unit testing, and how to automate the building and deploying of SQL Server databases. Intended for developers and administrators already comfortable with the concepts of designing, programming, testing and depl...

Full archival course description>>