Tables in database are responsible to store data in form of a grid like structure. Tables consist of Columns and Rows. The columns are the variables for which we want to store values and these values for each column forms a row of data. Each row is a collection of values of columns. Table Types … Continue reading Tables in SQL Server
Month: January 2019
What is Database
Consider the database as a container which contains several type of objects such as tables, views and many more. These objects helps database to store data in an organised fashion. There are two types of databases available. System Databases: These databases are used by SQL Server itself to perform its functionality such as logging transactions.User … Continue reading What is Database
SQL Server Editions
There are many SQL Server editions that focus on specific requirements such as SQL Server BI stack. Let's take a quick look at the available versions. Express: This version of SQL Server is available for free. If you are starting with SQL Server it's a good option to start with. It has almost all the … Continue reading SQL Server Editions
What is SQL Server?
MS SQL Server is an Relational Database Management System (RDBMS). To explain what RDBMS is, we need to understand SQL, Server and then RDBMS. SQL: It stands for Structured Query Language. It's a language that enable us to interact with Databases like Microsoft SQL Server. Server: A server is a computer that accept requests and … Continue reading What is SQL Server?
SQLer 