B.Tech(IT) undergrad from IIIT Allahabad || Android developer and passionate programmer || loves to code and teaching 

Suraj Singh

This course is consist of queries in sql which is a major part in sql. with the help of queries, we have all the functionality, whether it be searching, inserting something in table and much more.

GATE (Graduate Aptitude Test in Engineering) 2020 & 2021 complete preparation with best educators. Know about the detailed syllabus, best books, exam pattern and dates, previous year question papers a

GATE - Iconic Pro

Hindi

(Hindi) Queries in SQL - Simple to Complex

Programming Languages

Database Management System

CS & IT

GATE - CSIT, DSAI & Interview Preparation

GATE, ESE and IIT-JAM

Ace the toughest competitive and government exams in India 

Test Preparation

This chapter consist of course structure as well as the first chapter of course which tells about the select query in sql.

SELECT Query in SQL (in Hindi)

In this chapter, we discuss about the WHERE clause which we use to select specific data in tables.

WHERE Clause in SQL (in Hindi)

In this chapter, we are going to learn NULL,IS NULL, IS NOT NULL, AND operators in SQL

IS NULL, NOT NULL, AND Operators in SQL (in Hindi)

In this lesson, we discuss about the OR,IN,NOT IN queries and complex queries including nested queries.

OR,IN,NOT IN Operators in SQL (in Hindi)

In this chapter, we discuss about an important query BETWEEN and use of it. Also we discuss about some other complex queries using BETWEEN,AND,IN.

BETWEEN Number, Text, Date in SQL (in Hindi)

In this lesson, we discuss about the LIKE query with the help of which we can search with limited known information.

LIKE Operator in SQL (in Hindi)

In this lesson, we discuss about imp keyword ORDER BY in SQL use to sort data in particular order.

ORDER BY in SQL (in Hindi)

In this lesson, we discussed about NOT NULL  which we can use in our table.

NOT NULL in SQL (in Hindi)

In this chapter, we discussed about one of the important clause GROUP BY in SQL.

GROUP BY, HAVING Clause in SQL (in Hindi)

In this lesson, we have discussed how to add extra columns in existing tables.

ALTER TABLE for adding column and constraint in clomn in SQL

Teaching experience of 4+ years as GATE faculty with some prestigious GATE institutions,Qualifying GATE from 2014,Qualifyied UGC NET 2018(ju

Megha 

This course will give detail information about all the operation which can be performed on database.Different types of join with relevant examples will be discussed.

(Hindi) GATE (CS and IT): Relational Algebra:A Query Language

Hi guys, I am currently pursuing my engineering course. I love to code and to share my knowledge with others. Follow for more amazing course

Sourabh Adhikari

In this course, you are going to learn about the basics of DBMS, you will learn the different SQL queries and how to use them.

(Hindi) Understanding DBMS Using SQL

Hello !myself shubham vijay kogade, studying  computer engineering at sinhgad institute pune, Educator in Unacademy..

Shubham Kogade

In this course, Shubham Kogade discusses the different concepts of Sql. This course will be beneficial for GATE aspirants.

MySQL In Brief: GATE (CS and IT)


Done graduation from Thakur college of science and commerce,
Master in computer science ,
Educator in Unacademy.

Pratiksha Tripathi

In this course, Pratiksha Tripathi discussed few important concepts of PLSQL. This course provides all the requires topics for the beginners. She has covered the data types, conditional controls, Transactions, cursor.

Introduction to PL/SQL for Beginners

Stopped Teaching at Unacademy.
Subscribe at youtube- https://www.youtube.com/channel/UCz-PmB0Sk2QGtLlt2rLH5mQ

Balwant Singh

In this course we will cover all the topics of sql .we will start from scratch and will go to advanced level.

(Hindi) SQL Tutorials for GATE

Priyanka Chatterjee

Clear your concept of Normalization with the quick Revision Chart and GATE previous years Question. Get the full marks in exam..

Lessons

10 lessons • 1h 30m

Invalid Date

NaN

SELECT Query in SQL (in Hindi)

Invalid Date

NaN

WHERE Clause in SQL (in Hindi)

Invalid Date

NaN

IS NULL, NOT NULL, AND Operators in SQL (in Hindi)

Invalid Date

NaN

OR,IN,NOT IN Operators in SQL (in Hindi)

Invalid Date

NaN

BETWEEN Number, Text, Date in SQL (in Hindi)

Invalid Date

NaN

LIKE Operator in SQL (in Hindi)

Invalid Date

NaN

ORDER BY in SQL (in Hindi)

Invalid Date

NaN

NOT NULL in SQL (in Hindi)

Invalid Date

NaN

GROUP BY, HAVING Clause in SQL (in Hindi)

Invalid Date

NaN

ALTER TABLE for adding column and constraint in clomn in SQL