Database

 

1 - Introduction
• What Is Database?
• What is Database
Management System (DBMS)?
. What is Relational Model?
• Introduction to RDBMS.
• Brief on E.F CODD.

​

2 - Datatypes and Constraints
• What are Datatypes?
• Types and Examples.
• How to use.
• What are Constraints?
• Types and Examples.
• How to use.

​

3 - Statements in SOL
• Data Definition Language (DDL)
• Data ManipulationLanguage (DML)
• Transaction ControlLanguage (TCL)
• Data Control Language(DCL)
•Data Query Language(DQL)

​

4- Software installation
• Installing and set up of software
• Working on Oracle 10g.

​

5- Data Query Language (DQL)
• Select
• From
•Where
• Group By
• Having
• Order By

​

6 -Operators
• Types and Examples

​

7- Functions in SOL
• Single Row Functions
• Multi Row Functions
Max ()
Min (
Sum ()
Avg ()
Count ()

​

8-Sub Query
• Introduction to Sub Query
• Working of Sub Query
• Query Writing and Execution
•Types of Sub Query
1. Single Row Sub Query
2. Multi Row Sub Query
• Nested Sub Query.

​

9- Pseudo Columns
• Introduction on Pseudo
Columns
• ROWID
•ROWNUM
• Working and Usage.

​

10- JOINS
What is Join?
, Types of Joins, Cartesian Join
" Inner Join
Outer Join
•Self-Join
Queries and Examples,

​

11- Co- Related Sub Query
. Working and Examples

​

12- Data Definition Language
(DDL)
• Create
•Rename
• Alter
• Truncate
• Drop

​

13- Data Manipulation
Language (DML)
• Insert
• Update
• Delete

​

14- Transaction Control
Language (TCL)
• Commit
• Save point
• Rollback

​

15- Data Control Language (DCL)
• Grant
• Revoke

16 - Normalization
• Introduction to
Normalization
• Types of Normal Forms
• Examples.

​

17- E R Diagrams
• Introduction to ERD
• Example

​

​

​

​

​