In the previous sessions, you learnt what databases are, what they are composed of, and how to create a database along with its tables, constraints and values. In this session, we will dive into the core of SQL and you will learn all about the statements that are used for querying data. You will also develop the thought process that is required to extract the data needed for analysis and to drive business decisions.
In this session
You will learn how to write queries using the select, from, where, group by, having, order byand limit statements. A query may generally contain all or some of these keywords. You will also get an understanding of the need for the various types of operators and functions, which make it easy to address seemingly complex data requirements.
Eventually, Professor Ramanathan will talk about subqueries, CTEs (Common Table Expressions) and views, which help with solving even more complex problem statements.
People you will hear from in this session
Subject Matter Expert
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.