The Course is All about How We Can Manage the Business Data In The Database Following The RDBMS(Relational Database Management Systems).
1.) Students Can Understand Easily Each And Every Concept of Database As Part of The Interactive Sessions Daily.
2.) We Will Cover The Below:
SQL:
====
Basics Of SQL
Functions
Constraints
Joins
SubQueries
Hierarchical Queries
Pseudo Columns
Views
Indexes
SET Operators
DBA Security Aspects
Updates And Deletes, MERGE Statement in SQL
OLAP(Online Analytical Programming) Features
PLSQL
====
Basics of PLSQL
Control Structures
Compound Data Types
Cursors in PLSQL.
Exception Handling in PLSQL
Sub-Programs:
Stored Procedures
User Defined Functions
Packages
Triggers