Candidate should learn the concepts in SQL

Concepts in SQL:

• Basic terms and introduction in RDBMS technology
• Sub language commands like DDL, DML, DRL, TCL, DCL
• Built in functions
• Grouping the result
• Integrity constraints
• Joins
• Sub-queries
• Database objects like Views, Sequences, Synonyms, Index, Clusters
• Pseudo columns
• partitions & parallel process
• Locks

SQL Practice Questions and Answers

Basic Database Questions and Answers