Hello, my name is Nandhakumar.
I recently graduated with a Bachelor's degree in
Computer Science and Engineering. During my academic journey, I developed strong
skills in programming, data structures, and software development. I have worked on
projects involving [mention a specific project or technology if applicable, e.g.,
web development, machine learning, etc.], which allowed me to apply my knowledge in
practical scenarios.
I am passionate about technology and continuously strive to enhance my skills by
exploring new tools and frameworks. I am excited to start my career and contribute
to innovative projects where I can learn and grow. I believe my dedication and
problem-solving abilities will make me a valuable addition to any team. Thank you
for the opportunity to introduce myself."
FROM – Specifies the tables to retrieve data from. (and on clause)
WHERE – Filters rows based on conditions.
GROUP BY – Groups rows sharing a property.
HAVING – Filters grouped records.
SELECT – Chooses the columns to display.
ORDER BY – Sorts the result set.
LIMIT – Restricts the number of rows returned.
arithmetic operator,relational ,logical,special,subquery operator
aggregate function: max(),min((),Count(),sum(),avg() to obtain value
character function: upper(),lower(),length(),reverse() ,concat(), substr(original
string,position,length) replace(original string ,substring,newstring)
number function:
abs(),mod(m,n),round(),ceil(),floor(),truncate(),pow(base,power),sqrt()
date function: curdate(),sysdate(),
datediff() ,date_add(),date_format('date_value',date_format_pattern')(eg:
date_format(dOJ,'%y')=1995)
joins : cartesian /cross join, inner join ,outer join - left outer join,right outer
join, natural join ,self join