I have recently completed my graduation in Electronics and Communication. I love to teach computer programming.

Kinjal Aggrawal

Structured Query Language is domain -specific language used in programming. In this course, you will get to learn SQL which is a niche programming language used for writing code inside the Oracle database.
We are going to learn about basics of database,its types and their advantages and also going to learn commands of SQL like CREATE,INSERT,SELECT,DELETE,DROP,  
ALTER and many more. This course will help the learners in creating functions in SQL and creating VIEWS as well.

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

Querying and Managing Data with SQL

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 we are going to learn what is database, how it is organized in tabular manner and will also learn what are the elements of database with example of student.

Introduction to Database

In this lesson we are going to learn when to use databases, discuss example of library database and types of databases which are Hierarchical Database Management System, Network Database Management System and Relational Database Management System.

Types of Database

In this lesson we have discussed advantages of database system and learnt about entity relationship modeling and its three basic elements such as Entities, Attribute and relationships and their respective properties.

Entity Relationship Modelling

In this lesson, we are going to discuss normalization and its various types such as first normal form and second normal form. And you will also learn the importance of primary key and composite key.

Normalization and Keys in SQL

The concept of foreign key and third normal form is discussed in this lecture. The concept of referential integrity and transitive functional dependencies are also explained to understand third normal form.

Normalization - Third Normal Form

In this lesson, we are going to learn what is SQL and what are the different data types available in SQL and their ranges.

Introduction to SQL and Data Types

In this lesson we are going to learn basic operations of databases such as create,select,insert,update and delete.

Basic Operations on Database

In this lesson we learnt select clause, where clause, drop and alter commands and order by clause.

DDL and DML Commands

In this lesson you will learn AND, OR and NOT operators. It also talks about IS NULL, IS NOT NULL, LIMIT commands as well.

AND,OR and NOT Operations

This lesson talks about between and not between operator.

SQL BETWEEN Operator

SQL Wildcards

GROUP BY

This lesson talks about functions such as MAX, MIN, COUNT, SUM, AVG.

Mathematical Functions

The lesson talks about the HAVING clause and SQL aliases.

HAVING and SQL Aliases

This lesson talks about EXISTS, ANY, ALL operators.

EXISTS, ANY and ALL clause

The lesson talks about DCL commands such as GRANT, REVOKE and also talks about UNION and UNION ALL operator.

DCL and UNION operation

Lesson talks about IN and NOT IN operator.

IN operator

Lesson talks about Joins and its one of its types like Left Join.

SQL JOINS and Left Join

This lesson talks about right join and full outer join.

Right Join and Full Outer Join

Lesson talks about Self Join and Inner Join.

Inner Join and Self Join

Lesson talks about Select Into and Insert Into commands.

Select Into and Insert Into

Lesson talks about create, drop and alter database.

Create, Drop and Alter Database

Lesson talks about Primary key and unique key constraints.

Primary Key and Unique Constraint

This lesson talks about foreign key in SQL.

Foreign Key

Lesson talks about check and default constraints.

Check and Default Constraint

Lesson talks about create, drop indexes in SQL and auto increment field.

Create, Drop Index and Auto Increment

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

26 lessons • 2h 42m

Invalid Date

NaN

Introduction to Database

Invalid Date

NaN

Types of Database

Invalid Date

NaN

Entity Relationship Modelling

Invalid Date

NaN

Normalization and Keys in SQL

Invalid Date

NaN

Normalization - Third Normal Form

Invalid Date

NaN

Introduction to SQL and Data Types

Invalid Date

NaN

Basic Operations on Database

Invalid Date

NaN

DDL and DML Commands

Invalid Date

NaN

AND,OR and NOT Operations

Invalid Date

NaN

SQL BETWEEN Operator

+ See all lessons