Skip to content
UdemySQLPaid courseAll LevelsCertificate

Oracle SQL For Data Analysis : Truly From Basics to Advanced (Udemy.com)

RDBMS Concepts : SQL Basics : Complex SubQueries & Joins : Analytic Functions : Data Integrity : Transaction Handling

Created by: Prashant Munshi

Last updated January 2021

icon
What you will learn

  • SQL over Oracle 19 C version on Oracle LiveSQL platform
  • A to Z in SQL on Oracle's latest version
  • Go from an absolute beginner to an advanced SQL developer in less than 15 hours
  • RDBMS fundamentals and explanation on various terminologies for interview preparation
  • This is a complete course which does not require the students to have local installation of Oracle yet they we use the latest version of Oracle from web
  • Structure of basic query statement - Projection, Predicate and Verb
  • Use of Logical Operators - AND, OR, IN, BETWEEN, NOT, DISTINCT, LIKE
  • Various important properties of ORDER BY clause with examples
  • Deal with NULL values - IS NULL, NVL, NVL2, COALESCE
  • All forms of Sub-queries / Nested Queries - Multi-valued, Returning NULL, Set Comparison, Correlated, EXISTS operator, ANY & ALL operators

How it compares

Against the other 388 rated Udemy courses in SQL on CourseDuck:

  • Rating4.2 out of 5higher than 13% of them
  • Reviews327#249 of 389 by number of reviews
  • Length15.1 hourslonger than 86% of them
  • Last updatedJanuary 2021earlier than 64% of them

icon
Course Description

***SQL course which gained immediate popularity with the launch on UDEMY***

============================================================================

***Continuously being updated with new topics/videos***

***Added lecture SQL vs NOSQL*** > 19 Dec 2019 (under Interview Section)

***Added Interview Section*** > 15 Dec 2019

*** Added lecture Most Important SQL Queries*** > 15 Dec 2019

***Added lecture What is VIEW?*** > 15 Dec 2019

=============================================================================

You need to learn the most important and powerful language of the database world - SQL which makes your programming skills complete and enriched in just less than 20 hours of study!

If you have already wasted your time and money in hunting for a complete yet concise course in SQL through random YouTube videos or offered by inexperienced people - then you are at the right place here. This course brings step-by-step lessons in its logical series of videos to help you master the art and science of SQL. Moreover there is not even a basic knowledge of programming envisaged while designing this course.

This course has been brought by an highly experienced faculty who have had 20+ years of experience in working as Oracle developer and DBA out of which 6 years onside in USA and UK. The faculty has been working in Oracle field ranging from Oracle version 6 to the latest 19C.

This course is for everybody who likes to make career in Data Analytics, database programming, front end programming, ERP, or in general succeed as an IT professional, management people and undergraduate students of any stream. This course is covered on Oracle's LiveSQL platform available on web hence does not require any local installation of Oracle, yet the students can practice on latest version, the current is Oracle 19C. Being on web, students can learn, take notes or do practice sitting anywhere as Oracle LiveSQL is accessible on all the devices - PC, Laptops or even Mobiles.

icon
Udemy Discount

The discount is applied through our link. Open the course from here and Udemy's current promotional price is applied at checkout on most courses, no code to type.

Some courses are excluded from Udemy's promotions. If the price does not drop, clear your browser cookies and use the button again.

icon
Instructor Details

Prashant Munshi

I have more than 27 years of extensive experience in Oracle Database Administration (DBA) including onsite experience in US and UK of about 6 years. I have been a distinguished corporate trainer and adjunct faculty in the subjects of database engineering and software technologies; attached with various prestigious engineering & tech colleges in Central India since last 15 years.

icon
More courses by Prashant Munshi

$11.99

$64.99

icon
More SQL courses

$94.99

$16.99

$12.99

$13.99

$10.99

$34.99

icon
Reviews

4.2

327 ratings on Udemy

Select a bar to show only those reviews.Select the bar again to show every rating.

By Mark Givand on 9/1/2023

It was good it taught me a few things that I didn't all ready know and cleared up a couple of area in which I was a little confused.

By Raghavendra K on 10/2/2022

course is amazing, I have learnt and lot of things from this course.

By Kelvin Ling on 8/21/2021

This course have comprehensive coverage and comes with explanations & examples with solutions, lack of resources forces you to take notes which could be a better teaching method. However, resources could be improved, more information could be given, some examples are limited to sqlplus. Could include more advance examples or scenarios with solution. May have to search for more information after this course as some information given may not be enough. Overall, would recommend this course to beginners as concepts are well explained.

By Vilas Jadhav on 7/18/2020

Thank you very much sir, Excellent experience and It is good interactive learning session, lot of concepts are cleared and this will help in programming as well as daily use.

By Rajat Singh on 6/20/2020

The course was quite detailed but needs to have some pratical explaination of questions as discussed in the last lecture.

By Vanshika Singhal on 6/11/2020

It's good but could be better!!

By Nagahumsini R.R. on 5/29/2020

GOOD WILL LEARNT A LOT.KINDLY GIVE FREE JAVA COURSE TOO TO GAIN OUT KNOWLEDGE.THANKS IN ADVANCE

By Amit Peter on 2/4/2020

The instructor's knowledge on the subject in excellent, and more than knowledge, his method of teaching is commendable. I am sure that by the time I complete this course, I can say that I have not learnt but mastered SQL.

By Fauz Aziz on 12/26/2019

perfect place to learn with traditional examples. and i am gating recognizing what i learn when i was in college time. i hope this time i will go into the database side

By Deepak Navgire on 12/1/2019

The course is engaging. I could clear my knowledge of basics. However, waiting for more advance course with the same instructor.

Showing all 10 reviews on CourseDuck

Read all 327 reviews on Udemy

icon
Quality Score

No CourseDuck member has rated this course yet. Taken it? Give each part a thumbs up or down.

Content Quality
/
Video Quality
/
Qualified Instructor
/
Course Pace
/
Course Depth & Coverage
/

Overall Score : 84 / 100