Database normalization is consist of a set of normalization rules derived from recognized good practices. It ensures that the database is structured to store data in a possible efficient way. It also helps to reduce the amount of duplicate data from the database. First Normal Form(1NF) A table is in 1NF if there is all … Continue reading Database Normalization
Tag: SQL
Tables in SQL Server
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
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 