Undergrad @ IIIT Gwalior. Machine Learning enthusiast. Qualified JEE Mains and Advanced. Gate Aspirant.
Excellent orator.

Surya Pratap Singh

This course is part 3 of the course series on SQL where we help a learner help a learner become an expert an SQL (no matter whether he/she is new to SQL in the beginning). In this part, we'll be learning about displaying data with multiple tables and aggregating group functions. So let's get started.

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

English

SQL Made Easy - Part 3

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

In this lesson, we talked about Cartesian product, joining table using Oracle syntax, equijoin and non-equijoin.

Displaying Data from Multiple Table Part 1

In this lesson, we talked about Outer Joins, Self Join, Cross join, Natural Join, Using clause, ON condition and Three way join.

Displaying Data from Multiple Table Part 2

In this lesson, we talk about the definition of Group functions, their types and syntax and some examples.

Aggregating Data using Group Functions Part 1

In this lesson, we talked about groups within groups, GROUP BY clause and some illegal queries that you must avoid.

Aggregating Data using Group Functions Part 2

In this lesson, we talked about restricting group results by using HAVING clause and nesting of group functions.

Aggregating Data using Group Functions Part 3

Code HELLOSONU01 | 8+ Years Teaching Exp. in GATE CS IT & GATE DS AI on Unacademy | Mentored 2 Lakh+ Students | Produced Rankers Under 500

Sweta Kumari

In this course , I will cover The concepts of Relational model with all topics covered in GATE Syllabus.

(Hindi) Relational Model GATE Syllabus with PYQs

In this Course, Sweta Kumari will Cover Previous Year Questions on SQL & Relational Model.

(Hindi) SQL and Relational Model Previous Year Questions - GATE(CS and IT)

This course will cover Joins topic in SQL. I will describe type of joins in this course with important examples.

(Hindi) SQL Joins With Tabular Examples - GATE (CS/IT)

Hi, I'm Jigyasa Agrawal,
 Currently pursuing B.Tech in computer engineering at GBPUAT pantnagar.

Jigyasa Agrawal

This is the fourth course in SQL. Here you will learn the sub queries in SQL.

(Hindi) Basics of SQL - Part 4

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.

(Hindi) Queries in SQL - Simple to Complex

This Course will cover Normalization in Databases with 25 Previous Year Questions plus some practice questions from beginning level to expert. This Course is beneficial for 
GATE (CS and IT)
 aspirants.

Lessons

5 lessons • 49m

Invalid Date

NaN

Displaying Data from Multiple Table Part 1

Invalid Date

NaN

Displaying Data from Multiple Table Part 2

Invalid Date

NaN

Aggregating Data using Group Functions Part 1

Invalid Date

NaN

Aggregating Data using Group Functions Part 2

Invalid Date

NaN

Aggregating Data using Group Functions Part 3