Skip to content
UdemySQLPaid courseBeginner levelCertificate

Oracle Database For Beginners (Udemy.com)

Learn how to store, manipulate, query and process data in Oracle Database using SQL and PL/SQL

Created by: Srikanth Pragada

Last updated August 2023

icon
What you will learn

  • Concepts of Database, how to use SQL to retrieve & manipulate data and use PL/SQL to develop program units to implement business logic and rules

How it compares

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

  • Rating4.5 out of 5higher than 48% of them
  • Reviews154#314 of 389 by number of reviews
  • Length9.1 hourslonger than 66% of them
  • Last updatedAugust 2023earlier than 51% of them

icon
Course Description

Learn how to use Oracle Database to store, manipulate and query data.  It takes you from fundamentals of databases to creating program units to implement business logic and rules using PL/SQL.

The following are major topics covered:

  • What is DBMS and RDBMS

  • How to get started with Oracle Database 18c XE and Oracle SQL Developer

  • How to use SQL to retrieve, manipulate and create data

  • How to group data using GROUP BY and HAVING clauses

  • How to use different types of joins to get data from multiple tables

  • How to use subquery and correlated subquery to write complex queries

  • What is a view, advantages of view and how to manipulate base table through view

  • What is index and how index improves performance

  • Implementing object-level security using object privileges

  • How to create and use regular expressions

  • Writing PL/SQL blocks to process data

  • Various control structures in PL/SQL

  • Handling exceptions

  • Explicit and Implicit cursors

  • Creating procedures and functions to implement business logic

  • Creating database triggers to implement business rules

  • Dynamic SQL and collections

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

Srikanth Pragada

I have been teaching programming languages for more than 33 years. I worked with more than 15 programming languages.

Specialised in developing Web applications using Java EE, Spring, Microsoft .NET, Python + Django, React, Angular, Node.js and Express.js.

I am well-versed with many Database Systems like Oracle, MySQL, MS SQL Server and MongoDB.

I provide classroom and online training on C, Java, Java EE, JPA (Hibernate), Spring, Microsoft .NET, Oracle, Python, AWS, Data Science and Machine Learning with Python, React, Angular and Full-Stack Web Development using Node + Express + React through my company, Srikanth Technologies, Vizag, India.

I am a corporate trainer offering inhouse (or online) training for corporates. Please visit my website for details.

I love to learn and share my knowledge with as many as possible through my offline and online courses, my website, YouTube channel and repositories in GitHub.

I acquired the following industry certifications:

-  AWS Certified Cloud Practitioner

- Sun Certified Java Programmer 

- Sun Certified Web Component Developer for Java EE 

- Sun Certified Business Component Developer for Java EE 

- Oracle Database SQL Expert

- Oracle PL/SQL Developer Certified Associate

icon
More courses by Srikanth Pragada

Free

$59.99

icon
More SQL courses

$94.99

$16.99

$12.99

$13.99

$10.99

$34.99

icon
Reviews

4.5

154 ratings on Udemy

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

By Prasad Vedpathak on 4/18/2025

it is my first course on Udemy.I am happy cause it is very helpful and easy to understand.

By Sanket Anil Desai on 3/7/2024

There are some advance topics instead of beginner level. Facing some difficulty while understanding. Lets see how it goes

By Lokesh Rao Gujja on 11/11/2021

The best course to learn SQL and Oracle PL/SQL.

By Krishna Chaitanya on 11/14/2020

Good course for beginners to start with. Vast content

By Martin Belak on 8/27/2020

very good course even if I am intermediate developer. good to recapitulate some lessons and to learn new things. thank you. :)

By et on 8/22/2020

I am very happy with this course and feel I learn a lot that I don't know before. The knowledge I learn from here will help me in coding more efficiently.

By Raghavendra on 3/16/2020

The course was really good. Where are the answers to the exam questions?

By Praveen kumar S on 3/8/2020

For freshers is very easy to understand on SQL stuff, more explainmentory is nice and all user understanable concepts.

By Madan Neelapu on 2/8/2020

This course stands for its title: 'For Beginners'. Instructor explains all the concepts are explained concisely and to the point. It is very easy to follow along for beginners. I am here because especially PL/SQL is required for my job. But had an very good learning experience both in SQL and PL/SQL. The best part is you don't need to set-up/import a new schema/database. This course uses the built-in HR schema. It is good enough for beginners like me. As a beginner I would like to focus more on concepts and querying rather than administration(import, export etc) of database. Also, I liked the bullet-point notes shared in the slides. Its very easy to follow and memorize. The exercises and tests are really good. They gave me confidence. I would definitely recommend this course for other beginners out there who are interested to learn about database. Thank you Srikanth Pragada. Please keep doing more courses for beginners like this.

By Mercy Alfanso on 11/8/2019

Teaching is very clear and simple to understand,I have taken other courses from same trainer.Srikanth Sir your excellent trainer thank you for posting this course on udemy.

Showing all 10 reviews on CourseDuck

Read all 154 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 : 90 / 100