This course will Intro to SQL training and concepts of relational databases and the SQL programming language. You'll gain skills to write queries against single & multipletables, manipulate data in tables & create database objects.
This PL/SQL training shows you how to develop stored procedures, functions,
packages and database triggers. You'll learn to manage PL/SQL program units and dependencies.
Learn To:
- Understand the basic concepts of relational databases ensure refined code by developers.
- Create reports of sorted and restricted data.
- Run data manipulation statements (DML).
- Control database access to specific objects.
- Manage schema objects.
- Manage objects with data dictionary views.
- Retrieve row and column data from tables.
- Control privileges at the object and system level.
- Create indexes and constraints; alter existing schema objects.
- Create and query external tables.
- Conditionally control code flow (loops, control structures).
- Create stored procedures and functions.
- Use PL/SQL packages to group and contain related constructs.
- Create triggers to solve business challenges.
- Use some of the Oracle supplied PL/SQL packages to generate screen output and file output.
- Create custom packages for applications.
- Write Dynamic SQL code for applications.
Prerequisites
- Knoweldge of DBMS
- Data processing
Audience
- Working Professionals : Application Developers, System Analysts, Forms Developers, PLSQL Developers
- Freshers / New to Programming
View this Course
Certified
You have 
