SQL | Vihara Tech

Structured Query Language, is the backbone of data management and analysis in almost every industry today. Learning SQL empowers you to query and manipulate databases efficiently, making you indispensable in data-driven decision-making. Mastering SQL opens doors to roles in data analysis, business intelligence, and software development, giving you the skills to unlock valuable insights from vast datasets. Start your SQL journey today and discover the power to transform raw data into actionable information

Course Content

Demo Video

SELECT statement

FROM clause

WHERE clause

JOINs INNER JOIN

LEFT JOIN

RIGHT JOIN

FULL JOIN

GROUP BY clause

HAVING clause

ORDER BY clause

Aggregate functions (SUM AVG COUNT MIN MAX)

Subqueries (Nested queries)

UNION and UNION ALL

Views (CREATE VIEW ALTER VIEW DROP VIEW)

Indexes (CREATE INDEX DROP INDEX)

Transactions BEGIN TRANSACTION

COMMIT

ROLLBACK

Constraints PRIMARY KEY

FOREIGN KEY

UNIQUE

CHECK

Data manipulation INSERT

UPDATE

DELETE

DMl operations

DQL Operations

DDl Operations

Alter

drop

sprename

truncate