We will begin this session with an example that is fairly commonplace in the lives of many: Hospital visits. Recall the last time you went to the hospital as a patient. You may have observed that the receptionist asks for your details. The basic details may include name, age, gender, address, phone number, etc. Some additional details could include information on vaccinations, medical history, details of family illnesses and so on. Based on the information that you provide, the receptionist may assign you to a specific doctor, ward and nurse for treatment. Now, how are these decisions made in almost real-time? Well, this is how it all happens: All the data that you provide, along with the data pertaining to the hospital, is stored in some database. Operations are performed on the database to return relevant results so that the authorities involved can act accordingly.
But how is all of this exactly done? What are the tools and languages that are involved in the process? In this session, Professor Ramanathan will walk you through the data retrieval language that is used in RDBMS (Relational Database Management System): SQL (Structured Query Language).
There are many RDBMS (Relational Database Management System) available, for instance, MySQL, Oracle, MS Access, SQL Server and Postgres. You will be introduced to MySQL, and the platform that you will use in order to retrieve the required data is MySQL Workbench.
In this session
You will be introduced to certain basic SQL commands. SQL is one of the strongest tools for data manipulation, and it is used heavily across all industries. By the end of this session, you should be able to use MySQL databases and write basic SQL queries to retrieve relevant information from typical databases.
People you will hear from in this session
Subject Matter Expert
Professor & Dean (Academics), IIIT- B
The International Institute of Information Technology, Bengaluru, popularly known as IIIT Bangalore, is a premier national graduate school in India. Founded in 1999, it offers Integrated M.Tech., M.Tech., M.S. (Research) and PhD programs in the field of Information Technology.