Duration: 3 days
US Price: $1,595
UK Price: £995 *Prices are subject to VAT
CA Price: CDN$1,575 *Prices are subject to GST/HST
Description: 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 SELECT, INSERT, UPDATE and DELETE statements. Comprehensive hands on exercises are integrated throughout to reinforce learning and develop real competency.
Prerequisites: General computer knowledge. Familiarity with relational database concepts is helpful but not required.
|Relational Database Fundamentals
||Writing Basic SQL Queries
|Creating a Database
||Manipulating Query Results
|Advanced Query Techniques
||Manipulating Table Data Using SQL's Data Manipulation Language (DML)
||Working with Views
Due to border restrictions, we may not be able to accommodate requests for face-to-face training in Canada. Relocation assistance may be available to attend offerings in the United States. We also offer a remote attendance option. With remote attendance you receive the same live training delivery as students in the classroom and perform hands on exercises using the same equipment. Two-way video and audio communication allows interactive participation as though you are "sitting in the back row" as previous students have characterized our training. To read more about our remote attendance option, click here. If you have any questions, call us at 978.250.4983.