Introduction to Databases (You can choose database of your choice(Oracle,SQL Server or MySQL)
It includes topics like database architecture, SQL*Plus usage, data definition (DDL), data manipulation (DML), data control (DCL), and transaction control (TCL) languages. It also delves into specific areas such as managing schema objects, user security, backup and recovery, and working with multitenant architecture.
- Introduction to Databases (You can choose database of your choice(Oracle,SQL Server or MySQL)
- SQL Basics
- Data Definition Language (DDL): Creating, altering, and dropping etc
- Data Manipulation Language (DML): Inserting, updating, deleting, and retrieving data.
- Data Control Language (DCL): Granting and revoking privileges
- Transaction Control Language (TCL)
- Querying Data
- Joining Tables: Using different types of joins (inner, outer, etc.)
- Subqueries.
- Views.
- Indexes .
- Procedures.
- Functions.
- Using Procedural Languale.