SQL Basic to Advanced Online Training
SQL Advanced Level Online Training for 4 weekends
Fee:- Rs 5000/- INR
1. Database Introduction
2. Overview of SQL
3. Installations
MS SQL Server
MySQL Server
PostgreSQL Server
4. Querying from all the databases Tools
5.SQL Sub Language
DDL - create, alter, truncate, drop
DML - insert, update, delete
DQL / DRL - select
TCL - commit, rollback, Save Point
DCL - grant, revoke
6, Querying Data with SELECT Statement
SELECT LIST
ORDER BY
WHERE
Distinct
Non Distinct
WildCard (*)
7. Data Types
BIT
BOOLEAN
CHAR
DATE
DATETIME
DECIMAL
ENUM
INT
JSON
TIME
TIMESTAMP
VARCHAR
FLOAT
8, SQL Operators - Filtering Results
Logical Operators
BETWEEN, LIKE, IS, IS NOT, IS NULL, Column Aliases
Comparison Operators
>, <, =, <=, >=, <> or !=
Boolean Operators
TRUE, False
Arithmetic Operators
+, -,%
9.Inserting,Updating & Deleting
INSERT
UPDATE
DELETE
10. Constraints
default constraint
not null constraints
Primary key constraints
Composite Primary Key constraints
Unique Constraint
ALTER TABLE
DROP TABLE
11. Joins
INNER Join
OUTER Join
RIGHT Join
LEFT Join
Self Join
CROSS JOIN
12. Unions & Subqueries
Unions Operators
Subqueries
13. Views
Creating Views
Advantages of Views
Simplified Queries
DML Operations
14, SQL Functions
Introduction
Scalar Functions
Numeric Functions
Date/Time Functions
Control Flow Functions
Cast Functions
Aggregate Functions
15.Security
Creating User
Granting Permissions
Revoking Permissions
16.Stored Procedures
Beginning Stored Procedures
SP with Multiple Resultset
SP with Parameters - Functions
SP with Parameters - DML Operation
SP with Parameters - Input and Output
SP with Drop and Create
17, Indexes
Clustered Indexes
Secondary Index B-Tree
Hash Indexes
18, Triggers
Before Trigger
After Trigger
19, Project
Real-time project
Any questions & doubts
