Accelerated Introduction to SQL Class Intensive hands-on introduction to standard SQL programming. Data manipulation, queries, data modification. Construction of tables, indexes and views. Constraints, etc. Can be taught using most major SQL platforms. No prior knowledge of SQL is assumed, although students should have some exposure to programming and/or use of other query systems (including Access).
Vendor-specific versions of this class are available. See SQL202 for Microsoft SQL Server, SQL201W for MySQL and SQL212 for Oracle.
1 and 1/2 days
$435.00/Student
Introduction to SQL Data Retrieval Accelerated introduction to standard SQL programming with focus on retrieval and reporting: data retrieval, filtering data, calculations, summarization and grouping, etc. Same as first two modules of SQL200. Can be taught using MySQL, SQL Server or Oracle. Students will create their own SQL script library in this course which they can take with them. No prior knowledge of SQL is assumed, although students should have some exposure to programming and/or use of other query systems (including Access). The next class in sequence is SQL302s Intermediate SQL Queries Using SQL Server
1 day
$295.00/Student
Accelerated Introduction to SQL Using Microsoft SQL Server I Intensive 1 and 1/2 day, hands-on introduction to SQL programming using Microsoft SQL Server (Transact SQL). Covers data manipulation, queries, data modification, tables, indexes, views constraints, etc. No prior knowledge of SQL is assumed, although students should have some exposure to programming and/or use of other query systems (including Access). The next class in sequence is SQL302 Intermediate SQL Using SQL Server
1 and 1/2 days
$435.00/Student
Accelerated Introduction to SQL Queries using SQL Server Introduction to SQL queries using Microsoft SQL Server. Intensive, hands-on SQL class focusing on SQL data retrieval. Same as first two modules of SQL202. This course is ideal for business analysts looking to acquire SQL skills.
1 day
$295.00/Student
Accelerated Introduction to SQL Using Microsoft SQL Server II Introduction to Transact SQL specic constructs used in Microsoft SQL Server environments. Covers triggers, functions, variables, etc. Expansion to full day under development. Students should have taken the full Introduction to SQL or have equivalent experience.
1/2 Day
$195.00/Student
Intermediate SQL Using Microsoft SQL Server Intermediate SQL class. Covers intermediate level joins, subqueries, with clause, common table expressions, window (row) functions, delete and update from. Students should have taken the full Introduction to SQL or have equivalent experience.
1 1/2 days
$535.00/Student
Intermediate SQL Queries Using Microsoft SQL Server Intermediate SQL class. Same as first two modules of SQL302. Covers intermediate level joins, subqueries, with clause, common table expressions, window (row) functions. Students should have taken <a href = \"http://www.dhdursoassociates.com/courses/computer-training.php?courseid=sql202s\">Introduction to SQL Queries</a> or have equivalent experience.
Accelerated Introduction to SQL Using MySQL Intensive 1 and 1/2 day, hands-on introduction to SQL programming using MySQL. Covers data manipulation, queries, data modification, tables, indexes, views constraints, etc. No prior knowledge of SQL is assumed, although students should have some exposure to programming and/or use of other query systems (including Access).
1 and 1/2 days
$435.00/Student
Access SQL & Query Design Training Introductory Access SQL Programming course using MS Access. Also covers using the MS Access Query Designer. Students will gain a thorough introduction to designing and implementing MS Access queries using JET SQL in this unique course. Can also be taught with SQL Server, MySQL or Oracle as the back-end. A basic knowledge of MS Access and query concepts is assumed.
1 day
$295.00/Student
Individual Combo Training Passport 4 full days of classes at a large discount. Valid for six-months from date of purchase. Includes all application passport classes plus the list below. Additional days may be purchased on the original invoice or any time within the passport period.
Microsoft SQL Server
MySQL
Relational Database Design
Microsoft Access VBA Programming
Please refer to the Application Passport if interested in an even less expensive option for the 100 level courses.
4 days
$595.00/Student
SQL courses are offered to both groups and individuals on a convenient, custom scheduled basis. We can even tailor the class to your needs. Most classes run from 9:00AM to 4:00PM with a 1 hour lunch break.
(Final prices will reflect tuition, materials,
registration, applicable discounts and charges.)