Category Archives: SQL

SQL

Good Learning Site for beginners:
Short:
http://www.dofactory.com/sql/left-outer-join

Elaborate:
https://www.w3schools.com/sql/sql_select.asp

Less Important But Okay:
https://www.tutorialspoint.com/sql/index.htm
Questions:

http://programabad.com/questions/5268/sql-normalization

http://www.studytonight.com/dbms/database-normalization.php

http://programabad.com/questions/3940/cgpa

Dive into some SQL queries

In my 7th semester Level-3 Term -1 of my  BSc. Engineering course of Computer Science and Engineering in Daffodil International Univeristy(DIU) I am doing a course named Database Management System

Here our course teacher is using MS SQL Server 2008. I am sharing here what i have learnt from my class.

SQL stands for structured query language which help us to manage database easily

To create database in sql
Suppose a databse for university student

where we will create a table named student

after this we can show the empty table by this query

 

Now by this query  we will insert data into the table

Don’t forget to use values.It is actually SQL syntax and don’t forget to give
select * from statement at the end of the query as it will help to display the updated table where star or asterisks sign * means all info of this table

if we want to show some limited data from all then here is one example

 

Now I am going to update some of my data in the table then

2015-01-27 00_51_59-
Now I am going to delete some data from the table

 

2015-01-27 00_56_50-

Then here see the change.Age name with 22 and 23 have been deleted for this sql command.

We have used here OR statement because AND is not working in MS SQL Server 2008.I don’t know why…May be I don’t know the actual things about and/or in MS SQL. I apologize for this..

If this tutorial helped you to understand the basics of the sql query.Then don’t forget to keep soem comment below.

Thanks for reading 🙂