Certificate Course In MySQL

by JYCSM (Jatiya Yuva Computer Saksharta Mission) Claim Listing

Certificate Course In MySQL is offered by JYCSM (Jatiya Yuva Computer Saksharta Mission). Jatiya Yuva Computer Shaksharta Mission is the new lighting of computer education in India.

Price : Enquire Now

Contact the Institutes

Fill this form

Advertisement

JYCSM (Jatiya Yuva Computer Saksharta Mission) Logo

img Duration

3 Months

Course Details

Certificate Course In MySQL is offered by JYCSM (Jatiya Yuva Computer Saksharta Mission). Jatiya Yuva Computer Shaksharta Mission is the new lighting of computer education in India. The great scholars realized to make each Indian's life fulfilled with prosperity and improvement, progress through computer education.

 

Content:

  • 1. Definition of DBMS and RDBMS.
  • 2. Advantages and Disadvantages of Database.
  • 3. Database Languages (DDL, DML, DCL)
  • 4. Definition of MySql.
  • 5. Advantages of MySql.
  • 6. How does MySql Works in the Backend Process.
  • 7. Definition of Primary Key, Foreign Key, Candidate Key, Alternate Key.
  • 8. Data types of MySql (Char, Varchar, BLOB or Text, Int, Tinyint, Double, Number, Date, Datetime,
  • Timestamp, Time, Year, Float etc)
  • 9. Sql Commands :
  • A. Create
  • B. Show Database
  • C. USE
  • D. Rename
  • E. Show Tables
  • F. Insert
  • G. Alter
  • H. Drop
  • I. Describe
  • J. Select
  • K. Update
  • L. Select with where clause
  • M. Select with Wildcard Characters
  • N. Select with Count
  • O. Delete
  • 10. Concept of Relationship with example.
  • 11. Types of Relationship with MySql Commands:
  • A. 1:1 Relationship
  • B. 1:Many Relationship
  • C. Many: Many Relationship
  • 12. Concept of Constraints in MySql with Check Command.
  • 13. Group By and Having Clause, Any and ALL clause,
  • 14. Case Statement
  • 15. Project Work.
  • Howrah Branch

    Block A1, Block A, Kalyani, Howrah

© 2025 coursetakers.com All Rights Reserved. Terms and Conditions of use | Privacy Policy