What You Will Learn!
- Purpose of DBMS
- Normalization Overview
- EF Codd's Rule overview
- RDBMS & Oracle 9i +
- DDLS , DMLS & Basic Query writing with Group BY Clauses .
Description
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 Codd's' 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. Throughout 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.
This is course is for beginners and no prior knowledge on RDBMS is needed.
Who Should Attend!
- Beginner Database Developers curios to know RDBMS and Oracle
- Computer science students or graduates wish to continue their learning in RDBMS
