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
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).
Accelerated Introduction to SQL Using Oracle I 1 and 1/2 day introduction to Oracle SQL (PL/SQL) used in the Oracle Database. Intensive, hands-on course custom designed for analysts and power users. Same material as SQL200 but taught in an Oracle environment. Topics include data retrieval and manipulation, modifying data and creating tables and views. Uses the SQL Plus Query tool and the new Oracle SQL Developer.
1 and 1/2 days
Introduction to SQL Queries using Oracle Introduction to SQL queries using Oracle. Intensive, hands-on SQL class focusing on SQL data retrieval. Same as first two modules of SQL212. This course is ideal for business analysts looking to acquire SQL skills.
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 thourough introduction to designing and implementing MS Access queries using Access's JET SQL in this unique course. Can 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 6 full days of regularly scheduled classes at a large discount. Good for any scheduled class in San Juan Capistrano. 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 training courses are offered in three formats: 1) on-site groups at your facility in the Greater Los Angeles and San Diego areas or our studio, 2) private one on one SQL training as arranged and 3) regularly scheduled SQL classes at our studio in San Juan Capistrano, Orange County, CA. See calendar...
(Final prices will reflect tuition, materials,
registration, applicable discounts and charges.)