An invited talk by Eminent Guest Speaker Mr. Manjeet Singh, Team Lead, GSPANN Tech Inc.was organized on 17th February 2018, at I.T.S, Mohan Nagar, Ghaziabad. Before starting of the session, MrManjeet Singh was warmly welcomed by Dr. Sunil Kr Pandey Director IT, by presented him a Sapling. In this session, Mr.Manjeet Singh delivered talk on “Implementation of SQL”. In his address, he explained how to use SQL commands to retrieve information from the Database. He explained select command with where, group by, having, order by, distinct, all, unique conditions. He discussed about sequence execution of these commands in processor i.e. firstly ‘from’ statement is executed then ‘where’ condition then ‘group by’ condition then ‘having’ then ‘select’ statement is executed then ‘order by’ after that distinct/unique.

Month Of Events: 
February
Date Of Events: 
17
Year Of Events: 
2018
Image Of Events: 
Full Date Of Event: 
Saturday, February 17, 2018
Hide Body Of News : 

Mr. Singh enlightened on gridline structure, systematic treatment of null values, aggregate function, wild cards, operators, nested queries along with appropriate examples. 
This event was in the series of new initiative by Dept Research Committee, Dept. of IT for Invited talks by national speakers of repute by Dept of IT of the institute with an objective to provide the detailed insight of the theme to the upcoming and working professionals about the technological, research and allied issues and experience sharing by leading experts and professionals. 
MrSinghalso interacted with the Students and answered the queries related with SQL along with its demonstrationraised during the session.