Call: +91 93924 08393, +91 89775 43744 | Email:
[email protected]
Hyderabad | Bangalore
Home
About
Courses
Placements
Contact
Enquire Now
Data Science – SQL Training
Module 1: Introduction to Databases
What is a database? Why SQL?
Types of databases: Relational vs NoSQL.
Installing MySQL / PostgreSQL / SQLite.
Basic database design concepts (tables, rows, columns, keys).
Module 2: SQL Basics
CREATE, DROP, ALTER (database & tables).
Data types in SQL (INT, VARCHAR, DATE, etc.).
INSERT, UPDATE, DELETE records.
SELECT queries (basic retrieval).
Hands-on: Create & populate a student database.
Module 3: Filtering & Sorting
WHERE clause (conditions, operators).
ORDER BY (ascending, descending).
LIMIT clause.
LIKE, IN, BETWEEN operators.
Hands-on: Query employee records by conditions.
Module 4: Joins & Relationships
Primary key, foreign key concepts.
INNER JOIN, LEFT JOIN, RIGHT JOIN, FULL JOIN.
Self join.
Hands-on: Combine student and marks tables.
Module 5: Aggregations & Grouping
COUNT, SUM, AVG, MIN, MAX.
GROUP BY and HAVING clauses.
Subqueries (nested queries).
Hands-on: Find department-wise average salaries.
Module 6: Indexing & Optimization
Why indexing? Types of indexes.
Query optimization basics.
Normalization vs denormalization.
Transactions (BEGIN, COMMIT, ROLLBACK).
Hands-on: Optimize large dataset queries.
Module 7: Mini Project
Exciting and impactful projects that drive innovation, growth, and real-world results.
Contact Us
Visit our centres or drop an enquiry — we'll get back to you within one business day.
Hyderabad:
#502 Nagasuri Plaza, Ameerpet
Bangalore:
Jayanagar 4th block
Chennai:
Perungudi
Send Enquiry