If you are not learning technology of today then you can’t be part of a successful workforce of tomorrow. With our online certification courses you just don’t master the technology, you also get recognition. We are sure that this will get you the dream job and a shining that you want to have. Our online courses will provide you a personalized learning experience giving you enough flexibility of schedule/time and saving a lot of money and time for you.
Why Take This Course?
Why Join Us ?
Advance your Career
This program was built to ensure that you learn the right skills which are necessary to succeed.
|Oracle 11g PL/SQL Fundamentals I|
|Selecting the Appropriate Database Tool||00:00:00|
|Selecting the Appropriate Database Tool||00:00:00|
|Working with SQL Plus||00:00:00|
|DECLARE Clause Objects||00:00:00|
|PL/SQL Available Data Types||00:00:00|
|Declaring Simple Data Types and||00:00:00|
|Declaring Complex Data Types and Assignments||00:00:00|
|Declaring Complex RowTypes and Assignments||00:00:00|
|Declaring Complex Tables||00:00:00|
|Declaring Complex Records||00:00:00|
|Creating and Declaring User-Defined Types||00:00:00|
|What Can Be Included in the BEGIN Clause||00:00:00|
|Working with CHAR and VARCHAR2 Variables||00:00:00|
|Handling String Literals||00:00:00|
|Working with Numeric Variables||00:00:00|
|Working with Date Variables||00:00:00|
|Assigning and Using Boolean Variables||00:00:00|
|Using SQL Functions||00:00:00|
|SQL DML within PL/SQL||00:00:00|
|Exceptions and Embedded SQL||00:00:00|
|Logic Control and Branching||00:00:00|
|Working with LOOPS||00:00:00|
|Creating and Using the Indefinite Loop||00:00:00|
|Creating and Using the Conditional Loop||00:00:00|
|Using Nested Loops||00:00:00|
|Using the If-Then-Else||00:00:00|
|Using the CASE Statement||00:00:00|
|What Are the Types of Exceptions||00:00:00|
|Identify Exception Details||00:00:00|
|Creating User-Defined Exceptions||00:00:00|
|Using SQLCODE and SQLERRM Objects||00:00:00|
|Understand the Implicit Cursor||00:00:00|
|Creating User-Defined Events||00:00:00|
|Understanding the Concept and Purpose of Explicit Cursors||00:00:00|
|Learn about Cursor Attributes||00:00:00|
|Using the Continue Statement||00:00:00|
|Working with Updatable Cursors||00:00:00|
|Creating and Using Cursor Parameters FOR…LOOP Cursors||00:00:00|
|Understanding Nested Blocks||00:00:00|
|Difference between Global vs Local Objects and Exceptions||00:00:00|
|Subprograms: How They Differ from Nested Blocks||00:00:00|
|Course on Oracle 11g PL/SQL Fundamentals II|
|Install Oracle XE||00:00:00|
|SQL Developer Installation||00:00:00|
|Introducing the Database Program Unit||00:00:00|
|Creating Stored Procedures and Functions||00:00:00|
|Understanding the Parameter Specification||00:00:00|
|Executing Procedures and Functions||00:00:00|
|Calling Functions from within SQL||00:00:00|
|Handling Compilation Errors||00:00:00|
|Recompiling and Dropping Programs||00:00:00|
|Data Dictionary Storage||00:00:00|
|Using the Dependency Tracking Utility||00:00:00|
|What Is a Package? Creating a Package||00:00:00|
|Package Definition Information||00:00:00|
|Advanced Programming Techniques||00:00:00|
|Using Persistent Global Objects||00:00:00|
|Including Initialization Logic||00:00:00|
|Object Oriented Support within Packages||00:00:00|
|Learning to Use Cursor Variables||00:00:00|
|Weak Cursor Definitions||00:00:00|
|REF CURSOR Cursor Definition||00:00:00|
|Using Cursor Expression||00:00:00|
|Using the DBMS OUTPUT() Package||00:00:00|
|Using the UTL_FILE() Package||00:00:00|
|Understanding the Database Trigger||00:00:00|
|Row-Level Triggers Row Level Trigger Example 1 Row Level Trigger Example 2 Row Level Trigger Example 3||00:00:00|
|Working with the INSTEAD OF Trigger||00:00:00|
|Using Triggers within an Application||00:00:00|
|Using the CALL Statement||00:00:00|
|Trigger Maintenance Tasks Work with Multiple Triggers for a Single Table||00:00:00|
|Handling Mutating Table Issues||00:00:00|
|Using the Compound Trigger||00:00:00|
|What Is a System Event Trigger||00:00:00|
|Course on creating Database|
|Introduction to Database Objects||00:00:00|
|Database Objects – Index and View||00:00:00|
|Relational DBMS (RDBMS) – Introduction Computers and Databases||00:00:00|
|Installing Oracle 12c in Windows 10||00:00:00|
|Oracle Storage Structures||00:00:00|
|Oracle Parameter Files||00:00:00|
|Connecting to an Oracle Database||00:00:00|
|Basics of Oracle Database Internals and Security||00:00:00|
|Basic Oracle Database Operations||00:00:00|
|Structured Query Language (SQL)||00:00:00|
|Oracle Memory and Background Processes||00:00:00|
|SGA and Database Buffer||00:00:00|
|Oracle Backup and Recovery Concepts||00:00:00|
|Oracle Database 12c||00:00:00|
|LAB 2 – Connect String||00:00:00|
|Lab 3 – CREATE TABLESPACE||00:00:00|
|LAB 4 – Creating Schema User||00:00:00|
|LAB 5 – Logging in as the Schema user||00:00:00|
|LAB 6 – CREATE TABLE||00:00:00|
|LAB 7 – CREATE INDEX||00:00:00|
|LAB 8 – ALTER TABLE||00:00:00|
|LAB 9 – INSERT||00:00:00|
|LAB 10 – DELETE||00:00:00|
|LAB 11 – UPDATE||00:00:00|
|LAB 12 – Creating a ROLE||00:00:00|
|LAB 13 – Creating an Application user||00:00:00|
|LAB 14 – Testing the Application user||00:00:00|
|LAB 15 – Revoking the permissions||00:00:00|
|LAB 16 – Dropping the application user||00:00:00|
|LAB 17 – Dropping the Schema user||00:00:00|
|LAB 18 – Dropping the Tablespace||00:00:00|
|Oracle SID and Service Name||00:00:00|
|Oracle Client Side Networking||00:00:00|
|Beginner to advance PQ/SQL Course|
|Installing Java SDK||00:00:00|
|Installing SQL Developer||00:00:00|
|Running scripts necessary for the course Scripts for our Lab Exercises||00:00:00|
|PL/SQL Basics and What is PL/SQL||00:00:00|
|PL/SQL Structure First Example||00:00:00|
|Comments in PL/SQL||00:00:00|
|Scope of Variables||00:00:00|
|IF then ELSE statement||00:00:00|
|FOR Loop Exercise #1||00:00:00|
|Processing Data via PL/SQL||00:00:00|
|Working with Records||00:00:00|
|Cursors What are Cursors? Implicit Cursor Explicit Cursor||00:00:00|
|Retrieving 1 row using Explicit Cursor Retrieving more than 1 row using Explicit Cursor||00:00:00|
|Using Records in Cursors Cursor FOR Loop||00:00:00|
|Cursor Variable and Reference Cursor Exceptions for Cursors||00:00:00|
|Collections – What are Collections||00:00:00|
|What are VARRAYS||00:00:00|
|Scripts necessary to practise Triggers||00:00:00|
|Statement Level Trigger||00:00:00|
|Statement Level Trigger with multiple||00:00:00|
|Row Level Trigger||00:00:00|
|OLD and NEW Pseudo Records with an Example||00:00:00|
|Restricting the Trigger based on a Condition using the WHEN clause||00:00:00|
|Restricting the Trigger at a column level using the OF clause||00:00:00|
|Advanced Topics – Bulk Processing||00:00:00|
|Bulk Processing Introduction Bulk Processing Example Bulk Processing with LIMIT option Bulk Processing with ROWTYPE Enable/Disable/Drop a TriggerHandling Bulk Processing Exceptions||00:00:00|
|Advanced Topics – Dynamic SQL Dynamic SQL Introduction Dynamic SQL Example Bind variables and Parsing Dynamic SQL with Bind variables Dynamic SQL with Cursors Dynamic SQL with Bulk Collect DBMS_SQL package||00:00:00|
|Advanced Topics – Table Functions Object Creation Table Functions Pipelined Table Functions||00:00:00|
|Advanced Topics – Large Objects (LOB’s) Large Objects (LOB’s) Introduction Character Large Object (CLOB) Binary Large Object (BLOB) Storing Images/Videos in BLOB’s Binary Files (BFILE) Temporary LOB’s||00:00:00|
Learn with Instructor led LIVE Classes same like classroom training
Self Paced Videos
Learn with Pre Recorded Videos & Project work with any time, any where
We come to train you in your office campus itself
How can I get this course?
Click over “BUY NOW” Button given below the course, you will be redirected to online payments page. Payment can be done online via different modes of payment like Credit Cards, Debit Cards, Net Banking, E-wallets etc.
What do I get?
Depends upon what you choose. You can either enroll for live classes or purchase a tablet/SD card course.
How are live classes different from SD card/tablet courses?
Live classes will be streamed online through our platform on scheduled time. You can watch the streaming session along with other learners, ask your doubts immediately and get them resolved. While tablet/SD card courses are pre-recorded which you can watch whenever you want. Although live streamed videos will remain available to watch-re watch upto a certain time period.
How do I get my doubts resolved?
In live classes you can ask your doubts immediately where it will be resolved by our experts immediately. In case of tablet/SD card courses you can mail your doubts/questions to the mail id provided. Your doubts will be resolved within 24 hours by our experts.
How many number of times can I watch the videos?
You can watch video courses as many times as you want, during the validity duration of the course. However, after the validity period videos will get vanished from SD card/tablet. Although SD card/tablet will be yours to use onwards.
What will be the validity duration of courses?
It will be mentioned for each course. You’ll have the options to choose any of the mentioned plans.
What if I miss my scheduled live class?
No worries at all. Each and every video will be available after each live session. You can watch that when you get time. You can also watch them any number of time during the course duration.
Do I need some software or special tool to play lecture videos?
No. You can play our videos on regular video players. Also our live courses will be streamed on our website so you don’t need any special software or tool for that.