Oracle Database Master Class
SCALive > Oracle Database Master Class

Oracle Database Master Class

5 Reviews
This course is available.
Rs. 6499.00 Rs. 3800.00
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 :

  60+ Hours of On-Demand Video
  Learn from Mobile/PC/Tablet
  HD Quality Training Content
  Industry Level Content
  Play & Pause Videos
  6 Months Validity
  Bonus Content
  Certification

Instructor

                   

                     Mr. Sachin Kapoor

  • Mr. Sachin Kapoor is a  senior trainer with an experience of more  than 20 very long years.
  • He has trained more  than 2,00,000 students till date.
  • He actively interacts with approximately 8000 new students every year.
  • Mr. Sachin has  been teaching programming languages since  2000 .
  • Pre-requisites For This Course
  • What Is Oracle ?
  • What Is An OORDBMS?
  • History Of Oracle
  • Editions Of Oracle
  • Course Outline
  • Introduction To SQL
  • Oracle V/s SQL
  • History Of SQL
  • What Is PL-SQL ?
  • How To Use SQL & PL-SQL ?
  • Types Of SQL Commands
  • Data Types In Oracle
  • Char Types
  • Number Types
  • Date Types
  • LOB Types
  • ID Types
  • Data Types In Oracle
  • Char Types
  • Number Types
  • Date Types
  • LOB Types
  • ID Types
  • About Sys & System Users
  • Creating New User
  • Granting Privilege To The User
  • Create Table Command
  • Describe Command
  • 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
  • Introduction To DML Commands
  • The INSERT Command
  • Different Types Of INSERT Commands
  • Introduction To null
  • The UPDATE Command
  • Operators In Oracle
  • Formatting Columns
  • Some Queries Based On Operators
  • Pattern Matching
  • Functions In Oracle
  • The DUAL Table
  • Various DATE Functions
  • Date Arithmetic
  • Introduction To NUMERIC Functions
  • Various NUMERIC Functions Of Oracle
  • Introduction To CONVERSION Functions
  • The TO_CHAR() Function
  • The TO_NUMBER() Function
  • The TO_DATE() Function
  • Introduction To GROUP Functions
  • Types Of GROUP Functions
  • Introduction To MISCELLANEOUS Functions
  • Types Of MISCELLANEOUS Functions
  • 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
  • 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
  • SubQueries
  • Types Of SubQueries
  • Single Row SubQuery
  • Multi Row SubQuery
  • Introduction To ROWNUM
  • Internal Working Of ROWNUM
  • Top N Analysis
  • Queries
  • Introduction To Set Operators
  • Types Of Set Operators
  • Restrictions On Set Operators
  • Queries
  • Introduction To Set Operators
  • Types Of Set Operators
  • Restrictions On Set Operators
  • Queries
  • Using The Default Clause
  • Renaming Constraints
  • Disabling/Enabling Constraint
  • Validate/NoValidate Option
  • Obtaining Details About Constraints
  • Removing Constraints
  • Introduction To Sequences
  • Syntax Of Sequence
  • Sequence Attributes
  • Using A Sequence
  • Connecting Sequence With Table
  • Removing Sequence
  • Obtaining Details Of Sequence
  • 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
  • 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
  • Introduction To DCL Commands
  • Understanding Schema
  • SYS and SYSTEM
  • Creating New User
  • Concept Of TableSpace
  • Unlocking Users
  • Dropping Users
  • Understanding Privileges
  • System Privileges
  • Object Privileges
  • Grant Command
  • Revoke Command
  • Role
  • Removing Roles
  • TCL Commands
  • Commit
  • Rollback
  • Savepoint

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

Loops in PL-SQL

  • Loops In PL-SQL
  • Basic Loop
  • While Loop
  • For Loop

Cursor in PL-SQL

  • Cursor In PL-SQL
  • Types Of Cursors
  • Implicit Cursor
  • Explicit Cursor

Exceptions

  • Introduction To Exceptions
  • Handling Exceptions
  • Predefined Exceptions
  • Pragma
  • User-Defined Exception
  • Resuming After Exception
  • Using Raise_Application_Error

Procedures and functions

  • Introduction To Procedures And Functions
  • Benefits
  • Procedure V/s Functions
  • Syntax Of Creating A Procedure
  • Parameter Types
  • Examples

Packages

  • Introduction To Packages
  • Benefits
  • Components Of A Package
  • Examples
  • Dropping Package

Primary Key

  • Generating Primary Key
  • New Way Of Auto Generating Primary Key
  • Restrictions
  • Examples

Statement lever trigger

  • Statement Level Trigger
  • Creating A Statement Level Trigger
  • Instead Of Trigger
  • Examples
  • Removing/ Disabling/Enabling A Trigger

Collections in PL-SQL

  • Collections In PL-SQL
  • Types Of Collections
  • Introduction To Associative Array
  • Using Associative Array
  • Methods Of Associative Arrays

Nested Tables

  • Introduction To Nested Tables
  • Declaring & Initializing
  • Adding Elements
  • Accessing Elements
  • Example

PL-SQL Object-Oriented  Programming

  • PL-SQL Object-Oriented Programming
  • What Are Object Types ?
  • Creating And Initializing Object Types
  • Adding Constrcutor
  • Example
  •  

Customer Reviews


Thank you for your review

Write a review




Why Choose SCALive ?

Our instructors go far beyond the typical role of faculty to provide a comprehensive learning experience to students, build work portfolio and assistance in placement.

Give a flight to your career

We want to help you in building a career you love. Get trained in cutting edge technologies, with hands-on practice, helping you in changing your career or succeeding in the job you already have.

Daily Offline & Online classes

We provide Daily Classes at our academy. Also, students get assistance throughout digital/offline classes.

Practice and revise

We pay equal importance to students' practical knowledge as well as theoretical lessons. We also provide assistance in the revision of course material.

Become Job Ready

Our courses are designed keeping one thing in mind that student should get prepared for interviews after completing this course, so if you are struggling with interviews you are at right place.

Seamless Doubt Solving

We know that being a noob in technology, you will have many doubts while learning, our 24x7 doubts solving support will let you resolve your queries in minutes.

Career Counselling

Our mentors are in regular touch with students to provide the right career advice and support.

Learn from anywhere

Our specially designed LMS will let you learn from anywhere and anytime in this world helping you in utilizing your free time for new skill development.

24x7 Support

We provide tech support services to address your issues on call/Email. Call our Customer Service executive or submit your request online, our tech support staff will get in touch with you.






Our Testimonialssca live





About Sharma Computer Academy

SCAlive is a premier education institute. SCAlive is a pioneer in providing career-orientated courses to aspiring professionals since 2000. The institute has trained 2 Lacs students through a wide network of E-Learning Platform and Center located in Bhopal, Madhya Pradesh. SCAlive is a leader in training since 2000.
We want to achieve unparalleled standards of quality IT education in an inexpensive fee structure. We are working to create leading IT professionals of global standards that will contribute towards the technical and economical growth of our country. Life is all about making the right choices, so choose your career at SCA and become an IT professional. I welcome you to the world of experiential learning & wish you the best on having a positive, impactful, and life- long experience in the very important phase of your academic life at Sharma Computer Academy.
Direction




Copyright © 2021 SCALive.in - Designed by Animeria
Chat With Us!
Leave a Message
Online support currently not available.
please leave your message.
course coupon