SQL Programming school training courses in Burlington, VT (public, in-house or online)

This SQL programming course teaches students relational database fundamentals and SQL programming skills. Topics covered include relational database architecture, database design techniques, and simple and complex query skills. This class is intended for analysts, developers, designers, administrators, and managers new to the SQL programming language. Upon completion, participants will understand SQL functions, join techniques, database objects and constraints, and will be able to write useful S...

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

Our trainers are industry and product experts that have mastered the use of each product in the field and enjoy teaching others how extract the maximum benefit from OEM product use at each students organization, big or small. Students learn from Industry experts with hands on product experience in multiple hardware and software environments and will benefit in the following ways.

Benefits of AMS Trainers
•The industries highest quality Computer Product Trainers for more than 4,000+ pro...

Full archival course description>>