(ourse Duration: 5 Days (40 hours
Prerequisite: Oracle Database 12c Program with PLSQL
?What will you learn
SQL course introduces students to the fundamentals of SQL using Oracle Database 11g database technology. In this course students learn the concepts of relational databases and the powerful SQL programming language beside many Oracle SQL features that you cannot find in any other Database.PL/SQL part of this course introduces students to PL/SQL and explains the benefits of this powerful programming language. Students learn to create PL/SQL blocks of application code that can be shared by multiple forms, reports, and data management applications. Students also learn to create anonymous PL/SQL blocks and are introduced to stored procedures and functions. Students learn about declaring identifiers and trapping exceptions. Students use Oracle SQL Developer to develop, execute and manage PL/SQL stored program units such as procedures, functions, packages, and database triggers. Students also learn to manage, PL/SQL subprograms and triggers. Students are introduced to the utilization of some of the Oracle-supplied packages. the fundamental concepts. Students use Oracle SQL Developer to develop these program units. SQL*Plus and JDeveloper are introduced as optional tools.
Course outline: