SQL Malayalam Tutorial with MySQL | Yes Tech Media

Introduction

This tutorial provides a comprehensive guide to SQL using MySQL, tailored for Malayalam speakers. It covers essential concepts from database creation to advanced SQL functions, making it suitable for beginners and those looking to enhance their database management skills.

Step 1: Understand Basic Concepts

• Database: A structured set of data held in a computer.
• Relational Database: A type of database that stores data in tables, allowing relationships between them.
• Primary Key: A unique identifier for a table record.
• Foreign Key: A field in one table that uniquely identifies a row of another table.

Step 2: Install MySQL

1. Download MySQL from the official website.
2. Follow the installation prompts based on your operating system.
3. Configure the server settings, including root password and security options.

Step 3: Create a Database

1. Open the MySQL command line or your preferred MySQL client.
2. Use the following command to create a database:

   CREATE DATABASE your_database_name;
   

Step 4: Delete a Database

• To remove a database, use:

  DROP DATABASE your_database_name;
  

Step 5: Create a Table

1. Define your table structure and use:

   CREATE TABLE your_table_name (
       id INT AUTO_INCREMENT PRIMARY KEY,
       column_name1 DATA_TYPE,
       column_name2 DATA_TYPE
   );
   

Step 6: Delete a Table

• To delete a specific table, run:

  DROP TABLE your_table_name;
  

Step 7: Insert Records

• To add data to your table, use:

  INSERT INTO your_table_name (column_name1, column_name2) VALUES (value1, value2);
  

Step 8: Update Records

• To modify existing records:

  UPDATE your_table_name SET column_name = new_value WHERE condition;
  

Step 9: Delete Records

• To remove records from a table:

  DELETE FROM your_table_name WHERE condition;
  

Step 10: Select Data

• To retrieve data, use:

  SELECT * FROM your_table_name;
  

Step 11: Use Where Clause

• To filter results:

  SELECT * FROM your_table_name WHERE condition;
  

Step 12: Distinct Clause

• To eliminate duplicate entries:

  SELECT DISTINCT column_name FROM your_table_name;
  

Step 13: Order By Clause

• To sort results:

  SELECT * FROM your_table_name ORDER BY column_name ASC|DESC;
  

Step 14: Modify Columns

1. To add a new column:

   ALTER TABLE your_table_name ADD column_name DATA_TYPE;
   

2. To modify an existing column:

   ALTER TABLE your_table_name MODIFY column_name DATA_TYPE;
   

Step 15: Rename or Delete Columns

• Rename a column:

  ALTER TABLE your_table_name CHANGE old_column_name new_column_name DATA_TYPE;
  

• Delete a column:

  ALTER TABLE your_table_name DROP COLUMN column_name;
  

Step 16: Truncate Table

• To quickly delete all records without removing the table structure:

  TRUNCATE TABLE your_table_name;
  

Step 17: Use Functions

• Arithmetic Operators: Use for mathematical calculations.
• String Functions: Manipulate string data.
• Date Functions: Handle date and time values.

Step 18: Working with Joins

• Inner Join: Retrieve records with matching values in both tables.

  SELECT * FROM table1 INNER JOIN table2 ON table1.column = table2.column;
  

• Left Join: Retrieve all records from the left table and matched records from the right.
• Right Join: Retrieve all records from the right table and matched records from the left.
• Full Join: Retrieve records when there is a match in either left or right table.

Conclusion

This tutorial has covered the fundamentals of SQL with MySQL, from database creation to executing complex queries. To further enhance your skills, practice these commands and explore advanced SQL functions. Consider diving into additional resources or courses for more in-depth learning on specific topics.