Duration :  1 Month

Pre-requisite : C Prog

  • Introduction to DBMS and RDBMS Database design and Normalization
  • Writing Basic SQL Statements Restricting and Sorting Data
  • Using Single Row Function to Customize output
  • Reporting Aggregated Data Using Group Functions, Displaying data from Multiple Tables
  • Using Sub queries, Using Set Operators, Manipulating Data
  • Using DDL statements to create and manage tables, Creating other schema objects
  • Managing objects with data dictionary views, Controlling user access, Managing schema objects
  • Manipulating large data sets, Generating reports by Grouping related data, Managing data in different time zones
  • Retrieving data using sub queries, Hierarchical Retrieval, Regular expression support