Download PDF
1. Introduction
● What is a Database?
● What is a Database Management System (DBMS)?
● What is a Relational Model ?
● Introducon to RDBMS
● What is database Testing?
● Why is Database Testing important?
● How to install a sample database for practice?
2. Data Types and Constraints
● What are Data Types?
● Types and Examples
● How to use it?
● What are Constraints?
● Types and Examples?
● How to use it?
3. Statements in SQL
● Data Defination Language (DDL)
● Data Manipulation Language (DML)
● Transaction Control Language (TCL)
● Data Control Language (DCL)
● Data Query Language (DQL)
4- Software installation
● Installing and set up of software
● Use mysql workbench
5- Data Query Language (DQL)
● Select
● From
● Where
● Group By
● Having
● Order By
6 -Operators
● Types and Examples
7- Functions in SQL
● Single Row Functions
● Multi-Row Functions
1.Max ()
2.Min ()
3.Sum ()
4.Avg ()
5.Count ()
8-Sub Query
●Introduction to Sub Query
● Working of Sub Query
● Query Writing and Execution
● Types of Subquery :
1. Single Row Subquery
2. Multi-Row Subquery
● Nested Subquery.
10- Pseudo Columns
● Introduction on Pseudo Columns
● ROWID
● ROWNUM
● Working and Usage.
11- JOINS
● What is Join?
● Types of Joins.
● Cartesian Join
● Inner Join
● Outer Join
● Self-Join/Left/Right
● Queries and Examples.
12- Co- Related Subquery
● Working and Examples
13- Data Definition Language (DDL)
● Create
● Rename
● Alter
● Truncate
● Drop
14- Data Manipulation Language (DML)
● Insert
● Update
● Delete
15- Transaction Control Language (TCL)
● Commit
● Save point
● Rollback
16- Data Control Language (DCL)
● Grant
● Revoke
17 - Normalisation
● Introduction to Normalization
● Types of Normal Forms
● Examples.
18- E R Diagrams
●Introduction to ER Diagram
●Examples
