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