MS SQL SERVER SOLUTION (Chapter 1 ) : Starting SQL

 For any type of query or doubt regarding any solution or if you are not able to understand the solution or if you have any other alternative solution that you want to show me, You can directly comment on the corresponding class video in youtube. So that everyone can participate in that discussion. But remember I will use the only those techniques that we have learned so far. Exercises have been built in that way. It does not involve any knowledge on  unknown topics. When I was a student I missed this sequential way of exercise. I tried to build the exercise on what you have learnt recently. So that you can focus on recently learnt topic only and a bit revise of earlier chapters. As an example, this is the solution of chapter 1 and I have used only the techniques learned in this chapter itself. So if you are not able to crack any logic, that means you have to spend more time on "Basic syntax".

So keep that in mind while commenting your doubts in the corresponding youtube class as well. suppose you are commenting in youtube class 1, then I will show the solutions using techniques learnt on class 1 only. Let's create a good automated way to learn this topic and create an intelligent self learning platform by which you can get maximum knowledge without paying anything. For the effective learning you can copy the 1st solution code to create the dataset quickly. solution 2 onwards , you can not copy anything. you have to write it by your own 😊. Happy learning.

 I am a teacher by passion not by profession. So I also want you to become passionate on databases.


For further help, 

debabrataguha20@gmail.com 

https://www.facebook.com/ddebb.guha/ 

https://www.linkedin.com/in/debabrata-guha-719008119/

 


 ------------------------------------ regarding chapter 1 ----------------------------------------

Class: https://youtu.be/zkdZTP_T4v0

You will get all the class video in youtube: https://www.youtube.com/playlist?list=PLtyCwTfL5QAzWl_mfVTjxHqGbwiyoUTnh

You will get all the exercise in the Facebook group  https://www.facebook.com/groups/331231161093613/ 

__________________________________________________________________________

 



1.      Q1. Create the table and insert the data.

Soln.

 

CREATE TABLE [dbo].[EMPLOYEE]

(

               [EID]                     int,

               [ENAME]             varchar(100),

               [GRADE ]              varchar(1),

               [AGE]                   int,

               [GENDER]           varchar(1),

               [STATE]               varchar(2),

               [SALARY]             numeric(9,2)

)

 

               GO

 

               INSERT INTO [dbo].[EMPLOYEE] values

               (101,’Goutam Sinha’,’A’,40,’M’,’BH’,50000.00),

               (102,’Srijan Basu’,’B’,30,’M’,’WB’,40000.00),

               (103,’Nandini Apte’,’A’,45,’F’,’MH’,57000.00),

               (104,’Satyen Murmu’,’B’,33,’M’,’JH’,32000.00),

               (105,’Priya Kumari’,’C’,31,’F’,’JH’,25000.00),

               (106,’Vignesh D’,’D’,25,’M’,’TN’,15000.00),

               (107,’Grishma Dasari’,’C’,27,’F’,’AP’,17000.00)

 

 








Comments

Popular posts from this blog

Java concepts Theory

About Myself ..