From the course: ASP.NET Web Forms Essential Training

Unlock the full course today

Join today to access over 22,500 courses taught by industry experts or purchase this course individually.

Working with SQL Server

Working with SQL Server - ASP.NET Tutorial

From the course: ASP.NET Web Forms Essential Training

Start my 1-month free trial

Working with SQL Server

“

- Every application today needs to store the data somewhere and one of the most popular technologies in Microsoft world, it's a SQL Server. So, let's hear a little bit, what is SQL Server and how can we work with it? SQL Server, it's a relational database management system. Meaning that the data stored inside the database has some relation with one another. So, we can have different kind of organizations. If we look inside the server itself, we are going to see that the data is organized first in databases. So, database, it's a big container containing a lot of tables, so every table contain data that is related. Mostly pertaining to one single entity. And inside the table, what we have, we have columns, so the column, it will define the type of data that we want to store in that particular column. And then the data itself is stored in rows, so if we look at one big database, we would have several tables and then normally, the tables have some kind of relationship between them and…

Contents