This class is for class 12 computer science students.
This class will give a theoritical understanding as well as a hands on practice of the topic.
Students should have pen and paper to make notes.
MySQL software installed on students system will be preferred but not compulsory.
Last ten minutes of the class will be for questions/answers and doubt clearing.
Following topics will be covered in the class.
- Introduction to MySQL
- Database management system
- Different types of Database management systems
- Difference between DBMS and RDBMS
- Different types of languages used by Database management systems.
- Introduction of SQL ( Structured Query Language)
- Different types of SQL commands
- DDL, DML, TCL etc.
- Understanding the syntax of commands to write commands easily and accurately
- Introduction to commands like Create, Alter, Drop, Insert, Update, Delete etc.
- Runing MySQL software on system and understanding it's interface.
- Practicing SQL commands on MySQL software like Create and Use commands.
- Exiting MySQL