CALL US TODAY ! 9354437773 | info@firstskool.org

Why Take This Course?

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.

Courses on Oracle provide an insight as to how other operating systems have developed.

Why Join Us ?

null

Expert Team

Our courses are developed by team of experts who have
real expertise in the same domain. They know what is
best for you and how to deliver it to you. Courses are
finalized after proper scruiting, minimising chances
of any error.
null

Consistent Guidance & Doubt Resolution

Our expert team would always be there for you to
clear any doubt regarding subject matter or providing
you guidance regarding the course you are taking.
null

Personalized Learning

You can watch our videos in your laptop/tablet at your
homes whenever you want. Saving lot of time and money
that you would be spending at coaching centres in megacities.
null

One Stop Solution

We will be providing everything that you need to
develop relevant skills and lead a path to success
in corporate world.

Advance your Career

This program was built to ensure that you learn the right skills which are necessary to succeed.

Be Right On Target

With our accurate and guidance scientific teaching methods you can acquire skills and knowledge which is essential for making you what you want to be.

Learn with Ease

You don’t have to go through tons of coaching materials and lots of stress analyzing what to study from where to study. Learn with us sitting at your homes in comfort what is essential.

Learning Community

By joining groups you can have peers to learn and compete with. It certainly helps in assessing yourself and eases the path to success.


Course Curriculum

Oracle 11g PL/SQL Fundamentals I
Introduction 00:00:00
Course Setup 00:00:00
Selecting the Appropriate Database Tool 00:00:00
Selecting the Appropriate Database Tool 00:00:00
PL/SQL Blocks 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
Assignments 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
Comparison Operators 00:00:00
Using SQL Functions 00:00:00
SQL DML within PL/SQL 00:00:00
Using SELECT 00:00:00
Exceptions and Embedded SQL 00:00:00
Using Sequences 00:00:00
Logic Control and Branching 00:00:00
Using GOTO 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
Trapping 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
Introduction 00:00:00
Install Oracle XE 00:00:00
SQL Developer Installation 00:00:00
Workstation Setup 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
Managing Dependencies 00:00:00
Tracking Dependencies 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
Package Maintenance 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
Statement-Level Triggers 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 Languages 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
Concepts Illustrated 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
Programmable Objects 00:00:00
Oracle Backup and Recovery Concepts 00:00:00
Oracle Database 12c 00:00:00
Oracle Networking 00:00:00
Diagnostic Data 00:00:00
LAB Scenario 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 Listener 00:00:00
Oracle Client Side Networking 00:00:00
Beginner to advance PQ/SQL Course
Software Installation 00:00:00
Installing Oracle 00:00:00
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 Advantages 00:00:00
PL/SQL Structure First Example 00:00:00
Declaring Variables 00:00:00
Comments in PL/SQL 00:00:00
Scope of Variables 00:00:00
IF then ELSE statement 00:00:00
CASE Statement 00:00:00
WHILE Loop 00:00:00
FOR Loop Exercise #1 00:00:00
Processing Data via PL/SQL 00:00:00
PL/SQL Blocks 00:00:00
Exceptions 00:00:00
Packages 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
Exercise #7 00:00:00
Collections – What are Collections 00:00:00
Collection Terminology 00:00:00
Associative Arrays 00:00:00
Nested Tables 00:00:00
What are VARRAYS 00:00:00
Collection Methods 00:00:00
MULTISET Operators 00:00:00
Collections Summary 00:00:00
Exercise #8 00:00:00
Triggers 00:00:00
Scripts necessary to practise Triggers 00:00:00
Trigger’s Introduction 00:00:00
Trigger Types 00:00:00
Statement Level Trigger 00:00:00
Statement Level Trigger with multiple 00:00:00
Actions 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
Context Switch 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

Pricing

FAQ

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.

© FirstSkool  All rights reserved.

X