SQL & PL/SQL
Oracle Database: SQL Fundamentals
Source Duration : 40 Hours Exam Code : 1Z0-071
- Introduction
- Retrieving Data Using the SQL SELECT Statement.
- Restricting and Sorting Data.
- Using Single-Row Functions to Customize Output.
- Using Conversion Functions and Conditional Expressions.
- Reporting Aggregated Data Using the Group Functions.
- Displaying Data from Multiple Tables using Joins.
- Using Subqueries to Solve Queries.
- Using the Set Operators.
- Manipulating Data.
- Using DDL Statements to Create and Manage Tables.
- Creating Other Schema Objects.
Additional Topics.
- Using SQL Developer.
- Using SQL*Plus.
- Oracle Joins.
Oracle PL/SQL Fundamentals
Source Duration : 40 Hours Exam Code : 1Z0-149
- Declaring PL/SQL Variables.
- Writing Executable Statements.
- Writing SQL in PL/SQL.
- Writing Control Structures.
- Working with Composite Data Types.
- Using Explicit Cursors.
- Handling Exceptions.
- Using PL/SQL Subprograms.
- Creating Procedures and Using Parameters.
- Creating Functions.
- Creating Packages.
- Working with Packages.
- Using Dynamic SQL.
- Design Considerations for PL/SQL Code.
- Creating Compound, DDL, and Event Database Triggers.
- Using the PL/SQL Compiler.
- Managing PL/SQL Code.
- Managing Dependencies.
For More Details and complete syllabus
Contact
Info@gitacademy.in
Or Call on
+91 9588610775
Drop a mail
send us a message
Drop a mail to us , ask your doubts and get full details about all the courses offered by us.