Scribd
Upload
14 views2 pages

MySQL Python Skills IT Recruiter

The document outlines essential MySQL and Python skills for IT recruiters. Key MySQL skills include DDL, DML, DCL, TCL, Joins, and Aggregation, while Python skills cover variables, conditions, loops, functions, data structures, exception handling, file handling, libraries, and OOP. Examples are provided for each skill to illustrate their application.

Uploaded by

aravindgb11
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
14 views2 pages

MySQL Python Skills IT Recruiter

The document outlines essential MySQL and Python skills for IT recruiters. Key MySQL skills include DDL, DML, DCL, TCL, Joins, and Aggregation, while Python skills cover variables, conditions, loops, functions, data structures, exception handling, file handling, libraries, and OOP. Examples are provided for each skill to illustrate their application.

Uploaded by

aravindgb11
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 2

Core MySQL and Python Skills for IT Recruiters

MySQL Skills

DDL: CREATE, ALTER, DROP - e.g., CREATE TABLE employees (id INT, name VARCHAR(50));

DML: SELECT, INSERT, UPDATE, DELETE - e.g., INSERT INTO employees VALUES (1, 'Arun');

DCL: GRANT, REVOKE - e.g., GRANT SELECT ON db_name TO 'user1';

TCL: COMMIT, ROLLBACK - e.g., BEGIN; UPDATE salary SET amount = 50000; COMMIT;

Joins: INNER JOIN, LEFT JOIN - e.g., SELECT * FROM emp INNER JOIN dept ON ...;

Aggregation: GROUP BY, HAVING - e.g., SELECT dept, COUNT(*) FROM employees GROUP BY dept;

Python Skills

Variables & Data Types - e.g., name = 'Aravind', age = 25

Conditions & Loops - e.g., if age > 18:, for i in range(5):

Functions - e.g., def greet(): print('Hello')

Data Structures - e.g., list = [1,2,3], dict = {'id':1, 'name':'Aravind'}

Exception Handling - e.g., try: ... except:

File Handling - e.g., open('file.txt', 'r')

Libraries - pandas, numpy - e.g., import pandas as pd

OOP - class Employee: pass

You might also like