
1st class free
About KANKATALA
Kankatala N S S Sukesh Kumar provides online tutoring support in SQL and Database Management Systems. The teaching approach focuses on helping learners understand database concepts through practical examples, interactive sessions, and hands-on query writing practice. Lessons are designed for beginners as well as students looking to strengthen their SQL and DBMS knowledge. The tutor emphasizes concept clarity, structured learning, and problem-solving to help students build confidence in working with databases. Regular practice and guided learning support the development of strong database management and querying skills. Sessions are conducted in Telugu, ensuring clear communication and an effective learning experience.
Courses by KANKATALA
What You Will Learn
Module 1: Introduction to Databases & SQL
What is a Database?
DBMS vs RDBMS
Introduction to SQL
Database Terminology (Tables, Rows, Columns, Keys)
Installing and Setting Up SQL Environment
Module 2: SQL Basics
Creating Databases
Creating Tables
Data Types
INSERT Statement
SELECT Statement
WHERE Clause
ORDER BY Clause
DISTINCT Keyword
Module 3: Filtering and Sorting Data
Comparison Operators
Logical Operators (AND, OR, NOT)
BETWEEN
IN
LIKE
LIMIT / TOP
Module 4: SQL Functions
String Functions
Numeric Functions
Date Functions
Aggregate Functions
COUNT()
SUM()
AVG()
MIN()
MAX()
Module 5: Grouping Data
GROUP BY
HAVING Clause
Combining GROUP BY and Aggregate Functions
Module 6: Joins
Primary Key & Foreign Key
INNER JOIN
LEFT JOIN
RIGHT JOIN
FULL JOIN
SELF JOIN
Module 7: Subqueries
Single Row Subqueries
Multiple Row Subqueries
Nested Subqueries
Correlated Subqueries
Module 8: Data Manipulation Language (DML)
INSERT
UPDATE
DELETE
TRUNCATE
Module 9: Constraints
NOT NULL
UNIQUE
PRIMARY KEY
FOREIGN KEY
CHECK
DEFAULT
Module 10: Advanced SQL
UNION & UNION ALL
CASE Statement
EXISTS & NOT EXISTS
Common Table Expressions (CTEs)
Window Functions (ROW_NUMBER, RANK, DENSE_RANK)
What students say
Similar tutors with Skills
Ready to start learning Dbms Sql? Book a free demo with KANKATALA.

0.0(0 reviews)