SQL Demo Class Deepali Maam Weekdays & Wknds| SQL Basics

Best to get started with Database Trainings
https://sites.google.com/view/techbodhi/all-courses/sql-training
1 - Introduction
• What Is Database?
• What is Database Management System (DBMS)?

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 SQL
• Data Definition 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

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
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.

09- 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- E R Diagrams
• Introduction to ERD