This session deals with installation, configuration and usage of MySQL server on a Ubuntu Server machine and MySQL client on a Kali Linux machine. First of all, a bit of user management is done, i.e., creating, deleting users and granting/revoking privileges to them. Then a remote login is made from client machine Kali to perform various database management operations including creating, modifying and deleting databases and tables. Different constraints like not null, unique, primary key, foreign key, default, check and index are discussed. Scripts are used to run various SQL statements. Finally, different queries are run on a database to make the students understand the concepts of different SQL operators, functions, joins, sub-queries, views, transactions, triggers and events.

Leave a Reply

Your email address will not be published. Required fields are marked *