SQL Database Training Course

SQL Database training is offered by AEIT for all skill level. Our courses integrate Practical, Hands-on Training & Exposure with Industry Use Case Studies and Real Projects using datasets from companies like Uber, Amazon, Sandisk, Nike, Swiggy, Yelp, and Walmart, etc.

Content:

• History of Sql
• Basic Sql
• Why and Scope of Sql
• Sql as Open source Technology
• Sql for Web Based Application
• Sql Database Engines (INNODB , MyISAM etc.. )
• Sql Data Types (INT , Varchar , Date , timestamp etc..)
• Sql Create Database Query
• Sql List Database Query
• Sql Create Table
• Sql List Tables in database Query
• Sql Show Table Fields
• Sql er query
• Sql Primary Key Constraint
• Sql Unique Key Constraint
• Sql Full Text Key Constraint
• Sql Foreign Key Constraint
• Sql Where clause
• Sql Alias
• Sql Where clause with AND Logic
• Sql Where clause with OR Logic
• Sql Where clause with AND & OR Logic
• Sql Like Query with wild card character
• Sql Between Query with Example
• Sql Order By Query with Example
• Sql Group By Query with Example
• Sql Having Clause
• Sql Sub Query Example
• Import and Export through Command line
• Import and Export through PHPMYADMIN Tool
• Sql Functions - AVG()
• Sql Functions - MIN()
• Sql Functions - MAX()
• Sql Functions - COUNT()
• Sql Functions - SUM()
• Sql Functions - ROUND()
• Sql Functions - CONCAT()
• Sql Functions - LCASE()
• Sql Functions - UCASE()
• Sql Functions - repeat()
• Sql Functions - substr()
• Sql Functions - strpos()
• Sql Functions - sqrt()
• Sql Functions - power()
• Sql Functions - abs()
• Sql Functions - concat_ws()
• Sql Functions - concat()
• Sql Functions - curdate()
• Sql Functions - curtime()
• Sql Functions - datediff()
• Sql Functions - hour()
• Sql Functions - second()
• Sql Functions - day()
• Sql Functions - month()
• Sql Functions - now()
• Sql inner Join
• Sql Left Join
• Sql Right Join
• Sql Natural Join
• Sql Roll back and Commit
• Sql Union
• Sql Query Optimization Concept
• Sql Views
• Sql Stored Procedures
• Sql Triggers
• Sql Functions
• Sql Clustering
• Sql Indexing
• Sql Database Normalisation concept