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

Jigyasa Agrawal

In this course, Jigyasa Agrawal has discussed the sql for advance level.

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

Advanced Level SQL - Part 1

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

We are going to study how to alter any table after its creation

Alter Table ( in Hindi)

How to modify , delete and rename any column or table after its creation

Alter Table - Modify and Dropping a Column ( in Hindi)

Do you know it is possible to create a user defined column at runtime also .... Lets see how ?

Putting Text in a Query Output in SQL ( in Hindi)

Lets see what is a dual table and what operations it can perform

Dual Table ( in Hindi)

We can create a view which is a virtual table and later use it in our query ... Lets see how ..

SQL Views ( in Hindi)

Sql Indexes (in Hindi)

Lets see how we can apply check constraints to restrict values in a column

Check Constraints (in Hindi)

Cross Join (in Hindi)

Last Clause (in Hindi)

We are going to see how to produce numbers randomly

Random and Order by Random (in Hindi)

We are going to study how to apply order in limit

Order by Limit (in Hindi)

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)

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

11 lessons • 56m

Invalid Date

NaN

Alter Table ( in Hindi)

Invalid Date

NaN

Alter Table - Modify and Dropping a Column ( in Hindi)

Invalid Date

NaN

Putting Text in a Query Output in SQL ( in Hindi)

Invalid Date

NaN

Dual Table ( in Hindi)

Invalid Date

NaN

SQL Views ( in Hindi)

Invalid Date

NaN

Sql Indexes (in Hindi)

Invalid Date

NaN

Check Constraints (in Hindi)

Invalid Date

NaN

Cross Join (in Hindi)

Invalid Date

NaN

Last Clause (in Hindi)

Invalid Date

NaN

Random and Order by Random (in Hindi)

+ See all lessons