Oracle Database For Beginners

  • Overview
  • Curriculum
  • Instructor
  • Review

About This Course

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

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

  • 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

Course Curriculum

1 Lectures

Instructor

Profile photo of Srikanth Pragada
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,...

More Courses By Srikanth Pragada
Review
4.9 course rating
4K ratings
ui-avatar of Blusalt Inc
Blusalt I.
5.0
8 months ago

Sounds clear

  • Helpful
  • Not helpful
ui-avatar of Surendra
Surendra
5.0
9 months ago

4

  • Helpful
  • Not helpful
ui-avatar of Madhurendra Kumar
Madhurendra K.
5.0
10 months ago

nice

  • Helpful
  • Not helpful
ui-avatar of ALLUGUNTI SIDDA RAMI REDDY
Allugunti S. R. R.
4.0
1 year ago

it was a wounderful sessions

  • Helpful
  • Not helpful
ui-avatar of Sanket Anil Desai
Sanket A. D.
3.0
1 year ago

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

  • Helpful
  • Not helpful
ui-avatar of Ankush Gholap
Ankush G.
5.0
1 year ago

very good course

  • Helpful
  • Not helpful
ui-avatar of Adrian carl Munoz
Adrian C. M.
5.0
2 years ago

Very good!

  • Helpful
  • Not helpful
ui-avatar of Tanveer Ahmed Khan
Tanveer A. K.
3.5
3 years ago

Good Course!!

  • Helpful
  • Not helpful
ui-avatar of John Christopher M. Reyes
John C. M. R.
5.0
3 years ago

yes.

  • Helpful
  • Not helpful
ui-avatar of Lokesh Rao Gujja
Lokesh R. G.
5.0
3 years ago

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

  • Helpful
  • Not helpful
Leave A Reply

Your email address will not be published. Required fields are marked *

Ratings

Courses You May Like

Lorem ipsum dolor sit amet elit
Show More Courses