MySQL Course

Course Duration: Approx. 15 hrs. Rs. 6,000

Following is the list of topics that will be covered during the course:

  1. 1. Introduction
  2. 2. Managing Database
  3. 3. MySQL Data Types
  4. 4. MySQL OPERATORS
  5. 5. MySQL Constraints
  6. Primary Key Constraint b.  Unique Constraint
  7. NOT NULL Constraint d.  Default Constraint
  8. FOREIGN KEY Constraint
  9. 6. Data Definition Language a.    Create Statement b.   Alter Statement
  10. Drop Statement
  11. 7. Data Manipulation Language a.    Insert Statement
  12. b. Update Statement c.    Delete Statement d.   Select Statement
  13. 8. SQL WHERE clause
  14. Equality conditions b.  Range conditions
  15. IN condition
  16. d. BETWEEN condition e.   LIKE condition
  17. 9. DISTINCT clause
  18. 10. LIMIT clause

 

  1. 11. MySQL Joins
  2. Inner Join b.  Outer Join
  3. Left Outer Join
  4. Right Outer Join
  5. 12. MySQL Functions
  6. Scalar Functions i.  UCASE() ii.   LCASE() iii.   LEN()
  7. MID()
  8. NOW()
  9. b. Aggregate Functions
  10. COUNT()
  11. SUM() iii. AVG() iv. MIN() v.  MAX()
  12. 13. GROUP BY clause and HAVING condition