I am a software engineer and having experience of 3 years in application software development.Love anchoring and mentoring.

Ruchita Jain

In this course, Ruchita Jain discusses how to query a database, to define the structure of data, to modify data in the database, and apply constraints using sql.

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

Learn SQL for Beginners

Web Development

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

First lesson for SQL consisting of introduction to SQL and use of select clause with different keywords to retrieve the data

Introduction to Sql and its Various Clauses

Use of comma, arithmetic expressions ,logical connectives and between as a comparison operators to retrieve data using Sql

Select, Where, and From in SQL

Retrieving data from two tables and rename operation

Retrieving Data from Two Tables and Rename Operation

String operations in SQL  and pattern matching

String Operations in SQL

Order by in SQL

Set operations in SQL (1) with examples on union and union all

Set Operations in SQL: Part 1

Intersect and intersect all with examples.

Set Operations in SQL: Part 2

Set Operations in SQL: Part 3

Aggregate functions in SQL with examples.

Aggregate functions in SQL

Group by and having clause with examples.

Group By and Having Clause in SQL

Null Values in SQL

Nested Subqueries

Modification of database by using delete ,insert and update commands

Modification of database

Joins in SQL(inner join with natural and on)

Joins in SQL (1)

Left outer join, right outer join and full outer join with join conditions and examples

Joins in SQL(2)

Create, drop database and create, drop, alter a table and introduction of constraints in SQL

Create Database in SQL

Constraints in SQL: Part 1

Constraints in SQL with examples and referential triggered actions

Constraints in SQL: Part 2

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

18 lessons • 2h 32m

Invalid Date

NaN

Introduction to Sql and its Various Clauses

Invalid Date

NaN

Select, Where, and From in SQL

Invalid Date

NaN

Retrieving Data from Two Tables and Rename Operation

Invalid Date

NaN

String Operations in SQL

Invalid Date

NaN

Order by in SQL

Invalid Date

NaN

Set Operations in SQL: Part 1

Invalid Date

NaN

Set Operations in SQL: Part 2

Invalid Date

NaN

Set Operations in SQL: Part 3

Invalid Date

NaN

Aggregate functions in SQL

Invalid Date

NaN

Group By and Having Clause in SQL

+ See all lessons