Microsoft SQL Server is a relational database management system which is designed to run from single desktop machine to multiprocessor huge servers. Basically SQL Server is used to store the large data of websites as well as of CRMs.
SQL Server uses a type of database called a relational database. In relational databases, data is organized into tables.Tables are organized by grouping data about the same subject and contain columns and rows of information.
As you saw, a relational database is composed of different types of objects. The following are some of the more common objects:
1- Tables are the objects that contain the data types and actual raw data.
2- Columns are the parts of the tables holding the data.
3- Data types are the base storage type of your data.
4- Stored procedures are like macros in that SQL code that can be written and stored under a name.
5- User defined functions are transact SQL code thats very similar to stored procedures.
6- Triggers are stored procedures that activate either before or after data is added, modified or deleted from the database.
7- Views are basically queries stored in the database that can reference one or many tables.
8- Index can help organize data so that queries run faster.
9- Primary keys are essential to relational database. They enforce uniqueness among rows, providing a way to uniquely identify
every item you want to store.
10- Foreign key are one or more columns that reference the primary keys or unique constraints of other tables.
All above mentioned objects are described in brief. There are other objects as well which will be described in details among with above mentioned objects in this tutorial latter.
In the next chapter we will learn how to install SQL Server onto your machine, in a network environment.
Previous
Index
Next
No comments:
Post a Comment