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
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
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
Instructor Details
- 4.5 Rating
154 Reviews
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
More courses by Srikanth Pragada
More SQL courses
SQL - The Complete Developer's Guide (MySQL, PostgreSQL) (2025)
4.8 (2,153 Reviews)
Provider: Udemy
Time: 19.7h
$94.99
SQL Server High Availability and Disaster Recovery (HA/DR) (2026)
4.8 (1,810 Reviews)
Provider: Udemy
Time: 88.3h
$16.99
70-461 Session 3: Querying Microsoft SQL Server (T-SQL code) (2025)
4.8 (1,094 Reviews)
Provider: Udemy
Time: 3.6h
$12.99
Modern Event-Driven Spring Boot: Kafka & Spring Cloud Stream (2026)
4.8 (494 Reviews)
Provider: Udemy
Time: 13.4h
$10.99
Oracle Database 12c Backup and Recovery using RMAN (2024)
4.8 (428 Reviews)
Provider: Udemy
Time: 20.1h
$34.99
Reviews
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.
Quality Score
No CourseDuck member has rated this course yet. Taken it? Give each part a thumbs up or down.
Overall Score : 90 / 100








