So far, you have learnt about some of the basic and advanced SQL concepts. So, let’s continue with this module and learn more about case statements and stored routines. You will also understand the importance of using these and other SQL features in this session.
In this session
You will learn about case statements, which are used for classifying your results based on certain conditions. You will also learn about stored routines such as user-defined functions and stored procedures, which are used for storing and reusing large queries to solve complex problem statements efficiently. Finally, you will learn about cursorsand their uses.
People you will hear from in this session
Professor & Dean (Academics), IIIT-B
The International Institute of Information Technology, Bangalore, 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.
Lead Business Analyst, Swiggy
Shreyas has completed Bachelor of Engineering from PES Institute of Technology – West Campus, Bengaluru (now PES University). He leads the analytics division for New Initiatives at Swiggy, which involves coming up with various strategies to increase brand awareness. He has worked in both consulting and product-based roles. His areas of technical expertise include SQL, Excel, PowerBI, Tableau, Qlikview and R.