To create functions, store procedure , package , triggers , table design. To work on oracle advance objects , type , collection , objects. To create sql query , optimize query , creating and managing index , tuning query. To install oracle 10g , 11i , 12c in window and linux environment . To Export / Import db as per. Performance and tunning query , backup and recovery. To create database design , Manage END to END .