introduction sql server 2008

Introduction of SQL Server 2008

Prepared By,Harshida Parmar

http://www.nichetechinstitute.com

Steps• A database is a structured collection of records or data that is stored in a computer system. The structure is achieved by organizing the data.

• Database contain more than 1 tables…Table contain data field and data

Data field is knows as Column name Data store inside the data field

• To perform above operation we use SQL SERVER 2008

Prepared By, Harshida Parmar, NicheTech Com.Sol.Pvt.Ltd (http://www.nichetechinstitute.com)

Steps•

Prepared By, Harshida Parmar, NicheTech Com.Sol.Pvt.Ltd (http://www.nichetechinstitute.com)

Steps• Microsoft has released a new version of SQL Server that promises to improve life for database administrators. The latest version is SQL Server 2008, and it offers a large variety of new features and functionality that will make the administration better.

Prepared By, Harshida Parmar, NicheTech Com.Sol.Pvt.Ltd (http://www.nichetechinstitute.com)

Steps• It gives many type of functionalities like, create database, tables, queries, etc.

Prepared By, Harshida Parmar, NicheTech Com.Sol.Pvt.Ltd (http://www.nichetechinstitute.com)

Steps• Here I want to create one database so just right click on database and one window will pop up… specify your database name

Prepared By, Harshida Parmar, NicheTech Com.Sol.Pvt.Ltd (http://www.nichetechinstitute.com)

Steps• Then click on OK button…• Now I want to create the table inside the created database

so

Prepared By, Harshida Parmar, NicheTech Com.Sol.Pvt.Ltd (http://www.nichetechinstitute.com)

Steps• So just expand your database… In that you can find the Table folder… right click on the Table button… and select New table…

Prepared By, Harshida Parmar, NicheTech Com.Sol.Pvt.Ltd (http://www.nichetechinstitute.com)

Steps• Specify the column name and then after press CTRL+S…• Specify your table name… • Now if your want to insert the value inside the table

Prepared By, Harshida Parmar, NicheTech Com.Sol.Pvt.Ltd (http://www.nichetechinstitute.com)

Steps• Just right click on your created table and select edit 200 rows …

Prepared By, Harshida Parmar, NicheTech Com.Sol.Pvt.Ltd (http://www.nichetechinstitute.com)

Steps• You are allowed to enter the record inside the table….• This are the basic steps how to create database, table and how to insert the record inside the table….

Prepared By, Harshida Parmar, NicheTech Com.Sol.Pvt.Ltd (http://www.nichetechinstitute.com)

Thank you… For more details http://www.nichetechinstitute.com http://www.youtube.com/nichetechinstitute

Prepared By, Harshida Parmar, NicheTech Com.Sol.Pvt.Ltd (http://www.nichetechinstitute.com)