Oracle

Oracle Database (commonly referred to as Oracle DBMS, Oracle Autonomous Database, or simply as Oracle) is a multi-model database management system produced and marketed by Oracle Corporation. It is a database commonly used for running online transaction processing (OLTP), data warehousing (DW) and mixed (OLTP & DW) database workloads. Oracle Database is available by several service providers on-prem, on-cloud, or as hybrid cloud installation. It may be run on third party servers as well as on Oracle hardware (Exadata on-prem, on cle Cloud or at Cloud at Customer)

Things To Learn

  • Introduction to Oracle
  • DBMS
  • RDBMS
  • Normalization(1st nf,2nd nf,3rd nf,BCNF)
  • What is SQL
  • SQL Commands(DDL,DML,DCL,TCL)
  • Sub-queries
  • Aggregate, Date, String functions etc.
  • Joins
  • Creating index,Synonym,View,Cluster etc.