27 comments:

Hello, i would like to ask that what is the benefits of sql training, what all topics should be covered and it is kinda bothering me … and has anyone studies from this course http://www.wiziq.com/course/125-comprehensive-introduction-to-sql of SQL tutorial online?? or tell me any other guidance...would really appreciate help… and Also i would like to thank for all the information you are providing on sql training.

I am not a programmer but I have this SQL subject this session and have to prepare for it. What all topics should be covered in it?And has anyone studied from this course www.wiziq.com/course/125-comprehensive-introduction-to-sql of SQL tutorial online?? or tell me any other guidance...would really appreciate help

1---> select DeptName from Employee where Empid>103;2---> select EmpName from Employee where EmpHeadId=105;3---> select EmpName from Employee where Department='E-101';4---> select EmpName from Employee where EmpId=(select EmpId from EmpSalary where IsPermanent='Yes');5---> select EmpName,ContactNo from Employee where EmpId=(select EmpId from EmpSalary where IsPermanent='No');

-- Select the Employee work under AbhishekSelect Employee.EmpId, Employee.EmpName from Employee left join EmpDept on Employee.EmpId = EmpDept.DeptHead where Employee.department='E-101' and Employee.EmpName <> 'Nishant'

-- select the Employee Head who is PermanentSelect Employee.Empid,Employee.EmpName,EmpSalary.Ispermanent from EmpSalary left join Employee on EmpSalary.EmpId = Employee.EmpId Where IsPermanent='Yes'

-- Select the name and contact number of dept head who is not PermanentSelect Employee.Empid,Employee.EmpName,Employee.ContactNo,EmpSalary.Ispermanent from EmpSalary left join Employee on EmpSalary.EmpId = Employee.EmpId Where IsPermanent='No'-- Select the name employeewho is working Hr and permanentSelect Employee.Empid,Employee.EmpName,Employee.ContactNo,EmpSalary.Ispermanent from EmpSalary left join Employee on EmpSalary.EmpId = Employee.EmpId Where EmpSalary.IsPermanent='Yes' and Employee.Department='E-101'

-- Select Duration of Project which is not AssignedSelect Project.ProjectId,Project.Duration from Projectleft joinEmpProjecton Project.ProjectId = EmpProject.ProjectIdWhere EmpProject.ProjectId is null

-- Select the name of employee who is working on p-4Select Employee.EmpName,EmpProject.ProjectIdfrom Employee left joinEmpProjecton EmpProject.EmpId = Employee.EmpIdWhere EmpProject.ProjectId='p-4'

-- Select the Project Id which duration is greater then 30 monthSelect ProjectId from Project where duration > 30

-- select the salary of employee who is currently working in project P1

Select EmpSalary.Salary,EmpSalary.EmpId,EmpProject.ProjectId from EmpSalary left joinEmpProject on EmpSalary.EmpId = EmpProject.EmpId where EmpProject.projectId='p-1'