SQL basic to advanced Online training
For Online training Contact me at venkat.mr369@gmail.com
SQL training from basic to advanced levels will take place over four weekends.
1. Database Introduction
SQL was initially developed at IBM by Donald D. Chamberlin and Raymond F. Boyce after learning about the relational model from Edgar F. Codd in the early 1970s.This version, initially called SEQUEL (Structured English Query Language), was designed to manipulate and retrieve data stored in IBM's original aspirational database management system, System R, which a group at IBM San Jose Research Laboratory had developed during the 1970s.
Around 1980's SQL became commercial
RDBMS & NOSQL
Please Subscribe to MyChannel
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
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.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
16, Indexes
Clustered Indexes
Secondary Index B-Tree
Hash Indexes
17, Triggers
Before Trigger
After Trigger
18, Project
Real-time project
Any questions & doubts
