Oracle Database MasterClass
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
CertificationIntroduction
- Pre-requisites For This Course
- What Is Oracle ?
-
What Is An OORDBMS?
-
History Of Oracle
-
Editions Of Oracle
- Course Outline
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
Data types
- Data Types In Oracle
- Char Types
- Number Types
- Date Types
- LOB Types
- ID Types
Version & Installation
- Data Types In Oracle
- Char Types
- Number Types
- Date Types
- LOB Types
- ID Types
Creating User
- About Sys & System Users
- Creating New User
- Granting Privilege To The User
- Create Table Command
- Describe Command
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
DML Commands
- Introduction To DML Commands
- The INSERT Command
- Different Types Of INSERT Commands
- Introduction To null
- The UPDATE Command
Operators in Oracle
- Operators In Oracle
-
Formatting Columns
-
Some Queries Based On Operators
- Pattern Matching
Functions in Oracle
- Functions In Oracle
- The DUAL Table
- Various DATE Functions
- Date Arithmetic
Numeric Functions
- Introduction To NUMERIC Functions
- Various NUMERIC Functions Of Oracle
Conversion functions
- Introduction To CONVERSION Functions
- The TO_CHAR() Function
- The TO_NUMBER() Function
- The TO_DATE() Function
Group functions
- Introduction To GROUP Functions
- Types Of GROUP Functions
- Introduction To MISCELLANEOUS Functions
- Types Of MISCELLANEOUS Functions
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
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
SubQuerries
- SubQueries
-
Types Of SubQueries
-
Single Row SubQuery
- Multi Row SubQuery
Introduction of ROWNUM
- Introduction To ROWNUM
- Internal Working Of ROWNUM
- Top N Analysis
- Queries
Set Operators
- Introduction To Set Operators
- Types Of Set Operators
- Restrictions On Set Operators
- Queries
Constraints
- Introduction To Set Operators
- Types Of Set Operators
- Restrictions On Set Operators
- Queries
Default Clause
- Using The Default Clause
- Renaming Constraints
- Disabling/Enabling Constraint
- Validate/NoValidate Option
- Obtaining Details About Constraints
- Removing Constraints
Sequences
- Introduction To Sequences
- Syntax Of Sequence
- Sequence Attributes
- Using A Sequence
- Connecting Sequence With Table
- Removing Sequence
- Obtaining Details Of Sequence
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
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
DCL Commands
- Introduction To DCL Commands
- Understanding Schema
- SYS and SYSTEM
- Creating New User
- Concept Of TableSpace
- Unlocking Users
- Dropping Users
Privilages
- Understanding Privileges
- System Privileges
- Object Privileges
- Grant Command
- Revoke Command
- Role
- Removing Roles
TCL Commnads
- 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
end
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 .Similar Courses
Customers who viewed this item also viewed
Recently Rate & Reviews
nice explanation and good live interaction
This project is very helpful for learning how to implement programming at an industry-standard level. In this project, I am revising the Python concepts. Assignments are very interesting. An explanation is very nice.
This project is very helpful for learning how to implement programming at an industry-standard level. In this project, I am revising the c concepts and learn about error handling in C. Sir teaches us some C programming advanced concepts like file handling, storage class. Assignments are very interesting. This is also helpful for resume and boosts your resume
got to learn about many concepts thru this project and it was a decent project to develop, using the knowledge of c programming.
Thank you sir for this project
It was a wonderful learning Experience.
When i was in school i just hated computer and later i had to do engineering as no choices were left and i was regretting About that decision but when i attended his first lecture i felt that computer was not boring subject but the teacher was and SACHIN SIR is literally A LEGEND , he made my decision of persuing engineering worthful now m enjoying coding everything is just different . Thank you so much sir.
Sachin is the best teacher to learn Programming. If you want to learn Programming in deep so he was the man who can. Practical experience is best in SCA. You will learn any language very easily by Sachin sir and can make any project by his teaching.
This is wonderful cource for me. Course provide a reality of project .How to work in project this course wouderfully explanation . i can also thanks to sachin sir and all the sca team
This is wonderful cource for me. Course provide a reality of project .How to work in project this course wouderfully explanation . i can also thanks to sachin sir.
I am blessed that i have join Sca . I think no one can teach like Sachin sir , Joining C Project Batch is very good experience .
Here we learn how to practically implement the logic we learn in c programming lang.Thanks to @Sachin sir and all the sca team.
I am very thankful to @Sachin sir and SCA for sechduling this course
Great course that will provide an opportunity to develop yourself if you take the work seriously. A true value of time investment.Thank you SACHIN SIR
In c project batch i have learned so many things .Every one knows that only learning is not everything implementing the things is the real knowledge ,I am thankful to sachin sir for this awesome c project batch that SCA organized. After learning c lang its necessary to us to implement the logics that we have learn during learning c lang and the launching of this c project batch by sachin sir gives us an opportunity to implementing that logics under a supervision of most experienced faculty SACHIN SIR .
So I am very thank ful to the SCA and SACHIN SIR for sheduling this wonderful project batch in c language.