Assessment Evaluation Parameters
Skill Assessment Evaluation Parameter
MS SQL Server Understanding of basic SQL syntax and commands.
MS SQL Server Knowledge of normalization and denormalization.
MS SQL Server Ability to design efficient database schemas.
MS SQL Server Ability to write SELECT statements for querying data.
Technical Discussion Parameters
Skill Questions on
SQL DDL, DML, DCL Query and Operations, Clauses,
Aggregate Functions, String Functions, GROUP BY,
Having, Joins & subqueries
ssment Evaluation Parameters
What to check?
Use of SELECT, FROM, WHERE, GROUP BY, HAVING, and ORDER BY clauses.
Proper use of primary keys, foreign keys, and normalization rules.
Joins, Types of Joins usage
S.noGroup Name Trainer Name
1 1 Amega Dhanu A 21it002@nandhaengg.org Prasanna
2 1 Archana A S archana.2103010@srec.ac.in Prasanna
3 2 Dhanusree Dhanusree sreedhanu75@gmail.com Prasanna
4 2 Dilip Krishnan J dilipkrishnan003@gmail.com Prasanna
5 3 Gurupirasath Vedhamanigurupirasath003@gmail.com Prasanna
6 3 Harshavarthini G achhu524@gmail.com Prasanna
7 4 Jasiya Yasika jasiyayasika.2101112@srec.ac.inPrasanna
8 4 Jaswanth T jaswanth9611@gmail.com Prasanna
9 5 Jyothika Sujith jyothikasujith7@gmail.com Prasanna
10 5 Kanthety Jansu Choudhary
jansuchoudharykanthety@gmail.com
Prasanna
11 6 Karthikram Prabhakar karthikram.2102103@srec.ac.inPrasanna
12 6 Kavinsubash K R kavinramasamy2003@gmail.comPrasanna
13 7 Kayalvizhi Sivakumar
kayalvizhisivakumar019@gmail.com
Prasanna
14 7 Noorul Misbah K noorulmisbah15@gmail.com Prasanna
15 8 P Lavanya Ghowri lavanya.82102079@srit.org Prasanna
16 8 Pranav S pranav.itsmee@gmail.com Prasanna
17 9 Praveen N praveenpv149@gmail.com Prasanna
18 10 R Sonal Noel Raj sonalnoelraj.2103129@srec.ac.inPrasanna
19 10 Rahul G rahul.2101210@srec.ac.in Prasanna
20 10 Rajbarath Senthilnathan rajbaraths007@gmail.com Prasanna
21 11 Saily Pralhad Avhad avhadsayali01@gmail.com Prasanna
22 11 Samyuktha M B samyuktha.2102159@srec.ac.inPrasanna
23 12 Sarath Krishnan sarathkrishnan.2101224@srec.ac.in
Prasanna
24 12 Sathyan S sathyasivakumar315@gmail.comPrasanna
25 13 Shimona Stephen shimona.2102209@srec.ac.in Prasanna
26 13 Sivanika Sri S sivanikasri.2102214@srec.ac.in Prasanna
27 13 Sundhara Pandi sundharapandi008@gmail.com Prasanna
28 Trisha S trisha.2102236@srec.ac.in Prasanna
29 Varshaa B varshaa2242004@gmail.com Prasanna
30 Varshini S varshinis2204@gmail.com Prasanna
31 Vignesh R vigneshppa@gmail.com Prasanna
**SQL Demo Marks Allocation:
Not Done - 0 mark; 20% to 30% done - 2 to 3 mark; 40% to 50% done - 4 to 5 marks; 60 % to 70%done
SQL Coding Challenge Evaluation (To Be Filled By Evaluator)
Project Name Schema Creation DDL DML Joins-1
Virtual Art Gallery 8 9 8 8
Virtual Art Gallery 8 8 8 8
CarRental 9 9 8 8
CarRental 8 8 8 8
Virtual Art Gallery 9 8 8 8
Virtual Art Gallery 9 9 9 8
Ecom 8 8 8 8
Ecom 8 9 8 8
CrimeManagement 9 9 9 9
CrimeManagement 8 9 9 9
CareerHub 9 9 9 9
CareerHub 8 9 9 9
CarRental 8 9 8 8
CarRental 9 9 9 8
Virtual Art Gallery 9 9 8 9
Virtual Art Gallery 9 8 8 9
CrimeManagement 8 9 9 9
CrimeManagement
CarRental 9 9 9 8
CarRental 9 8 8 8
CareerHub 8 8 9 9
CareerHub 9 9 9 8
CrimeManagement 9 8 8 8
CrimeManagement 9 9 9 9
CareerHub 8 9 8 9
CareerHub 8 9 8 8
CareerHub 9 8 8 8
Car Rental 9 8 8 8
Ecom 9 8 8 8
Car Rental 9 8 8 8
Car Rental 9 8 8 8
one - 4 to 5 marks; 60 % to 70%done - 6 to 7 marks; 80% to 90%done - 8 to 9 marks; 100 % done- 10 marks
Operators(IN/
Aggregate Built-in
Joins-2 Subqueries BETWEEN/LIKE
Functiosn Functions
etc)
8 8 8 8 8
7 8 8 7 8
8 7 8 8 9
8 9 8 9 8
8 8 8 9 9
7 8 9 8 8
7 8 8 9 8
7 8 8 9 9
8 9 9 9 9
9 9 9 9 10
8 8 8 8 8
7 9 8 9 8
8 8 8 8 8
7 7 8 8 8
8 8 7 7 7
7 9 9 9 8
8 9 9 9 9
8 9 9 9 9
8 8 8 8 8
8 8 9 8 8
8 8 9 8 8
7 7 7 8 8
9 9 8 8 8
7 8 7 8 9
8 9 8 8 8
7 8 8 8 8
7 8 8 8 8
7 8 8 8 8
7 8 8 8 8
7 8 8 8 8
marks
SQL Coding
Technical Challenge Score in
Status
Discussion %
(Autofilled)
9 82 Cleared
7 77 Cleared
9 83 Cleared
8 82 Cleared
8 83 Cleared
9 84 Cleared
8 80 Cleared
8 82 Cleared
9 89 Cleared
10 91 Cleared
9 85 Cleared
8 84 Cleared
9 82 Cleared
8 81 Cleared
7 79 Cleared
9 85 Cleared
9 88 Cleared
Not Cleared
9 88 Cleared
8 81 Cleared
8 83 Cleared
8 84 Cleared
8 78 Cleared
8 86 Cleared
9 82 Cleared
9 83 Cleared
8 80 Cleared
8 80 Cleared
8 80 Cleared
8 80 Cleared
8 80 Cleared
Evaluator overall Comments/Feedback
She is good enough in basic of SQL, joins and subqueries
Need to improve on joins and subqueries
Good in all aspects
All good as need to write more on sqb subqueries
He able to explain in flow .Good at basic concepts. Need to learn to write complex
queries
Able to give answers and nice explanation
Overall good at basics , Need to concetrate on subqueries and clauses
He is good enough in basic of SQL, need to concentrate on Joins
He able to explain in flow .Good at basic concepts.Need to concentrae on
subqueries.
He is good enough in basic of SQL, need to concentrate on Joins with clauses
He able to explain in flow .Good at basic concepts.Need to concentrae on joins
He is good enough in basic of SQL, need to concentrate on Joins with clauses
Flow of query writing quit good, need to improve in subquery area
Overall good at basics , Need to concetrate on subqueries and clauses
He is good enough in basic of SQL, need to concentrate on functions
He able to explain in flow .Good at basic concepts.Need to concentrae on joins
Good at Basics of SQL . able to explain in a flow
Absent
He able to explain in flow .Good at basic concepts.
Good enough in basic of SQL, need to concentrate on Joins with clauses
Good enough in basic of SQL, Need bit practice on all topics
He is good enough in basic of SQL, need to concentrate on Joins with clauses
Good enough in basic of SQL, Need bit practice on all topics
Overall good at basics , Need to concetrate on functions
He able to explain in flow .Good at basic concepts.Need to concentrae on joins
Shee is good enough in basic of SQL, need to concentrate on Joins with clauses
Good enough in basic of SQL, Need bit practice on all topics
Good enough in basic of SQL, Need bit practice on all topics
Good enough in basic of SQL, Need bit practice on all topics
Good enough in basic of SQL, Need bit practice on all topics
Good enough in basic of SQL, Need bit practice on all topics
