PLSQL Developer (Remote)

DBMS & SQL Concepts of RDBMS, Normalization techniques Entity Relationship diagram/ ER-Model Transaction, commit, rollback, ACID properties Transaction log Difference in behavior of the column if it is nullable SQL Statements Join Operations DDL, DML, Data Modelling Optimal Query writing - with Aggregate fn, Group By, having clause, Order by etc. Should be hands on for scenario-based query Writing Query optimizing technique, Indexing in depth Understanding query plan Batching Locking schemes Isolation levels Concept of stored procedure, Cursor, trigger, View Beginner level - PL/SQL - Procedure Function writing skill. Spring JPA and Spring Data basics Hibernate mappings UNIX Basic Concepts on Unix Commonly used Unix Commands with their options Combining Unix commands using Pipe Filter etc. Vi Editor & its different modes Basic level Scripting and basic knowledge on how to execute jar files from host Files and directory permissions Application based scenarios.