Also learned about the database concepts. I used Apache and MySQL database. First we were told about the advantages of using DBMS over the file system. I studied concepts of DDL,DML and DCL languages and then got myself familiar with basic queries of SQL like insert,update,delete and create,alter,update,rename,etc.
Also, learned about the concepts of views.
Tried some basic queries of SQL that covers basic concepts and queries of SQL and learned about different types of keys and constraints in SQL .
Then, we learned about Normalisation — The basic concept, its need, its forms and the concept of functional and multivalued dependencies.