PL SQL Online Training

Oracle 10g PL/SQL students will able to write stored procedures, functions, packages and triggers and implement complex business rules in Oracle. Students will also learn programming concepts, management and security issues of working with PL/SQL program units. Programming topics will include the creation of triggers and stored procedure features.

Description

PL/SQL (Procedural Language/Structured Query Language) is a database oriented programming language that extends Oracle SQL with procedural capabilities. This language offers far more execution potential than simple updates, selects, inserts, and deletes. It also offers a procedural extension that allows for modularity, declaration of variables, loops and other logic constructs and error handling.

Pre-requisites

Students must have sound Technical Knowledge and Logical Skills.

How will I perform the practical sessions in Online training?

For online training, US Global IT provides a virtual environment that helps in accessing each other’s system. The complete course material in pdf format, reference materials, course code is provided to trainees. US Global IT conductes online sessions through any of the available requirements like Skype, WebEx, GOTOMeeting, Webinar, etc.

PL SQL Course Syllabus

PL_SQL Overview
PL_SQL Environment Setup
Connecting to PL/SQL environment
PL_SQL Basic Syntax
Structure of pl-sql program
PL_SQL Data Types
PL_SQL Variables
PL_SQL Constants and Literals.
PL_SQL Operators
PL_SQL Conditions
PL_SQL Loops
PL_SQL Strings
PL_SQL Procedures
PL_SQL Functions
PL_SQL Cursors
PL_SQL Exceptions
PL_SQL Triggers
PL_SQL Packages

Certification

Certification assistance provided with proper guidance and certification notes.

Course Features

Online Courses: 40-45 Hours

For Instructor-led live online training program, each session will be 1-Hour as per schedule. We offer weekdays or weekend schedules. You have the flexibility to watch the class recording (which is posted on LMS) if you miss any class. For Self Paced Video Training program, you will be provided recorded videos for all topics covered.

Assignments/Quizzes: 10 Hours

Assistance/installation guides for setting up the required environment for Assignments/Projects is provided. Online access to quizzes with auto evaluation.

Project/Case Study: 5 Hours

At the end, you'll work on a real-time project based Case study on any of the selected Use cases. Problem statement and Data sets will be provided.

Course Materials Access: Lifetime

You get six months access to the Learning Management System (LMS). Apart from the class recordings all installation guides, class presentations, sample codes, project documents are available in the LMS. Course and Study materials access is provided for Lifetime.

24 x 7 Support

We have 24x7 online support team available for help with technical queries you may have during the course. All the queries are tracked as tickets and you get a guaranteed response. If required, the support team can also provide you live support by accessing your machine remotely.

Get Certified

Certification assistance provided with proper guidance and certification dumps.

Resume and Placement Assistance

US Global IT works with multiple consulting/staffing companies in US. Dedicated Resume and Interview assistance is provided by our experts after you successfully complete the training and project/case study. We or our sister consulting companies don’t charge any extra fees for this service.