The Introduction to Structured Query Language (SQL) course focuses on both the database design, which covers the process of analyzing complex business scenarios and creation of a data model, and the programming in SQL, which introduces the concepts of implementing a database design by creating a physical database, and covers such topics as subqueries, combining multiple queries into a single query using SET operators, and reporting aggregated data using group functions. The Oracle Programming in Procedural Language/Structured Query Language (PL/SQL) course is designed to extend the database programming knowledge in the Intro to SQL course and covers implementing database functionalities that cannot not be achieved in standard SQL, such as stored procedures, functions, packages, and more. These two courses prepare students for certification as an Oracle PL/SQL Developer Certified Associate.

Prerequisites: Because this is a combined course, faculty will need to have some familiarity with database concepts and participate in a total of 5-6 webinars - 3 prior to and 2-3 after the in-class training.

For travel assistance information, please visit: http://batec.org/summer_institute_2013/classesdisplay.php
ATE Area:
  • Information and Security Technologies
Add to Calendar:
BATEC Summer Institute- Oracle SQL & PL-SQL.ics

Location

Google Map Google Map