This course will teach how to use Oracle database to store, manipulate and query data. It takes you from the fundamentals of databases to creating program units to implement business logic and rules using PL/SQL.

What will you learn in this course?

• What are 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 the base table through a view
• What is the 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

This course is meant for any beginner of DBMS who is interested in learning how to use DBMS, SQL and PL/SQL to build database-driven applications or to interact with the database in data analysis and data science.