📚 Welcome to the ultimate SQL tutorial in Tamil, your one-stop destination to learn SQL from scratch! Whether you're a beginner or looking to strengthen your database skills, this video is packed with step-by-step explanations and real-world query examples to help you master SQL concepts.
🌟 What You'll Learn:
✅ What is a Database and DBMS/RDBMS
✅ Installing Microsoft SQL Server
✅ SQL Commands, Constraints, Joins, and Views
✅ Advanced Topics: CTE, Subqueries, Stored procedure, Functions, Window Functions, Transactions, and Dynamic sql queries, temp table, Trigger, cursor and more
✅ Hands-on Query Examples with Clear Tamil Explanations
This 8+ hour video ensures you grasp the fundamentals and advanced SQL topics with ease. Perfect for aspiring developers and students!
🎥 Chapters for Easy Navigation:
00:00 - What is a database
00:02:28 - Learn DBMS and RDBMS
00:05:16 - What is sql
00:08:10 - How to install Microsoft sql server
00:14:37 - Different types of sql commands
00:17:58 - Basic usage of common sql commands
00:30:58 - Where clause usage
00:47:14 - Wildcards usage in sql
01:04:48 - Primary key constraint in sql
01:14:08 - Not null constraint in sql
01:18:09 - Unique constraint in sql
01:22:34 - Check constraint in sql
01:26:29 - Default constraint in sql
01:29:05 - Foreign key constraint in sql
01:36:55 - Group by/having/Aggregate functions/Order by/Distinct
01:48:24 - Joins in sql/inner/left/right outer join
02:00:46 - Self join/cross join
02:11:00 - Views in sql
02:30:31 - Subquery in sql
02:50:56 - Correlated subquery in sql
02:57:55 - Exists/Not exists
03:01:52 - Any/All
03:12:05 - CTE in sql
03:26:48 - Aggregate window functions
03:37:05 - Value window functions/first_value/last_value/lead/lag
03:46:33 - Ranking window functions/row_number/rank/dense_rank/ntile
03:58:42 - Temp table in sql
04:10:48 - Stored procedure in sql
04:23:39 - Index in sql
04:44:13 - Trigger in sql
05:02:49 - Functions in sql/scalar/table valued functions
05:27:44 - Cursor in sql
05:54:10 - Transaction in sql
06:10:46 - Merge in sql
06:23:13 - Schedule jobs in sql server
06:38:01 - Normalization in sql
06:56:13 - Set operations in sql
07:07:33 - Recursive CTE in sql
07:33:04 - Dynamic sql queries
08:12:48 - Data type conversion/cast/convert
📢 Don't forget to like, comment, and subscribe for more in-depth tutorials in Tamil! Share this with your friends who are passionate about learning SQL.
🔗 Related links and Playlists:
Import AdventureWorks database - [ Ссылка ]
Queries used in this videp can be accessed through this link - [ Ссылка ]
Individual topic videos playlist - [ Ссылка ]
leetcode sql problem solving videos playlist - [ Ссылка ]
