Learning Tracks

Quick Links

Authentication

Follow us

SQL

Description

This series of tutorials will help you understand the basics of SQL on MySQL environment.

What will you learn

Students will have a good working knowledge on SQL and can use it for their Educational as well as Business projects and assignments.

Requirements

No prior knowledge on SQL or any other software is needed.

Section

11 Sections

Introduction to SQL

Introduction to Database 4 mins
Windows of SQL and Features 2 mins
Concept of Records/Attributes 2 mins
Properties of RDBMS 2 mins
How to create database/table 1 mins
Types of Datatypes 2 mins
Need and Types of Operators in SQL 1 mins

Creation and Description of Tables

What are constraints in SQL 3 mins
Creating a Table 7 mins
Details of a Table 3 mins
Concept of Primary Key and Foreign Key 3 mins
Alter Table 2 mins

Entering observations in Tables

How to enter values in Table Part 1 6 mins
How to enter values in Table Part 2 7 mins
Updating rows in a Table 7 mins
Removing duplicate rows 6 mins
Inserting values in Rows (Advanced) 3 mins

Formatting Tables

Inserting and Deleting observations from existing tables 4 mins
Addition of new columns and description of columns 1 mins
GROUP BY Clause in SQL 4 mins
GROUP BY using 2 variables 2 mins
ORDER BY Clause in SQL 1 mins
ORDER BY using Descending Order 2 mins
Pattern Matching using LIKE operator 4 mins
Pattern Matching using NOT LIKE operator 1 mins
Difference between DROP and TRUNCATE Table 2 mins

Joins in SQL

Need of alias in Joins 1 mins
Creating alias for tables 1 mins
Creating alias for columns 1 mins
Joining columns using concat_ws() and concat() functions 2 mins
Kinds of Joins in SQL 1 mins
Creating Tables to understand concept of Joins 3 mins
Entering observations in Tables 5 mins
INNER JOIN and LEFT JOIN 6 mins
RIGHT JOIN 1 mins
CROSS JOIN 1 mins

Subqueries in SQL

Concept of SUBQUERY 1 mins
Executing SUBQUERY 1 mins
Concept of INNER Query and OUTER Query 1 mins
Mapping in Subquery 2 mins
Union Operator 1 mins
Application of Union Operator 1 mins
Difference between Union and Join 1 mins
Insert and Replace Statements in SQL 1 mins
Conditions for using REPLACE statements (part 1) 1 mins
Conditions for using REPLACE statements (part 2) 1 mins

Types of Functions in SQL

Need for functions 1 mins
Sum functions 1 mins
Average functions 1 mins
Minimum and maximum functions in SQL 1 mins
Sum function inside group function 2 mins
Concatenation function 3 mins
Length and Trim Function 3 mins
Substring function 3 mins
Having Clause in SQL 3 mins
Left and Right Functions in SQL 3 mins

Functions applied on Dates

Date Functions in SQL 1 mins
now() function 2 mins
Entering observations regarding date variables 4 mins
day() function 4 mins
datediff() function 4 mins
Concept of view in SQL 1 mins
Creating view in SQL 2 mins
Altering views in SQL 6 mins

Stored Procedures

Stored Procedure 3 mins
Application of Stored Procedure 3 mins
Understanding arguments in procedure statement 2 mins
Calling a procedure 2 mins
IN and OUT parameter difference 4 mins

Trigger in SQL

Understanding the concept of Trigger 3 mins
Creating a Trigger 4 mins
Application of Trigger Statement 3 mins

Study Material

Section 1 10 mins
Section 2 10 mins
Section 3 10 mins
Section 4 10 mins
Section 5 10 mins
Section 6 10 mins
Section 7 10 mins
Section 8 10 mins
Section 9 10 mins
Section 10 10 mins

Reviews

View course preview

₹5000.0

This course is available in

What's included

Mobile support
Lesson archive
Course certificate