SQL - Structured Query Language | Tamil

Udmey Course Link [ www.udemy.com/... ]
Datatype Documentation [ dev.mysql.com/... ]
Course Outline: Mastering Databases and SQL with MySQL
1.What is a Database?
- Definition and importance
- Types of databases
2.Understanding SQL and RDBMS
- Introduction to SQL
- What is a Relational Database Management System (RDBMS)?
- Key features of RDBMS
3.Installing MySQL
- Downloading and installing MySQL
- Setting up MySQL Workbench
4.Creating Databases and Tables
- Syntax and examples
- Primary keys and foreign keys
- Auto-increment fields
5.SQL Datatypes
- Overview of different datatypes
- Choosing the right datatype for your data
6.Basic SQL Commands
- SELECT, INSERT, UPDATE, DELETE
- Basic querying and filtering
- Using WHERE clause
7.SQL Constraints
- NOT NULL, UNIQUE, PRIMARY KEY, FOREIGN KEY, CHECK, DEFAULT
- Examples and use cases
8.Normalization
- What is normalization?
- Benefits of normalization
- Types of normalization (1NF, 2NF, 3NF,)
9.Types of Normalization
- Detailed explanation with examples
- Practical applications and best practices
10.DML (Data Manipulation Language) & DDL (Data Definition Language)
- Detailed commands and examples
- Differences between DML and DDL
11.JOINS and Types
- INNER JOIN, LEFT JOIN, RIGHT JOIN,CROSS JOIN
- Examples and use cases
12.Working with Views
- Creating and managing views
- Advantages of using views
13.Stored Procedures
- What are stored procedures?
- Creating and executing stored procedures
- Advantages of using stored procedures
14.Functions and Types
- Built-in functions
15.Group By
- Using GROUP BY clause
- Aggregate functions (COUNT, SUM, AVG, MAX, MIN)

[@divyacleasiya7836]

Hi Karthi, very useful video you are creating. Please try to upload video in Python and libraries of that . Thanks !

[@codewithkarthik]

Sure 🙂

[@rocksachin1779]

THANK YOU SO MUCH BRO AND EXPLAIN IS VERY GOOD 👍

[@codewithkarthik]

So nice of you

[@Balajiji4888]

Thanks Bro

[@codewithkarthik]

You’re welcome bro ☺️

[@alluaravinth4628]

Bro apdiye AWS course ❤

[@codewithkarthik]

Sure bro

[@ramyaravi7478]

Hello sir, for me I cant install not displayed all options.

[@vijayk8684]

Bro python and django course poduga ..

[@codewithkarthik]

Sure bro

[@darshans7]

useful bro, thanks for teaching. edhu basics to intermediate ah bro?

[@codewithkarthik]

Yes bro it’s basic to intermediate level but cover all fundamentals you required to get start with SQL

[@darshans7]

@@codewithkarthik super bro
Thanks ✨

[@gayathrir265]

Python django, tkinter course

[@codewithkarthik]

Sure 👍🏻

[@VishnusDesign]

Good Job Bro !

[@codewithkarthik]

Thank you very much!

[@vaishnashanmugam5385]

thank you so much anna

[@codewithkarthik]

You're most welcome

[@rees12334]

Hostinger host pannum pothu databse veraya pay panna ventumaa

[@codewithkarthik]

I never used hostinger bro

[@NaveenKumar-kr8lc]

Hi bro is your next video going to be AWS

[@codewithkarthik]

Not sure yet

[@rowandinesh8575]

Expected one.. Super bro❤

[@codewithkarthik]

Thank you 😀

[@ashokkumarp3249]

can you put video node js bro

[@codewithkarthik]

I’ll try bro 👍🏻

[@PLATO-en5kp]

thank you bro 🥰🥰

[@codewithkarthik]

Welcome 😊