In this lecture, we will touch upon

1. How is SQL different from a programming language

2. Starting to write queries (SQL)

3. SELECT statement

4. My first SQL

In this lecture we will learn the use of * in SQL

In this lecture, we will learn one of the most important traits needed in life- how to ignore things :)

Put simply, how to write comments in SQL

In this lecture, we will learn

1. How to filter data in SQL

2. Syntax of the WHERE keyword

In this lecture, we will familiarize ourselves with

1. More than one filter condition in a query

2. Other operators

   1. IN

   2. >

   3. <

In this lecture, we will understand

1. A new operator called BETWEEN

2. Difference between filtering on a numeric value and a String value

In this lecture, we will understand

1. What is NULL and what is it significance in SQL

2. How to filter based on NULL

3. Another wildcard character %

In this lecture, we will understand the two keywords used to join filters

1. AND

2. OR

In this lecture, we will look at

1. How to order results

2. Ascending

3. Descending

   
   

In this lecture, we will learn how to fetch data housed in many tables. We will get familiar with the important concept called joins.

In this lecture, we will learn about the different types of joins

1. Left join

2. Right join

3. Self Join

   
   

In this lecture, we will explore what are functions, when to use them and how to use them to our advantage

In this lecture, we will learn

1. How date values in columns are special

2. How will you write queries dealing with dates

In this lecture, we will explore

1. Use of GROUP BY 

2. When is it helpful

In this lecture we will become better at GROUP BY by learning the value of using the keyword HAVING.

In this lecture, we will learn about sub queries. A query within a query?

In this lecture, we will explore

1. What is database testing

2. Why is it needed

3. Various aspects of data testing that you as a QA tester may have to take care of

   
   

What did we do so far?