Consider a data set of the Indian census containing at least a billion rows, with data on every individual’s height, weight, monthly income, and hundreds of more such attributes. How do you even start with the analysis of such an extensive data set to capture any trends in the data? The SQL clauses that you will learn in this segment and throughout this session will help you with this.
So, in this segment, you will learn about the basic constructs of the SELECT query. You will specifically learn about the following:
- Select’ Clause
- ‘From’ Clause
- ‘Where’ Clause
- Operators: Arithmetic, Comparison and Logical.
Now, it is important that you go through the next videos carefully, as they will form the foundation for the entire SQL course.
Before proceeding to the operations, download the following SQL script and set up the schema on which all the operations are performed.
Also, please download the attached script file, which contains the questions that are solved in the upcoming videos.
So, in the video, you learnt about a few basic queries using the select and from statements. After watching the next couple of videos, you will be able to filter data based on certain given criteria and group it into categories, if required. You will also learn how to use operators in queries. In the next video, you will have hands-on using the basic SQL commands.
In the next video, you will see more SQL operators’ applications.
Operators can be used for various functions: pattern matching, returning a subset of the data based on its properties or comparing different values to get a sense of the distribution of the data. Pattern matching is an important concept in text-based processing. As you learnt, in SQL, certain characters are reserved as wildcards, which can match any number of preceding or trailing characters.
Additional Resources:
- SQL Operators is an excellent resource where you can have a quick glance at the various operators that are supported in SQL.
Now let’s try to solve some MCQs as well as SQL querying questions below:
In the next segment, you will learn about the aggragate functions.