Oracle Database For Beginners
Oracle Database For Beginners
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
Learn how to store, manipulate, query and process data in Oracle Database using SQL and PL/SQL
Url: View Details
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
Rating: 4.5
Level: Beginner Level
Duration: 9 hours
Instructor: Srikanth Pragada
Courses By: 0-9 A B C D E F G H I J K L M N O P Q R S T U V W X Y Z
About US
The display of third-party trademarks and trade names on this site does not necessarily indicate any affiliation or endorsement of hugecourses.com.
View Sitemap