The Data Monk is hiring 8 to 10 candidates for 1 month (remote) internship.
Qualification:-
1. Should be in the 3rd or 4th year of graduation
2. Should have good knowledge of SQL and basics of Python
3. Should have a good understanding of at least one ML algorithm/concept out of Regression, NLP, Statistics, Forecasting, Classification, and Solving case studies
4. Should be able to contribute for 4-6 hours per day (5 days)
5. Should have decent written and spoken English
6. We prefer candidates from non-IITs/NITs 😛
In the comment box below, please provide the following information
1. Name
2. College
3. Branch
4. Year of completion of the course
5. Available from
6. Rating in SQL (0-10)
7. Describe any concept in SQL in the most basic terms (Optional, but will help us in reviewing your candidature)
8. Algorithm of your choice
9. Email id
We will contact the candidate via email and will share the relevant information.
P.S. – This is a fixed stipend internship where the stipend amount depends on the domain for which you are selected !!
You can also put your queries in the comment box
The Data Monk Interview Books – Don’t Miss
Now we are also available on our website where you can directly download the PDF of the topic you are interested in. At Amazon, each book costs ~299, on our website we have put it at a 60-80% discount. There are ~4000 solved interview questions prepared for you.
10 e-book bundle with 1400 interview questions spread across SQL, Python, Statistics, Case Studies, and Machine Learning Algorithms – Ideal for 0-3 years experienced candidates
23 E-book with ~2000 interview questions spread across AWS, SQL, Python, 10+ ML algorithms, MS Excel, and Case Studies – Complete Package for someone between 0 to 8 years of experience (The above 10 e-book bundle has a completely different set of e-books)
12 E-books for 12 Machine Learning algorithms with 1000+ interview questions – For those candidates who want to include any Machine Learning Algorithm in their resume and to learn/revise the important concepts. These 12 e-books are a part of the 23 e-book package
Individual 50+ e-books on separate topics
Important Resources to crack interviews (Mostly Free)
There are a few things which might be very useful for your preparation
The Data Monk Youtube channel – Here you will get only those videos that are asked in interviews for Data Analysts, Data Scientists, Machine Learning Engineers, Business Intelligence Engineers, Analytics Manager, etc.
Go through the watchlist which makes you uncomfortable:-
All the list of 200 videos
Complete Python Playlist for Data Science
Company-wise Data Science Interview Questions – Must Watch
All important Machine Learning Algorithm with code in Python
Complete Python Numpy Playlist
Complete Python Pandas Playlist
SQL Complete Playlist
Thanks,
The Data Monk
1. Name : Aishwarya Pundlik Lagashetti
2. College : Nagesh Karajagi Orchid College of Engineering & Technology, Solapur
3. Branch : CSE
4. Year of completion of course : 4th
5. Available from : 25th September 2022
6. Rating in SQL : 7/10
7. Describe any concept in SQL : SQL joins
The SQL Joins is used to combine records from two or more tables in a database. A JOIN is a means for combining fields from two tables by using values common to each. It helps to catch data from two or more database tables. There are various types of Joins such as Cross Joins, Inner Joins, Outer Joins, Left/Right Joins, etc.
8. Algorithm of your choice :
9. Email id: aish,lagashetti@gmail.com
1. Name – Mohd Saif Ali
2. College- Dr. Akhilesh Das Gupta institute of technology and management
3. Branch – Electronics and communication
4. Year of completion of the course- 2023
5. Available from – immediately
6. Rating in SQL (0-10) – 6
8. Algorithm of your choice – Regression, classification
9. Email id – msaifali2000@gmail.com
Hello,
I am Nishtha from Karnal Haryana. Currently , I am pursuing Bachelor of Technology in computer science and engineering from Chandigarh Group Of Colleges , Landran. I’ll be completing my graduation by the year 2024. I am available to work .
My SQL rating would be 7 out of 10 as I’ve learnt SQL in last 2 months only.
SQL JOIN ) join is a clause used to combine rows and column of two or more tables. It can be related to the cartesian product in maths.
I have basic knowledge of ML, yet I am always open to learning new things and in order to meet the requirements I’ll learn whatever I am asked to .
I can be contacted at nishthaofficial1@gmail.com
Thankyou .
1. Name – Devangi Parekh
2. College – Government Engineering college , Gandhinagar
3. Branch – Computer Engineering
4. Year of completion of the course – 2019 (Master of Engineering)
6. Rating in SQL : 5-6
7. concept in SQL- Sql injection: It is a technique that attackers use to gain unauthorized access to database by adding some malicious code to a database query.
8. Algorithm of your choice : BFS & DFS Algorithm – the algo. is used to find shortest path between two points.
9. Email id : devangi95parekh@gmail.com
1.Name : Mayuresh More
2.College : Bharat College of Engineering-University of Mumbai
3.Branch : Computer Engineering
4.Year of completion : June 2023
5.Available from : Immediately
7.Rating SQL : 6 out of 10 ( basic knowledge like operations on table)
Describe any SQL concept : Well SQL has 5 basic commands DATA DEFINITION LANGUAGE ( DDL ) DATA MANIPULATIVE LANGUAGE ( DML ) DATA QUERY LANGUAGE ( DQL) DATA CONTROL LANGUAGE ( DCL )
TRANSCATION CONTROL LANGUAGE ( TCL)
DQL is used to data from table
TCL is used for transaction purpose like rollback commit and save
DDL is used to modify the structure of the table using CREATE ALTER DROP TRUNCATE operations
DML is used to manipulate the data like INSERT UPDATE OR DELETE the data present in the table
DCL is used to give define control like GRANT or REVOKE
8. Algorithms :
Linear Regression Model – Have create a project using Linear Regression Model
https://github.com/mayureshTech404/Linear_Reegression_Project
Logistic Regression
9. Email id : mayureshmore54@gmail.com
1.Name : Mayuresh More
2.College : Bharat College of Engineering, Badlapur- University of Mumbai
3.Branch : Computer Engineering
4.Year of completion : June 2023
5.Available from : Immediately
7.Rating SQL : 6 out of 10 ( basic knowledge like operations on table)
Describe any SQL concept : Well SQL has 5 basic commands DATA DEFINITION LANGUAGE ( DDL ) DATA MANIPULATIVE LANGUAGE ( DML ) DATA QUERY LANGUAGE ( DQL) DATA CONTROL LANGUAGE ( DCL )
TRANSCATION CONTROL LANGUAGE ( TCL)
DQL is used to data from table
TCL is used for transaction purpose like rollback commit and save
DDL is used to modify the structure of the table using CREATE ALTER DROP TRUNCATE operations
DML is used to manipulate the data like INSERT UPDATE OR DELETE the data present in the table
DCL is used to give define control like GRANT or REVOKE
8. Algorithms :
Linear Regression Model – Have create a project using Linear Regression Model
https://github.com/mayureshTech404/Linear_Reegression_Project
Logistic Regression
9. Email id : mayureshmore54@gmail.com
1. Name:- Divyanshu Gour
2. College:- Shri Vaishnav Vidyapeeth Institute of Information Technology, Indore
3. Branch:- Computer Science
4. Year of completion of the course:- 2023
5. Available from:-December 2022
6. Rating in SQL (0-10):- 7
7. Describe any concept in SQL in the most basic terms (Optional, but will help us in reviewing your candidature):- Whenever we want to retrieve data from 2 different tables we use SQL joins. There are 4 main types of joins inner join, left outer join, right outer join, and full outer join. We take the primary key of one table and the foreign key of another table and compare them and get the required column data.
8. Algorithm of your choice:- Regression Algorithms
9. Email id:- divyanshugour197@gmail.com
1. Name:- Divyanshu Gour
2. College:- Shri Vaishnav Vidyapeeth Institute of Information Technology, Indore
3. Branch:- Computer Science
4. Year of completion of the course:- 2023
5. Available from:-December 2022
6. Rating in SQL (0-10):- 7
7. Describe any concept in SQL in the most basic terms (Optional, but will help us in reviewing your candidature):- Whenever we want to retrieve data from 2 different tables we use SQL joins. There are 4 main types of joins inner join, left outer join, right outer join, and full outer join. We take the primary key of one table and the foreign key of another table and compare them and get the required column data.
8. Algorithm of your choice:- Regression Algorithms
9. Email id:- divyanshugour197@gmail.com
1. Name : DINESH PANDIAN
2. College : SRI RAMAKRISHNA ENGINEERING COLLEGE
3. Branch : ELECTRONICS AND COMMUNICATION
4. Year of completion of the course : 2023
5. Available from : 01OCT2022
6. Rating in SQL : 5
7. Describe any concept in SQL in the most basic terms : right join and left joins are theoreticaly different but practically same
8. Algorithm of your choice : DESCISION TREE
9. Email id : dineshpandain700@gmail.com
Name: Devayani K V
College: IIT Ropar
Branch: Mechanical
Year of completion of the course: expected year of graduation is 2024
Available from: October 1st
Rating in SQL: 7
Describe a concept in SQL: Inner join: it is used between two tables and returns the non-null rows having the same keys on which they are connected.
Algorithm of choice: Regression
Email ID: kvdevayani14@gmail.com
Name: Devayani K V
College: IIT Ropar
Branch: Mechanical
Year of completion of the course: expected year of graduation is 2024
Available from: October 1st
Rating in SQL: 7
Describe a concept in SQL: Inner join: it is used between two tables and returns the non-null rows having the same keys on which they are connected.
Algorithm of choice: Regression
Email ID: kvdevayani14@gmail.com .
1. Name – Samvigya Trivedi
2. College – BML Munjal University
3. Branch – MBA: Business Analytics
4. Year of completion of the course – March 2023
5. Available from – Immediately
6. Rating in SQL (0-10) – 7
7. Describe any concept in SQL in the most basic terms – WHERE Clause cannot contain aggregate function whereas HAVING Clause can contain aggregate function. WHERE Clause can be used without GROUP BY Clause whereas HAVING Clause cannot be used without GROUP BY Clause
8. Algorithm of your choice – Linear and Logistic Regression
9. Email id – samvigya.trivedi.21mb@bmu.edu.in
I am looking for an internship in the domain of analytics. Coming with exceptional skills in sql, python and few machine learning algorithms. Completed training in data science where i learnt the required skills.
I am looking for an internship in the domain of analytics. Coming with exceptional skills in sql, python and few machine learning algorithms. Completed training in data science where i learnt the required skills. Pursuing MBA Final year from Central University of Hyderabad will be available during 5pm to 10pm from Monday to Friday.
I am Devanshi. I have completed B.tech(computer science) from Shri Ramswaroop memorial university in 2022. I have good knowledge about SQL. I also practice SQL on HackerRank. I would rate myself in SQL on the scale of 1-10 to be 7. I also have knowledge about joins in SQL , we use joins when we have more than 1 table and they must have at least 1 attribute in common so that we can fetch tha data using that common attribute which we also refer as foreign key.
I can join immediately.
I also have knowledge of Machine learning and know one of the algorithms that is linear regression.
U can contact via mail. My mail id is- divanshinigam123@gmail.com
1. Name – Kalpesh Nerkar
2. College – D.Y.Patil Clg of Engineering, Akurdi, Pune
3. Branch – Production (S/W)
4. Year of completion of the course – 2020
5. Available from – immediate
6. Rating in SQL (0-10) – 7.5
7. Describe any concept in SQL in the most basic terms (Optional, but will help us in reviewing your candidature)
– I good knowledge about All DDL, DML command as well as CTE, Subquery, Joins, View, Store Procedure, Indexing.
– I just explain some concept related to view, So we create view by using command i.e
Create view (viewname)
As
(Stored the query that you want to store)
– So View is database object but its not contain any type of data, Its Show that data which already store in main table.
– we use view for hiding complex structure of our query, row level & column level security
– we also alter & drop view just by using alter & drop command just like we use in table
– sp_refreshview – when you add column in your main table then its not directly affected in your view statment for that you need to 1st execute this sp_ refreshview command & then you are able to See this newly added column
– View with schema binding – So its mean your scemas are binded and user are not able to manipulate columns in your main table.
– Update view – we avoid to updating view because its shows some random result. But if you want to update your view then query in view need to satisfied some conditiones like its not contain where by, group by & distinct clauses , its not contain set operators & subquery means we able to update only if query contain single table. So this is short introduction about view.
9. Email id – kbnerkar11@gmail.com
1. Name: Tanmay Srivastava
2. College: I.T.S Engineering College, Greater Noida
3. Branch: Electronics and Communication (ECE)
4. Year of completion of the course: 2022
5. Available from: 21 Sept, 2022
6. Rating in SQL (0-10): 7
7. Describe any concept in SQL in the most basic terms (Optional, but will help us in reviewing your candidature):
Topic: JOINS
A JOIN clause is used to join rows from two or more tables based on a common column between them.
There are four types of Joins:
Inner join: It returns all the rows from different tables that satisfy the join requirement.
Left Join: It returns all rows from the left table but only the matching rows from the right table when the join is satisfied.
Right Join: It returns all rows from the right table but only the matching rows from the left table when the join is satisfied.
Outer Join: It returns all the rows when there is a match in any of the tables. As a result, it returns all rows from the left-hand side table as well as all rows from the right-hand side table.
8. Algorithm of your choice: Classification: KNN, SVM & Regression: Linear
9. Email id: tanmayraj777@gmail.com
1. Name- Sagar Narayan Sanap
2. College- VJTI Mumbai
3. Branch-Civil (Construction Management)
4. Year of completion of the course- 2019
5. Available from-Immediatly
6. Rating in SQL (0-10)- 08
7. Describe any concept in SQL in the most basic terms (Optional, but will help us in reviewing your candidature)-
SQL is structured Query Language. On following functions I can work in SQL.
Syntax to get data.
Use database_name;
Select* from table_name;
WHERE- use for filtering data of given condition.
DISTINCT- To get unique records.
GROUP BY- Use to group the data.
Lpad()- Use for padding on left side
Rpad()-Use for padding on right side
Aggregation functions- count(*), Max(), Min(), sum(), avg() etc.
Able to apply subqueries using where clause.
Able to use having clause with aggregation functions-
Joins- Joins are use to join two or more than two table on common key.
There are five types of join.
Inner join
Left join
Right join
Full outer join
Cross join
8. Algorithm of your choice-
select * from table_name where city in(‘value1’, ‘value2’);
Select * , count(*) as count from table_name;
9. Email id: sagarsanap920@gmail.com
1. Name- Sagar Narayan Sanap.
2. College- VJTI Mumbai
3. Branch-Civil (Construction Management)
4. Year of completion of the course- 2019
5. Available from-Immediatly
6. Rating in SQL (0-10)- 08
7. Describe any concept in SQL in the most basic terms (Optional, but will help us in reviewing your candidature)-
SQL is structured Query Language. On following functions I can work in SQL.
Syntax to get data.
Use database_name;
Select* from table_name;
WHERE- use for filtering data of given condition.
DISTINCT- To get unique records.
GROUP BY- Use to group the data.
Lpad()- Use for padding on left side
Rpad()-Use for padding on right side
Aggregation functions- count(*), Max(), Min(), sum(), avg() etc.
Able to apply subqueries using where clause.
Able to use having clause with aggregation functions-
Joins- Joins are use to join two or more than two table on common key.
There are five types of join.
Inner join
Left join
Right join
Full outer join
Cross join
8. Algorithm of your choice-
select * from table_name where city in(‘value1’, ‘value2’);
Select * , count(*) as count from table_name;
9. Email id: sagarsanap920@gmail.com
Devansh Chand
Parul institute of technology
Computer science engineering
2024
Can start immediately
Rating in SQL: 5
Algorithm: Linear Regression
Email id: devanshc80@gmail.com
1. Name : Vineet Gehlot
2. College : Jodhpur Institute of Engineering and Technology
3. Branch : Electrical Engineering
4. Year of completion of the course : 2023
5. Available from : 6pm – 10pm
6. Rating in SQL (0-10) : 3
7. Describe any concept in SQL in the most basic terms (Optional, but will help us in reviewing your candidature)
1. Database : A relational database is a collection of data that contains the pre-defined relationship between them in the form of tables with rows and columns. Some of the key terms which are used thoroughly in the relational database are tables, records, primary keys, attributes, and foreign keys.
2. Commands : Data Definition Language (DDL): The DDL commands such as create, drop, alter and truncate is used for creating, dropping, altering and modifying the structure of database objects.
8. Algorithm of your choice:
SQL TO COMPUTE THE SHORTEST DISTANCE FROM ARRAY OF POINTS
We know the math formula to compute the distance between two points is: sqrt((a.x – b.x)^2 + (a.y – b.y)^2.
Given an array of points, we want to brute force every point except itself to compute the minimal distance. We can connect the table to itself, however need to exclude the computation of the same point to itself, which is zero.
select
round(min(sqrt(pow(a.x – b.x,2) + pow(a.y – b.y,2))), 2) as ‘shortest’
from
point_2d a, point_2d b
where
a.x != b.x or a.y != b.y
9. Email id : vineetgehlot.r@gmail.com
1. Name: Tanmay Srivastava
2. College: I.T.S Engineering College, Greater Noida
3. Branch: Electronics and Communication (ECE)
4. Year of completion of the course: 2022
5. Available from: 21 Sept 2022
6. Rating in SQL (0-10): 7
7. Describe any concept in SQL in the most basic terms (Optional, but will help us in reviewing your candidature):
Topic: JOINS
A JOIN clause is used to join rows from two or more tables based on a common column.
There are our types of Joins:
1) Inner join: It returns all the rows from existing tables that satisfy the join criteria.
2) Left Join: It returns all rows from the left table but only the matching rows from the right table when the join condition is satisfied.
3) Right Join: It returns all rows from the right table but only the matching rows from the left table when the join condition is satisfied.
4) Outer Join: It returns all the rows when there is a match in any of the tables. As a result, it returns all the rows from the left-hand side table and all the rows from the right-hand side table.
The above concept can be easily explained with the help of Venn Diagrams and their corresponding equations.
8. Algorithm of your choice: Regression: Linear & Classification: KNN (K- Nearest Neighbor) and SVM (Support Vector Machines)
9. Email id: tanmayraj777@gmail.com
1. Name: Rakshita Singh
2. College: Fergusson College, Pune
3. Branch : MSc Computer Science
4. Year of completion of the course : 2023
5. Available from : October 1, 2022 to December 31st, 2022
6. Rating in SQL (0-10) : 8
7. Describe any concept in SQL in the most basic terms
Stored routines : It is a set of statements stored on server . It helps in scenarios where same set of statements are to be executed multiple times for different values. The two types of stored routines are stored procedures and function.
Stored procedures are used in scenarios where 0 to multiple values are to be returned. It uses both in and out parameters while calling procedure.
create procedure proc1(in a int, out b int)
begin
–body of function
end
Functions are useful in scenarios where only one value is to be returned. Only the return type is mentioned for the function.
create function f1(age int) return int
begin
— body of function
end
8. Algorithm of your choice
Regression :supervised learning technique to predict continuous values based on the relationship between dependent and independent variable.
Type: Linear, polynomial, logistic etc
Classification : Prediction of discrete data values. Eg: K-nearest neighbor, naive bayes etc.
9. Email id : rakshita23jan@gmail.com
1. Name: Tanmay Srivastava
2. College: I.T.S Engineering College, Greater Noida
3. Branch: Electronics and Communication (ECE)
4. Year of completion of the course: 2022
5. Available from: 21 Sept 2022
6. Rating in SQL (0-10): 7
7. Describe any concept in SQL in the most basic terms (Optional, but will help us in reviewing your candidature):
Topic: JOINS
A JOIN clause is used to join rows from two or more tables based on a common column.
There are our types of Joins:
1) Inner join: It returns all the rows from different tables that satisfy the join criteria.
2) Left Join: It returns all rows from the left table but only the matching rows from the right table when the join condition is satisfied.
3) Right Join: It returns all rows from the right table but only the matching rows from the left table when the join condition is satisfied.
4) Outer Join: It returns all the rows when there is a match in any of the tables. As a result, it returns all the rows from the left-hand side table and all the rows from the right-hand side table.
The above concept can be easily explained with the help of Venn Diagrams and their corresponding equations.
8. Algorithm of your choice: Regression: Linear & Classification: KNN (K- Nearest Neighbor) and SVM (Support Vector Machines)
9. Email id: tanmayraj777@gmail.com
1. Utkarsh Kejriwal
2. Lovely Professional University
3. Computer Science (BTech + MTech)
4. 2025
5. October 1, 2022
6. 3
7. Slicing and Filtering : Slicing is similar to the if function we use in python, but in this case we use ‘where’. If ‘like’ is used while slicing, it gives out a pattern to the condition we need, rather than typing each word/number separately. Using these clauses, we can easily filter and look at the data required
8. Classification – Logistic Regression, K-nearest neighbours, Decision Tree, Random Forest
9. kejriwalutkarsh407@gmail.com
1. Name. SelvaNachiyar
2. College University VOC College of Engineering
3. Branch Civil Engineering
4. Year of completion of the course 2017
5. Available from sept 30
6. Rating in SQL (0-10) 9/10
7. Describe any concept in SQL in the most basic terms (Optional, but will help us in reviewing your candidature)
COUNT (*) Counts the total number of rows in a table
DISTINCT Gives o/p of distinct values removing duplicates from the respective columns
8. Algorithm of your choice
9. Email id selvanachiyar95@gmail.com
1. Name – Kolaru Gideon Mosimiloluwa
2. College – Federal university of technology, Akure
3. Branch – Nigeria
4. Year of completion of the course – 4th year
5. Available from – Anytime
6. Rating in SQL (0-10) – 8
7. Describe any concept in SQL in the most basic terms (Optional, but will help us in reviewing your candidature) – Databases:
Databases are a collection of tables used to store data as well as show relationship between the data in the different tables across the database.
8. Algorithm of your choice – Regression
9. Email id – kolarumosimiloluwa@gmail.com
1. Name: Ashishkumar Rana
2. College: Ramniranjan Jhunjhunwala College
3. Branch: Statistics
4. Year of completion of the course: 2023
5. Available from: October 25
6. Rating in SQL (0-10): 7
7. Describe any concept in SQL in the most basic terms (Optional, but will help us in reviewing your candidature):
What is a Composite Primary Key?
A Composite primary key is a set of columns whose values uniquely
identify every row in a table. What it means is that a table that contains
a composite primary key will be indexed based on columns specified in the
primary key. This key will be referred to in the Foreign Key tables
select A.* FROM
(select SUBSTRING(LoginID, 17,10) AS Name, vacationHours+SickLeaveHours as Total_Hours
from AdventureWorks2019.HumanResources.Employee) A
order by A.Total_Hours desc;
8. Algorithm of your choice
K Nearest Neighbours algorithm:
K-nearest neighbors (KNN) algorithm is a type of supervised ML algorithm that
can be used for both classifications as well as regression predictive problems.
However, it is mainly used for the classification of predictive problems in the industry.
o It assumes the similarity between the new data and available data and put the
new data into the category that is most similar to the available categories.
o It stores all the available data and classifies a new data point based on the
similarity. This means when new data appears then it can be easily classified
into a good suite category by using K- NN algorithm.
o KNN is a lazy learning and non-parametric algorithm.
o It’s considered a non-parametric method because it doesn’t make any
assumptions about the underlying data distribution.
o It’s called a lazy learning algorithm because it doesn’t perform any training
when you supply the training data. Instead, it just stores the data during the
training time and doesn’t perform any calculations.
9. Email id: ashishrana1501@gmail.com
1. Name : Shamie Dasgupta
2. College : St. Xavier’s College, Kolkata
3. Branch : Bsc. (Hons) Statistics
4. Year of completion of the course : 2022
5. Available from : Available immediately
6. Rating in SQL (0-10) : 7
7. Describe any concept in SQL in the most basic terms (Optional, but will help us in reviewing your candidature) :
Explaining the concept of foreign key: when an attribute is dependent on another attribute for its existence then it is called a foreign key relation.The dependent attribute is the foreign key. an example of the use of foreign key is:
create table project(Pid varchar(10) primary key,Pname varchar(20) default ‘sartup’,
ploc varchar(10) NOT NULL check(ploc IN(‘Kolkata’,’Pune’,’Delhi’,’Chennai’)),
Budget number(10) check(budget=25000 and salary<=90000), DOB DATE NOT NULL,
PId varchar(10) references project(Pid), SuperNum number(10));
Here the PId attribute of the employee table is dependent on the PId attribute of the project table and hence it forms a foreign key relationship.
8. Algorithm of your choice : Statistics/Machine Learning/prediction and forecasting/ Classification
9. Email id : shamiedasgupta2000@gmail.com
1. Name – Jaisingh Chauhan
2. College – RJ College of Arts, Science & Commerce
3. Branch – Statistics
4. Year of completion of the course – 2023
5. Available from 25th October 2022
6. Rating in SQL (0-10) – 07
7. Describe any concept in SQL in the most basic terms (Optional, but will help us in reviewing your candidature)
–> SQL Join statement is used to combine data or rows or columns from two or more tables based on a common field between them. Different types of Joins are as follows:
INNER JOIN
LEFT JOIN
RIGHT JOIN
FULL JOIN
—> INNER JOIN
The INNER JOIN keyword selects all rows from both tables as long as the condition is satisfied. This keyword will create the result-set by combining all rows from both the tables where the condition satisfies i.e value of the common field will be the same.
—> LEFT JOIN
This join returns all the rows of the table on the left side of the join and matches rows for the table on the right side of the join. For the rows for which there is no matching row on the right side, the result set will contain null. LEFT JOIN is also known as LEFT OUTER JOIN.
—> RIGHT JOIN
RIGHT JOIN is similar to LEFT JOIN. This join returns all the rows of the table on the right side of the join and matching rows for the table on the left side of the join. For the rows for which there is no matching row on the left side, the result set will contain null. RIGHT JOIN is also known as RIGHT OUTER JOIN.
—>FULL JOIN
FULL JOIN creates the result-set by combining results of both LEFT JOIN and RIGHT JOIN. The result set will contain all the rows from both tables. For the rows for which there is no matching, the result set will contain NULL values.
–> Code
Create Database Jaisingh;
Use Jaisingh;
CREATE TABLE EMP(
E_NO INT,
NAME VARCHAR(30),
DEPT_ID INT
)
CREATE TABLE DEPT(
DEPT_ID INT,
DEPT_NAME VARCHAR(30)
)
INSERT INTO EMP VALUES(4578,’JAISINGH’,01 )
INSERT INTO EMP VALUES(7698,’AYAAN’,10 )
INSERT INTO EMP VALUES( 1268,’VATSALA’,05)
INSERT INTO EMP VALUES( 1865,’AKSHARA’,02)
INSERT INTO DEPT VALUES( 01,’ANALYTICS’)
INSERT INTO DEPT VALUES( 05,’DATA’)
INSERT INTO DEPT VALUES( 07,’LINUX’)
INSERT INTO DEPT VALUES( 02,’WINDOWS’)
SELECT * FROM EMP
SELECT * FROM DEPT
–INNER JOIN
SELECT E.E_NO, E.NAME, D.DEPT_NAME, E.DEPT_ID
FROM EMP E –THIS IS LEFT TABLE SINCE IT IS WRITTEN FIRST
INNER JOIN DEPT D
ON E.DEPT_ID = D.DEPT_ID;
–OUTER JOIN
SELECT * FROM EMP
SELECT * FROM DEPT
SELECT E.E_NO, E.NAME, D.DEPT_NAME, E.DEPT_ID
FROM EMP E –THIS IS LEFT TABLE SINCE IT IS WRITTEN FIRST
OUTER JOIN DEPT D
ON E.DEPT_ID = D.DEPT_ID;
–LEFT JOIN
SELECT * FROM EMP
SELECT * FROM DEPT
SELECT E.E_NO, E.NAME, D.DEPT_NAME, E.DEPT_ID
FROM EMP E –THIS IS LEFT TABLE SINCE IT IS WRITTEN FIRST
LEFT JOIN DEPT D
ON E.DEPT_ID = D.DEPT_ID;
–RIGHT JOIN
SELECT * FROM EMP
SELECT * FROM DEPT
SELECT E.E_NO, E.NAME, D.DEPT_NAME, E.DEPT_ID
FROM EMP E –THIS IS LEFT TABLE SINCE IT IS WRITTEN FIRST
RIGHT JOIN DEPT D
ON E.DEPT_ID = D.DEPT_ID;
–FULL JOIN
SELECT * FROM EMP
SELECT * FROM DEPT
SELECT E.E_NO, E.NAME, D.DEPT_NAME, E.DEPT_ID
FROM EMP E –THIS IS LEFT TABLE SINCE IT IS WRITTEN FIRST
FULL JOIN DEPT D
ON E.DEPT_ID = D.DEPT_ID;
8. Algorithm of your choice – Decision Tree
–>Decision Tree is a supervised learning method used in data mining for classification and regression methods. It is a tree that helps us in decision-making purposes.
>The decision tree creates classification or regression models as a tree structure. It separates a data set into smaller subsets, and at the same time, the decision tree is steadily developed.
>The final tree is a tree with the decision nodes and leaf nodes.
>A decision node has at least two branches. The leaf nodes show a classification or decision. We can’t accomplish more split on leaf nodes-The uppermost decision node in a tree that relates to the best predictor is called the root node.
>Decision trees can deal with both categorical and numerical data.
9. Email id – jaisinghrjcollege@gmail.com
1. Name: Tushar Kanta Mahuri
2. College: Sambalpur University
3. Branch: CSE
4. Year of completion of the course: 2023
5. Available from Tomorrow
6. Rating in SQL (0-10): 7
7. Describe any concept in SQL in the most basic terms (Optional, but will help us in reviewing your candidature):
Different types of JOINs in SQL:
(INNER) JOIN: Returns records that have matching values in both tables
LEFT (OUTER) JOIN: Returns all records from the left table, and the matched records from the right table
RIGHT (OUTER) JOIN: Returns all records from the right table, and the matched records from the left table
FULL (OUTER) JOIN: Returns all records when there is a match in either the left or right table
8. Algorithm of your choice: SVM
9. Email id: mahuritushar@gmail.com
1.)Hanith
2.)SRM
3.)cse(CORE)
4.)2024
5.)Available from 22/09/2022 after 7:00pm
6.)Rating in SQL in the range of 7
7.)Key is used to fetch from the data table according to the requirements ,some of the keys are primary key, foreign key, unique key.
8.) bubble sort
9.) Linear Regression
10.) hanithreddy2@gmail.com
I am a mba student in business analytics specialization . I would love to work and gain experience while giving my efforts to your firm
1. Name : B. Akash
2. College: SRM IST
3. Branch: CSE
4. Year of completion of the course: 2023
5. Available from: September 25
6. Rating in SQL (0-10): 8
7. Describe any concept in SQL in the most basic terms (Optional, but will help us in reviewing your candidature):
Sometimes when a user performs a join operation they will experience data redundancy. One of the ways this redundancy can be avoided is by decomposing the tables. This is called Normalization. Normalization is used to eliminate data redundancy. There different normal forms are 1NF, 2NF, 3NF, 4NF, BCNF and 5NF. Each normal form have different set of rules to be followed.
8. Algorithm of your choice: Regression
9. Email id: akubala23@gmail.com
Name.Chetan Gijare
Branch :Computer sciene of engg.
College :priyadarshini college of engg.
Year off pass:2022
Available :25/09/2022
7/10
aditya4321gijare@gmail.com
1. Name: Tanmay Srivastava
2. College: I.T.S Engineering College, Greater Noida
3. Branch: Electronics and Communication (ECE)
4. Year of completion of the course: 2022
5. Available from: 21 Sept 2022
6. Rating in SQL (0-10): 7
7. Describe any concept in SQL in the most basic terms (Optional, but will help us in reviewing your candidature):
Topic: JOINS
A JOIN clause is used to join rows from two or more tables based on a common column.
There are our types of Joins:
1) Inner join: It returns all the rows from different tables that satisfy the join criteria.
2) Left Join: It returns all rows from the left table but only the matching rows from the right table when the join condition is satisfied.
3) Right Join: It returns all rows from the right table but only the matching rows from the left table when the join condition is satisfied.
4) Outer Join: It returns all the rows when there is a match in any of the tables. As a result, it returns all the rows from the left-hand side table and all the rows from the right-hand side table.
The above concept can be easily explained with the help of Venn Diagrams and their corresponding equations.
8. Algorithm of your choice: Regression: Linear & Classification: KNN (K- Nearest Neighbor) and SVM (Support Vector Machines)
9. Email id: tanmayraj777@gmail.com
Interested in 1 month data analytics internship.
1. Name- Shivam Mittal
2. College- Dr. Akhilesh Das Gupta Institute Of Technology and Management
3. Branch-B.Tech(Information Technology)
4. Year of completion of the course-2023
5. Available from- 5th October
6. Rating in SQL (0-10) – 7
7. Describe any concept in SQL in the most basic terms (Optional, but will help us in reviewing your candidature)- The topic that I would like to explain is Keys . Keys in the most basic language can be defined as the the elements with which you can identify a row in the table. There are various types of Keys present in SQL such as
a)Primary Key->The key in the table which is capable of uniquely identifying a row in the table. It is NOT NULL and can not
be same for two entries in the table. Only one primary key per table is possible.
b)Alternate Key->All the keys except for the primary key in the table fall in this category.
c)Foreign Key->This is the primary of another table defined as an attribute in some other to generate a relationship
between the two tables.
8. Algorithm of your choice- Decision Tree Classifier
As the same suggests, this algorithm is a part of the many classification algorithms present with us. In our lives we must have gone through situations where we need to choose between the options that are present with us. This is exactly what this algorithm does. This falls under supervised machine learning.
In this algorithm we begin at the root node and check find the best attribute in the table and divide the dataset into possible values based on the best attribute. This process is done recursively until the the leaf node is attained.
There are two methods to select the attributes:-
a)Information Gain-> this is the measure of changes in the entropy after division of dataset. We try to maximize the
information always.
b)Gini Index-> this is the measure of impurity or purity used while creating a decision tree. The attributes with lower gini
indices are to be chosen.
9. Email id- mittalshivam1974@gmail.com
1. Name bage Aman shaikh
2. College jai hind College
3. Branch msc big data analytics
4. Year of completion of the course 2022
5. Available from immediately
6. Rating in SQL (0-10) 5
7. Describe any concept in SQL in the most basic terms (Optional, but will help us in reviewing your candidature)
8. Algorithm of your choice
9. Email id shaikhmuskan5127@gmail.com
Name: Faizan Hussain
College: Haldia Institute of Technology
Branch: Computer Science of Engineering with specialization of Data Science
Year of Completion: 2024
Available from: Immediately
Rating in SQL: 6/10
Concept of SQL: Primary Key – A column in database which is unique and can help us to identify or query a specific row through that primary key value.
Algorithm of your choice: Regression
Email id: faizanhussain1601@gmail.com
1. Name
Dhiyanesh Babu C V
2. College
Vellore Institute of Technology ( VIT Vellore )
3. Branch
CSE specialization in Data Science ( 5 yrs )
4. Year of completion of the course
2024 ( currently in 4th year )
5. Available from
From now
6. Rating in SQL (0-10)
8/10 ( I have done a course in college and even have a certification from Udemy )
7. Describe any concept in SQL in the most basic terms (Optional, but will help us in reviewing your candidature)
REVOKE – Removes user permission.
COMMIT – Saves all the executed commands/transactions to Database.
SAVEPOINT – Save point within transaction, to ROLLBACK ( Go back to a state till where all commands executed successfully ) whenever some thing goes wrong.
%ROWTYPE – Gives the record type present in table.
FLASHBACK – Query used to see past data.
8. Algorithm of your choice
Algorithms that surprised me include,
a) Counting and Radix sort
b) Longest consecutive subsequence
c) Decision Tree and K-means clustering
d) Rabin Karp and KMP algorithm
9. Email id
cv.dhiyanesh@gmail.com
10. LinkedIn profile link
https://www.linkedin.com/in/dhiyanesh-babu-c-v-3516891a5/
11. My certifications ( LinkedIn )
Udemy – Machine learning, Python, SQL
Coursera – AI applications on Azure
INeuron – Currently am doing computer vision and NLP
12. Projects
I have done projects in ML like, ( https://github.com/Dhiyanesh-babu/Machine-Learning-mini-projects )
Anomaly Detection
Movie recommendation
Time series forecasting
I have done a project in NLP + Django,
Twitter sentiment analysis, ( https://github.com/Dhiyanesh-babu/Python-projects )
I am so passionate about this field. It will be a good opportunity to showcase my skills and gain industry experience.
I will be happy to receive to this intern and i will try my best to finish the assigned tasks. Hoping for a call back.
Thank you.
1. Name
Dhiyanesh Babu C V
2. College
Vellore Institute of Technology ( VIT Vellore )
3. Branch
CSE specialization in Data Science ( 5 yrs )
4. Year of completion of the course
2024 ( currently in 4th year )
5. Available from
From now
6. Rating in SQL (0-10)
8/10 ( I have done a course in college and even have a certification from Udemy )
7. Describe any concept in SQL in the most basic terms (Optional, but will help us in reviewing your candidature)
REVOKE – Removes user permission.
COMMIT – Saves all the executed commands/transactions to Database.
SAVEPOINT – Save point within transaction, to ROLLBACK ( Go back to a state till where all commands executed successfully ) whenever some thing goes wrong.
%ROWTYPE – Gives the record type present in table.
FLASHBACK – Query used to see past data.
8. Algorithm of your choice
Algorithms that surprised me include,
a) Counting and Radix sort
b) Longest consecutive subsequence
c) Decision Tree and K-means clustering
d) Rabin Karp and KMP algorithm
9. Email id
cv.dhiyanesh@gmail.com
10. LinkedIn profile link
https://www.linkedin.com/in/dhiyanesh-babu-c-v-3516891a5/
11. My certifications ( LinkedIn )
Udemy – Machine learning, Python, SQL
Coursera – AI applications on Azure
INeuron – Currently am doing computer vision and NLP
12. Projects
I have done projects in ML like, ( https://github.com/Dhiyanesh-babu/Machine-Learning-mini-projects )
Anomaly Detection
Movie recommendation
Time series forecasting
I have done a project in NLP + Django,
Twitter sentiment analysis, ( https://github.com/Dhiyanesh-babu/Python-projects )
I am so passionate about this field. It will be a good opportunity to showcase my skills and gain industry experience.
I will be happy to receive to this intern and i will try my best to finish the assigned tasks. Hoping for a call back.
Thank you.
1. Name: Eshwar Galam
2. College: Central Institute of Technology, Kokrajhar
3. Branch: CSE
4. Year of completion of the course: 2023
5. Available from November
6. Rating in SQL (0-10) : 4
7. Describe any concept in SQL in the most basic terms (Optional, but will help us in reviewing your candidature)
8. Algorithm of your choice
9. Email id:eshwargalam7777@gmail.com
1. Name : Prince Kumar
2. College : JSS academy of technical education
3. Branch : Mechanical Engineering
4. Year of completion of the course : 2022
5. Available from : Immediately
6. Rating in SQL (0-10) : 08
7. Describe any concept in SQL in the most basic terms (Optional, but will help us in reviewing your candidature)
Self join :-
a join is always cross product with a condition in self join, a table is joined with himself.
always remember that in a sql query (select _ from _ where ___ statement,)
the from _ where______ part will get computed first. and then the select part.
In a self join, you join a table with itself.
In self join we must have to make the 2 variables to do the join, otherwise SQL will give an error when you try to join 2
tables by themselves without make 2 variable of same table .
8. Algorithm of your choice :
9. Email id : prince.dataman@gmail.com
1. Name : Prince Kumar
2. College : JSS academy of technical education
3. Branch : Mechanical Engineering
4. Year of completion of the course : 2022
5. Available from : Immediately
6. Rating in SQL (0-10) : 08
7. Describe any concept in SQL in the most basic terms (Optional, but will help us in reviewing your candidature)
Self join :-
a join is always cross product with a condition in self join, a table is joined with himself.
always remember that in a sql query (select _ from _ where ___ statement,)
the from _ where______ part will get computed first. and then the select part.
In a self join, you join a table with itself.
In self join we must have to make the 2 variables to do the join, otherwise SQL will give an error when you try to join 2
tables by themselves without make 2 variable of same table .
8. Algorithm of your choice :
9. Email id : prince.dataman@gmail.com
Name :- Kaushal Agrawal
College :- DR BR Ambedkar National Institute Of technology Jalandhar
Branch :- Instrumentation and Control Engineering
Pass out year :- 2024
Available from :- Immediately
Rating (SQL) :- 9/10
Email ID :- kaushalagr.02@gmail.com
1. Name -:Jai Sinha
2. College -:SRM IST KTR CHENNAI
3. Branch-:cse
4. Year of completion of the course-:3
5. Available from-:October 2022-March 2023
6. Rating in SQL (0-10)-:8
7. Describe any concept in SQL in the most basic terms (Optional, but will help us in reviewing your candidature)-: Foreign key is a primary key of another table
8. Algorithm of your choice-:Linear Regression
9. Email id-: jaioff02@gmail.com
Om Bhatt
Graphic Era University Dehradun
B. tech CS
2024
25 October
0
Don’t know any in sql
ombhattreal@gmail.com
Abhinav Kumar Goswami
IIT BHU Varanasi
Pharmaceutical Engineering and Technology (B. Tech and M. Tech)
2023
15 December 2022
9
Random Forest
abhinavkumargoswami@gmail.com
Name : Mayank Joshi
College : University of Texas, Austin
Branch : Data Science and Business Analytics
Year of completion of the course : January 2023
Available from : October 2022
Rating in SQL (0-10) : 6
Describe any concept in SQL in the most basic terms :
Ans. Types of Datatypes in SQL are :-
Numeric: TINYINT, INT, BIGINT
Floating numbers: DECIMAL, FLOAT
Strings: CHAR, VARCHAR, BLOB, TEXT
Date and Time : DATE,TIME, DATETIME
Types of SQL commands :
Data Definition Language(DDL) – CREATE, ALTER, DROP, TRUNCATE
Data Manipulation Language(DML) – INSERT, UPDATE, DELETE
Data Query Language(DQL) – SELECT
Data Control Language(DCL) – GRANT, REVOKE
Transactional Control Language(TCL) – COMMIT, ROLL BACK
Algorithm of your choice : Random Forest Classifier
Email id : joshimayank297@gmail.com
1. Name: Tanmay Srivastava
2. College: I.T.S Engineering College, Greater Noida
3. Branch: Electronics and Communication (ECE)
4. Year of completion of the course: 2022
5. Available from: 21 Sept 2022
6. Rating in SQL (0-10): 7
7. Describe any concept in SQL in the most basic terms (Optional, but will help us in reviewing your candidature):
Topic: JOINS
A JOIN clause is used to join rows from two or more tables based on a common column.
There are our types of Joins:
1) Inner join: It returns all the rows from different tables that satisfy the join criteria.
2) Left Join: It returns all rows from the left table but only the matching rows from the right table when the join condition is satisfied.
3) Right Join: It returns all rows from the right table but only the matching rows from the left table when the join condition is satisfied.
4) Outer Join: It returns all the rows when there is a match in any of the tables. As a result, it returns all the rows from the left-hand side table and all the rows from the right-hand side table.
The above concept can be easily explained with the help of Venn Diagrams and their corresponding equations.
8. Algorithm of your choice: Regression: Linear & Classification: KNN (K- Nearest Neighbor) and SVM (Support Vector Machines)
9. Email id: tanmayraj777@gmail.com
1. Name- SHRUTI AGRAWAL
2. College- JECRC University
3. Branch- Computer Science & Engineering (CSE)
4. Year of completion of the course- 2023
5. Available from- Immediately (Oct 2022)
6. Rating in SQL (0-10)- 7-8
7. Describe any concept in SQL in the most basic terms (Optional, but will help us in reviewing your candidature)- KEYS and Aggregate functions(COUNT,MAX, SUM, MIN,AVG) .
8. Algorithm of your choice- Classifications and Regression Algorithms
9. Email id- agrawal24shruti@gmail.com
1.K.Sri Sravya
2. AndhraUniversity
3. Information Technology
4. 2023
5. December 1st, 2022
6. Rating in sql: 7
7. SQL JOINS:
JOINS are used for combining rows from two or more tables,.
Different types of joins include
–>InnerJoin
–>OuterJoin
–>FullJoin
–>SelfJoin
8. Merge sort Algorithm:
It is a divide and conquer algorithm.It divides list into 2 halves, each half is further divided and this process continues until smallest subset is obtained. This smallest subset is sorted and merged until a single entire list of sorted values is obtained.
Time Complexity is O(nlogn)
9. karipeddiss@gmail.com
1. Sunidhi Bansal
2. Lovely Professional University
3. B.Tech CSE (Hons.)
4. 2024
5. 1st June 2023
6. 7-8
7. I would like to explain the concept of keys. The primary key is the column or the combination of one or more columns that uniquely identify that particular row. It can have no null values and no duplicates. For example, if we have an employee table having the details of employees, then the employee_id will be the primary key because it will uniquely identify each and every employee. Employee_id will never be null because every employee being a part of the company has this id. It can’t be null for the same reason. Next is a foreign key. To understand this key, let’s take an example, let’s say we have two tables, one is the student table, containing all the details of students like student_id, student_name, student_class, etc. Another table is the course table, which tells which student has opted for which course. So here, the student table is the parent table and the course table is the child table. Now the foreign key will make sure that the course table has only those students that are already present at the student table. So we can say that the foreign key maintains the link between two tables and provides referential integrity.
8. Logistic Regression
9. Agilist.sunidhi@gmail.com
Ashish Salunkhe
Manipal Institute of Technology
Mechanical Engineering
Completed Gradation in September 2022
Available immediately
Would rate 8 out of 10 for SQL
ashishsalunkhe286@gmail.com
Name: Yamini.M
College: Velammal Institute of Technology
Branch: B-Tech AI & DS
Year of completion: 2024
Available from: October 9
Rating in SQL: 8
SQL is a standard language for accessing and manipulating databases. It can execute queries against database, retrieve records from database and so on. It have concepts like DDL, DML , DCL, TCL.
Algorithm of your choice: basics of machine learning algorithms like classification, regression, logistic regression, knn etc
Email id : yaminimagesh03@gmail.com
1. Name:- Abhay Gulhane
2. College:- G H Raisoni College of Engineering and Management, Amravati.
3. Branch:- Electrical Engineering
4. Year of completion of the course:-2020
5. Available from 25 September
6. Rating in SQL (0-10) 7
7. Describe any concept in SQL in the most basic terms (Optional, but will help us in reviewing your candidature)
8. Algorithm of your choice:- linear regression
9. Email id abhaygulhane01@gmail
1. Name:- Piyush Kumar Sharma
2. College:- Delhi Technological University
3. Branch:- Information Technology
4. Year of completion of the course:- 2024
5. Available from:- November 2022
6. Rating in SQL (0-10):- 8/10
7. Describe any concept in SQL in the most basic terms (Optional, but will help us review your candidature):- When we want to retrieve data from the database, the output data is usually spread out to multiple tables. To avoid this, we use SQL joins to handle tasks that include selecting rows from two or more related tables in order to be consistent.
Different types of JOINS in SQL:
INNER JOIN: Selects records that have matching values in both tables.
SELF JOIN: It is a regular join, but the table is joined with itself.
LEFT JOIN: Returns all records from the left table (table1), and the matching records from the right table (table2).
RIGHT JOIN: Returns all records from the right table (table2), and the matching records from the left table (table1).
FULL JOIN: Returns all records when there is a match in left (table1) or right (table2) table records.
8. Algorithm of your choice:- Linear regression, K-Nearest Neighbor, Logistic Regression
9. Email id:- pks05072001@gmail.com
1. Name – Zagesh Rathod
2. College – Already graduated
3. Branch – Commerce
4. Year of completion of the course – 2015
5. Available from – Immediately
6. Rating in SQL (0-10) – 8
7. Describe any concept in SQL in the most basic terms (Optional, but will help us in reviewing your candidature) – Inside a table, a column often contains many duplicate values; and sometimes you only want to list the different (distinct) values that’s when you can use SELECT DISTINCT
8. Algorithm of your choice – Random Forest
9. Email id – zageshrathod@gmail.com
Name: Mir saif ali
College: Lords institute of engineering
Branch: Cse
year of completion:2023
Available from: october
SQL rating: 8
concepts: *SQl commands
* CRUD operation
*Keys
* Joins
Gmail: mir.saif.ali424@gmail.com
1. Name KARIPEDDI SRI SRAVYA
2. College Andhra University College of Engineering
3. Branch INFORMATION TECHNOLGY
4. Year of completion of the course 2023
5. Available from December 2022
6. Rating in SQL: 7/10
7. Describe any concept in SQL in the most basic terms (Optional, but will help us in reviewing your candidature)
Joins :
JOINs are used to combine rows from two or more tables.
Different types of joins include:
–>Inner Join: Selects records that have matching values in both the tables
–>Outer Join:
–Left Join: Selects all the elements from left table and the matching elements from right table
–Right Join: Selects all the elements from right table and the matching elements from left table
–>Full Join: Selects the elements that have a match in either of the tables
–>Self Join: A table joined with itself
8.Describe an algorithm :
Merge Sort:
It is one of the divide and conquer algorithm. In this we first divide the list into 2 parts, each part is further divided into various subparts. The smallest subparts are sorted and merged. This process continues until we obtain a single list that is completely sorted.
9. Email id karipeddiss@gmail.com
Name: Ishan Jat
College: Marwadi University (GTU)
Branch: B.E. (Computer Engineering)
Year of completion: 2023
Availability: Immediately from 4pm onwards
SQL rating: 7/10
SQL concept: JOIN QUERY, this SQL query is comes in handy while dealing with large datasets and used to join tables using primary key and foreign key.
ML Algorithm: I prefer Random Forest Classifier for most of my classification projects because RFC is a ensemble technique which provides a lot a versatility while preparing the model not just that, even when working on a huge and complex dataset it maintains the accuracy compared to other ML Algorithms.
Email: ishanjat123@gmail.com
Name=Aditya Singh
College=NIT JAMSHEDPUR
BRANCH=metallurgy and materials engineering
Year of completion of the course=2024
Available from =25 September
Rating SQL=8
SQL concept
1.Aggregrate functions -these are used to take multiple rows as input and return 1 row as output.Some of aggregate functions are max,min ,avg,sum.These are applied only with the select statement and the having clause
2. Group by- this is used to group by category and then apply aggregate functions on the specific groups.
3. Having clause- use to put conditions on the aggregate functions
4.Select clause helps in showing the result.’*’ is used to show all the columns in the data set.
5.where clause is used to filter the results
ML CONCEPT=
(I)Supervised Machine Learning-
1. Linear regression –
In this algorithm,we try to find the best possible fit line by optimising the value of the weight and bias using the gradient descent algorithm (which states that update the value of the weight and bias until the global minima is reached that is a point where the slope of Gradient Descent is zero).
2. Logistics regression
In this model the sigmoid function is used to predict the values,here also the weight and bias are optimised using the gradient descent algorithm,the cost function used here is called the log loss error funtion.
3.K Nearest Neighbors-here the model learns the entire training data (lazy learner) after that when a test point is given ,depending on the value of K ,K closest points from the given test point is found and in case of regression problems the average is found out and in case of classification problem the majority count is taken.
4.SVM-
Here the main aim is to maximize the distance between the two marginal planes until the planes touches a support vector.
5.Decision Tree-here the data is split on the basis ,where the maximum information gain is obtained.
first we calculate the entropy ,and then the information gain for all the features and depending on the maximum information gain the column is choosen for the split.
6.Ensemble methods-
(i)Voting Ensemble-The main aim of this method is to combine many weak learners to produce a strong learner.Voting Ensemble works on the majority count for the classification problem,and in the case of regression mean is calculated
(ii)Bagging Ensemble-In this Low bias High Variance(example knn,fully grown decision tree) are joined parallel to each other and then subset of data is fed to each model and the prediction from each model is noted.
(iii)Boosting Ensemble-In this underfitting model (Decision tree stump) are used(In case of Adaboost).Here the model is joined in a sequential stagewise and each model is given weight depending on the accuracy of correct prediction it can make
(II)Unsupervised-
KMeans-First k is choosen and then that many random points are choosen and distance of all the points is found out , and the points nearer to the centroid is formed into a clusterand the above steps is repeated until there is no change in the centroid position or the epochs is finished
Email-sanjaymrid@gmail.com
1. Name : Narravula Dushyanth Sai Chowdary
2. College : Gayatri Vidya Parishad College of Engineering
3. Branch : Computer Science and Engineering Specialization With Artificial intelligence and Machine Learning
4. Year of completion of the course : 2024
5. Available from : 4 pm to Overnight (IST)
6. Rating in SQL (0-10) : 7
7. Describe any concept in SQL in the most basic terms (Optional, but will help us in reviewing your candidature) : I know joins very well .
The primary purpose of joins is to merge the records from two or more tables in a database and to access multiple records from different tables in a database.
There are four types of joins.In those
a)Inner Join : The Inner join results a table by
considering common elements in
both tables.
b)Left Join : The Left join results all the records
from left side table.
c)Right Join : The Right join results all the records
from right side table
d)Full Join : The full Join results the combination
of results of both Right and Left join
I.e it results all records from both
tables.
8. Algorithm of your choice : All Regression Algorithms and when comes to Classification I know Logistic Regression, Navies Bayes ,Decision Trees
9. Email id : narravula.dushyanthsai@gmail.com
I am currently in 3rd year and pursuing a degree in CSE from Shri Ramdeobaba College of Engineering and Management, Nagpur, Maharashtra.
I have good knowledge of SQL, python and machine learning.
I was selected in the Amazon Machine Learning Summer School, 2022.
My current CGPA in college: 10
1. Name : Keerthi Bandewale
2. College : B V Raju Institute of Technology
3. Branch : Computer Science and Engineering
4. Year of completion of the course : 2024
5. Available from : 25-09-2022
6. Rating in SQL (0-10) : 7
7. Describe any concept in SQL in the most basic terms (Optional, but will help us in reviewing your candidature)
SQL stands for structured Query Language. It is used for retrieving and managing the data from relational databases.
A relation is nothing but a table(made up of rows and columns) in which data is stored. Rows are called as tuples/records
while columns are called as attributes. In the process of retrieving and storing the tables are sometimes combined .
“JOIN” – In order to join two tables there must be atleast one common attribute . Here we combine the data from two or
more tables. To join two tables, specify them as a comma-separated list in the from clause like below.
select column1 from table1 Inner join table2 on table1.column1 = table2.column1;
Join is of basically two types . They are INNER JOIN and OUTER JOIN
— INNER JOIN : It returns only those records that are matched between the tables.
— OUTER JOIN : It returns all the records including the mismatched ones between the tables.
* LEFT JOIN : It returns all the records from the left table even if there are no matches in the right one.
* RIGHT JOIN : It returns all the records from right table even if there are no matches from left table.
8. Algorithm of your choice : K-Nearest Neighbor Algorithm , Random Forest , Decision Tree, Logistic regression , SVM
9. Email id :keerthibandewale2003@gmail.com
1. Name : Mohamad Ehthesham S
2. College : Sri Jayachamarajendra college of Engineering
3. Branch : Mechanical
4. Year of completion of the course : 2023
5. Available from : Monday
6. Rating in SQL (0-10) : 8
7. Describe any concept in SQL in the most basic terms (Optional, but will help us in reviewing your candidature)
: Group-by – it is used to arrange the values into groups e.g. If there are 3 different customers who have made 4 , 3 and 6 money transactions respectively, then by using group-by function we can able to find total transaction made by each customer by using some aggregate function like SUM, AVG etc..
8. Algorithm of your choice
9. Email id- mohammedfaiz0102@gmail.com
10. github – https://github.com/MohamadFaiz0102
11. LinkedIn – https://www.linkedin.com/in/-mohamad-ehthesham/
1: Mohd Shahid
2: Maulana Azad National Urdu University Hyderabad
3: Btech in Computer Science
4:2024
5:
6: 7-8
7:
8: Regression
9: msaligs@gmail.com
1. Name: Monisha S
2. College: St. Joseph’s College, Bangalore
3. Branch : MSC Mathematics
4. Year of completion of the course : 2022
5. Available from : immediately
6. Rating in SQL (0-10) : 5/10
7. Describe any concept in SQL in the most basic terms (Optional, but will help us in reviewing your candidature) : Normalization is a database design technique that helps in organizing tables in such a way that it reduces the redundancy of data. Normalization also divides larger tables into smaller tables and links them using relationships. The main purpose of Normalization is to eliminate redundant data and ensure data is stored logically. There are various Normalization rules such as 1NF, 2NF, 3NF, and BCNF.
8. Algorithm of your choice
9. Email id : monisha6415@gmail.com
1.Name: Monisha S
2. College: St. Joseph’s college, Bangalore
3. Branch: MSC Mathematics
4. Year of completion of the course:2022
5. Available from: immediately
6. Rating in SQL (0-10): 5/10
7. Describe any concept in SQL in the most basic terms (Optional, but will help us in reviewing your candidature): Normalization is a database design technique that helps in organizing tables in such a way that it reduces redundancy of data. Normalization also divides larger tables into smaller tables and links them using relationships. The main purpose of Normalization is to eliminate redundant data. There are various Normalization rules such as 1NF, 2NF, 3NF, and BCNF.
8. Algorithm of your choice
9. Email id : monisha6415@gmail.com
1. Name ; Ayush kumar srivastava
2. College ; Rajiv Gandhi institute of Petroleum technology
3. Branch ; Petroleum engineering
4. Year of completion of the course ; 2023
5. Available from ; may 2023
6. Rating in SQL (0-10) ; 8
7. Describe any concept in SQL in the most basic terms (Optional, but will help us in reviewing your candidature) ; ERROR HANDLING
MySQL ERROR HANDLING uses to encounter Errors in the stored procedure. Whenever any error occurs inside a stored procedure, it is very important to handle it. To handle that, MySQL is providing an easy way to define handlers that handle the errors (such as warnings or exceptions to specific conditions).
To declare the handler, we use the following syntax:
DECLARE action HANDLER FOR condition statement;
If the condition matches, then the MySQL will execute the statement and continue or exit from the code block based on the action.
Action accepts one of the following values:
CONTINUE: the execution of the code block is continuing.
EXIT: the execution of the enclosing code block, where the handler is declared or terminated.
8. Algorithm of your choice ; Sorting algorithm behind order by query
9. Email id epe19018@rgipt.ac.in
1. Name – Gireesh Kumar Singh
2. College – National Institute Of Technology, Patna
3. Branch – Electrical Engineering
4. Year of completion of the course – 2023
5. Available from – 25 Oct 2022
6. Rating in SQL (0-10) – 7
7. Describe any concept in SQL in the most basic terms (Optional, but will help us in reviewing your candidature) –
Joins : A JOIN clause is used to combine rows from two or more tables, based on a related column between them. Joins are of different types as follows:-
1) INNER JOIN -> Here only matching records are considered. Non-matching records are discarded.
2) LEFT OUTER JOIN -> Here all the matching records and non-matching records of left table padded with NULL are considered.
3) RIGHT OUTER JOIN -> Here all the matching records and non-matching records of right table padded with NULL are considered.
4) FULL OUTER JOIN -> Here all the matching records and non-matching records of left & right table padded with NULL are considered( not in MySQL).
5) CROSS JOIN -> Here each record of left table will to joined to each record of right table.
8. Algorithm of your choice – Statistics
9. Email id – gireeshk025199@gmail.com
1. Name : SAHIL MILIND PATIL
2. College : PES MODERN COLLEGE OF ENGINEERING
3. Branch : INFORMATION TECHNOLOGY
4. Year of completion of the course : 2024
5. Available from : Jan 2023-april 2023
6. Rating in SQL (0-10) : 8
7. Describe any concept in SQL in the most basic terms (Optional, but will help us in reviewing your candidature) : Constraints ,Clauses ,DML ,DDL statements
8. Algorithm of your choice : Create Table table_name
9. Email id : sahil.patil2529@gmail.com
1. Name: Avradyooti Dutta
2. College: SCMHRD
3. Branch: Business Analytics MBA 2nd year
4. Year of completion of the course: 2023
5. Available from: Immediate joiner
6. Rating in SQL (0-10): 9
7. Describe any concept in SQL in the most basic terms (Optional, but will help us in reviewing your candidature): JOIN command helps combine two tables to find the relation between those two tables.
8. Algorithm of your choice: Bagging, boosting
9. Email id: avradyootidutta@gmail.com
Shwetank Kumar
Jss Academy Of Technical Education
ECE
2022
1 OCTOBER
Sql Rating 7
SQL is standardized programming language that is used to manage relational databases and perform various operations on the data in them. Normalisation should be implemented to maintain data consistency, integrity.
email :. shwetankkumar196@gmail.com
1. Name- Shubham Kumar Saras
2. College- Dr. Ambedkar Institute of Technology, Bangalore
3. Branch- CSE
4. Year of completion of the course- 2023
5. Available from- 1st Oct
6. Rating in SQL (0-10)- 8
7. Describe any concept in SQL in the most basic terms (Optional, but will help us in reviewing your candidature)- I like the DELETE statement which is used to delete existing records in a table.
8. Algorithm of your choice- join
9. Email id- shubhamsarasofficial@gmail.com
Mohit Singh
Indian Institute of information technology design and manufacturing, kurnool
Artificial intelligence and data science
2024
December 2022
8
Primary key helps to uniquely identify each row in a dataset for eg. in a dataset of every person in our country adhaar number would be a primary key
Logistic Regression
nirdin2001@gmail.com
1. Name-Gurleenkaur Ahluwalia
2. College-Modern college of engineering
3. Branch-MBA(IT)
4. Year of completion of the course-2020
5. Available from-6/10/2022
6. Rating in SQL (0-10)-6
7. Describe any concept in SQL in the most basic terms (Optional, but will help us in reviewing your candidature)- Primary key is a column or columns that contains value that uniquely identifies each row in a table
8. Algorithm of your choice- Random forest and Decison tree
9. Email id-gurleenahluwalia97@gmail.com