Forem: Vaishu gajula

Day 6 Towards my Career

Vaishu gajula — Mon, 07 Apr 2025 18:16:09 +0000

I am so here to give my preparation towards my career goal I oracle I have gone through the sub queries .ROWID, inline views , I have started the PL?SQL basic I came to know about the syntax I have not gone through it but later it just made me to dive into it I am so happy for doing those programming codes
Later in the afternoon I have done some logical question those are very basic
I am getting Some confidence day-by day by solving the problems and going through the topics I am so confident now
I hope I Will maintain these consistency to move forward my journey towards my career
If you also towards your journey of your career don't forget to connect through the comments.

Day 4 I have revised some of oracle concepts

Vaishu gajula — Fri, 04 Apr 2025 18:01:40 +0000

Hi Everyone Today I have revised some of the topics in oracle like cross join ,set operators like union, union all, intersect, minus
I would like to define them in simple words
unio means that combines the two queries into one and it eliminates the duplicates gives the result in order.
Union all is used to combine two rows but it gives the duplicate result also and the result is also not sorted.
Intersect means the values in first query but not there in second query
Group By clause
It is mainly used to group rows based on rows /columns to calculate min , sum ...for each group
And also I have learned ROLLUP and cube
These both are used to get the grand total and sub total
but the cube will displays for each group by column and also displays he grand total.
Then I revised the concept of case which works similarly as the switch case to implement if -then -else
simple case
when the condition is based on the equal operator. vice versa for the searched case
Tomorrow I will go through the subqueries which is a great topic
I Will be always looking forward for my career ...

Day-3 Exploring Oracle, JavaScript

Vaishu gajula — Thu, 03 Apr 2025 18:14:29 +0000

Today I have gone through the integrity constraints in deeper.
then i performed some operations like creating the table with check and i learned the relationship among the table using

one-to-one They are used to combine to table in which the one values of the table should match with the exactly with one another in other table using the unique
1 to many is same as one-to-one but we don't use the unique
many-to-many we have the relation like making the relation between multiple records in one table are related to multiple records in another table.
and some basics of join how we are join the table using the join i learned about the self join in which we can get the table using the same table. outer join and inner join
inner join gives the only the matched results
but wont return the unmatched records.
I am always looking forward of my journey towards my career .
That's it for today