DEV Community

Pranav Bakare profile picture

Pranav Bakare

Oracle Full Stack Developer

Location Nashik,Maharashtra,India Joined Joined on  Email address pranavsb699@gmail.com Personal website https://linktr.ee/pranavbakare github website

Work

ORACLE PLSQL DEVELOPER at TCS

Pin Pinned

CURSOR in PLSQL | Best Explanation
mrcaption49 profile

CURSOR in PLSQL | Best Explanation

#beginners #programming #tutorial #sql
7
Comments 1
3 min read
Trigger in PL/SQL with Example - Part 1 | BEFORE Trigger
mrcaption49 profile

Trigger in PL/SQL with Example - Part 1 | BEFORE Trigger

#sql #database #fullstack #backend
2
Comments
2 min read
Pranav Bakare
mrcaption49 profile

Pranav Bakare

#devops #docker #ai #chatgpt
6
Comments
1 min read
Build your first CI/CD pipeline
mrcaption49 profile

Build your first CI/CD pipeline

#docker #kubernetes #cicd #githubactions
42
Comments 4
3 min read
Cron Job Basics
mrcaption49 profile

Cron Job Basics

#devops #cicd #docker #kubernetes
4
Comments
4 min read
ORACLE vs postgress database Difference
mrcaption49 profile

ORACLE vs postgress database Difference

Comments
1 min read

Want to connect with Pranav Bakare?

Create an account to connect with Pranav Bakare. You can also sign in below to proceed if you already have an account.

Create Account
Already have an account? Sign in
SavePoint best Explanation
mrcaption49 profile

SavePoint best Explanation

Comments
2 min read
PLSQL BEST PART 2
mrcaption49 profile

PLSQL BEST PART 2

Comments
4 min read
PLSQL BEST PART 1
mrcaption49 profile

PLSQL BEST PART 1

Comments
4 min read
Working of SQL*Loader
mrcaption49 profile

Working of SQL*Loader

Comments
2 min read
Oracle Query Optimizer
mrcaption49 profile

Oracle Query Optimizer

Comments
3 min read
Query with PARALLEL and Without PARALLEL Execution
mrcaption49 profile

Query with PARALLEL and Without PARALLEL Execution

Comments
1 min read
Types of Materialized views
mrcaption49 profile

Types of Materialized views

Comments
4 min read
Most commonly used Oracle Hints Patterns
mrcaption49 profile

Most commonly used Oracle Hints Patterns

Comments
4 min read
EXPLAIN PLAN in more detail explanation
mrcaption49 profile

EXPLAIN PLAN in more detail explanation

Comments
5 min read
Detailed Explanation of DBMS PROFILER | Part 2
mrcaption49 profile

Detailed Explanation of DBMS PROFILER | Part 2

Comments
4 min read
Detailed Explanation of DBMS PROFILER with its Steps
mrcaption49 profile

Detailed Explanation of DBMS PROFILER with its Steps

5
Comments
4 min read
SQL*Loader in Oracle SQL
mrcaption49 profile

SQL*Loader in Oracle SQL

Comments
5 min read
Oracle Optimizer with Analogy Explanation
mrcaption49 profile

Oracle Optimizer with Analogy Explanation

Comments
3 min read
Oracle Optimizer
mrcaption49 profile

Oracle Optimizer

Comments
3 min read
Query hints in Oracle SQL
mrcaption49 profile

Query hints in Oracle SQL

Comments
1 min read
Query hints
mrcaption49 profile

Query hints

Comments
3 min read
Solution to a mutating trigger error in Oracle SQL
mrcaption49 profile

Solution to a mutating trigger error in Oracle SQL

Comments
2 min read
Analogy of mutating trigger with examples
mrcaption49 profile

Analogy of mutating trigger with examples

Comments
2 min read
Mutating trigger in Oracle SQL
mrcaption49 profile

Mutating trigger in Oracle SQL

#oracle #fullstack #devops #backend
Comments
2 min read
Compound Trigger in Oracle SQL
mrcaption49 profile

Compound Trigger in Oracle SQL

#oracle #fullstack #database #data
Comments
3 min read
ROWNUM vs ROW_NUMBER in Oracle
mrcaption49 profile

ROWNUM vs ROW_NUMBER in Oracle

Comments
3 min read
Pipelined Table Functions | ORACLE PLSQL | Best Explanation
mrcaption49 profile

Pipelined Table Functions | ORACLE PLSQL | Best Explanation

Comments
4 min read
Bulk Collect | Partitioning | Parallel Execution | Materialized Views | Dynamic SQL | Pipelined Table Functions | Large datasets
mrcaption49 profile

Bulk Collect | Partitioning | Parallel Execution | Materialized Views | Dynamic SQL | Pipelined Table Functions | Large datasets

Comments
4 min read
Types of constraints (primary key, foreign key, unique, check, and not null)
mrcaption49 profile

Types of constraints (primary key, foreign key, unique, check, and not null)

Comments
3 min read
USER_CONS_COLUMNS table | Constraints in SQL
mrcaption49 profile

USER_CONS_COLUMNS table | Constraints in SQL

Comments
1 min read
USER_CONSTRAINTS | Constraints in SQL
mrcaption49 profile

USER_CONSTRAINTS | Constraints in SQL

Comments
1 min read
OLAP (Online Analytical Processing)
mrcaption49 profile

OLAP (Online Analytical Processing)

#datascience #database #data #dataengineering
9
Comments
3 min read
EXPLAIN PLAN & DBMS_PROFILER Explanation
mrcaption49 profile

EXPLAIN PLAN & DBMS_PROFILER Explanation

#database #oracle #plsql #performance
5
Comments
2 min read
Table functions and Pipelined functions in PLSQL | Best Explanation
mrcaption49 profile

Table functions and Pipelined functions in PLSQL | Best Explanation

#oracle #fullstack #backend #devops
5
Comments
2 min read
Analogy explaination of EXPLAIN PLAN and DBMS_PROFILER
mrcaption49 profile

Analogy explaination of EXPLAIN PLAN and DBMS_PROFILER

#oracle #fullstack #backend #devops
10
Comments
2 min read
EXPLAIN PLAN and DBMS_PROFILER
mrcaption49 profile

EXPLAIN PLAN and DBMS_PROFILER

#oracle #plsq #fullstack #backend
5
Comments
2 min read
Kubernetes Basics | Get started with Kubernetes
mrcaption49 profile

Kubernetes Basics | Get started with Kubernetes

#kubernetes #docker #fullstack #devops
Comments
4 min read
Docker Compose vs Kubernetes
mrcaption49 profile

Docker Compose vs Kubernetes

#kubernetes
11
Comments
3 min read
Docker | Docker Compose | Kubernetes
mrcaption49 profile

Docker | Docker Compose | Kubernetes

#docker #kubernetes #devops #fullstack
Comments
2 min read
Docker and Docker Compose
mrcaption49 profile

Docker and Docker Compose

#docker #kubernetes #devops #fullstack
Comments
2 min read
Interview Questions | 10 most important distinctions between concepts in Oracle SQL
mrcaption49 profile

Interview Questions | 10 most important distinctions between concepts in Oracle SQL

#oracle #fullstack #data #database
Comments
2 min read
GROUP BY vs PARTITION BY in SQL
mrcaption49 profile

GROUP BY vs PARTITION BY in SQL

7
Comments
2 min read
Joins in ORACLE SQL
mrcaption49 profile

Joins in ORACLE SQL

Comments
2 min read
Key in Oracle SQL
mrcaption49 profile

Key in Oracle SQL

Comments
2 min read
Constraints in Oracle SQL
mrcaption49 profile

Constraints in Oracle SQL

Comments
2 min read
Best examples of Procedure in Oracle SQL
mrcaption49 profile

Best examples of Procedure in Oracle SQL

9
Comments
2 min read
PL/SQL Developer Interview Questions
mrcaption49 profile

PL/SQL Developer Interview Questions

#interview #webdev #fullstack #oracle
Comments
5 min read
RefCursor without SYS_REFCURSOR declaration | RefCursor with SYS_REFCURSOR declaration
mrcaption49 profile

RefCursor without SYS_REFCURSOR declaration | RefCursor with SYS_REFCURSOR declaration

10
Comments
2 min read
Normal cursor Vs Ref cursor
mrcaption49 profile

Normal cursor Vs Ref cursor

Comments
1 min read
Normal Cursor and Ref Cursor
mrcaption49 profile

Normal Cursor and Ref Cursor

Comments
3 min read
Correlated subquery | Simplest Explanation
mrcaption49 profile

Correlated subquery | Simplest Explanation

5
Comments
1 min read
Subquery and Co-related subquery
mrcaption49 profile

Subquery and Co-related subquery

#webdev #beginners #programming #tutorial
8
Comments
1 min read
SDLC | Waterfall model | Agile | DevOps
mrcaption49 profile

SDLC | Waterfall model | Agile | DevOps

#devops #sdlc #fullstack #cloud
Comments
3 min read
On-Demand Refresh | Materialized Views (Mviews) in ORACLE SQL
mrcaption49 profile

On-Demand Refresh | Materialized Views (Mviews) in ORACLE SQL

#sql #oracle #fullstack #backend
9
Comments
3 min read
Top 10 advanced-level questions | ORACLE PLSQL DEVELOPER
mrcaption49 profile

Top 10 advanced-level questions | ORACLE PLSQL DEVELOPER

#oracle #fullstack #devops #database
5
Comments
3 min read
Query optimization techniques in Short | Best Explanation
mrcaption49 profile

Query optimization techniques in Short | Best Explanation

#fullstack #data #database #oracle
Comments
1 min read
What is Docker | In simple words
mrcaption49 profile

What is Docker | In simple words

#webdev #docker #beginners #programming
Comments
2 min read
Infosys Portals career 2024
mrcaption49 profile

Infosys Portals career 2024

#infosys #tcs #aws #fullstack
5
Comments
1 min read
PL/SQL Collections | Best Explanation
mrcaption49 profile

PL/SQL Collections | Best Explanation

5
Comments
5 min read
PL/SQL collections
mrcaption49 profile

PL/SQL collections

9
Comments
4 min read
BULK COLLECT in Oracle SQL | Best Explanation
mrcaption49 profile

BULK COLLECT in Oracle SQL | Best Explanation

10
Comments
4 min read
DBMS_SQL package | Dynamic SQL
mrcaption49 profile

DBMS_SQL package | Dynamic SQL

#fullstack #devops #oracle #opensource
6
Comments
2 min read
Dynamic SQL in Oracle SQL | Best Explanation
mrcaption49 profile

Dynamic SQL in Oracle SQL | Best Explanation

#fullstack #database #backend #oracle
8
Comments
4 min read
CTE | Common Table Expression | Real world scenarios examples
mrcaption49 profile

CTE | Common Table Expression | Real world scenarios examples

#fullstack #backend #database #oracle
8
Comments 2
2 min read
loading...