Home

About Us

Catalog Main Catalog Microsoft Access Courses Database Development Courses Discounts and Passports Miscellaneous Fees & Services SQL Courses

Contact Us

SQL212: Accelerated Introduction to SQL Using Oracle I Book List | Course Links
Tuition: $290.00 per student Length: 1 and 1/2 days
Synopsis: 1 and 1/2 day introduction to Oracle 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 new Oracle SQL Developer GUI tool.
Formats: Corporate groups (min. 2 students) at your facility or online. Single individuals may arrange a private class.
Scheduling: Flexible. Both onsite and online classes are custom scheduled to suit.
Group Discounts: 2-4 students 20%, 5-8 30%, >8 quote

Session 1	Introduction to SQL	3.0 Hours
	Relational database foundations Using Oracle SQL Develope or SQL Plus Basic SQL data retrieval operations, DML SQL Select statement SQL Predicates, SQL Where clause Operators Sorting Calculated fields, Concatenation
Session 2	SQL Functions, Multi-table Retrieval	3.0 Hours
	String Manipulation Date Functions, Etc. SQL Aggregate functions (SUM, AVG, etc.) Group by Having Inner join, outer joins, self join Single and multi-valued subqueries Correlated subqueries Unions
Session 3	SQL Data Modification	3.0 Hours
	Modifying data, Insert, Update, Delete Creating tables and constraints, CREATE, DROP Modifying table design, ALTER Creating and using Views Creating Indexes Summary & Conclusion

Materials: Manual with PowerPoint slides, text book, and training certificate.   Location: Classes are normally taught on-site at your facilities or via online Remote Learning. Related Services Need help with a project? We may also provide programming and consulting services covering the above material. See Programming and Consulting for more information.