Learn basic concepts of Oracle SQL and PL/SQL. The course covers the following topics:
1. Introduction to Oracle and DBMS technologies
2. Schemas & Tables
3. Normalization & Denormalization
4. Oracle SQL & PL/SQL tools
5.Connecting to Database
6. Architecture of Oracle
7. Creating Database Objects
8. Creating and modifying tables
9. DB users, roles, and basic security
10.Working with Data
11. Joining multiple tables
12. Queries, Sub-queries, nested sub-queries
13. Commit Vs. Rollback
14. Functions, Stored functions
15. Brief introduction to PL/SQL