Learn RDBMS with Oracle

This course is good for new graduates and who are aspiring for Database development career. Database development  is hot in a current Job Market . Although there are many NoSQL databases are currently popular , NoSQL DBs are not a replacement to RDBMS.  This course is to understand the Basic knowledge on RDBMS and writing SQL queries in Oracle . This entire course can be broken into 2 parts one is RDBMS Fundamentals and next is SQL Fundamentals.

Under DBMS Fundamentals , Concepts of RDBMS , Normalization in DB, EF Codds’ Rules which core part of RDBMS systems are well explained.  This is well built to share the enough details on DBMS Keys along with Data Integrity and constraints .

Under SQL Fundamentals , this course teaches what are the types of Joins , what are Sub Queries , CTE Queries , how to write a SQL with single , Multi Table joins  and how to write a query with Group by clauses . Also included the part of Data dictionaries and how this can be used in Oracle. Through out this course you will learn RDBMS through Oracle .  This course is designed with excellent practice test and assignment at the end of the lesson to test your understandings.