UG KLUian | ECE student | aspirant to teach | love programming

Srija Kalyanam

In this course you will learn Structured Query Language statements, aggregate functions, group by function, nested queries and joins with examples. It is the most important part of DBMS and after this course anyone can attend an interview based on SQL confidently.

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 - Storing, Querying and Managing Data

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

In this lesson I illustrated about key constraints like primary key foreign key with example tables in DBMS and also about data types which are very important to create tables

Data Types and Constraints in Structured Query Language

This lesson deals with the Data definition language, data retrieval language with syntax and examples in SQL and about comparison operators.

Data Definition Language, Data Retrieval Language and Comparison Operators in SQL

In this lesson, Srija has explained Data Manipulation Language, Transaction Control Language, and Logical Operators in SQL.

Data Manipulation Language, Transaction Control Language and Logical Operators in SQL

Number functions and character function with syntax and suitable examples in Sql are explained here.

Character Functions and Number Functions in SQL

Types of inner joins are vividly explained here with syntax and examples by taking tables in SQL.

Joining Relations, Inner Joins in SQL

All types of outer joins with examples and syntax are explained clearly by taking tables.

Types of Outer Joins in SQL

This lesson gives an explanation about nested queries, aggregate functions like sum average minimum and maximum in database management system.

Aggregate Functions and Nested Queries in SQL

This lesson covers the Nested queries, group by functions examples with syntax and few examples (taking 3 tables) on set operators(types of set operators explained in first lesson) in SQL.

Group by Function, Examples on Nested Queries and Group by Function

This lesson brings the examples on SQL statements using nested queries concept.

Examples on Group by Function and Nested Queries

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 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


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

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

9 lessons • 1h 23m

Invalid Date

NaN

Data Types and Constraints in Structured Query Language

Invalid Date

NaN

Data Definition Language, Data Retrieval Language and Comparison Operators in SQL

Invalid Date

NaN

Data Manipulation Language, Transaction Control Language and Logical Operators in SQL

Invalid Date

NaN

Character Functions and Number Functions in SQL

Invalid Date

NaN

Joining Relations, Inner Joins in SQL

Invalid Date

NaN

Types of Outer Joins in SQL

Invalid Date

NaN

Aggregate Functions and Nested Queries in SQL

Invalid Date

NaN

Group by Function, Examples on Nested Queries and Group by Function

Invalid Date

NaN

Examples on Group by Function and Nested Queries