Diksha IT Training Centre

Diksha Oracle Training Centre is a platform for IT Graduate as it provides both offline and online training to IT graduate to excel/his her carrier in IT industry.

Search This Blog

Posts

Showing posts with the label Complex SQL queries Part6

Show All

No results found

About Me

Dheeraj Kumar Jha: I Have Around 14 plus years of experience in IT Software Industry and worked on Various MNC'S like Mphasis,IBM,Headstrong, Tech Mahindra and EPAM and also had expereince for knowledge Transition to get new projects in India.I have worked with various domains like Banking,Telecom and Chain Management. I worked as a Project lead , Tech Lead and Project Manager for several onsite projects. I trained several resources who recently joined the organization. I receive several awards and appreciation from the industry for innovative ideas. During my work i always motivated team members and if required i provided the training . From last 1 year i am providing training in Oracle database and other programming language through offline and online. Apart from that I am Oracle Certified .

Visit profile

Labels

%TYPE and %ROWTYPE in Oracle
%TYPE and %ROWTYPE uses in Anonymous PL/SQL block
1NF
2D Array in C
2NF
3D Array in
3NF
abs character function in Oracle
Advance Unix Command
Advance Unix Command Part 2

Advance Unix Command Part1
Advantages of Index in Oracle Query
Aggregate Functions and Group By Clause in Oracle with Examples
Agile and Waterfall Model uses and difference in SDLC
Agile Model
Agile vs Waterfall Model
Algorithm in Computerscience
Algorithm in Programming
AND
Anonymous PL/SQL Block
ANY and ALL operator in SQL
Array in C
Array to Function
Array to Function in C
Basic and Advance command in Unix
Basic and Commonly used command in Unix
Basic Concept of Unix Operating System
Basic Overview of Data warehouse
Basic Program In C
Basic Shell Programming in Unix
BCNF
Benefits of Computer Coding for School Kids
Benefits of Scrum Methodologies in Agile Model
break in C program
Btree and Bitmapped index in Oracle
BULK COLLECT IN PL/SQL
C Basics Programs with with different data types and IF Conditional statement
C Beginner
C IF Statement
call by reference
call by reference function in C
CASE
ceil
Certification Benefits to get job in IT Industry
Cluster and non-cluster Index
Coding for School Kids
Collection
Collection in PL/SQL
Complex Queries Part4
Complex query part 5
Complex SQL queries Part6
Computer Science Fresher
Concept of Software Development life Cycle in IT industry
continue in C program
CURRVAL
Cursor and Types of Cursor in Oracle with Examples
Data Analyst Job
Data Dictionary
Data Dictionary table in Oracle Database
Data Warehouse
Database Developer Role
Database developer roles and responsibilities in IT organisation
Database importance
Database Interview Questions
Database Management System
Database Scope in IT industry
dbms_sql
Demand of Production Support Job in IT industry
Distinct in SQL
do-while loop
Double Pointer
Dual Table in Oracle
dynamic sql
ELSE -IF
exception handling in PL/SQL
execute immediate
Explicit Cursor
Explicit Cursor and For Cursor Loop with examples
Features of Oracle Database
First interview in IT organisation
floor
For Cursor Loop
For Loop in C
Frequent Interview Questions on SQL and PL/SQL
Function call value
function call value in C Program
Function in C
Go to
go to statement in C
Hot Skills In IT
How to Face First Interview in IT Company
IF-ELSE
IF-THEN
IF-THEN-ELSE
Importance of SQL JOIN
Important Queries in SQL
Important Queries in SQL part 5
Important SQL Queries
Important SQL queries part 2
Important SQL queries Part 6
IN
Index in Oracle
instr
Interview questions for Oracle developer
Interview Questions on SQL and PL/SQL
Interview Tips
Introduction to C
IT and skill training
IT Certification
IT importance in Corona
IT Skills To Learn
IT Training Benefits
LEVEL
Logical Operator and other Operators uses in Oracle SQL
Loop in C
Materialized View in Oracle
Materialized View uses and benefits in Oracle database
MINUS and INTERSECT
Multi Dimensional Array C
Nested for loop
Nested IF
Nested IF ELSE
NEXTVAL
Normalization in Database
NOSQL basic Concept
NOSQL DATABASE
nvl
nvl2
OCA Certification Benefits
OCA certification value in IT industry
OCA Quix Part4
OCA Quiz
OCA Quiz Part2
OCA Quiz Part3
OCA Quiz Part5
one dimensional Array in C
Online Learning
Online Learning Advantage and Disadvantage
OR and NOT
Oracle Database Demand
Oracle Database OImportance in IT industry
Oracle Join
Oracle Stored Procedures
Oracle Tuning
Order by in SQL
Overview of Algorithm in Computer Science and uses in Programming Language.
Overview of Agile Model
Pattern Program
PL/SQL in Oracle
PL/SQL Procedures
PL/SQL Trigger
Pointer
Pointer and Array in C
Pointer in C
Pointer to a function in C
Pointer to Pointer
Pointer uses in Array
Production Support Job
Production support Job role
Production support work in IT
Pseudo Column in Oracle
Public and Private Synonym
Role of Data Analyst in Organization
Role of IT in COVID 19 Crisis
round
ROWID
ROWNUM
Scrum Methodologies in IT industry
SDLC
Set operator in Database
Set operator in Oracle Database
Shell Script in Unix
sign
Simple View and Complex View
SQL
SQL and PL/SQL demand in IT Industry
SQL Command
SQL JOIN
SQL Queries
SQL queries part 3
SQL Queries Part2
SQL query tuning
SQL QUIZ part1
SQL Quiz Part3
SQL QUIZ with Answer Part 2
SQL Quiz with Answer Part 4
SQL QUIZ with Answer Part 5
SQL SUBQUERY AND CO-RELATED SUBQUERY
SQL SUBQUERY AND CO-RELATED SUBQUERY IN Oracle
Stored Procedure in Oracle
Structure in C
Structure in C Programming
substr
Switch
Synonym and it's advantage in Oracle Database
Top 50 Interview Questions On SQL and PL/SQL
Top Interview Questions on SQL and PL/Sql
Triangle program in C
trunc
Types and Clasiification of SQL
UNION
UNION ALL
Unix Basic Command
unix command
Unix Operating System
user defined functions in C
Uses of Pointer in Function programProgram
Varray in PL/SQL
Views In Oracle
while loop
while loop in C
Why Join is important in SQL
Why Production Supports Job Demand in IT industry and its role in Application Support Project

Show more Show less

Report Abuse

Powered by Blogger