Learn RDBMS with Oracle

Learn RDBMS with Oracle, available at $44.99, has an average rating of 4, with 17 lectures, 5 quizzes, based on 9 reviews, and has 26 subscribers.

You will learn about Purpose of DBMS Normalization Overview EF Codds Rule overview RDBMS & Oracle 9i + DDLS , DMLS & Basic Query writing with Group BY Clauses . This course is ideal for individuals who are Beginner Database Developers curios to know RDBMS and Oracle or Computer science students or graduates wish to continue their learning in RDBMS It is particularly useful for Beginner Database Developers curios to know RDBMS and Oracle or Computer science students or graduates wish to continue their learning in RDBMS.

Enroll now: Learn RDBMS with Oracle

Summary

Title: Learn RDBMS with Oracle

Price: $44.99

Average Rating: 4

Number of Lectures: 17

Number of Quizzes: 5

Number of Published Lectures: 17

Number of Published Quizzes: 5

Number of Curriculum Items: 23

Number of Published Curriculum Objects: 23

Number of Practice Tests: 1

Number of Published Practice Tests: 1

Original Price: ?1,199

Quality Status: approved

Status: Live

What You Will Learn

Purpose of DBMS

Normalization Overview

EF Codds Rule overview

RDBMS & Oracle 9i +

DDLS , DMLS & Basic Query writing with Group BY Clauses .

Who Should Attend

Beginner Database Developers curios to know RDBMS and Oracle

Computer science students or graduates wish to continue their learning in RDBMS

Target Audiences

Beginner Database Developers curios to know RDBMS and Oracle

Computer science students or graduates wish to continue their learning in RDBMS

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.

Course Curriculum

Chapter 1: Course Introduction

Lecture 1: RDBMS with Oracle – A Course Preview

Chapter 2: Introduction

Lecture 1: Introduction to DBMS

Lecture 2: Types of DB Management System

Lecture 3: RDBMS -A quick Look

Lecture 4: RDBMS -A quick Look -ACID Transactions

Lecture 5: EF Codds Rule -An overview

Chapter 3: Database Design

Lecture 1: DB Design -A Quick Overview

Lecture 2: DBMS Keys

Lecture 3: Normalization

Lecture 4: Data Integrity

Lecture 5: DB Design Tools

Lecture 6: Chapter Summary

Chapter 4: Oracle SQL Reference

Lecture 1: SQL Fundamentals -Introduction

Lecture 2: DBMS Languages – SQL Reference Part I

Lecture 3: DBMS Languages – SQL Reference Part II

Lecture 4: SQL Sub Queries by Example

Lecture 5: Working with Database Constraints

Instructors

Mohanakrishnan Rajamani
Senior Data Engineer

Rating Distribution

1 stars: 0 votes

2 stars: 2 votes

3 stars: 0 votes

4 stars: 6 votes

5 stars: 1 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!