Sql Database Training Course

Duration:
30 HRS

Subjects:
Sql open source database

  • 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