Oracle Database MasterClass

Oracle Database MasterClass

Only 0 seats left.
Rs. 6,499.00 Sale price
About Course: This course is must for anyone who wants to develop desktop based or web based applications and wants to manage database efficiently. In this course you will learn latest about oracle along with the fundamentals of Oracle software. Oracle is the most successful RDBMS software used with most of the applications.You will also learn SQL and PL.

This Course Includes :

Video player free icon     60+ Hours of On-Demand Video
Smartphone      Learn from Mobile/PC/Tablet
Video player free icon      HD Quality Training Content
Web free icon      Industry Level Content
Pause free icon     Play & Pause Videos
Click free icon      6 Months Validity
Giftbox free icon     Bonus Content
Award free icon    Certification


Course Content

Introduction

  • Pre-requisites For This Course
  • What Is Oracle ?
  • What Is An OORDBMS?
  • History Of Oracle
  • Editions Of Oracle
  • Course Outline
                           
                                        video locked 
                Purchase this course to view this section

Introduction of SQL

  • Introduction To SQL
  • Oracle V/s SQL
  • History Of SQL
  • What Is PL-SQL ?
  • How To Use SQL & PL-SQL ?
  • Types Of SQL Commands
                              
                           
                                        video locked 
                Purchase this course to view this section

Data types

  • Data Types In Oracle
  • Char Types
  • Number Types
  • Date Types
  • LOB Types
  • ID Types
     
                          
                                        video locked 
                Purchase this course to view this section

Version & Installation

  • Data Types In Oracle
  • Char Types
  • Number Types
  • Date Types
  • LOB Types
  • ID Types
                           
                                        video locked 
                Purchase this course to view this section

Creating User

  • About Sys & System Users
  • Creating New User
  • Granting Privilege To The User
  • Create Table Command
  • Describe Command
                           
                                        video locked 
                Purchase this course to view this section

Table Commands

  • The ALTER TABLE Command
  • Uses Of ALTER TABLE Command
  • Adding / Modifying Columns
  • Deleting Columns
  • Rename Column/ Table
  • The TRUNCATE TABLE Command
  • The DROP TABLE Command
                           
                                        video locked 
                Purchase this course to view this section

DML Commands

  • Introduction To DML Commands
  • The INSERT Command
  • Different Types Of INSERT Commands
  • Introduction To null
  • The UPDATE Command
                           
                                        video locked 
                Purchase this course to view this section

Operators in Oracle

  • Operators In Oracle
  • Formatting Columns
  • Some Queries Based On Operators
  • Pattern Matching
                            
                                        video locked 
                Purchase this course to view this section

Functions in Oracle

  • Functions In Oracle
  • The DUAL Table
  • Various DATE Functions
  • Date Arithmetic
                           
                                        video locked 
                Purchase this course to view this section

Numeric Functions

  • Introduction To NUMERIC Functions
  • Various NUMERIC Functions Of Oracle
                          
                                        video locked 
                Purchase this course to view this section

Conversion functions

  • Introduction To CONVERSION Functions
  • The TO_CHAR() Function
  • The TO_NUMBER() Function
  • The TO_DATE() Function
                           
                                        video locked 
                Purchase this course to view this section

Group functions

  • Introduction To GROUP Functions
  • Types Of GROUP Functions
  • Introduction To MISCELLANEOUS Functions
  • Types Of MISCELLANEOUS Functions
                           
                                        video locked 
                Purchase this course to view this section

Clause

  • Introduction To GROUP BY Clause
  • Using WHERE With GROUP BY
  • Using HAVING With GROUP BY
  • WHERE vs HAVING
  • Introduction To ORDER BY Clause
  • Sorting Order Of ORDER BY
  • Sorting On Multiple Columns
  • Behavior  Of DISTINCT And NULL In ORDER BY
                            
                                        video locked 
                Purchase this course to view this section

Introduction to joins

  • Introduction To Joins
  • Types Of Joins
  • Cartesian Join
  • Equi Join
  • Outer Join
  • Types Of Outer Joins
  • ANSI Syntax For Join
  • Natural Join
  • Non-Equi Join
                            
                                        video locked 
                Purchase this course to view this section 

SubQuerries

  • SubQueries
  • Types Of SubQueries
  • Single Row SubQuery
  • Multi Row SubQuery
                           
                                        video locked 
                Purchase this course to view this section

Introduction of ROWNUM

  • Introduction To ROWNUM
  • Internal Working Of ROWNUM
  • Top N Analysis
  • Queries
                           
                                        video locked 
                Purchase this course to view this section

Set Operators

  • Introduction To Set Operators
  • Types Of Set Operators
  • Restrictions On Set Operators
  • Queries
                            
                                        video locked 
                Purchase this course to view this section

Constraints

  • Introduction To Set Operators
  • Types Of Set Operators
  • Restrictions On Set Operators
  • Queries
                            
                                        video locked 
                Purchase this course to view this section

Default Clause

  • Using The Default Clause
  • Renaming Constraints
  • Disabling/Enabling Constraint
  • Validate/NoValidate Option
  • Obtaining Details About Constraints
  • Removing Constraints
                           
                                        video locked 
                Purchase this course to view this section

Sequences

  • Introduction To Sequences
  • Syntax Of Sequence
  • Sequence Attributes
  • Using A Sequence
  • Connecting Sequence With Table
  • Removing Sequence
  • Obtaining Details Of Sequence
                            
                                        video locked 
                Purchase this course to view this section

View

  • Introduction To View
  • Advantages Of View
  • Types Of View
  • Making Changes In The View
  • Using Special Clauses With The View
  • Restrictions On A Single View
                           
                                        video locked 
                Purchase this course to view this section

Indexes

  • Introduction To Indexes
  • Benefits Of Indexes
  • Types Of Indexes
  • Single Index And Composite Index
  • Implicit Index And Function Based Index
  • Removing Indexes
  • Obtaining Details Of Index
                            
                                        video locked 
                Purchase this course to view this section

DCL Commands

  • Introduction To DCL Commands
  • Understanding Schema
  • SYS and SYSTEM
  • Creating New User
  • Concept Of TableSpace
  • Unlocking Users
  • Dropping Users
                            
                                        video locked 
                Purchase this course to view this section

Privilages

  • Understanding Privileges
  • System Privileges
  • Object Privileges
  • Grant Command
  • Revoke Command
  • Role
  • Removing Roles
                            
                                        video locked 
                Purchase this course to view this section

TCL Commnads

  • TCL Commands
  • Commit
  • Rollback
  • Savepoint
                            
                                        video locked 
                Purchase this course to view this section

Introduction to PL-SQL

  • Introduction To PL-SQL
  • Advantages Of PL-SQL
  • PL-SQL Architecture
  • Example
  • Data Types In PL-SQL
  • Variable Declaration & Assignment
  • Constants & Comments
  • Operators
                            
                                        video locked 
                Purchase this course to view this section

Loops in PL-SQL

  • Loops In PL-SQL
  • Basic Loop
  • While Loop
  • For Loop
                            
                                        video locked 
                Purchase this course to view this section

Cursor in PL-SQL

  • Cursor In PL-SQL
  • Types Of Cursors
  • Implicit Cursor
  • Explicit Cursor
                            
                                        video locked 
                Purchase this course to view this section

Exceptions

  • Introduction To Exceptions
  • Handling Exceptions
  • Predefined Exceptions
  • Pragma
  • User-Defined Exception
  • Resuming After Exception
  • Using Raise_Application_Error
                            
                                        video locked 
                Purchase this course to view this section

Procedures and functions

  • Introduction To Procedures And Functions
  • Benefits
  • Procedure V/s Functions
  • Syntax Of Creating A Procedure
  • Parameter Types
  • Examples
                            
                                        video locked 
                Purchase this course to view this section

Packages

  • Introduction To Packages
  • Benefits
  • Components Of A Package
  • Examples
  • Dropping Package
                            
                                        video locked 
                Purchase this course to view this section

Primary Key

  • Generating Primary Key
  • New Way Of Auto Generating Primary Key
  • Restrictions
  • Examples
                            
                                        video locked 
                Purchase this course to view this section

Statement lever trigger

  • Statement Level Trigger
  • Creating A Statement Level Trigger
  • Instead Of Trigger
  • Examples
  • Removing/ Disabling/Enabling A Trigger
                            
                                        video locked 
                Purchase this course to view this section

Collections in PL-SQL

  • Collections In PL-SQL
  • Types Of Collections
  • Introduction To Associative Array
  • Using Associative Array
  • Methods Of Associative Arrays
                            
                                        video locked 
                Purchase this course to view this section

Nested Tables

  • Introduction To Nested Tables
  • Declaring & Initializing
  • Adding Elements
  • Accessing Elements
  • Example
                            
                                        video locked 
                Purchase this course to view this section

PL-SQL Object-Oriented  Programming

  • PL-SQL Object-Oriented Programming
  • What Are Object Types ?
  • Creating And Initializing Object Types
  • Adding Constrcutor
  • Example
                            
                                        video locked 
                Purchase this course to view this section
 end
Instructor
                   
                     Mr. Sachin Kapoor
 Check free icon    Mr. Sachin Kapoor is a  senior trainer with an experience of more  than 20 very long years.
Check free icon     He has trained more  than 2,00,000 students till date.
Check free icon     He actively interacts with approximately 8000 new students every year.
Check free icon     Mr. Sachin has  been teaching programming languages since  2000 .

Customer Reviews

No reviews yet
0%
(0)
0%
(0)
0%
(0)
0%
(0)
0%
(0)

Customer Reviews

No reviews yet
0%
(0)
0%
(0)
0%
(0)
0%
(0)
0%
(0)
20+

Years Of Experience

200000+

Students Trained

25+

Technologies Mastered

35000+

Classes Completed

Whatsapp tochat-whatsapp